The tax control account should tell you, at any point, exactly how much you owe the tax authority and why.
Roll the VAT or sales tax control account forward each period: opening balance, plus output tax on sales, minus input tax on purchases where it is recoverable, minus payments made. The closing balance should equal the amount on the return due but not yet paid. List every reconciling item, such as manual journals, late invoices and corrections, with evidence.
For VAT, the control account (or the combined input and output VAT accounts) collects tax charged on sales and tax reclaimable on purchases. Its balance is the net amount owed to, or due from, the tax authority. For US sales tax, the liability account collects tax charged to customers that must be remitted to each state or local jurisdiction.
Many businesses split the balance into separate accounts for output tax, input tax and the amount owed for the current return. Whatever the structure, the reconciliation proves the same thing: the ledger balance agrees to what has been filed and paid.
Opening balance (owed from the previous period)
+ Output tax on sales this period
− Recoverable input tax on purchases this period (VAT)
− Payments made to the tax authority
+/− Adjustments and corrections
= Closing balance
The closing balance should equal the return for the latest period plus any earlier amounts still unpaid, or minus any refund still due. Build the roll-forward in Excel with each line in its own row and a final check cell that compares the closing balance to the ledger balance:
=ROUND(B8-B10,2)
where B8 is the calculated closing balance and B10 is the ledger balance. It should return zero. See fixing rounding differences in Excel if small differences appear.
Each return figure should trace back to a report from the ledger:
Keep the report you filed from, saved at the time you filed it. Reports rerun later often differ because of back-dated postings.
Reclaimed input tax needs a valid tax invoice from the supplier. Sample the largest input tax amounts each period and check:
For US sales tax, reconcile by jurisdiction. A single liability balance can agree in total while one state is overpaid and another underpaid. Keep a schedule with one row per jurisdiction showing tax collected, tax remitted and the balance, and agree the total to the ledger.
With jurisdiction in column A, tax collected in column C and tax remitted in column D on a transaction list, summarise with:
=SUMIFS(C:C,A:A,F2)-SUMIFS(D:D,A:A,F2)
with each jurisdiction listed down column F. See SUMIFS for accountants.
In the UK, VAT returns are filed with HMRC, generally through Making Tax Digital compatible software, and the input tax rules decide what can be reclaimed. In the US, sales tax is set and collected at state and local level, and there is no input tax reclaim in the same way. Filing frequencies, rates and registration thresholds change and differ by jurisdiction, so check the current rules with HMRC or each state's tax authority.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
The most common causes are invoices back-dated into a filed period, manual journals posted directly to the VAT account, and payments posted to the wrong account.
At least every return period, and ideally every month end so problems are found before the return is due.
Many businesses keep them separate because it makes the return easier to trace. The reconciliation works either way as long as each movement agrees to a report.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.