GSTR-2B Reconciliation: The Complete Guide for CA Firms and Finance Teams
Everything you need to know about GSTR-2B reconciliation — from downloading portal data to matching purchase registers, categorizing exceptions, and exporting filing-ready ITC reports.
Published 18 August 2026· 14 min read
By Complytics Editorial Team · GST Compliance & GSTR-2B Reconciliation
Every GST return period, Chartered Accountant firms and finance teams face the same challenge: download GSTR-2B from the GST portal, cross-reference it against the purchase register, and figure out which Input Tax Credit (ITC) is safe to claim in GSTR-3B. For a single client with 2,000 purchase invoices, this can take an entire day in Excel. For a CA firm managing 50 clients, it becomes a firm-wide bottleneck that delays filings and risks lost ITC.
This guide covers everything you need to run GSTR-2B reconciliation correctly — whether you work manually in spreadsheets or use GSTR-2B reconciliation software like Complytics. We explain what GSTR-2B is, when to reconcile, how to categorize exceptions, and how to build a monthly workflow that scales across your entire client portfolio.
What is GSTR-2B and why does it matter?
GSTR-2B is an auto-drafted, static statement of Input Tax Credit available to a registered person for a given tax period. The GST portal generates it based on invoices filed by your suppliers in their GSTR-1 (or through the Invoice Furnishing Facility for QRMP taxpayers). Unlike GSTR-2A, which updates dynamically as suppliers file, GSTR-2B is generated on a fixed schedule — typically on the 14th of the month following the tax period for monthly filers.
GSTR-2B is the primary document for ITC reconciliation because it represents what the government's system considers available credit. You cannot claim ITC on invoices that do not appear in GSTR-2B (subject to certain exceptions and the Invoice Management System workflow). This makes reconciliation between your purchase books and GSTR-2B the single most important compliance activity before filing GSTR-3B.
For CA firms, GSTR-2B reconciliation is not just a technical exercise — it is risk management. Every rupee of ITC your client claims in GSTR-3B Table 4 must be traceable to a reconciled entry. Department officers and auditors routinely ask for reconciliation working papers. A clean, documented reconciliation is your first line of defense in any scrutiny.
When should you reconcile GSTR-2B?
The ideal reconciliation cadence is monthly, aligned with your GSTR-3B filing cycle. Here is the timeline most CA firms follow:
- Day 12–14 of the month: GSTR-2B becomes available on the GST portal for the previous tax period. Download it immediately — do not wait.
- Day 14–18: Export the purchase register from Tally, Zoho Books, Busy, SAP, or Excel. Run reconciliation against GSTR-2B.
- Day 18–22: Resolve exceptions — chase vendors for missing GSTR-1 filings, verify tax mismatches, flag ineligible ITC.
- Day 22–25: Export GSTR-3B Table 4 ITC breakdown from reconciled data. Get client sign-off.
- Before GSTR-3B due date: File GSTR-3B with reconciled ITC figures. Lock the reconciliation period for audit trail.
For QRMP (quarterly) filers, reconcile each month within the quarter even if GSTR-3B is filed quarterly. Waiting until quarter-end means you discover missing ITC too late to recover under Section 16(4) time limits.
The six reconciliation buckets every CA firm should use
Effective GSTR-2B reconciliation categorizes every purchase invoice into one of six buckets. This is the framework Complytics uses, and it maps to how department officers think about ITC:
1. Matched
Invoice appears in both the purchase register and GSTR-2B. GSTIN, invoice number, invoice date, and tax amounts (CGST, SGST, IGST, CESS) agree within acceptable tolerance. These entries are ready for GSTR-3B Table 4 reporting after your review sign-off.
2. Mismatched
Invoice appears in both sources but tax amounts differ. Common causes: supplier filed wrong tax rate, rounding differences, partial credit notes not reflected, or amendments filed after the original invoice. Each mismatch needs investigation — is the error in your books or the supplier's filing?
3. Missing in GSTR-2B
Invoice exists in your purchase register but does not appear in GSTR-2B. The most common reason: supplier has not filed GSTR-1 for that invoice. Other causes include wrong GSTIN on the supplier's filing, invoice filed in a different period, or IMS rejection. You cannot claim ITC until the invoice appears in GSTR-2B.
4. Missing in books
Invoice appears in GSTR-2B but not in your purchase register. This usually means the purchase was not recorded in your accounting system, or it was recorded under a different invoice number or GSTIN. You may have unclaimed ITC sitting on the portal.
5. Ineligible ITC
Invoice matches but ITC is blocked under GST law — motor vehicles (except certain categories), food and beverages, outdoor catering, beauty treatment, health services, club membership, travel benefits, works contract services for construction of immovable property, and items covered under Section 17(5) of the CGST Act. Flag these before they enter GSTR-3B Table 4.
6. IMS pending
Invoice appears in the Invoice Management System (IMS) but requires action — either the recipient must accept/reject, or the supplier's filing is pending IMS clearance. These entries may or may not flow into GSTR-2B depending on the IMS workflow status. Track these separately from standard missing entries.
How invoice matching actually works
Whether you reconcile manually or with software, the matching logic follows the same principles. Understanding these helps you debug false mismatches and configure automation correctly.
Invoice number normalization
The number one cause of false "missing" entries is invoice number formatting differences. Your books may record "INV-2024-001" while the supplier filed "INV/2024/001" or "2024001" on the portal. Good reconciliation software strips slashes, hyphens, spaces, and leading zeros before comparing. Manual Excel reconciliation requires a normalization column — and one typo breaks the entire VLOOKUP chain.
GSTIN validation
Every match requires the supplier GSTIN to agree. A single digit error in GSTIN — common when suppliers have multiple registrations — creates a phantom missing entry. Validate GSTIN format (15 characters, valid state code) before matching.
Tax amount comparison
Compare CGST, SGST, IGST, and CESS separately — not just the total tax amount. A supplier who filed IGST instead of CGST+SGST creates a mismatch even when the total tax is correct. Set a rounding tolerance (typically ₹1.00) for minor differences caused by line-item rounding vs header rounding.
Credit and debit note (CDN) handling
Credit notes reduce ITC; debit notes increase it. CDNs must be linked to the original invoice in both your books and GSTR-2B. A credit note filed without referencing the original invoice number creates orphan entries that appear as mismatches or missing items.
Fuzzy matching for near-misses
When exact and normalized matching fails, fuzzy matching uses similarity scoring (typically trigram-based) to suggest probable matches. A score above 85% with matching GSTIN and tax amount is usually the same invoice with a formatting difference. Always require human review before accepting fuzzy matches — never auto-claim ITC on suggested matches.
Manual Excel reconciliation vs automation
Most CA firms start with Excel. It works for 1–2 clients with a few hundred invoices. It breaks at scale. Here is an honest comparison:
| Factor | Excel / VLOOKUP | Reconciliation software |
|---|---|---|
| Time per client (2,000 invoices) | 4–8 hours | 15–20 minutes |
| Invoice number normalization | Manual formula, breaks often | Automatic multi-tier matching |
| CDN handling | Separate sheet, manual linking | Auto-linked to original invoice |
| Multi-client management | One file per client, no firm view | Firm dashboard across all clients |
| Audit trail | File versions, if saved | Immutable log of every action |
| GSTR-3B Table 4 export | Manual pivot / SUMIF | One-click from accepted matches |
The tipping point for most firms is around 10 clients. Below that, Excel is tolerable if your team is disciplined. Above 10, the time cost and error risk make automation the rational choice — especially when a single missed mismatch can mean thousands of rupees in lost ITC or a notice from the department.
Monthly reconciliation workflow for CA firms
Here is a repeatable workflow that scales from 5 to 200 clients. Adapt the timeline to your firm's filing calendar:
- Gather source files. Download GSTR-2B JSON/Excel from the GST portal for each client GSTIN. Export purchase registers from accounting software. Ensure both cover the same tax period.
- Upload and map columns. Import both files into your reconciliation tool. Map column headers (invoice number, GSTIN, dates, tax amounts) once and save as a template for recurring uploads.
- Run auto-matching. Let the system categorize invoices into the six buckets. Review the match rate — 95%+ auto-matched is typical for well-maintained books.
- Review exceptions only. Focus human attention on mismatched, missing, ineligible, and IMS pending entries. Accept or reject suggested matches. Document reasons for rejections.
- Chase vendors. For missing-in-2B entries, contact suppliers with exact invoice numbers, GSTINs, and tax amounts. Use templated follow-up emails. Log every communication.
- Export filing-ready reports. Generate GSTR-3B Table 4 ITC breakdown, vendor-wise mismatch statements, and executive reconciliation summary. Archive with timestamp and approver name.
- Lock the period. Once GSTR-3B is filed, lock the reconciliation period. No further edits — changes go through an amendment workflow with full audit trail.
Audit documentation: what to keep and for how long
GST law requires records to be maintained for at least 6 years from the date of filing the annual return. For reconciliation specifically, keep:
- Downloaded GSTR-2B file for each period (JSON or Excel from portal)
- Purchase register export used for reconciliation
- Reconciliation working paper showing all six buckets with counts and amounts
- Vendor follow-up emails and responses for missing invoices
- GSTR-3B Table 4 export with approver sign-off
- Any manual adjustments with written justification
Department officers increasingly ask for reconciliation working papers during scrutiny. A firm that can produce a clean, timestamped reconciliation trail for any period within minutes has a significant advantage over one digging through email attachments and old Excel files.
Common mistakes that cost CA firms ITC
- Reconciling after GSTR-3B filing. Discovering unmatched ITC after filing means you either amend GSTR-3B or lose the credit under Section 16(4).
- Claiming ITC on unmatched invoices. Booking ITC in GSTR-3B Table 4 without reconciliation is a direct compliance risk.
- Ignoring IMS pending entries. Post-2025 IMS compliance means some invoices require recipient action before appearing in GSTR-2B.
- Not chasing vendors early enough. Suppliers need time to file amended GSTR-1. Start vendor follow-ups by day 18, not day 28.
- One spreadsheet per client with no firm-wide view. Partners cannot see which clients are at risk before the filing deadline.
- No period lock after filing. Post-filing edits without audit trail create discrepancies during department scrutiny.
How Complytics automates GSTR-2B reconciliation
Complytics by Vedora Labs is built specifically for CA firms managing multiple GST clients. It implements the entire workflow described in this guide:
- Upload purchase register and GSTR-2B — supports Tally, Zoho Books, Busy, SAP, Excel, CSV
- Deterministic multi-tier matching with invoice normalization and CDN linking
- Auto-bucket into matched, mismatched, missing, ineligible, and IMS pending
- Human review and accept/reject for every match — no auto-claim of ITC
- One-click GSTR-3B Table 4 export from accepted matches only
- Section 16(4) deadline alerts and Rule 37 unpaid invoice tracking
- Vedora AI explains mismatches and drafts vendor follow-up emails
- Firm-wide dashboard with per-client isolation and immutable audit trail
CA firms typically reconcile a client in under 20 minutes — down from 4–8 hours in Excel. That time savings compounds across your entire portfolio every month.
Frequently asked questions
- What is the difference between GSTR-2A and GSTR-2B?
- GSTR-2A is a dynamic, continuously updated statement of inward supplies based on suppliers' GSTR-1 filings. GSTR-2B is a static, auto-drafted ITC statement generated on a fixed schedule (typically the 14th of the following month). GSTR-2B is the document used for ITC reconciliation and GSTR-3B filing — not GSTR-2A.
- Can I claim ITC on invoices not in GSTR-2B?
- Generally, no. ITC is available only when the invoice appears in GSTR-2B (or is accepted through the IMS workflow). If a supplier has not filed GSTR-1, the invoice will not appear in GSTR-2B and you cannot claim the ITC until the supplier files.
- How often should I reconcile GSTR-2B?
- Monthly, aligned with your GSTR-3B filing cycle. For QRMP quarterly filers, reconcile each month within the quarter to catch missing ITC early and allow time for vendor follow-ups before Section 16(4) deadlines.
- What match rate should I expect from automated reconciliation?
- Well-maintained books with consistent invoice numbering typically achieve 95–99% auto-match rates. The remaining 1–5% are genuine exceptions requiring human review — tax mismatches, missing portal entries, CDNs, and ineligible ITC.
- Do I need separate reconciliation for each GSTIN?
- Yes. GSTR-2B is generated per GSTIN per tax period. If your client has multiple GSTINs across states, each requires its own reconciliation. Multi-GSTIN clients are common for businesses operating in multiple states.
- What files do I need to start GSTR-2B reconciliation?
- You need two files: (1) GSTR-2B downloaded from the GST portal (JSON or Excel format), and (2) your purchase register for the same tax period exported from your accounting software. Both must include at minimum: supplier GSTIN, invoice number, invoice date, and tax amounts (CGST, SGST, IGST, CESS).
Related articles
Ready to automate reconciliation across your client portfolio?