Reconciliation should explain differences, not hide them
GST reconciliation compares accounting records with filed returns and portal statements, then documents why they differ. Its purpose is to support correct reporting and eligible input tax credit. A larger credit figure is not automatically a better outcome: claiming unsupported credit can create a liability, while overlooking an eligible invoice can increase cash tax payments unnecessarily.
The practical question is whether every material amount has an explanation and a responsible person. A spreadsheet that matches annual totals but ignores duplicate invoices, credit notes or wrong tax heads provides limited assurance. Reconciliation should leave an evidence trail from each exception to its eventual accounting and return treatment.
Start with a controlled set of source records
Collect the purchase register, sales register, debit and credit notes, relevant GST statements, filed return copies and supporting ledgers for the same reporting period. Keep the original exports unchanged. Record the download date, period, GSTIN and source of each file so a reviewer can distinguish an initial download from a later version.
Include opening unresolved items rather than starting each month with an empty exception list. An invoice reported by a supplier in a later period may relate to an earlier purchase. Without that carry-forward record, the team may either overlook it again or claim the same document twice.
- Use one GST registration and reporting period at a time.
- Keep taxable value and each tax head in separate columns.
- Preserve original invoice references alongside any normalised matching key.
- Identify amendments and credit notes separately from original invoices.
- Reconcile the exported register total with the accounting ledger before matching.
Match documents before comparing totals
A matching key normally combines supplier GSTIN, document type, invoice reference and date, supported by taxable value and tax amounts. Normalising spaces or letter case can help identify likely matches. It should not erase genuine differences, such as two documents from different years carrying the same reference.
Use exact matches first, followed by a separate review of probable matches. A tolerance for rounding should be documented and limited. It should not cause an invoice with an incorrect GSTIN, material tax difference or different supply to be accepted automatically. Preserve both original values in the working file.
Each match should produce a clear status: matched, books only, portal only, value mismatch, tax-head mismatch, duplicate or pending investigation. These categories make follow-up specific. A single label such as mismatch leaves the reviewer unable to tell whether the issue requires supplier action, a ledger correction or an eligibility decision.
Review purchases against GSTR-2B
GSTR-2B is an auto-drafted ITC statement used when preparing the relevant credit disclosures in GSTR-3B. The GST portal's GSTR-2B FAQs explain its role. Treat it as a reconciliation source rather than a replacement for invoices, receipt evidence and the legal review of credit eligibility.
A document appearing in the statement may still require an eligibility adjustment. Conversely, a purchase recorded in the books may need supplier follow-up before it can be considered for credit under the applicable conditions. Do not claim every portal amount or treat every unmatched book entry as permanently lost without investigating.
Where the Invoice Management System applies, include the relevant document actions and current portal guidance in the review. Keep evidence of actions taken and use the appropriate generated or recomputed statement for the return. Avoid relying on an old download when subsequent portal actions have changed the relevant position.
Separate ordinary purchases from special categories
Imports, reverse-charge transactions, input service distributor credits and other special categories need their own supporting records and review. A supplier-invoice matching routine alone cannot establish the full credit position. Build separate schedules where necessary, and bring their reviewed amounts into the return reconciliation without double counting.
Reconcile outward supplies in two stages
First compare sales records with GSTR-1. Check document coverage, dates, recipient details, place of supply, taxable values, tax heads and credit notes. Investigate missing invoices and amendments rather than adjusting a single summary amount to force agreement. The sales ledger should also reconcile with the accounts for the relevant period.
Next compare the outward-supply liability reported in GSTR-3B with the reconciled GSTR-1 position. Explain differences by category and period. Timing, amendments and classification can all affect the comparison, but an explanation must be supported by the underlying documents and the applicable reporting treatment.
For example, matching total output tax does not prove correct reporting if one invoice used an incorrect tax head and another error offset it. Review material components as well as totals. A net zero difference can contain two separate errors requiring different actions.
Build an exception register that drives action
| Exception | Evidence to review | Next step |
|---|---|---|
| Purchase in books only | Invoice, receipt and supplier reporting details | Seek supplier clarification and review claim conditions |
| Portal document absent from books | Original document and purchase approval | Confirm ownership before recording or taking credit |
| Tax amount differs | Invoice and amendment history | Determine which record needs correction |
| Duplicate document | Earlier claim and matching history | Prevent repeat credit and review prior treatment |
| Credit note unresolved | Commercial settlement and supplier document | Review accounting and credit adjustment together |
Add an owner, first-identified date, amount, due action and evidence link to each item. Record whether the amount was claimed, deferred, reversed or otherwise adjusted, with the return period. Closing an exception should require evidence of resolution rather than merely an email promising future correction.
Bridge the numbers into GSTR-3B
Prepare a credit bridge showing the relevant source amounts, identified ineligible items, reversals, reviewed reclaims and the final proposed return disclosure. Keep the categories distinct. The tax team should be able to explain how each reviewed schedule enters the return and why the final amount differs from a raw statement total.
Assume the books contain GST of Rs 1,00,000. Of this, Rs 8,000 relates to invoices still under supplier investigation and Rs 5,000 has been identified as ineligible. A further Rs 7,000 appears on the portal without supporting purchase records. These figures do not justify adding all portal credit or claiming the entire book amount. Review each category and any other required adjustments before determining the claim.
Credit time limits, payment-related conditions, reversal requirements and correction routes require period-specific review. Do not defer an exception indefinitely. Escalate ageing items early enough for the responsible professional to assess available action under the applicable rules.
Measure progress without confusing credit and cash
Monitor unresolved value, oldest exception, repeat supplier errors and completed corrections. These measures reveal process weaknesses more clearly than a single match percentage. A high match rate can still conceal a large unresolved invoice or a material eligibility issue.
Eligible credit can affect cash tax payments, but it is not automatically a cash refund or freely available bank balance. Forecast the cash effect using realistic return and utilisation assumptions. Keep disputed or unsupported amounts separate from confirmed positions in management reports.
Finxora's CMA report software can support preparation of financial statements and working capital computations from entered figures. It should not be presented as a GST reconciliation or return-filing service. Explore the financial tools directory separately, and complete the tax reconciliation before using GST balances in a funding proposal.
Complete a monthly sign-off
The preparer should retain source files, matching results, exception decisions and the return bridge. A reviewer should check material exceptions, duplicate controls and the link to the filed return. Carry unresolved items into the following period with their history intact. This makes reconciliation a continuing control over accurate reporting instead of a rushed exercise performed only at year end.
