Use the ROUND function to ignore small differences (like ₹1 or ₹2) that occur due to decimal points.
: Navigate to the Return Dashboard and select the financial year and month. Step C : Download GSTR-2A (or GSTR-2B) in Excel/JSON format.
: Detect clerical mistakes, duplicate entries, or rounding issues between your accounting data and portal data. Step-by-Step Data Download from the GST Portal gstr 2a and 3b reconciliation in excel format download
Consolidate your data into one workbook with two distinct tabs: : "GSTR 2A Data" (Portal Data) Tab 2 : "Purchase Register" (Your Book Data) Ensure both tabs contain these standardized columns: Supplier GSTIN Supplier Name Invoice Number Invoice Date Taxable Value Integrated Tax (IGST) Central Tax (CGST) State Tax (SGST) Step 3: Standardize the Invoice Numbers
: Do not leave reconciliation for the end of the financial year. Use the ROUND function to ignore small differences
This guide provides a comprehensive walkthrough of the reconciliation process and explains how to use an Excel format to automate the task. Understanding GSTR 2A and GSTR 3B
: The supplier failed to file their GSTR 1 or missed adding your specific invoice. : Detect clerical mistakes, duplicate entries, or rounding
Download your purchase register (books of accounts) for the same period. Step 2: Standardize the Sheets Open Microsoft Excel and create three sheets: (Your internal purchase register) Sheet 2: "Portal Data" (The downloaded GSTR-2A data) Sheet 3: "Reconciliation Summary" (Where the magic happens)