Free MTD VAT spreadsheet templates for Excel

ANNA’s free templates for VAT filing

We created a collection of Making Tax Digital (MTD) spreadsheet templates to make calculating and submitting via our VAT bridging tool easy. Sign up below to get all three VAT templates:

  • Standard (accrual) VAT
  • Cash basis
  • Flat rate

Brought to you by ANNA

The app that makes MTD a doddle

HMRC compliant
We are HMRC-recognised with MTD integration available to all our VAT customers.
Digital records, made easy
ANNA lets you record VAT with all your sales and expenses as you go
File VAT from the app
ANNA calculates your VAT automatically. Filing to HMRC with the tap of a button

Spreadsheets are great, but ANNA is better!

MTD Self Assessment

Let Auto Accountant handle it for you, automatically.

Free

Present box

Get your 2025/26 Self Assessment prepared and filed for free as well!

Limited time offer

Get started
  • MTD updates prepared automatically and ready to file quarterly
  • Year-end Self Assessment filed – submit your final declaration to HMRC
  • 2025/26 Self Assessment filed for free – connect your HMRC account to unlock
  • Auto Accountant takes care of your bookkeeping
  • 24/7 Auto-Accountant support – jargon free answers to any tax queries
  • Automatic VAT Return calculation and direct filing with HMRC
  • Invoicing with card payments so you get paid faster
  • Personalised tax calendar for your business
  • Easily pay 1 employee through payroll with automated PAYE and NIC’s

Automate your VAT Return calculation

You can set up ANNA Business Tools in a jiffy, and then you’ll be ready to file VAT Returns, do your bookkeeping, send invoices and store your documents with our MTD-friendly set of tools recognised by HMRC.