UK VAT Record Spreadsheet | In-Year Sales Purchases and Threshold Tracker
NowPrice:$20.77
Original Price: $25.97
20% off
Sale ends on December 20
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
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.
What you get
• SAMPLE and BLANK Excel workbooks
• Instructions, Dashboard, Settings, Sales, Purchases, VAT summary, Rates and dropdown lists
• Choose Standard 20%, Reduced 5%, Zero 0%, Exempt or Out of scope on each row — VAT and gross are calculated
• Quarterly period totals from a period-end date you set, plus a threshold watch
• Official figures from GOV.UK, checked 17 November 2026: standard 20%, reduced 5%, zero 0%, registration threshold £90,000, deregistration threshold £88,000, and scheme-join figures noted on the Rates sheet
How to use it
1. On Settings, enter your name, scheme and the end date of your first VAT period. Later periods are calculated in three-month steps to the month-end.
2. Log sales and purchases excluding VAT, then choose the VAT rate.
3. Read the Dashboard and VAT summary. File and pay through your HMRC VAT account, not through this file.
4. Check current rates, thresholds and recovery rules on GOV.UK.
Google Sheets: use File → Import → Upload. Core formulas use SUM, SUMIFS, IF, MIN, MAX, ROUND and SEARCH. Excel sheet protection often does not transfer — re-protect the Rates and workings sheets in Sheets if you want to. After importing, change one figure and confirm the Dashboard updates.
What this is not
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. Some costs may not carry recoverable VAT. If you are unsure, speak to a qualified accountant.
Disclaimer: This is a record-keeping and planning tool. Figures are estimates based on the amounts you enter and on HMRC rates published on GOV.UK as at 17 November 2026. It is not official HMRC or GOV.UK software, not tax, legal or financial advice, and not a substitute for a qualified accountant or for filing your Self Assessment return (or a VAT return) with HMRC. You are responsible for checking that rates, thresholds, dates and your own figures are current and correct. April Sixth is a trading name, not a government body.
Sources (checked 17 November 2026): https://www.gov.uk/vat-rates · https://www.gov.uk/register-for-vat · https://www.gov.uk/how-vat-works/vat-thresholds
AI-assistance disclosure: This listing text and the spreadsheet were produced with assistance from AI tools, then reviewed, edited and tested by a person. Official rates and dates were checked against GOV.UK (17 November 2026) and the formulas were recalculated independently. This is not official HMRC software and is not tax advice.
File format: Microsoft Excel .xlsx (SAMPLE and BLANK). Instant digital download. No physical item will be sent.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
UK Employed Plus Side Hustle Tax Tracker Spreadsheet 2026/27 | Self Assessment
Sale Price $16.40
Original Price $20.50
-
Digital download
UK CIS Tax Spreadsheet for Subcontractors 2026/27 | Trades CIS Deduction & Tax Estimator
Sale Price $20.77
Original Price $25.97
-
Digital download
UK Landlord Rental Income Spreadsheet 2026/27 | Finance-Cost Tax Reducer
Sale Price $20.77
Original Price $25.97
-
Digital download
UK Tradesperson Job and Tax Bundle 2026/27 | CIS, Mileage and Invoice Log
Sale Price $27.34
Original Price $34.17