Download the GSTR 2A JSON or Excel files from the GST portal and paste the raw data into this sheet. Ensure you have these exact columns: Supplier GSTIN Supplier Trade/Legal Name Invoice Number Invoice Date Invoice Value Taxable Value Integrated Tax (IGST) Central Tax (CGST) State/UT Tax (SGST) 2. The Purchase Register (PR) Sheet
For , download a free automated tool like:
: The invoice exists in your accounting books (GSTR-3B) but shows a zero value under GSTR-2A. You must contact the vendor to upload it in their next GSTR-1 filing. gstr 2a and 3b reconciliation in excel format download
Once your Excel sheet runs the comparison, categorize the results into these actionable buckets: Action Required Invoices match perfectly in both data sets. No action needed. Missing in 2A
If you download a standard reconciliation utility, the workflow generally looks like this: Download the GSTR 2A JSON or Excel files
The most basic "format" is the official Excel file generated by the GST Portal. Log in to the GST Portal. Step 2: Navigate to Services > Returns > Returns Dashboard . Step 3: Select the Financial Year and Return Period.
– Copy the table below into Excel:
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.
A GSTR 2A and 3B reconciliation Excel template typically includes the following sheets: You must contact the vendor to upload it