GSTR-2B Universal Reconciliation Tool
Upload → Reconcile → Export · Any GSTIN · Any Period
Developed by Mohamed Mashood |
⚠️
Excel Library failed to load. Please check your internet connection and press F5 to refresh.
(One of cdnjs.cloudflare.com / jsdelivr.net / unpkg.com must be accessible)

GSTR-2B vs Tally Reconciliation

Upload the GSTR-2B Excel downloaded from the GST Portal
and the Tally GSTR-3B Voucher Register for instant reconciliation.

📋
GSTR-2B Portal Excel
GST Portal → Returns → GSTR-2B → Download Excel
Multi-sheet file (B2B, B2BA, B2B-CDNR…)
.xlsx.xls
✓
📊
Tally — All Other ITC
Tally → GSTR-3B → Voucher Register
Vouchers of: All other Input Tax Credit
.xlsx.xls.csv
✓
🔄
Tally — RCM (Optional)
Tally → GSTR-3B → Voucher Register
Vouchers of: Inward Supplies — Reverse Charge
.xlsx.xls.csv
✓
💡 2B File: GST Portal standard Excel (B2B, B2BA, B2B-CDNR sheets).  |  Tally File: GSTR-3B Voucher Register — Date, Particulars, GSTIN, Vch Type, Vch No., Taxable, IGST, CGST, SGST columns. Tool auto-detects column positions — performs invoice-level reconciliation if Doc No. is present, otherwise defaults to party-wise matching.
GSTR-2B Reconciliation
—
—
—
Mohamed Mashood |
🔍 Reconciliation
📋 All B2B Invoices (GSTR-2B)
GSTINSupplier NameInvoice No. DateType Taxable ₹ IGSTCGSTSGST RCMITCPeriodFiled
✅ ITC Available Summary
⚠ ITC Not Available — Must be declared in GSTR-3B Table 4(D)(2).
🚫 ITC Not Available
↩ ITC Reversal — Rule 37A / 180 days. GSTR-3B Table 4(B)(2).
↩ ITC Reversal
❌ ITC Rejected — IMS reject. Do not include in GSTR-3B.
❌ ITC Rejected
🔄 B2BA — Supplier amended invoices. Please verify if Tally has been updated.
🔄 B2BA — Amended Invoices
Orig InvOrig DateGSTINSupplier Rev InvRev Date TaxableIGST CGSTSGSTITC
📝 CDNR — Credit / Debit Notes
GSTINSupplierNote No.Type Supply TypeNote Date ValueTaxable IGSTCGSTSGST ITC
🔄 Tally Debit Note ↔ 2B CDNR (Credit Note) Reconciliation
📋 Tally Debit Note (Returns to Supplier) 📊 2B CDNR — Supplier's Credit Note (Filed in Portal)
DateGSTINPartyTally Vch No. Taxable CGSTIGSTSGST Status 2B Note No.Note Date 2B Taxable 2B CGST Diff ₹ ITC
🔄 RCM (Reverse Charge Mechanism) — Supplier does not charge GST for these entries; the buyer must pay the tax. Flagged as RCM in 2B. Declare in GSTR-3B Table 3.1(d) and claim ITC in Table 4(A)(3).
🔄 RCM Entries — 2B vs Tally Comparison
📋 2B — RCM Invoices (rcm=Yes) 📊 Tally — RCM Register (Journal entries)
GSTINSupplierInvoice No.Date 2B Taxable 2B Tax Tally PartyVch No. Tally Taxable Tally Tax Tax Diff ₹ StatusITC
🚨 These invoices are present in GSTR-2B but missing in Tally. Must be entered in Tally to claim ITC.
💡 Deferred Entries Tip: If an invoice is from previous year (March/April), it may already exist in Tally as a deferred entry with blank GSTIN. Check Tally for vouchers with: (1) Party Name matching supplier, (2) Blank GSTIN field, (3) Invoice number, (4) Tax amount exactly as shown. If found, it's NOT actually missing — update tool data or correct the Tally entry fields.
📋 Missing Bills — Present in 2B, not in Tally
GSTIN Supplier Name Invoice No. Invoice Date Invoice Type Taxable ₹ IGST ₹ CGST ₹ SGST ₹ Total Tax ₹ RCM ITC Avail Filed Period Action
Processing…
Reading files