How to Switch Accounting Software Without Losing Data UK

Affiliate disclosure: Some links on this page may earn us a small commission at no extra cost to you — this never affects our editorial independence.

Introduction

Switching accounting software feels far more daunting than it should. The worry isn’t really the new interface — it’s the quiet terror that six years of invoices, VAT returns and painstakingly reconciled transactions might vanish into the ether.

A clean, data-safe migration is achievable for most small businesses. But it’s worth being honest from the start: “switching without losing data” rarely means moving every record perfectly intact. It means protecting what matters legally and operationally, understanding exactly what won’t transfer, and keeping your old system accessible so nothing is truly gone.

This guide walks through the whole process.

Step 1: Pick the Right Cut-Over Date

The single most important decision, and most guides bury it. Don’t pick a random date — choose a natural financial boundary.

The start of a new VAT quarter. The cleanest option for VAT-registered businesses: your old software handles all returns up to that point, and the new one starts fresh.

The start of your financial year. Better still if it coincides with a VAT quarter, because your year-end trial balance becomes your opening balance and your accountant will already have signed off the numbers.

1 April is popular because it lines up with many limited companies’ 31 March year end and the start of a VAT quarter for many businesses. Note the personal tax year ends 5 April, which is a different date.

If You’re in Scope for MTD for Income Tax, Add a Constraint

This is new and most migration guides haven’t caught up with it.

Making Tax Digital for Income Tax went live in April 2026 for sole traders and landlords with qualifying income above £50,000, dropping to £30,000 in April 2027. If you’re in scope, you’re submitting quarterly updates due 7 August, 7 November, 7 February and 7 May, alongside any VAT obligations.

That changes the calculation. A VAT quarter boundary may no longer be the cleanest cut-over if it falls awkwardly against your MTD update deadlines. Aim for a date that gives clear air before the next quarterly update, and make sure your new software is recognised for MTD for Income Tax specifically — approval for MTD for VAT does not carry across, as they’re separate programmes with different technical requirements.

Whatever you choose, don’t let a VAT or MTD deadline fall in the middle of your migration.

Give yourself four to six weeks of preparation. Rushing the cut-over because you’re frustrated with your current software is among the most common mistakes.

Step 2: Export Everything From Your Current System

Before you cancel anything or start setting up the new platform:

Trial balance. Non-negotiable. Export as at your cut-over date, as both PDF and spreadsheet. This becomes your opening balance.

Transaction history. Full history — invoices, bills, expenses, bank transactions — as CSV or Excel. Most major platforms allow this. If yours doesn’t, that’s a red flag worth addressing before you switch.

Customer and supplier lists. Names, addresses, payment terms, outstanding balances. These usually import cleanly.

VAT return history. Download PDFs of every return submitted. Your submissions sit with HMRC, but the workings and supporting figures live in your software. Don’t rely on HMRC’s portal alone.

MTD quarterly update records, if you’re in scope for Income Tax. Same principle — the submission is with HMRC, the underlying detail is in your software.

Bank statements. Last 12 months in PDF and CSV, downloaded from the bank independently of your accounting software. This is your safety net.

Attachments and documents. Manually download scanned receipts, purchase invoices and other attachments stored in your current software. Cloud storage, your email archive or a document management tool are better long-term homes anyway.

Step 3: What Typically Does Not Migrate Cleanly

Being honest about this saves most post-migration grief.

Reconciliation history. That a transaction was matched to a bank statement line is almost never carried over. Historic transactions imported in bulk won’t have the tick. Fine if you’re migrating opening balances rather than full history, but don’t expect clean reconciliation records for past periods.

Attachments and document links. Scanned receipts and signed contracts attached to individual transactions almost never transfer — they sit in proprietary storage. Move them manually if they matter.

Custom reports. Report templates, dashboards and saved views you’ve built over years are gone. You’ll rebuild from the new platform’s defaults.

Historic VAT returns. Final figures are held by HMRC and visible in your Government Gateway account, but the detailed submission records, workings and audit trail stay in your old software. A strong reason to keep it accessible.

Payroll history. Treat this as an entirely separate migration. If you switch payroll mid-tax-year, year-to-date figures must carry across accurately — get these wrong and your RTI submissions and P60s will be wrong too. Many businesses keep payroll on a separate system, or ask their accountant to manage the cut-over. Switching payroll at the start of a tax year on 6 April avoids the problem entirely.

Fixed asset registers. Depreciation schedules often need manual recreation. Check whether your new platform can import them, and budget time if not.

Step 4: Migrate Opening Balances, Not Full History

This is the professional approach and it will save you significant pain.

Rather than importing years of individual transactions — which leads to reconciliation nightmares and often corrupted data — migrate at the level of opening balances:

