● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Taxes & VAT›VAT Tracker Spreadsheet
Hero image of the VAT Tracker Spreadsheet, showing the full workbook at a glance
TAXES & VAT

VAT Tracker Spreadsheet

If you are VAT registered, every sale and purchase carries a question: what rate applies, how much VAT did you collect, and what will you owe when the quarter ends? This vat tracker spreadsheet answers all of it in one workbook, with the nine box return laid out ready to copy.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know what you owe HMRC before the quarter ends

VAT gets stressful when the numbers only come together at the deadline. This tracker keeps them together all quarter instead. You set your business name, VAT number, scheme and quarter start date on Start Here, and the quarter end and return due date fill themselves in. From there, every sale and purchase you log updates what you have collected, what you can reclaim, and what you will owe.

On the Sales Log, each line takes a date, invoice number, customer, item, net amount and VAT rate, and the VAT and gross total are worked out for you. Purchases work the same way, with the VAT you paid becoming your input VAT. The VAT Rates tab shows which rate goes on which kind of sale, with examples, and breaks your sales down by rate straight from the log.

The VAT Return tab is the heart of the workbook: all nine boxes laid out, from output VAT in Box 1 through to the net VAT you owe in Box 5, ready to copy into your HMRC return or Making Tax Digital software. On the Flat Rate scheme, it also shows both schemes side by side so you can compare. The Quarterly Summary keeps all four quarters together with a chart of net VAT.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the workbook into your own Google account
  • BLANK Excel workbook, clean and ready for your own numbers
  • EXAMPLE Excel workbook filled with sample data, so you can see how everything works first
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files delivered as an instant download, with no ZIP to unpack

Good to know

  • Runs in Microsoft Excel and in free Google Sheets, with nothing to install
  • Works on your computer, tablet and phone
  • Prepares the nine box figures; filing itself happens with HMRC
  • Built for UK and EU small business owners who are VAT registered
  • A record keeping tool, not tax advice; check current HMRC guidance before filing

Questions about this template

The things buyers ask us most.

Does this file my VAT return for me?

No. The tracker prepares the nine box amounts for you, checked against your own sales and purchase logs, ready to copy into your HMRC return or your Making Tax Digital software. The actual filing still happens with HMRC, but you arrive at that page with the figures already worked out.

Does it work for the Flat Rate scheme?

Yes. Pick Flat Rate as your scheme on Start Here and the VAT you owe switches to the flat rate amount, worked out from your gross sales. The VAT Return tab also shows the standard and Flat Rate figures side by side, so you can compare the two before you decide anything.

What if I sell at more than one VAT rate?

That is exactly what this tracker is built for. Each sale and purchase line carries its own rate, standard, reduced or zero, and the VAT is worked out line by line. The VAT Rates tab breaks your sales down by rate, so you can check the split before the return goes in.

Is this tax advice?

No. This tracker is a planning and record keeping tool that organises your figures and does the arithmetic. VAT rules, rates and thresholds change over time, so check the current HMRC guidance and speak to a qualified professional before you file a return or change your VAT scheme.

More in Taxes & VAT

All templates in this category →

Three more workbooks from the same shelf.

Freelancer Tax Tracker

Log every payment and see what to set aside for tax each quarter.

$6.99 $2.80
View on Etsy
Self Employed Tax Tracker

Income, sales tax, deductions and quarterly estimates in one calm year-round file.

$7.50 $3.00
View on Etsy
Receipt Tracker Spreadsheet

Every receipt logged once, missing ones listed, and a tax page ready for your accountant.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00