GST / VAT Return Reconciliation
Match your purchase register against what your suppliers actually filed, and find the input tax credit you are about to lose.
Nothing you paste leaves this page. Parsing and matching happen in your browser.
How it works
Input tax credit generally depends on your supplier having filed the invoice, not merely on your holding it. An invoice in your books that never appears in the filed data is credit at risk — and in most regimes the deadline for fixing it is short and unforgiving.
Three exception types matter. Credit at risk is in your books but not filed. Unclaimed credit is filed by the supplier but missing from your books, which means you are giving up money you are entitled to. Amount mismatches share an invoice number but disagree on value, and are usually a data-entry error on one side or the other.
Credit at risk = Σ tax on invoices in your books with no filed counterpart
- Purchase register — invoices you have recorded and intend to claim credit on
- Filed data — the statement of invoices your suppliers actually declared
- Credit at risk — claimed by you, not declared by the supplier
Worked example
A register of 8 invoices against filed data showing 7
Inputs
Results
One invoice at risk and one you have not claimed. Both are worth chasing before the filing deadline — one costs you money, the other saves it.
Frequently asked questions
What format should I paste?
Copy straight out of a spreadsheet, or paste CSV. A header row is optional — columns are identified by their headings when present and by their content when not. Dates, references and amounts are detected automatically, and amounts may carry currency symbols, thousands separators or accounting parentheses.
What should I paste for the tax amount?
The credit you are claiming on each invoice, not the invoice total. Paste the invoice number and the tax amount, and both sides will compare like with like.
What do I do about credit at risk?
Contact the supplier and ask them to file or amend. Most regimes give a limited window, after which the credit is permanently lost — so the value of finding it early is the whole point of running this monthly rather than annually.
Why would a supplier file an invoice I have not recorded?
Usually an invoice that never reached you, or one that was received and not entered. Either way it is credit you are entitled to and are not claiming, which is worth as much as the credit at risk.
Is my ledger data uploaded anywhere?
No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.
More in Reconciliation
Two-List Matcher
Paste any two lists of transactions and find what does not line up — matched pairs, exceptions on each side, and duplicates within either.
ReconciliationBank Reconciliation
Match your cash book against the bank statement and produce a proper reconciliation — outstanding items, unrecorded charges and adjusted balances on both sides.
ReconciliationInvoice vs Payment Reconciliation
Match payments received against invoices raised, and find the short payments, overpayments and unallocated cash sitting in your receivables.
ReconciliationPayment Gateway Payout Reconciliation
Reconcile what the gateway actually paid you against what your orders say it should have — with fees, refunds and missing settlements itemised.
ReconciliationDuplicate Payment Detector
Scan a payment run or a full year of ledger for payments made twice — the same supplier, the same amount, days apart.
ReconciliationAR / AP Aging Report Builder
Turn a flat list of open invoices into a proper aged report — bucketed, totalled, and sorted by how long the money has been outstanding.