Best MTD Software for Sole Traders Who Use Spreadsheets
If you currently manage your accounts in Excel or Google Sheets, MTD introduces a challenge: spreadsheets alone can't submit data directly to HMRC. Here's how to handle the transition — whether you want to keep your spreadsheet or move to a dedicated accounting app.
Last updated:
Why Spreadsheet Users Need to Consider Their Options Now
If you've been managing your self-employed accounts in a spreadsheet and filing Self Assessment manually each year, MTD for Income Tax requires a change. From April 2026, if you're in scope, every quarterly submission must go through HMRC's digital API — something a standalone spreadsheet cannot do.
You have two main routes to compliance:
Option A: Keep your spreadsheet
Continue using Excel or Google Sheets for record-keeping, but add bridging software to handle quarterly submissions to HMRC.
Option B: Switch to accounting software
Move your records to a full MTD-compatible accounting package that handles both record-keeping and submissions natively.
Both are valid. The right choice depends on how many transactions you handle, how comfortable you are with your current spreadsheet, and whether you want features like bank feeds and invoicing.
Full guide: Spreadsheets and MTD explainedBridging Software: A Brief Explainer
Bridging software is a class of MTD-compatible tool that connects your existing records (usually a spreadsheet) to HMRC's MTD API. At the end of each quarter, you import your income and expense totals into the bridging tool, which formats and submits the data to HMRC on your behalf.
Bridging tools are typically simpler and cheaper than full accounting platforms — they do one job (submit to HMRC) without replacing your record-keeping method. Key things to look for in bridging software:
- HMRC recognition specifically for MTD Income Tax (not just VAT)
- Compatibility with your spreadsheet format (Excel, CSV, Google Sheets)
- Clear submission confirmation and reference numbers
- Support for multiple income sources if you have both self-employment and property
The bridging software market for MTD for Income Tax is still developing. Check HMRC's recognised software list for the most current approved options.
Full Accounting Apps That Work Well for Ex-Spreadsheet Users
If you decide to transition away from spreadsheets, these four platforms are the most widely used MTD-compatible accounting applications for UK sole traders. All are HMRC-recognised for MTD Income Tax.
Xero
From £16/month (Ignite plan). No free plan. 30-day free trial.
Smart, cloud-based accounting for growing businesses
Best for: Growing sole traders
- HMRC-recognised MTD software
- Strong mobile app
- Extensive integrations (800+ apps)
QuickBooks
From £10/month (Sole Trader plan). No free plan. 30-day free trial.
Powerful accounting with MTD built in
Best for: Sole traders wanting comprehensive features
- HMRC-recognised
- Feature-rich platform
- Good reporting and dashboards
Sage
Free tier available (Sage Sole Trader). Paid plans from £7/month. No bank account required for free access.
UK-built accounting with a genuinely free tier for sole traders
Best for: Sole traders wanting a free HMRC-recognised option
- Genuinely free HMRC-recognised tier for sole traders
- UK company with UK-based phone and chat support
- No bank account required to access free plan
FreeAgent
From £19/month (sole trader, direct). Free with qualifying NatWest, RBS, Ulster Bank, or Mettle business accounts.
Accounting built specifically for freelancers and sole traders
Best for: Freelancers and sole traders who want all-in-one MTD + Self Assessment
- Purpose-built for freelancers and sole traders
- Free with NatWest, RBS, Ulster Bank, or Mettle business accounts
- Self-assessment filing included in all plans
How to Transition from Spreadsheets to MTD Software
Switching to accounting software doesn't mean losing your historical data. Here's a practical step-by-step approach to making the transition smoothly:
- 1
Choose your software
Select an HMRC-recognised platform and take advantage of a free trial to test the interface before committing.
- 2
Export your historical data
From your spreadsheet, prepare a CSV export of your transactions with columns for date, description, amount, and category. Most accounting apps provide an import template to help structure this.
- 3
Set up your opening balances
Enter your bank balance and any outstanding invoices at the date you start using the new software. Many platforms have an opening balance wizard to guide you through this.
- 4
Connect your bank feed
Once your account is set up, connect your bank account to import transactions automatically. This replaces the manual entry you were doing in your spreadsheet.
- 5
Register with HMRC for MTD
Once your software is set up, authorise it to connect to HMRC on your behalf. Your software will guide you through the HMRC authorisation process.
Learn More About Spreadsheets and MTD
Our detailed guide covers bridging software, how the submission process works, and whether sticking with your spreadsheet is the right choice.