MTD for Excel: Can I Use Spreadsheets for Making Tax Digital?

If you have been using Excel to manage your business finances for years, the thought of Making Tax Digital (MTD) might feel overwhelming. You might be wondering if you are forced to abandon your trusted spreadsheets and learn a completely new system.

The good news is that you can keep using Excel. HMRC fully supports spreadsheets for MTD, provided you follow one specific rule: you must submit your data using a digital link.

What is a Digital Link?

A digital link means that data is transferred electronically between software programs without manual intervention.

To create a digital link from Excel to HMRC, you need to use bridging software.

How Bridging Software Works with Excel

Bridging software acts as a secure tunnel between your Excel spreadsheet and HMRC's systems. It reads the final totals from your spreadsheet and sends them directly to HMRC in the correct format.

Here is how the process usually works:

1. Keep using Excel: You continue recording your daily income and expenses in your spreadsheet exactly as you do now.
2. Calculate your totals: At the end of the quarter, your spreadsheet calculates your total income and expenses.
3. Connect the bridge: You open your bridging software (this might be a web portal or an Excel add-in).
4. Link the cells: You tell the bridging software which cells in your spreadsheet contain your final totals.
5. Submit to HMRC: You click a button in the bridging software to securely send those totals to HMRC.

Why Excel is Still a Great Option

For many sole traders and landlords, full accounting software like Xero or QuickBooks is overkill. It can be expensive, complex to learn, and full of features you will never use.

Excel gives you complete control over your data. By pairing Excel with simple, low-cost bridging software, you stay compliant with MTD without changing how you work.

Getting Your Spreadsheet Ready

You do not need to completely rebuild your spreadsheet for MTD, but you should ensure it is organized. Make sure you have clear summary cells that calculate your total income and total expenses for the quarter. These are the numbers your bridging software will need to read.