Reconciling your VAT return without a spreadsheet marathon
Updated 2026-08-01 · 6 min read
Filing pain is almost never a tax knowledge problem. It is a data shape problem: figures live in different places, in different states, with no single record of what was issued and when.
The four numbers to tie out
A return reconciles when these four agree and you can explain any difference in one sentence.
- Total taxable supplies for the period, by tax category
- Output VAT charged, computed from the same line data
- Credit notes issued in the period, netted against the original supply
- Cash received, which should never be used to derive the VAT figure on accrual
Credit notes are where returns break
A credit note that is not linked to its original invoice is invisible to reconciliation. Every credit note should carry a hard reference to the invoice it corrects, mirror its tax categories, and never be issued by editing the original.
Editing an issued invoice destroys the audit trail and is the fastest way to fail a review.
Making it a five-minute job
When invoices, payments and credit notes live in one structured store, the return becomes a query rather than a compilation exercise. In BusinessPilot AI you can ask the copilot for output VAT for a period and get the figure alongside the invoices that produced it — and export a ledger CSV that ties to it line by line.