About Services Tools Blog Contact us

VAT Return Exception Review

Checks a UK VAT return export for wrong rates, figures in the wrong boxes, missing evidence and later Xero edits, then hands over a correction list with the effect on each box.

  • Accounting & Reconciliation
  • Professional services
  • Pipeline
  • Productised
  • Local/private
  • 2026

The problem

The Xero totals can add up while the VAT treatment of individual lines is wrong. Those errors only show up in a line-by-line review. And edits made after a draft return are easy to miss.

What it does

A reader opens the return workbook and checks that the boxes tie together, that rates multiply out correctly, and for invoice gaps and suppliers that appear under more than one rate. It stops if those checks fail. Later steps check completeness, VAT charged, VAT reclaimed and whether it can be reclaimed, and write a worklist showing the effect on each box. A separate read-only check lists records changed since a chosen date. Nothing is posted back to Xero.

Outcomes

  • A list of wrongly treated rows, with amounts, goes beyond a totals check.
  • The review stops when the workbook fails the arithmetic checks.
  • A list of changes since a date shows later Xero edits before the return is filed.
  • Each correction is stated as its effect on a box, ready for an accountant.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

VAT return gate 1 Jan–31 Mar 2026

Box 1 output tax
£18,420
declared
Box 4 input tax
£6,115
declared
Box 5 payable
£12,305
whole pounds
Box 6 turnover
£92,100
declared
Preset quarter Loaded

Pell & Alden Ltd

VAT 214 5836 90 · three sheets · 148 lines

Output sales, input purchases, box summary. No file upload.

Review
Ready on the loaded quarter
Arithmetic gate Passed
CheckRuleResult
Box 3 equals Box 1 plus Box 2A01Pass
Box 5 equals Box 3 minus Box 4A02Pass
Box 6 ties back to the output sectionsA05Pass
Box 7 ties back to the input sectionsA06Pass
Each row rate is within 2p of the sectionA08Pass
Gross equals net plus VAT on every rowA09Pass

Ledger changes

Read only

Pulled after the draft return. Nothing is written back.

Records since 4 March
3
2 edited · 1 created
Delta
WhenRecordKindState
6 Mar 2026SI-24018 Linden & Holt GmbHSales invoiceEdited
11 Mar 2026SI-24022 Marston Civic HallSales invoiceEdited
18 Mar 2026Bank 4421 card settlementBank lineCreated
JSON delta
{ "since": "2026-03-04", "edited": ["SI-24018", "SI-24022"], "created": ["bank-4421"] }

Correction worklist

Ready for the accountant
Box 1 movement
+£57.28
Box 4 movement
+£15.28
Payable
+£42.00
Cash effect of the set
Box impact not posted
Correction Box 1 Box 4 Box 6 Box 7 Cash
Linden & Holt to zero-rated income 0.00 0.00 +1,840.00 0.00 0.00
Quayline Software to reverse charge +57.28 +57.28 +286.40 0.00 0.00
Reed Rooms out of the return 0.00 −42.00 0.00 −210.00 +42.00
Net +57.28 +15.28 +2,126.40 −210.00 +42.00

Turnover is light by £2,126.40. Only the entertainment line changes the cash payable. The correction file is for the accountant. The ledger is not updated from here.

How it works

  1. Read the return workbook without a spreadsheet application.
  2. Stop unless the box totals, section totals and each row's rate calculation add up.
  3. Flag missing evidence, costs that cannot be reclaimed and suppliers on the wrong rate.
  4. Make a read-only list of Xero rows changed since a given date.
  5. Write a findings list and a correction worklist with the effect on the boxes.

Pipeline

flowchart LR
  Book[Return workbook] --> Gate[Arithmetic gate]
  Gate --> Rates[Rate and evidence checks]
  Delta[Xero changes] --> Find[Exception list]
  Rates --> Find
  Find --> Fix[Correction worklist]