Failure to perform this reconciliation can lead to excessive ITC claims, resulting in demand notices (Form ASMT-10), interest liabilities at 18% per annum, and potential penalties. Why You Need a GSTR 2A vs 3B Reconciliation Format in Excel
Download your GSTR-2A/2B reports from the GST portal for the relevant period. Simultaneously, export your Purchase Register (Books) and GSTR-3B filings for the same duration. 2. Standardize Formats
Assuming your GSTR-2A data is in Sheet1 and your Purchase Register is in Sheet2 , enter this formula in an empty column in Sheet1 to find the corresponding tax amount: =XLOOKUP(A2, Sheet2!A:A, Sheet2!B:B, "Not Found in Books") (Where A2 is the Supplier GSTIN or a unique combined key like GSTIN+Invoice Number, column A:A is the lookup array in your books, and B:B is the tax amount column). Step 3: Identify the Discrepancies
This comprehensive guide explains everything you need to know about GSTR‑2A and GSTR‑3B reconciliation, including step‑by‑step instructions, how to download reports in Excel format, and where to find free reconciliation templates. gstr 2a and 3b reconciliation in excel format download
You can use these free Excel utilities to automate the matching process: GSTZen Sample Report : A consolidated Excel file for comparing GSTR-1, 2A, and 3B data Finexo Online Tool : A free web-based utility to reconcile GSTR-2A and purchases that exports results to Excel. GSTplus Utility : A comprehensive GSTR-2A reconciliation utility designed for large datasets. 2. Guide: Step-by-Step Excel Reconciliation Step 1: Download Portal Data Log in to the GST Portal Returns Dashboard Select the Financial Year box, click and select Generate Excel File Repeat this for to get your filed summary. Step 2: Export Books of Accounts Export your Purchase Register
– Copy the table below into Excel:
: Accurate reconciliation ensures you do not miss out on legitimate tax credits. Step-by-Step Reconciliation Process in Excel Failure to perform this reconciliation can lead to
Late adjustments or incorrect claims can attract interest under Section 50.
This tab uses formulas to compare the two datasets side-by-side:
Paste your GSTR-2A data here. Minimum required columns: You can use these free Excel utilities to
| Supplier GSTIN | ITC as per Books (₹) | ITC as per GSTR‑2A (₹) | ITC Claimed in GSTR‑3B (₹) | Excess / Short Claim | Follow‑up Required | |---|---|---|---|---|---|
A. Supplier GSTIN B. Invoice No. C. Invoice Date D. Taxable Value (GSTR-2A) E. IGST (GSTR-2A) F. CGST (GSTR-2A) G. SGST/UTGST (GSTR-2A) H. Total Tax (GSTR-2A) — formula: =E2+F2+G2 I. Taxable Value (GSTR-3B) J. IGST (GSTR-3B) K. CGST (GSTR-3B) L. SGST/UTGST (GSTR-3B) M. Total Tax (GSTR-3B) — formula: =J2+K2+L2 N. Match Status (Invoice-level) — formula examples below O. Difference — Tax (GSTR-3B minus GSTR-2A) — =M2-H2 P. Reason / Notes (e.g., missing credit, timing, wrong invoice, blocked credit) Q. Action Required (e.g., follow-up supplier, adjust next month, keep as exception) R. Reconciliation Category (Auto/Partial/Not claimed/Excess claimed)