DataMigration and cleanup
Clients, quotes and invoices in a single tool
When client data is spread across spreadsheets and old software, finding a complete client file means cross-checking several sources. This migration aims to bring client records, quotes and invoices together in a single management tool, while keeping the links between documents and their history.
A centralised history
- Customer data
- Quotes
- Invoices

(01)Where work gets stuck
One client, two names and scattered documents.
An employee is looking for a client’s history. The client’s record exists under two slightly different names, their quotes are in a spreadsheet and their invoices in the old software. To piece the client file back together, you have to check several files and sometimes re-enter the same information.
(02)How the data is carried over
Illustrative scenarioFive steps, from the original sources to the new tool.
Here is how the migration can run. It is an illustrative scenario: it does not describe a confirmed deployment step by step.
- 01
Inventory
List the sources and define which data to carry over.
- 02
Standardisation
Standardise the formats and spot duplicates.
- 03
Matching
Link each quote and each invoice to the right client record. Have the team confirm any ambiguous matches.
- 04
Test import
Run a test import and compare the volumes, the amounts and a few complete client files with the original data.
- 05
Final import
Once approved, import the final data and check that the teams can find their client files in the new tool.
(03)Concrete example
Illustrative scenarioA trade name on one side, a registered name on the other.
The same company appears under its trade name in the quotes file and under its registered name in the invoicing software. The team checks that it is the same business, then links the documents to one shared record. When the client file is opened, the quotes and invoices can be reached from that same record.
(04)What it changes day to day
Expected benefitsWhat teams can expect.
Less time spent searching
Teams spend less time searching: a complete client file no longer means cross-checking several sources.
A centralised history
They find a client’s history from a single tool, along with the record, quotes and invoices.
Data put to use again
They reuse the client data already carried over to prepare new quotes.
One caveat
The drop in data re-entry also depends on how the new tool is used after the migration.
(05)Indicators to track
To be measuredThree measures to compare, before and after go-live.
This page announces no measured results. Taken before and after go-live, these three measures will help judge the migration.
Number of duplicate records
Clients recorded more than once, sometimes under similar names.
Time to find a complete client file
From the search to reaching the client’s record, quotes and invoices.
Number of re-entries per week
Information entered a second time, counted over one week.
Services behind this project