Workbook
VAT Record
Keep an in-year UK VAT record of sales and purchases, see output VAT, input VAT and the net amount, and watch the £90,000 registration and £88,000 deregistration thresholds.
Choose Standard 20%, Reduced 5%, Zero 0%, Exempt or Out of scope on each row. VAT and gross are calculated. Quarterly period totals run from a period-end date you set. File and pay through your HMRC VAT account, not through this file.
It is not a VAT return, not Making Tax Digital software, not a filing or payment tool, and not tax advice. It does not support the Flat Rate Scheme calculation, partial exemption or capital-goods schemes.
£18.99
Listed price. 20% off on Etsy until 20 December 2026.
What’s included
- Sample workbook and a blank copy
- Output VAT, input VAT and the net amount
- Standard 20%, reduced 5%, zero, exempt or out of scope on each row
- A watch on the £90,000 registration and £88,000 deregistration thresholds
- Quarterly totals from a period-end date you set
- Official figures from GOV.UK, checked on 17 November 2026
- Works in Excel and Google Sheets
The picture shows the sample workbook. The figures in it are examples, not a customer story and not a promise of your tax bill.
Rates and thresholds in the download were taken from GOV.UK as at 17 November 2026. Check they are still current before you rely on a figure.
Not tax advice. These are record-keeping tools that give estimates, not professional advice.