MTD Made Simple: VAT Spreadsheet | VAT-Registered Sole Trader | Excel & Google Sheets 2026/27

A professionally designed MTD for Income Tax bookkeeping spreadsheet for VAT-registered UK sole traders.

Includes full VAT tracking: VAT rate dropdown on income and expenses, net amount auto-calculated, and a VAT Tracker tab showing your quarterly VAT position.

Also includes everything needed for MTD for Income Tax quarterly updates: your cumulative year-to-date totals calculate automatically in the Quarterly Summary tab, ready to copy into bridging software and submit to HMRC.

One-time purchase. No monthly fees. Works in Excel and Google Sheets.

Note: This spreadsheet tracks your VAT position for your records. It is not bridging software for MTD for VAT. You still need to submit your VAT return through HMRC-approved software such as VitalTax.

Works with all major bridging software

MTD Made Simple includes a built-in Submission Helper tab. It shows your quarterly cumulative totals mapped to the exact field names used by VitalTax, AbraTax, suiteSheets, and 123 Sheets. Set up your bridging software once and your cell mappings are saved for every future quarter.

Compatible with:

VitalTax (vitaltax.uk), Excel add-in, £30 + VAT per year

AbraTax (abratax.co.uk), Excel and Google Sheets, currently free in beta

suiteSheets (suitesheets.co.uk), Excel and Google Sheets, £20 per tax year

123 Sheets (123sheets.com), Excel, £19.50 + VAT per year

The VAT version also includes a VAT TRACKER tab for monitoring your quarterly VAT position. VitalTax and 123 Sheets both support MTD for VAT submissions as well as MTD for Income Tax.

MTD Made Simple handles your records. Bridging software handles the submission. Together they replace Xero for under £40 per year.