GSTR-2B Reconciliation

Why GSTR-2B Reconciliation Matters

Section 16(2)(aa) of the CGST Act says: you can claim ITC only if the invoice appears in your GSTR-2B for that period. If your vendor doesn't file their GSTR-1, or files with the wrong GSTIN, you lose the credit — sometimes permanently.

Doing this manually for a business with 200+ purchase invoices/month is a nightmare. iAccounting matches them in seconds and tells you exactly where the gaps are.

GSTR-2B in 30 Seconds

• An auto-generated ITC statement.
• Published by GSTN on the 14th of every month (cut-off = 13th).
• Shows every B2B invoice your vendors filed in their GSTR-1.
• Static — does not change after publication (unlike 2A).
• You can claim ITC only from 2B.

Step 1 — Sync GSTR-2B

1. Go to GST → GSTR-2B Reconciliation.
2. Select period.
3. Click "Sync from Portal".
4. Enter GST portal credentials (encrypted, not stored).
5. iAccounting downloads the full GSTR-2B JSON.

Or download manually from gst.gov.in → GSTR-2B → Download JSON, and upload to iAccounting.

Step 2 — Run Auto-Match

Click "Run Match". The engine matches on:

1. Vendor GSTIN (exact)
2. Invoice number (with fuzzy logic for prefix/suffix variations)
3. Invoice date
4. Total taxable value (tolerance: ±₹1)
5. Tax amounts CGST/SGST/IGST (tolerance: ±₹1)

Step 3 — Review the 5 Buckets

Bucket 1: Matched ✓ (Green)

Invoice in your books and 2B with same values. Safe to claim ITC. Usually 70-85% of records.

Bucket 2: Partial Match ⚠ (Yellow)

Same vendor + invoice, but small differences:

• Taxable value off by ₹2 → likely rounding
• Tax amount off by ₹1 → rounding
• Invoice number with extra space → cosmetic

Click "Auto-resolve" for cosmetic differences. Investigate real value differences.

Bucket 3: In Your Books, Not in 2B ✗ (Red)

You have the invoice but vendor hasn't filed GSTR-1. Options:

1. Follow up with vendor — tell them to file GSTR-1 to release ITC.
2. Defer ITC — mark this invoice "Provisional" in iAccounting; ITC moves to next 2B when vendor files.
3. If vendor never files — eventually you'll have to reverse and write off.

Bucket 4: In 2B, Not in Your Books ✗ (Red)

Vendor has filed an invoice against your GSTIN, but you don't have it in your records. Options:

1. Missing invoice — ask vendor for the bill, enter it, you may have unclaimed ITC waiting.
2. Wrong GSTIN by vendor — they entered your GSTIN for someone else's invoice. Get them to amend their GSTR-1.
3. Duplicate — vendor mistakenly reported twice.

Bucket 5: Mismatch (Purple)

Invoice number / date / value differs significantly. Investigate before action.

Step 4 — Apply & Carry Forward

After resolving each row, click "Apply & Update GSTR-3B". This:

1. Updates GSTR-3B Table 4(A) with eligible matched ITC.
2. Moves unmatched invoices to "Provisional ITC" — visible but not claimed.
3. Notes invoices to follow up with vendor.

Step 5 — Vendor Follow-up Workflow

For vendors who consistently delay GSTR-1 filing, iAccounting can send automated reminders:

1. Open Reports → Vendor Compliance.
2. See each vendor's GSTR-1 filing rate and last-filed date.
3. Click "Send Reminder" — pre-filled email/SMS asking them to file.
4. For chronic offenders, flag and discontinue purchases.

ITC You Can't Claim Even If in 2B

Section 17(5) lists "blocked credits". iAccounting auto-flags these as Ineligible ITC even if matched:

• Motor vehicles (with seating capacity ≤ 13, except for further supply, transport of passengers, training)
• Food, beverages, outdoor catering
• Beauty treatment, health services
• Membership of clubs, health/fitness centres
• Travel benefits for employees
• Works contract for construction of immovable property (own use)
• Goods/services for personal consumption
• CSR expenses

These go into GSTR-3B Table 4(D) — visible to GSTN but not added to credit.

Rule 37 Reversal — Unpaid Vendor After 180 Days

If you've claimed ITC but haven't paid the vendor within 180 days of the invoice date, you must reverse the ITC + interest.

iAccounting tracks this automatically. From Reports → Rule 37 Tracker:

• List of unpaid vendor invoices nearing 180 days.
• Auto-generated reversal entry when day 181 hits.
• Re-claim entry when payment is finally made.

Rule 42 / 43 — Proportional Reversal

If you make both taxable and exempt supplies, you can't claim full ITC on common inputs. The Rule 42/43 formula proportions it:

Reversal = Common ITC × (Exempt Turnover / Total Turnover)

iAccounting computes this monthly under GST → Compliance → Rule 42/43. The reversal hits GSTR-3B Table 4(B).

Useful Reconciliation Reports

Best Practices

1. Sync 2B on the 14th of every month — earliest you can.
2. Resolve all flags before filing GSTR-3B on the 20th — gives you 6 days.
3. Follow up unmatched invoices weekly — don't let them age past 60 days.
4. Track Rule 37 every month-end — to avoid surprise reversals.
5. Keep a vendor compliance dashboard — drives better procurement decisions.
6. Don't claim provisional ITC after the 30 November/31 March deadline — it expires.

What's Next?

• File GSTR-3B with Reconciled ITC
• Conceptual: GSTR-2B Rules & Workflow
• Input Tax Credit Rules