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 practicesGlobal 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
$99$1,54994% off
Buy the global library · $99What's inside


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.
