Why is GSTR 2B reconciliation with purchase register mandatory before filing GSTR-3B?

Under Section 16(2)(aa) of the CGST Act, Input Tax Credit cannot be claimed unless the invoice details are furnished by the supplier in GSTR-1 and communicated in GSTR-2B. Claiming ITC without 2B reconciliation invites automated DRC-01C mismatch notices and 18% interest under Section 50.

What happens if an invoice is in the purchase register but missing in GSTR 2B?

If an invoice is recorded in your books but missing in GSTR-2B, you must not claim ITC in the current month's GSTR-3B. Hold the credit, follow up with the vendor to file GSTR-1, and claim the ITC once it reflects in subsequent GSTR-2B. Under Rule 37A, you must also ensure suppliers pay tax to avoid mandatory reversals.

GSTR 2B Reconciliation with Purchase Register Guide

Q: What is GSTR 2B reconciliation with purchase register?

GSTR 2B reconciliation with purchase register is the process of comparing your internal accounting purchase records (from Tally, Busy, SAP, etc.) with the government-generated GSTR-2B statement to verify that suppliers have filed GSTR-1, tax amounts match, and 100% of your eligible Input Tax Credit (ITC) can be safely claimed in GSTR-3B.

Q: How to do GSTR 2B reconciliation with purchase register without JSON files?

You can export your purchase register in standard Excel/CSV format from your accounting software and download the official GSTR-2B Excel directly from the GST portal. Then, drag and drop both Excel files into GSTHawk to get an instant reconciliation report in under 10 seconds without generating JSON files.

1. Why GSTR 2B Reconciliation with Purchase Register is Legally Mandatory

Earlier, businesses could claim provisional ITC (5% above GSTR-2A) under Rule 36(4). However, with the enforcement of Section 16(2)(aa) and the deletion of the 5% provisional credit window, GSTR 2B reconciliation with purchase register is now a strict statutory mandate.

Every month, between the 11th (GSTR-1 cutoff) and the 20th (GSTR-3B deadline), tax teams must compare their internal books against GSTR-2B to achieve three vital objectives:

Claim 100% Eligible ITC: Ensure that all taxes paid to suppliers are claimed in GSTR-3B Table 4(A)(5) without missing legitimate credits.
Block Ineligible Credit: Identify and exclude blocked ITC under Section 17(5) and time-barred invoices under Section 16(4).
Prevent DRC-01C Notices: Avoid automatic department demand intimations issued under Rule 88D for claiming ITC in excess of GSTR-2B.

2. Step-by-Step Workflow: GSTR 2B Reconciliation with Purchase Register

Export Purchase Register

Export your monthly or quarterly purchase register from TallyPrime, Busy, SAP, or Zoho Books into standard Excel (.xlsx) or CSV format.

Download GSTR-2B Excel

Log into the GST portal after the 14th of the month and download your GSTR-2B statement in Excel (no JSON file required).

Upload to GSTHawk

Drop both Excel files into GSTHawk Reco Engine. Columns are auto-mapped instantly with zero manual formatting.

Export 19-Sheet Report

Download a categorized 19-sheet audit report with separate tabs for Exact Matches, Typo Matches, Missing in 2B, and Rule 37A tracking.

3. Common Mistakes in GSTR 2B Reconciliation with Purchase Register

Most accounting departments face major bottlenecks when attempting manual GSTR 2B reconciliation with purchase register in Excel:

Common Problem in Books	GSTR-2B Portal Entry	Excel VLOOKUP Result	GSTHawk Solution
`INV/001`	`1`	#N/A Error	Matched (Fuzzy Logic)
Leading zeros: `00452`	Excel number: `452`	Mismatch	Auto-Normalized
Multi-rate items (18% & 12%)	Single consolidated invoice	Duplicate rows	1-to-N Auto Consolidated
Round-off difference ₹0.40	Rounded invoice total	Value Mismatch	Matched (₹1 Tolerance)

4. What to Do with Invoices Missing in GSTR-2B?

When you conduct GSTR 2B reconciliation with purchase register, you will inevitably find invoices recorded in your books that do not appear in GSTR-2B. Here is the legal compliance procedure:

Do Not Claim ITC in Current Month: Section 16(2)(aa) strictly prohibits taking credit for invoices missing in GSTR-2B.
Hold in "Pending 2B Ledger": Segregate these invoices in a separate internal ledger so they are not accidentally claimed in GSTR-3B Table 4(A)(5).
Follow Up with Defaulting Vendors: Contact the supplier immediately. If they filed after the 11th cutoff, the invoice will appear in the next month's 2B. If they haven't filed at all, remind them before the Section 16(4) cutoff.
Monitor Rule 37A Compliance: If a supplier filed GSTR-1 but neglects to file GSTR-3B by 30th September of the next financial year, you must reverse the claimed ITC by 30th November.

5. Why Leading CAs Use GSTHawk for GSTR 2B Reconciliation

100% In-Browser Privacy: Financial records never upload to any remote server. Matching runs inside your browser RAM using Web Workers.
Sub-10-Second Processing Speed: Reconcile up to 50,000+ invoice rows in under 10 seconds.
Direct Excel Support: No need to convert portal files to JSON. Upload raw portal Excel sheets directly.
Smart Fuzzy Invoice Matching: Automatically resolves prefixes, slashes, hyphens, and leading zeros without manual VLOOKUP formulas.

6. Frequently Asked Questions (FAQ)

What is GSTR 2B reconciliation with purchase register?

It is the monthly matching of your internal accounting purchase register against government GSTR-2B to verify tax credits, identify supplier defaults, and ensure statutory compliance before filing GSTR-3B.

Why is GSTR 2B reconciliation with purchase register mandatory?

Under Section 16(2)(aa) of the CGST Act, you cannot claim ITC unless the invoice appears in GSTR-2B. Reconciling prevents automated DRC-01C mismatch notices and 18% interest penalties.

Can I perform GSTR 2B reconciliation with purchase register without JSON files?

Yes! GSTHawk allows you to directly upload the Excel export of GSTR-2B from the GST portal alongside your Tally or Busy purchase register, completing reconciliation in 10 seconds.

How to resolve invoice number mismatches during reconciliation?

GSTHawk features an automated fuzzy matching engine that strips prefixes, slashes, hyphens, and leading zeros, matching invoices even when bookkeepers enter abbreviated numbers.

GSTR 2B Reconciliation with Purchase Register: Complete Practical Guide for CAs & Accountants