All services
Accounting and bookkeepingPayroll and employmentTax complianceTax advisory and planningBusiness setup and secretarialSystems and digital transformation
Self AssessmentBookkeepingPayrollGuidesAboutContactWhatsApp us

Data migration and chart of accounts setup

Move to new accounting software without losing your history, and rebuild the structure so reports make sense.

Last reviewed 21 November 2026. Figures are for the 2026/27 tax year.

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.

SymptomLikely causeFix
Many accounts with tiny balancesOver-detailed historyMerge into broader categories
"Miscellaneous" is one of the largest costsPoor coding disciplineCreate specific accounts and rules
Year-end adjustments keep appearingWrong accounts for capital items or loansRestructure balance sheet accounts
Reports do not match the accountsMapped differently over timeAgree a consistent mapping
Hard to separate personal and businessMixed use of one accountAdd clear director or drawings accounts

How a migration works

  1. Scope. We agree what is moving: opening balances only, or also transaction history, customers, suppliers and fixed assets.
  2. Cleanse. We tidy the source data. Duplicate contacts, old balances and errors are easier to fix before the move than after.
  3. Map. Each old account is matched to a new one, and the mapping is written down.
  4. Load. Balances and, where agreed, history are imported into the new system.
  5. Reconcile. We compare the new system's reports with the old ones, line by line.
  6. 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.

The balances that cause most trouble

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.

What to gather before a migration
  • 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.

WhatsApp usCall