Ensure both your GSTR_2A_Data and Purchase_Register sheets use identical columns for easy cross-referencing: Column A: Supplier GSTIN Column B: Invoice Number Column C: Invoice Date Column D: Taxable Value Column E: Integrated Tax (IGST) Column F: Central Tax (CGST) Column G: State Tax (SGST) 3. Create a Unique Key (The Matchmaker)
(Your books/claimed ITC)
: Find the GSTR-2A tile under the "Auto drafted Returns" section. Click Download and select the Excel format option. gstr 2a and 3b reconciliation in excel format download
The Goods and Services Tax Network (GSTN) tracks mismatches between auto-generated data and self-declared returns. If your claimed ITC in GSTR-3B exceeds the ITC available in GSTR-2A/2B, tax authorities will issue automated demand notices (such as Form DRC-01C). Protect Your Cash Flow
✅ The primary goal is to ensure that the ITC claimed in your GSTR-3B matches the eligible ITC available in your GSTR-2B. Any mismatched or missing invoices can lead to an under- or over-claim of ITC, resulting in cash flow issues or interest on reversed credits. The Goods and Services Tax Network (GSTN) tracks
: Do not leave reconciliation for the end of the financial year.
Here is a practical workflow for performing the reconciliation using Excel. This can be done manually or with the help of automated templates. Any mismatched or missing invoices can lead to
: Choose the specific Financial Year and the Return Filing Period (Month/Quarter).
Regular reconciliation highlights which suppliers are defaulting on their GST filings. You can hold payments or follow up with defaulting vendors before the statutory deadlines close for the financial year. Step-by-Step GSTR-2A vs 3B Reconciliation Process in Excel