Skip to searchSkip to main content
Languages
TAXAJ
Free GST ITC Reconciliation Tool — GSTR-2B vs Purchase Register | TAXAJ
GST · Input Tax Credit · Free Tool

GST ITC reconciliation, 2B vs purchase register, in seconds.

Match your GSTR-2B against your books, see exactly how much Input Tax Credit is safe to claim, and catch every mismatch before you file GSTR-3B. No sign-up. Nothing to install.

Runs in your browser — no data uploaded Excel & JSON supported Built by practising CAs

GSTR-2B (supplier data)

Step 1
⬇︎
Choose or drop the 2B file.xlsx · .xls · .csv · GSTN .json

Purchase Register (your books)

Step 2
⬇︎
Choose or drop the purchase register.xlsx · .xls · .csv
Match tolerance (₹ per invoice, on tax):
Load both files to begin.

Input Tax Credit — reconciliation summary

ITC in 2B
Matched — safe to claim
In 2B, not in books
In books, not in 2B — at risk
6 sheets: Summary, Matched, Tax mismatch, Only in 2B, Only in books, Probable.
How it works

From two files to a filing-ready answer

The tool does the invoice-by-invoice matching your team would otherwise do by hand, and shows only what needs a human decision.

1

Load GSTR-2B

Upload the 2B you downloaded from the GST portal — Excel or JSON. Columns are detected automatically.

2

Load your books

Add the purchase register exported from Tally, Zoho Books or any accounting system, in Excel or CSV.

3

Match on GSTIN + invoice

Every line is matched on supplier GSTIN and invoice number, with a tax tolerance you control.

4

Act & export

See eligible ITC, mismatches and risk items, then export a clean multi-sheet Excel for your working papers.

Reading the results

Five buckets, each with a clear next step

Matched

Same GSTIN and invoice, tax within tolerance. This Input Tax Credit is reflected in 2B and safe to claim.

Tax mismatch

Invoice matches but the tax amount differs. Reconcile the difference — often a data-entry or rounding gap — before claiming.

In books, not in 2B

Claimed in your books but not reported by the supplier. This is the Section 16(2)(aa) exposure — chase the supplier or hold the claim.

In 2B, not in books

Reported by the supplier but missing from your books. Usually an unbooked purchase to verify and record.

Why GSTR-2B reconciliation matters

Input Tax Credit (ITC) is often the largest number on a GST return, and it is also the most scrutinised. Under Section 16(2)(aa) of the CGST Act, a registered person can claim ITC on a purchase only if the supplier has reported that invoice and it appears in the buyer's GSTR-2B. That single rule makes monthly reconciliation between your purchase register and 2B non-negotiable — claim credit that isn't in 2B and you invite interest, reversal and notices; miss credit that is in 2B and you overpay tax.

GSTR-2A vs GSTR-2B — which one to reconcile against

GSTR-2A is a dynamic statement that keeps updating as suppliers file returns. GSTR-2B is a static, auto-drafted statement generated once a month. Because ITC eligibility is anchored to 2B, this tool reconciles your books against GSTR-2B, giving you a stable, defensible position for the period before you file GSTR-3B.

What good reconciliation catches

  • Ineligible credit booked in your accounts but not reflected in 2B.
  • Tax mismatches where the invoice matches but the IGST/CGST/SGST differs.
  • Missed credit that suppliers have reported but you haven't recorded.
  • Duplicate or mis-keyed invoices surfaced through fuzzy matching.

How often should you reconcile?

Every month, before filing GSTR-3B. Doing it monthly keeps supplier follow-ups timely, prevents credit from lapsing under the annual time limit, and makes your GSTR-9 annual return far easier to close. This tool is built to make that monthly step a two-minute task instead of an afternoon of spreadsheet matching.

Is the tool accurate and private?

All matching runs locally in your browser — your invoice data is never uploaded to any server. The output is a reconciliation you can review, export and attach to your working papers. It supports the professional judgment of a qualified practitioner; it does not replace the final review and sign-off that GST filing requires.

FAQ

GST ITC reconciliation — common questions

What is GSTR-2B reconciliation?+
It is the process of matching the auto-drafted ITC statement (GSTR-2B) from the GST portal against your own purchase register. It confirms how much Input Tax Credit is eligible to claim in GSTR-3B and highlights which invoices your suppliers have or have not reported.
Is this GST reconciliation tool free?+
Yes — it's completely free, with no sign-up and no limit on the number of reconciliations you can run.
Is my GST data safe? Where is it processed?+
Your files never leave your device. The entire reconciliation runs inside your browser using local JavaScript — no invoice data is uploaded anywhere.
What file formats does the tool accept?+
The GSTR-2B download from the GST portal in Excel (.xlsx/.xls) or JSON, and a purchase register in Excel or CSV. Column names are auto-detected and can be adjusted if needed.
What is the difference between GSTR-2A and GSTR-2B?+
GSTR-2A is dynamic and keeps changing as suppliers file; GSTR-2B is a static, monthly auto-drafted statement. ITC eligibility under Section 16(2)(aa) is determined with reference to 2B, which is why reconciliation is done against 2B before filing GSTR-3B.
How often should I reconcile ITC?+
Every month, before filing GSTR-3B, so that only eligible credit reflected in 2B is claimed and mismatches are resolved in time.
What does "in books but not in 2B" mean?+
You've recorded a purchase and its ITC in your books, but the supplier hasn't reported that invoice in 2B. Such credit is at risk under Section 16(2)(aa) and should be followed up with the supplier or held back from the claim.
Can TAXAJ file my GST returns for me?+
Yes. TAXAJ handles end-to-end GST compliance — registration, monthly GSTR-1 and GSTR-3B filing, reconciliation, annual returns and notices — across Delhi, Bengaluru, Goa and Bihar. Reach us at +91-8802-812-345.

Rather have experts handle it?

TAXAJ runs GST compliance for hundreds of businesses across India. Let our team take reconciliation, filing and notices off your plate.

Call +91-8802-812-345
TTAXAJ

Cloud-based CA, CS & legal services — tax, GST, FEMA, IPR, corporate law and foreign subsidiary setup.

📞 +91-8802-812-345

Offices

Delhi — HQNew Delhi

Bengaluru1442, 17th B Main Rd, 3rd Cross, J.P. Nagar — 560078
+91-8961-228-919

 

GoaH. No. 775, Revathi, Alto Betim, Porvorim, Bardez — 403521
+91-9976-030-405

Bihar+91-7091-020-202

© TAXAJ LLP · taxaj.com · This free tool assists reconciliation and does not constitute tax advice or a substitute for professional review.