• Debtors — total owed to you, broken down by customer
• Creditors — what you owe suppliers
• Bank balances — closing balance at your cut-over date
• VAT liability or credit — what you owe HMRC or are owed at that date
• All other balance sheet figures from your trial balance

Involve your accountant here. The opening balance journal looks straightforward until it isn’t. A misposted figure in retained earnings or the VAT control account causes months of confusion. Most accountants charge a modest fee for this, and it’s genuinely worth it.

Your new system then starts clean from the cut-over date, with your old system holding the history.

Step 5: Reconnect Bank Feeds

Once opening balances are correct, reconnect your feeds. Most UK business accounts integrate with major platforms via Open Banking.

Watch for:

• Duplicate transactions. If the feed imports transactions from before your cut-over date, delete or exclude them. Only transactions from the cut-over onwards should be processed.
• Match before reconciling. Let a few days of transactions come through before reconciling, so you have enough to match against.
• Credit cards and PayPal. These often need separate connections and are easy to overlook.

Step 6: Reconcile the First Period on Both Systems

Your first reconciliation in the new system is the most important one you’ll do.

Run the same period in both systems simultaneously. When your first VAT quarter — or MTD quarterly update period — closes on the new system, cross-check the figures against what the old one would have produced. That’s your proof the migration worked.

It’s extra work, but it catches errors before they compound. Keep a simple spreadsheet comparing turnover, VAT output, VAT input and bank balance.

Step 7: Keep Your Old System Accessible

Don’t cancel immediately, and don’t delete your data. This isn’t caution — it’s a record-keeping obligation.

Retention periods differ by business type, which matters when deciding how long to keep paying:

• VAT records — at least 6 years
• Limited company records — generally 6 years from the end of the accounting period they relate to
• Sole trader and self-employed records — generally at least 5 years after the 31 January submission deadline for the relevant tax year
• PAYE records — at least 3 years from the end of the tax year

Confirm current retention periods on GOV.UK, as these can be updated and longer periods apply in some circumstances, such as where a return was filed late or an enquiry is open.

Many providers offer a read-only or archive plan at reduced cost specifically for this. Check what yours offers — policies vary by provider and by plan, and have changed over time, so confirm directly rather than relying on what was true last year.

The safest approach: keep at least a basic tier of your old system for the retention period, or export everything into formats you can open without the software. PDF and CSV, not proprietary files.

FAQ

Can I switch mid-year without confusing my accountant?

Yes, but tell them before you start. Mid-year migrations are manageable, especially using a VAT quarter start as the cut-over, but your accountant needs the cut-over date, the opening balance journal, and a clear understanding of which system covers which period. Surprises at year-end are rarely welcome.

Will switching affect my Making Tax Digital obligations?

Only if you get the timing or the software wrong. Ensure the new platform is MTD-compatible for the specific programme you’re in — VAT and Income Tax are separate approvals — and authorise it with HMRC before your next submission. Don’t let a deadline fall mid-migration.

Do I need to tell HMRC I’m changing software?

Not directly. But if you’re MTD-registered for VAT or Income Tax, you’ll need to authorise the new software to submit on your behalf through your Government Gateway account. Your new platform will usually walk you through it.

What if my opening balances don’t agree between systems?

Stop and investigate before processing anything in the new system. Common culprits are uncleared bank transactions, timing differences on outstanding invoices, or an unadjusted VAT balance. This is exactly why having your accountant post the opening balance journal earns its fee.

Should I migrate payroll at the same time?

Preferably not. Payroll carries year-to-date figures that must transfer accurately for RTI and P60s to be correct. If you can, move payroll at the start of a tax year on 6 April and the accounting software at a VAT or MTD boundary, rather than doing both at once.

Conclusion

Switching accounting software without losing data is genuinely achievable — but “without losing data” means being strategic, not magical. You won’t move every reconciliation tick, every attachment and every custom report. You will preserve everything that matters: your financial history, your legal records, and your ability to file accurate returns.

The honest recommendation: pick a cut-over date at a VAT quarter or financial year start, checked against your MTD update deadlines if you’re in scope for Income Tax. Export everything. Work with your accountant on the opening balance journal. Keep your old system on a reduced plan for the statutory retention period. Reconcile your first period on both systems before declaring victory.

Do those five things and you’ll look back on the migration as far less terrifying than it seemed.

This article is general information about migrating accounting software, not tax or accounting advice. Record-keeping obligations, retention periods and Making Tax Digital requirements depend on your circumstances and business structure — check current GOV.UK guidance and work with a qualified accountant on your opening balance journal and cut-over timing. Software providers’ data retention and archive policies change; confirm the current position with your provider before cancelling any subscription.