How to Move From Spreadsheets to QuickBooks UK: A Step-by-Step Migration Guide
Affiliate disclosure: This article contains affiliate links — if you click through and purchase a QuickBooks subscription, we may earn a commission at no extra cost to you.
Sequencing Is Everything, and Timing Has Got Tighter
Moving from spreadsheets to QuickBooks is a genuinely manageable job if you do it in the right order: cut-over date, opening balances, contacts, bank feed, then reconcile before you trust anything.
One thing has changed that affects the first of those steps. Making Tax Digital for Income Tax has applied since 6 April 2026 to sole traders and landlords with qualifying income above £50,000. If that is you, your cut-over date is not a free choice — there is a trap in the obvious advice, and it is covered in Step 1.
Why Spreadsheets Stop Working
MTD Is Live, Not Coming
MTD for VAT already requires VAT-registered businesses to keep digital records and submit through compatible software. MTD for Income Tax joined it this year:
- £50,000 qualifying income — mandatory since 6 April 2026
- £30,000 — from April 2027
- £20,000 — from April 2028, confirmed rather than expected
Qualifying income means gross turnover, not profit, assessed on an earlier tax year, so a business with modest profits can be in scope.
Spreadsheets Are Not Banned — Manual Transcription Is
Worth being precise, because the usual framing overstates it. A spreadsheet is an acceptable digital record under MTD. What is not acceptable is typing figures from it into HMRC’s portal by hand, which breaks the digital link MTD requires.
So your options are compatible software like QuickBooks, or a spreadsheet plus bridging software that connects it to HMRC’s API. Bridging works, and it is a stopgap: extra cost, extra friction, another thing to go wrong at a deadline. Moving properly removes the problem.
The Practical Breaking Points
Beyond compliance, spreadsheets fail when more than one person needs access, when reconciling the bank takes hours, when a P&L means rebuilding it from scratch, or when your accountant bills you for reformatting your data before they can advise on it.
Step 1: Choose Your Cut-Over Date
The single decision that determines how clean this is.
The General Rule
Pick a natural boundary so that everything before it lives in the spreadsheet and everything after lives in QuickBooks, with no period split across both:
- The start of a new VAT quarter, if you are VAT registered, or
- The start of a new tax year, 6 April
Diary it at least four weeks ahead. The preparation is the work; the migration itself is a weekend.
If You Are Already in Scope for MTD for Income Tax
Here is the trap, and it is new this year.
MTD for Income Tax has fixed quarters that do not move with your VAT periods:
| Quarter | Period | Deadline |
|---|---|---|
| Q1 | 6 April – 5 July | 7 August |
| Q2 | 6 July – 5 October | 7 November |
| Q3 | 6 October – 5 January | 7 February |
| Q4 | 6 January – 5 April | 7 May |
If you are mandated, those quarterly updates have to be submitted from compatible software for the current tax year. So choosing a cut-over date of, say, 6 January 2027 does not park the problem — it leaves you needing to file Q1, Q2 and Q3 of 2026/27 from somewhere.
Which gives two workable routes:
- Cut over at 6 April and run bridging software for any quarters already gone, or
- Back-load the year to date — enter everything from 6 April into QuickBooks now, and file the current and remaining quarters from it
The second is more work up front and much tidier afterwards. If you are reading this in autumn, that means importing roughly six months of transactions rather than starting from a clean boundary, which is a nuisance but a one-off.
One piece of good news that takes the pressure off: there is a first-year penalty easement. For those mandated in April 2026, late submission of the first four quarterly updates carries no penalty points, though the obligation to file remains. Our QuickBooks MTD setup guide has the detail, including what the easement does not cover.
Step 2: Prepare Your Opening Balances
Where most migrations go wrong, and where an accountant earns their fee.
Your opening balances need to reflect your financial position at the cut-over date — a trial balance. From your spreadsheet, extract:
- Bank balance at the cut-over date, checked against the actual bank statement rather than what the spreadsheet claims
- Outstanding invoices issued but unpaid (debtors)
- Outstanding bills received but unpaid (creditors)
- Fixed assets — equipment, vehicles, property — with accumulated depreciation
- Loans and finance agreements outstanding
- VAT liability, if you are registered and mid-quarter
These go into QuickBooks as an opening balance journal. Get it wrong and the accounts never reconcile cleanly. An accountant can post the journal in half an hour from a clean trial balance, which is far cheaper than unpicking it six months later.
Step 3: Import Customers and Suppliers
Do this before any transactions, so every invoice and bill from day one links to a proper contact record.
- Build a clean customer list with at minimum name, email and billing address
- Do the same for suppliers
- Download QuickBooks’ CSV template from inside the software — Sales > Customers > Import, or Expenses > Suppliers > Import
- Map your columns to QuickBooks fields
- Run the import and check the error report
Clean the data first. Trailing spaces, inconsistent capitalisation and near-duplicate names are what makes imports fail or produce two records for one customer. Merge duplicates before importing, not after. Two formatting points that cause most failures: save as UTF-8 so apostrophes and accented characters survive, and use ISO dates (YYYY-MM-DD) so nothing gets read as an American month.
With a handful of contacts, typing them in is faster than wrestling a CSV.
Step 4: Connect the Bank Feed
The biggest single improvement over spreadsheet bookkeeping.
- Banking in the left-hand menu
- Connect account
- Find your bank — QuickBooks covers most UK banks including Barclays, HSBC, Lloyds, NatWest, Santander, Starling and Monzo
- Authenticate through your bank’s open banking flow
- Set the feed start date to your cut-over date, so you do not pull in transactions that belong in the spreadsheet
QuickBooks will suggest categories for each transaction. Review these properly for the first few weeks — the suggestions improve as it learns your patterns, and they are not reliable at the start.
Step 5: Reconcile Before You Trust It
After your first full month or quarter, reconcile before you do anything else with the data.
Go to Accounting > Reconcile and match QuickBooks against the actual bank statement. Every transaction should match, and if the closing balance disagrees, something is missing, duplicated or miscategorised.
Then cross-check against the spreadsheet. Run the same report in both — total sales for the period, say — and confirm they agree. If they do not, find out why before anything goes to HMRC.
This step is not optional. It is the only evidence that the migration worked.
What Does Not Migrate Cleanly
Be realistic about this.
Historical transactions. QuickBooks will not import years of past invoices, bills and payments. Your opening balance journal captures the net position at cut-over; individual earlier transactions stay in the spreadsheet. That is normal and correct.
Custom formulas and dashboards. No equivalent unless you rebuild them as QuickBooks reports. The built-in reporting is strong, but bespoke logic is yours to recreate.
Payroll history. Does not transfer. QuickBooks Payroll starts from the date you activate it, and historical records stay with your old system or provider.
Depreciation schedules. Not imported. You enter current net book value as an opening balance and set depreciation up going forward.
Keep Your Spreadsheets
Legally as well as practically.
Sole traders and partnerships must keep records for at least five years after the 31 January submission deadline of the relevant tax year. Limited companies must keep them for at least six years from the end of the company’s last financial year — note the company period runs from the year end, not a filing deadline.
Your spreadsheets hold the transaction-level records for everything before cut-over, so they are part of that obligation. The sensible approach:
- Save a final version as at the cut-over date
- Store it somewhere secure and backed up
- Mark it read-only, with a note of the period it covers
- Do not touch it again
It is an archive now, not a working document. Keeping it longer than the statutory minimum costs nothing and answers questions years later.
Which Plan, and What It Costs
Two plans are relevant for a sole trader migrating from spreadsheets, and both are MTD for Income Tax ready:
| Sole Trader Plus | Simple Start | |
|---|---|---|
| Standard, ex-VAT | £10/month | £16/month |
| First six months | £1 | £1.60 |
| MTD for Income Tax | Ready | Ready |
| VAT returns | No | Yes |
The deciding factor is VAT, not MTD. Sole Trader Plus cannot file VAT returns at all, so if you are registered or approaching the £90,000 threshold, Simple Start is the floor. Both are single-user with free accountant access.
The introductory offer is 90% off for six months, so the price rises roughly tenfold in month seven — diary month five. Our QuickBooks pricing guide has every tier, and the Sole Trader versus Simple Start comparison goes through the choice.
FAQ
Do I need to be VAT registered to use QuickBooks?
No. It handles invoicing, expenses and reporting regardless. If you are registered, you need Simple Start or above, because the Sole Trader plan cannot submit VAT returns.
Which plan do I need for Making Tax Digital?
For MTD for VAT, Simple Start and above. For MTD for Income Tax, both Sole Trader Plus and Simple Start are MTD ready — QuickBooks labels them as such on its own pages, so this is no longer the open question it was a year ago.
Can I import my old invoices?
Open, unpaid invoices can be imported by CSV, which is useful for debtors at your cut-over date. Paid historical invoices are captured by the opening balance instead. Importing every historical invoice is occasionally possible and rarely worth it.
Is a spreadsheet actually non-compliant?
Not in itself — spreadsheets are acceptable digital records. What is non-compliant is manually copying figures into HMRC’s portal. A spreadsheet plus bridging software is compliant; a spreadsheet plus retyping is not.
What if I am mid-year and already mandated for MTD for Income Tax?
You need the current year’s quarterly updates filed from compatible software, so either back-load from 6 April into QuickBooks or bridge the quarters already passed. The first-year easement means no penalty points on the first four updates, but they still have to be filed.
How long does the whole migration take?
Four weeks of preparation, then a weekend to execute, then one reporting period before you trust the output. The preparation is where the time goes.
Does this apply if I am moving a CRM rather than accounts?
Different job, same discipline. Our guide to migrating from spreadsheets to a CRM covers the contact-data equivalent.
The Bottom Line
Sequence it: cut-over date, opening balances with your accountant, contacts, bank feed, then reconcile a full period against both the bank statement and the old spreadsheet before you file anything.
Two things specific to right now. If your qualifying income is above £50,000 you are already inside MTD for Income Tax, so your cut-over date has to account for quarterly updates due this year — 7 November is the next one. And the first-year penalty easement means a messy mid-year migration will not cost you points, which is the best argument for doing it properly rather than fast.
Then keep the spreadsheet, locked and read-only, for five years after the relevant 31 January, or six years from your company year end. It is an archive, and the day you need it you will be glad it was not tidied away.
Pricing and features correct at time of writing. Plans and capabilities are subject to change — always confirm current details on the provider’s website before purchasing. This article is general information, not tax advice; check your own position with HMRC or a qualified accountant.