: Download your filed GSTR-3B return for the corresponding period. 2. Prepare Your Purchase Register

– Copy the table below into Excel:

This is a ready-to-use spreadsheet that simplifies the process. It allows you to import GSTR-2A/2B JSON files directly, auto-matches them with your purchase register, and generates a mismatch report. It also provides a summarized view of eligible and ineligible ITC.

➡️ Click Here to Download the GSTR-2A and 3B Reconciliation Excel Format (Note: Replace with your actual trusted file link) Key Features of this Template:

The Goods and Services Tax Network (GSTN) tracks mismatches between auto-populated credits and claimed credits, triggering automated demand notices for discrepancies.

You can download a GSTR 2A and 3B reconciliation Excel template from various online sources, such as:

Go to > Conditional Formatting > Highlight Cells Rules > Not Equal To .

The invoice appears in GSTR-2A but is absent from your purchase register. Action: Check if it belongs to another branch, or if it represents an omitted purchase invoice. Pro-Tips for Seamless Excel Reconciliation

Here is a practical workflow for performing the reconciliation using Excel. This can be done manually or with the help of automated templates.

The legal framework around ITC is clear and has become stricter. Starting from late 2025, the GST ecosystem moved to system-level "hard validations" that can block GSTR-3B submission when reclaimed ITC or RCM entries exceed ledger balances. Failure to reconcile can result in:

This is a dynamic, view-only statement of inward supplies (purchases) auto-populated from the returns filed by your suppliers. It provides a real-time view of all supplies made to you and updates whenever a supplier modifies their GSTR-1, GSTR-5, or GSTR-6.