Software Migration Checklist: Moving from Spreadsheets to MTD-Compliant Accounting Tools in 2026

The era of manual spreadsheets for tax reporting is ending. HMRC already mandates digital record-keeping and direct digital links for MTD VAT, and for MTD for Income Tax Self Assessment (ITSA) this becomes mandatory for most sole traders and landlords from April 2026. This guide is a practical checklist for moving from spreadsheets to MTD-compliant accounting software without losing data or missing a deadline.

Key MTD dates to plan around

What changes	When	Notes
MTD ITSA mandatory for qualifying income over £50,000	April 2026	First quarterly updates due in the 2026/27 tax year
MTD ITSA mandatory for qualifying income over £30,000	April 2027	Extends to many more businesses and landlords
Threshold drops toward £20,000	From 2028	Confirmed direction of travel, so plan as if it applies to you
Digital links required	Now (VAT), soon (ITSA)	Manual copy-paste between spreadsheets is not compliant

Why spreadsheets alone no longer pass

Spreadsheets are not banned, but they must be part of a digitally linked chain that reaches HMRC through recognised software. In practice that means no manual retyping of figures between files, and an API connection to submit quarterly updates. Hitting that bar with spreadsheets plus bridging software is fragile and easy to break, which is why most businesses move to a single system that keeps the records and files the returns.

The migration checklist

1. Confirm your obligation and timing. Add up your qualifying income (self-employment plus property). Note which April you are mandated from.
2. Choose HMRC-recognised software. Check it appears on HMRC's list of software for MTD ITSA and supports your sources of income.
3. Pick a clean cut-over date. The start of a tax year or VAT quarter is ideal.
4. Tidy your spreadsheets first. Fix inconsistent categories, remove duplicates, and reconcile to your bank before importing: bad data in is bad data out.
5. Set your opening position. Enter opening balances, outstanding invoices and bills, and any assets so reports are accurate from day one.
6. Import your history. Bring in prior transactions via CSV or a bank feed so you keep continuity for comparatives.
7. Connect your bank. A live bank feed is the single biggest time-saver and the foundation of digital record-keeping.
8. Recreate your categories and tax treatment. Map your old spreadsheet columns to the software's chart of accounts and VAT/tax rules.
9. Run one period in parallel. For a quarter, keep your spreadsheet alongside the software and reconcile the two. When they agree, retire the spreadsheet.
10. File your first quarterly update from the software. Confirm the submission lands with HMRC and diarise the remaining deadlines.

What to look for when choosing software

• Ease of use and a clear interface
• Core accounting: invoicing, expenses, bank reconciliation
• MTD ITSA compliance with direct digital links (no bridging hacks)
• Integrations you rely on (bank, payroll, CRM)
• Scalability and a credible roadmap
• Transparent pricing with no hidden per-feature costs
• Responsive support and training resources
• Strong data security and backups

Common migration pitfalls

• Inconsistent or error-ridden data in the original spreadsheets
• Underestimating how long data transfer and training take
• Choosing software that doesn't fit the specific income sources
• Resistance to changing a familiar process
• Leaving the switch until the deadline, with no parallel-running buffer

What happens if you miss MTD obligations

Failure	Consequence
Late quarterly update	Points-based penalty system, leading to fines
Late End of Period Statement	Points-based penalty system
Late Final Declaration	Points-based penalty system
Failure to keep digital records	Penalties for non-compliance with record-keeping rules
Late payment of tax	Interest plus potential late-payment penalties

How AccountsOS makes the switch painless

AccountsOS is built MTD-first. Connect your bank, forward or snap your receipts, and Finn, your AI accountant, categorises transactions, keeps a digitally linked record, and prepares your quarterly figures. There's no bridging software to maintain and no spreadsheet to keep in sync. You can ask, in plain English, "what's my income tax position this quarter?" and get an answer.

Frequently asked questions

Do I have to stop using spreadsheets entirely?

No, but any spreadsheet you keep must be digitally linked into HMRC-recognised software, with no manual retyping of figures. Most people find it simpler to move record-keeping into one MTD-compliant system rather than maintain a linked chain of spreadsheets and bridging tools.

When does MTD for Income Tax actually start for me?

From April 2026 if your qualifying income (self-employment plus property) is over £50,000, and from April 2027 if it's over £30,000. The threshold is set to fall further toward £20,000 later, so it's worth preparing even if you're under £30,000 today.

How long does migrating from spreadsheets take?

For a typical sole trader or landlord, allow a few hours to choose software, clean data and set opening balances, then run one quarter in parallel before switching fully. Starting at the beginning of a tax year or VAT quarter makes the cut-over cleanest.

Will I lose my historical records?

No. Import prior transactions via CSV or a bank feed so you keep comparatives and a continuous history. Set your opening balances so reports are accurate from your first day on the new system.