Free MTD Spreadsheet Template for Excel & Google Sheets
Quick Answer
You can use our free, HMRC-compliant MTD spreadsheet template to track your income and expenses, then submit to HMRC with Abridge bridging software when each quarter ends.
Preparing for Making Tax Digital (MTD) does not mean you have to buy expensive software. A well-structured spreadsheet is valid digital record-keeping — you only need bridging software when it is time to submit to HMRC.
Get the template
Download the MTD spreadsheet template — works in Excel and Google Sheets. Create a free account to copy the template and connect to Abridge when you are ready to file.
The template includes:
- Pre-labelled HMRC income and expense categories
- Quarterly total rows for MTD submission
- A layout designed to map cleanly to Abridge cell mapping
What makes a spreadsheet MTD compliant?
HMRC requires digital records that capture:
- The date of each transaction
- The amount
- The category (e.g. travel, rent, sales)
You cannot type final figures manually into an HMRC web form — bridging software transmits them digitally.
How to use the template
- Copy the template into Excel or Google Sheets via your Abridge account.
- Log transactions as they happen — the sheet calculates quarterly totals.
- Map cells in Abridge once, then submit each quarterly update to HMRC.
- File your Final Declaration at year-end through the same bridge.
Submit with Abridge
When the quarter ends, open Abridge (web, Excel add-in, or Google Sheets add-on), review your mapped totals, and submit to HMRC. No accounting software migration required.
Ready to comply with MTD?
Abridge makes it easy to submit your spreadsheet to HMRC.
Was this article helpful?
Ready to comply with MTD?
Abridge makes it easy to submit your spreadsheet to HMRC.