Accountio / Templates / VAT reconciliation

VAT reconciliation template: control account, 9-box check and error corrections

Prove each VAT return to the books: reconcile the VAT control account every quarter, check all nine boxes to the ledger, tie the accounts to the four returns and work out how to correct earlier errors.

UK practices
$15
Files
3, Word and Excel
Last checked
November 2026
Buy the pack · $15
Global library · 110 packs

Get this pack and 109 more for $99

VAT reconciliation · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What's inside

VAT reconciliation workbook, first page
VAT reconciliation workbook
VAT reconciliation review checklist, first page
VAT reconciliation review checklist

First page of each document. 3 files, Word and Excel.

What a VAT reconciliation involvesDocument in the pack
Keeping a VAT account that links the records to each returnVAT Notice 700/21
✓
VAT reconciliation workbookControl account by quarter, agreed to the trial balance and to box 3 less box 4
Getting every box on the return rightVAT Notice 700/12
✓
VAT reconciliation workbookBoxes 1 to 9 per ledger and per return, with the box 3 and box 5 arithmetic checked
Spotting swapped figuresVAT Notice 700/12
✓
VAT reconciliation workbookFlags box 8 above box 6 and box 9 above box 7
Tying the accounts to the year's returns
✓
VAT reconciliation workbookTurnover to box 6 and purchases to box 7, with each reconciling item listed
Correcting errors on the next return or telling HMRCVAT Notice 700/45
✓
VAT reconciliation workbook£10,000 and 1% of box 6 limits up to £50,000, and the box 1 or box 4 figure
Correcting within the 4-year time limitVAT Notice 700/45
✓
VAT reconciliation workbookTime limit worked out for each error, with the later start for under-claimed input tax
Moving figures by digital linkVAT Notice 700/22
✓
VAT reconciliation review checklistMaking Tax Digital check before the return goes in
A second person signing off the reconciliation
✓
VAT reconciliation review checklistSource figures, boxes, control account, annual tie-in and errors

Who it's for

UK practices that prepare VAT returns for clients, and finance teams that reconcile their own VAT at the year end.

Last checked

Checked against HMRC VAT Notices 700/12, 700/21, 700/22 and 700/45 in November 2026.