| GSTIN of Supplier | Invoice Number | Invoice Date | Taxable Value | CGST Claimed | SGST Claimed | IGST Claimed | Cess Claimed | Total ITC Claimed | |------------------|----------------|--------------|----------------|--------------|--------------|--------------|--------------|--------------------|

| Total ITC in GSTR-2A | 5% of that | ITC Claimed in GSTR-3B | Permissible Limit | Excess Claim (if any) | |----------------------|------------|------------------------|--------------------|------------------------| | 1,00,000 | 5,000 | 1,20,000 | 1,05,000 | 15,000 (Disallowed) |

To use the template:

Failing to cross-verify your auto-drafted ITC with your claimed ITC exposes businesses to severe financial and regulatory risks:

Goods and Services Tax (GST) reconciliation is a crucial process for businesses to ensure accuracy and compliance with tax laws. GSTR 2A and GSTR 3B are two essential returns that need to be reconciled to avoid discrepancies and potential penalties. In this review, we'll explore the concept of GSTR 2A and 3B reconciliation in Excel format, its benefits, and provide a downloadable template.

> Services > Returns > Returns Dashboard. Select the Financial Year and Period. Under the GSTR-2A tile, click and select Generate Excel File For GSTR-3B:

GSTR‑2A is dynamic and updates in real time as suppliers file their returns. GSTR‑2B is a static statement generated on the 12th of every month, based on supplier filings before that date. For reconciliation purposes, GSTR‑2B is considered the final reference for a given month.

For GST compliance in India, the reconciliation of GSTR-2A (auto-drafted purchases) and GSTR-3B (summary returns) is a critical monthly activity. While the government provides reconciliation tools on the GST portal, they are often slow and cumbersome. Consequently, finance professionals and business owners heavily prefer downloading Excel-based utilities to perform this reconciliation offline.

If ITC is wrongly availed and utilised, interest is charged under Section 50, and penalty may be levied under Section 73 or 74 of the CGST Act. The quantum depends on whether the mismatch was due to genuine error or fraudulent intent.

: Match invoice numbers between GSTR-2A and your purchase register to find missing entries.