TaxCalc bookkeeping spreadsheet transaction templates for MTD

Article ID: 3202
Last updated: 26 May, 2026

To assist you with complying with digital links for MTD reporting, we have produced spreadsheet templates for recording transactions and summarising totals. The totals can then be imported by VAT Filer (for quarterly MTD VAT return submissions) and by MTD Quarterly Filer (for quarterly MTD for Income Tax updates).

The following example bookkeeping transactions spreadsheets are available for businesses to use as a template and adapt as necessary for specific needs:

For use with VAT Filer:

TaxCalc MTD VAT Transactions Template (Net entry first)

TaxCalc MTD VAT Transactions Template (Gross entry first)

For use with MTD Quarterly Filer:

TaxCalc MTD Template 2025 (IT only)

TaxCalc MTD Template 2025 (Property Landlords)

Since MTD for income tax totals have to be submitted an a cumulative basis, whereas VAT is on a quarterly basis, there is no combined spreadsheet for IT and VAT. Therefore we suggest either combining the use of both spreadsheets or adapting one to fulfil both requirements.

Article ID: 3202
Last updated: 26 May, 2026
Revision: 28
Views: 23433
This article was:  


Also listed in
folder Tax Return Production
folder Tax Return Production -> MTD Quarterly Filer