Excel workbook previewUK VAT Return Workings Template (9 Boxes)
3 free downloads per account. Just your email and a 6-digit code.
About this template
VAT return workings are the schedules behind the nine figures a business submits to HMRC each period. A reviewer, an auditor or HMRC will ask how each box was built and whether box 5 agrees to the VAT control account in the ledger. This workbook gives a UK company one place to list its sales and purchase documents, its adjustments and its corrections, and to see the return build itself before it is submitted through Making Tax Digital software.
Every sales and purchase row carries a VAT treatment, and formulas route the VAT and net values into boxes 1 to 9 as described in HMRC VAT Notice 700/12, including reverse charge, postponed import VAT and the Northern Ireland boxes. An adjustments sheet applies the section 6.6 error correction limits, and a control account sheet agrees box 5 to the ledger. The worked example is an invented Leeds manufacturer's quarter to 30 September 2026.
Who it is for
The financial accountant or finance manager of a UK company who has to prepare and evidence the quarterly VAT Return and was asked for workings that tie to the ledger.
What is inside
- 9-box VAT Return built by formula from the ledgers, with box definitions from VAT Notice 700/12 section 3
- Sales sheet with 11 worked documents and 24 blank rows; Purchases sheet with 13 worked items and 24 blank rows
- 7 sales and 9 purchase treatments, including reverse charge, postponed import VAT, blocked VAT and Northern Ireland goods
- Adjustments sheet with bad debt relief and error corrections, plus the section 6.6 test of whether an error may go on the return
- 8 live checks: payment or repayment, box arithmetic, unknown treatments and dates outside the period
- VAT control account reconciliation of box 5 to the ledger, with sign-off
- Settings sheet with the due date by formula and VAT rates as dated input cells
How to use it
Enter the VAT period on the Settings sheet and check the rates, then list every sales and purchase document with its treatment.
Files
- XLSXuk-vat-return-workings-template.xlsx26 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What goes in box 6 of the VAT Return?
VAT Notice 700/12 says box 6 is the total value of sales and other outputs excluding VAT. It includes zero rated, reduced rate and exempt supplies, exports, reverse charge supplies and the box 8 figure. It excludes things such as capital introduced, loans, dividends, gifts of money and insurance claims. In this workbook a sales row marked outside the scope is left out of box 6.
When is a VAT Return due?
HMRC says the return and payment are usually due 1 calendar month and 7 days after the end of the VAT period, so a quarter ending 30 September is due by 7 November. Businesses on the Annual Accounting Scheme have different dates. The Settings sheet works out the date from the period end.
Can I correct an earlier VAT error on my current return?
Under section 6.6 of VAT Notice 700/12, errors from the previous 4 years can be corrected on the current return if the net value is GBP 10,000 or less, or up to GBP 50,000 where it is not more than 1% of box 6. Larger errors, and deliberate errors, are notified to HMRC separately. The Adjustments sheet runs this test for you.




