Finxora Logo
Sign In
GST Reconciliation: Find Missing Credit and Reporting Errors
Back to Blog

GST Reconciliation: Find Missing Credit and Reporting Errors

FINXORA
6 min read
GST
reconciliation
tax
finance
India

Reconcile purchases, sales, GSTR-2B and GSTR-3B with a clear exception register, evidence checks and follow-up steps before claiming eligible GST credit.

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

ExceptionEvidence to reviewNext step
Purchase in books onlyInvoice, receipt and supplier reporting detailsSeek supplier clarification and review claim conditions
Portal document absent from booksOriginal document and purchase approvalConfirm ownership before recording or taking credit
Tax amount differsInvoice and amendment historyDetermine which record needs correction
Duplicate documentEarlier claim and matching historyPrevent repeat credit and review prior treatment
Credit note unresolvedCommercial settlement and supplier documentReview 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.

Frequently Asked Questions

Published on February 14, 2026

Updated on February 21, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.