How to Switch from Spreadsheets to MTD Software Before April 2026

If your bookkeeping currently lives in a spreadsheet, you are not alone. Millions of UK sole traders still track income and expenses in Excel or Google Sheets. But Making Tax Digital for Income Tax changes what is acceptable from April 2026 — and a plain spreadsheet, without bridging software, will not be sufficient to meet quarterly submission requirements.

This guide walks you through exactly how to make the switch — what to do, in what order, and what not to worry about.

Why spreadsheets alone will not work for MTD

Making Tax Digital requires digital records and digital submissions to HMRC. A spreadsheet on its own does not have the capability to submit quarterly updates — it cannot communicate with the HMRC API. To be compliant, you need either:

1. MTD-compliant software (FreeAgent, Xero, QuickBooks, Sage, or similar) — handles records and submissions in one place
2. A spreadsheet plus bridging software — your spreadsheet does the records, bridging software reads the data and submits to HMRC

For most sole traders, option 1 is simpler, more reliable, and not significantly more expensive. Option 2 makes sense if your spreadsheet is highly customised and you genuinely do not want to change how you work.

Check whether MTD applies to your income level before you start →

Step 1: Export and archive your existing records

Before you do anything else, make a clean archive of your current records.

• Export your spreadsheet as a PDF and as an .xlsx file
• Save a copy of every tax year you have records for, clearly labelled
• Store them somewhere accessible: a dedicated folder in Google Drive, OneDrive, or an external drive

You will not need to import this data into your new software. But you may need to refer to it — for example when completing your End of Period Statement for the current tax year if you switch partway through. Keep it safe and well-organised.

Step 2: Identify your starting point

You do not need to migrate historical data. MTD software only needs to manage your records from the point you start using it.

Decide when your switch date will be:

• Start of the new tax year (6 April 2026) — cleanest option. Your old records cover up to 5 April 2026, new software takes over from 6 April.
• Mid-year switch — possible, but requires more care to avoid gaps or double-counting. If you switch mid-year, note the exact date and make sure your two record systems together cover every transaction without overlap.

For most sole traders, starting from 6 April is the cleanest approach. If you need to be compliant from April 2026, that is also the natural start date.

Step 3: Choose your MTD software

This is the decision that matters most. The main options for UK sole traders:

Software	Best for	Price (paid)
FreeAgent	Self Assessment filers, NatWest/RBS/Mettle customers	Free with qualifying accounts, or £22.80/month
QuickBooks	Invoicing-heavy businesses, freelancers	From £16.80/month
Xero	Accountant-led businesses, complex needs	From £16/month (Starter)
Sage	Growing businesses, existing Sage users	From £15/month

If you bank with NatWest, Royal Bank of Scotland, Ulster Bank, or use Mettle, FreeAgent is free and fully MTD-compliant — start there.

If you want to compare all options side by side: MTD software comparison →

Try FreeAgent free for 30 days — no credit card required →

Step 4: Set up your account

Once you have chosen your software, the setup process typically takes 30–60 minutes:

1. Create your account and enter your business details

• Legal name, trading name, business address
• Business type (sole trader)
• Your accounting period (standard UK tax year: 6 April to 5 April)
• Accounting method (cash basis is the default — see our cash basis vs accruals guide if you are unsure)

2. Connect your business bank account

• Most software connects via Open Banking — you authorise the connection once and transactions flow in automatically
• If you mix personal and business finances, now is a good time to open a separate business account (Mettle is free and comes with FreeAgent)

3. Set up your income and expense categories

• The software will suggest standard categories (sales, office costs, travel, etc.)
• Add any categories specific to your trade if needed

4. Enter your opening balances if switching mid-year

• If you are switching partway through a tax year, you will need to enter cumulative income and expense totals from 6 April up to your switch date
• Use your archived spreadsheet to extract these figures
• Most software has a dedicated section for opening balances or a "prior period" entry

Step 5: Import or reconnect your transactions

From your switch date onwards, transactions will flow in automatically via your bank feed. For the period between 6 April and your switch date (if mid-year), you have two options:

• Manual entry: work through your spreadsheet and enter each transaction into the software manually. Tedious but accurate.
• CSV import: export your bank transactions as a CSV file and import them into the software. Most platforms support this. Check the exact format your bank exports and what your software accepts.

If you are starting from 6 April with no gap, skip this step — your bank feed takes care of everything from day one.

Step 6: Categorise your transactions and reconcile

Once your transactions are in the software, spend time categorising them correctly:

• Match each transaction to the appropriate income or expense category
• Reconcile your software balance against your bank statement — every penny should match
• Flag anything unusual or unclear

Most software learns your categorisation preferences over time — after the first month or two, most recurring transactions will be auto-categorised and you will only need to review exceptions.

Step 7: Submit your first quarterly update

MTD quarterly update deadlines are:

Quarter	Covers	Deadline
Q1	6 April – 5 July	5 August
Q2	6 July – 5 October	5 November
Q3	6 October – 5 January	5 February
Q4	6 January – 5 April	5 May

Before your first quarterly deadline, make sure:

• You have authorised your software to connect to HMRC (usually a one-time process via your Government Gateway account)
• Your income and expense records for the quarter are complete and reconciled
• Your software shows the submission as ready

The submission itself takes less than five minutes. The work is in the bookkeeping — which should be done weekly, not in a rush before each deadline.

Try Xero free for 30 days — full MTD support included →

What you do not need to worry about

You do not need to import historical tax years. HMRC is not asking you to digitise everything you have ever done. Your pre-MTD records stay where they are.

You do not need to be an accountant. MTD software is designed for non-accountants. Categorisation takes a short learning curve — most people are comfortable within a few weeks.

You do not need to do everything at once. Set up your software, connect your bank, and start categorising. You can refine categories, add mileage, and adjust settings as you go. Perfect is the enemy of started.

Bridging software: if you really want to keep your spreadsheet

If your spreadsheet is highly customised and you do not want to change your workflow, HMRC-approved bridging software can transmit your spreadsheet data as MTD submissions. Options include GoSimpleTax, Absolute Tax, and others listed on HMRC's recognised software register.

The drawback: you still need to maintain the spreadsheet meticulously, and the bridging tool needs to read your data in a format it understands. It adds a step to the submission process. For most sole traders, it is more hassle than simply switching to integrated MTD software.

Summary

The switch from spreadsheets to MTD software is not as daunting as it sounds. The practical steps:

1. Archive your existing spreadsheet records
2. Choose a start date (6 April is cleanest)
3. Pick your software and set up your account
4. Connect your bank account for automatic feeds
5. Categorise and reconcile as you go
6. Submit your first quarterly update before the Q1 deadline

The hardest part is the decision to start. Once you begin, most sole traders find the new workflow significantly less time-consuming than spreadsheet-based bookkeeping — especially with automatic bank feeds eliminating manual data entry.

Last updated April 2026. HMRC's list of recognised MTD software is available at gov.uk/guidance/find-software-thats-compatible-with-making-tax-digital-for-income-tax.