VAT Return Calculator Template
Calculate your UK VAT Return figures (Box 1-9) from your sales and purchase records. Supports standard and flat rate schemes.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
VAT Calculator
- Standard VAT scheme calculations
- Flat Rate Scheme option
- All 9 VAT Return boxes auto-calculated
- Sales invoice VAT breakdown
What is a VAT Return Calculator?
A VAT Return Calculator is a spreadsheet that takes your sales and purchase records and calculates all nine boxes of your UK VAT Return automatically. Whether you are on the Standard VAT scheme or the Flat Rate Scheme, this template turns invoice data into ready-to-submit figures — no manual calculations, no guesswork.
Common use cases:
- Calculating quarterly VAT Return figures from sales and purchase invoices
- Choosing between Standard VAT and Flat Rate Scheme to see which saves money
- Creating an audit trail of how each VAT Return box was calculated
- Checking VAT calculations before submitting to HMRC
- Tracking VAT on both UK sales and EU/international transactions
When to use this template
- You are VAT-registered and need to submit quarterly VAT Returns
- You want to double-check your accounting software's VAT calculations
- You are considering the Flat Rate Scheme and want to compare
- You need a clear audit trail for HMRC in case of an inspection
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
Standard VAT Scheme Calculations
Enter sales and purchase invoices and the template calculates Boxes 1-9 for the standard VAT method.
Flat Rate Scheme Option
Switch to Flat Rate mode and the template applies your sector percentage to gross turnover instead.
All 9 VAT Return Boxes Auto-Calculated
Output VAT, input VAT, net VAT due, total sales, total purchases — all calculated from your invoice data.
Sales Invoice VAT Breakdown
Log each sales invoice with net, VAT, and gross amounts. The template summarises by VAT rate (20%, 5%, 0%, exempt).
Purchase VAT Reclaim Tracking
Record purchase invoices and reclaimable VAT. Flags non-reclaimable items like client entertaining automatically.
Quarterly Summary Sheets
Separate sheets for each quarter with a year-to-date summary. Perfect for matching to your VAT Return deadlines.
How This Template Helps Your Business
Eliminate Calculation Errors
VAT mistakes are expensive — penalties, interest, and HMRC scrutiny. The template's built-in formulas ensure every box is calculated correctly.
Flat Rate vs Standard Comparison
Not sure which scheme is cheaper? The template lets you model both and see your actual position. Many businesses overpay by staying on the wrong scheme.
HMRC Inspection Ready
Every VAT Return box links back to source invoices. If HMRC asks how you arrived at a figure, the audit trail is crystal clear.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Select your VAT scheme (Standard or Flat Rate) on the cover sheet
Enter your sales invoices on the Sales sheet — date, customer, net amount, VAT rate
Enter your purchase invoices on the Purchases sheet — date, supplier, net amount, VAT amount
Review the VAT Return Summary sheet — all 9 boxes are calculated automatically
Copy the figures to your HMRC VAT Return (or MTD software) and submit
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
VAT Invoice
Professional, HMRC-compliant VAT invoice template. Customise with your branding and business details.
Expense Tracker
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
A/P Ledger
Track money you owe suppliers. Monitor bills received, payments made, and upcoming due dates.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.