UK VAT Tracker for Excel

Product description

Your VAT records and returns, sorted, every quarter. Log your sales and purchases, and the VAT Tracker does the rest: it works out the VAT on every line, sorts it into the right quarter and fills in all 9 boxes of your VAT return. No more spreadsheets full of guesswork.

What you get

- Blank workbook, ready for your own records

- Filled-in example workbook, so you can see how it works

- Instant download Built for real small businesses

- Enter amounts as Net or Gross, and the VAT is calculated for you

- Every UK VAT rate: 20%, 5%, 0%, Exempt and Outside scope - Standard accounting or Flat Rate Scheme, invoice or cash basis

- Automatic deadlines, colour-coded as they approach

- Dashboard with charts and a £90,000 threshold check See which VAT scheme suits you.

The built-in comparison shows whether the Flat Rate Scheme or standard accounting would have cost you less.

Who it's for?

Sole traders, freelancers, online sellers and small UK businesses registered for VAT.

Frequently asked questions

• Does it submit my VAT return to HMRC? No. It keeps your records and prepares your figures. To submit under Making Tax Digital, you'll use MTD-compatible bridging software, and there are options listed on GOV.UK.

• Do I need Excel? It's designed for Microsoft Excel and also imports into Google Sheets.

• Does it work for monthly or annual VAT returns? It's built for quarterly returns, which most small businesses use.

• Is this tax advice? No. It's a record-keeping tool and isn't affiliated with HMRC.

• If you're unsure about your VAT, check GOV.UK or speak to an accountant.