MIS

GST Recon

Upload GST portal files and Tally registers to run nine invoice-level GST reconciliations — every mismatch is listed line by line with a suggested action.

Updated November 14, 2026

What GST Recon does

GST Recon compares the GST portal returns with the books, invoice by invoice, and flags every line that does not agree — missing invoices, amount differences, ITC claimed twice, tax under-declared in GSTR-3B.

Open the entity and go to GST Recon. Pick a check, upload its files, and click Run reconciliation.

The nine checks

Tab Check Files to upload
Inward 1. GSTR-2B vs Tally ITC GSTR-2B Excel (one or more) + Tally purchase register
Inward 2. RCM liability 3.1(d) Tally purchase register (RCM ledgers) + GSTR-3B; GSTR-2B optional
Inward 3. ITC reversal Rule 42/43 CA working paper + GSTR-3B
Outward 4. GSTR-1 vs Sales Register GSTR-1 Excel + Tally sales register
Outward 5. E-Invoice vs GSTR-1 E-Invoice MIS + GSTR-1 with IRN
Outward 6. E-Way Bill vs Sales E-Way Bill export + Tally sales register
Cross-check 7. GSTR-3B vs GSTR-1 / 2B GSTR-1 + GSTR-2B + GSTR-3B
Cross-check 8. HSN summary GSTR-1 with HSN sheets + Tally sales register with HSN
Cross-check 9. Cross-branch (same PAN) GSTR-2B of each branch GSTIN

Invoices are matched on supplier GSTIN + invoice number, ignoring punctuation and case — MIC-25-26-106 and MIC/25-26/106 are the same invoice. Differences of Rs 1 or less are treated as rounding.

Reading the result

  • Exceptions — lines that need action. They are shaded red; matched lines are green.
  • Amount impact — the tax effect of the exceptions (for example ITC per 2B minus ITC per books).
  • Status / Suggested action — what is wrong with the line and what to do about it.
  • Only exceptions hides matched lines; Excel downloads the same result as a workbook.
  • How the files were read lists, per sheet, the header row found and how many rows were skipped (blank, total and repeated-header rows) so you can check nothing was missed.

Client GSTIN

The client GSTIN is filled in from the entity. It decides whether a GSTR-1 line is intra-state (CGST + SGST) or inter-state (IGST); leave it blank to read it from the GSTR-2B file.

Options

  • E-Way Bill threshold (check 6) — invoices at or above this value need an E-Way Bill. Default Rs 50,000.
  • Branch that keeps duplicate ITC (check 9) — when the same supplier invoice appears in two branches' 2B, the other branch is asked to reverse it. By default the branch in the supplier's state keeps it (CGST/SGST can only be claimed there).

Files are processed for the run and not stored. Interest and late fees are not computed.

Was this correct?

Under each result there is Was this correct? with Like and Dislike. A click is saved and opens an optional form to say what was right or wrong (Skip keeps just the rating). Click the same button again to take it back. Each new run starts unrated. The names of the files you used are saved with the feedback, not the files.