Data migration and chart of accounts setup
Move to new accounting software without losing your history, and rebuild the structure so reports make sense.
Moving house for your numbers
Changing accounting software, or moving from spreadsheets to software for the first time, is a bit like moving house. Most of it is straightforward, but a few items are fragile, and it is better to plan the move than to discover afterwards what was left behind. A careful migration protects the continuity of your records and keeps your accountant, your auditor and HMRC all looking at the same story.
Why the chart of accounts comes first
The chart of accounts is the list of categories in which every transaction is recorded. It decides what your profit and loss and balance sheet look like. Over years, charts tend to grow untidily: duplicate categories, accounts nobody uses, and headings that only the previous bookkeeper understood.
A migration is the best moment to clean this up. A good chart has enough detail to answer real questions, such as how much each product line earns or how much is spent on subcontractors, without being so detailed that every transaction needs a debate.
| Symptom | Likely cause | Fix |
|---|---|---|
| Many accounts with tiny balances | Over-detailed history | Merge into broader categories |
| "Miscellaneous" is one of the largest costs | Poor coding discipline | Create specific accounts and rules |
| Year-end adjustments keep appearing | Wrong accounts for capital items or loans | Restructure balance sheet accounts |
| Reports do not match the accounts | Mapped differently over time | Agree a consistent mapping |
| Hard to separate personal and business | Mixed use of one account | Add clear director or drawings accounts |
How a migration works
- Scope. We agree what is moving: opening balances only, or also transaction history, customers, suppliers and fixed assets.
- Cleanse. We tidy the source data. Duplicate contacts, old balances and errors are easier to fix before the move than after.
- Map. Each old account is matched to a new one, and the mapping is written down.
- Load. Balances and, where agreed, history are imported into the new system.
- Reconcile. We compare the new system's reports with the old ones, line by line.
- Sign off. You approve the opening position before live transactions begin.
Opening balances or full history?
Many businesses do not need every historic transaction in the new software. Opening balances at a clean date, with older records kept as saved reports, is often enough, and it is quicker and cheaper. Full history makes sense when you need year-on-year comparison inside the system, when a lender or buyer will want to see it, or when you are within a year of an audit.
Debtors, creditors, VAT and loan balances are the ones that most often fail to agree after a move. We reconcile each to a source document, such as an aged list, a statement or a HMRC account, before we call the migration complete.
Fixed assets and depreciation
If you hold assets such as equipment or vehicles, the register of costs, dates and depreciation must move too. Capital allowances for tax follow a separate schedule from accounting depreciation. We carry across both so the year-end work is not disrupted.
Data protection
Accounting data includes personal details of customers, suppliers and employees. We handle it for the purpose of the migration only, transfer it through secure routes and agree what happens to the source files at the end.
- The last signed accounts and the trial balance at the conversion date
- Aged debtor and creditor lists
- Bank and card statements, reconciled to the same date
- VAT returns and the HMRC VAT account balance
- Fixed asset register and loan statements
- A list of users and what each needs to see
Where it leads
After migration, you will want the new software to be used well. See cloud accounting setup for configuration and software training and support for learning it. If the books also need catching up, our bookkeeping team can help.
How we confirm the work
Migration is set out in a written proposal based on the amount of data and the scope you choose.
Questions we are asked
Not usually. Opening balances at a clean date are often enough. We bring history across only where there is a clear reason.
Yes. Spreadsheet data is cleansed, mapped to a new chart of accounts and loaded in a controlled way.
We reconcile the new reports to the old ones and to source documents before sign-off, and give you the workings.
It should not, provided the VAT settings and opening balances are right. We time the move to avoid the middle of a VAT period where possible.
Move your records without losing anything
Tell us what you use now and what you are moving to, and we will send a written proposal for the migration.