Create a status column to highlight variances automatically. =IF(PR_IGST = GSTR2A_IGST, "Matched", "Mismatch") Use code with caution. SUMIF / SUMIFS
Reconciling GSTR-2A and GSTR-3B is a critical compliance requirement for every GST-registered taxpayer. Failing to match these returns can lead to severe tax notices, penalties, and the loss of Input Tax Credit (ITC).
Use these functions to find if an invoice from your books exists in the GST portal data, and vice versa. For example, to check if an invoice in your purchase register is in the portal data: =XLOOKUP(1, (Books_Data!A:A='Reconciliation_Output'!A2)*(Books_Data!B:B='Reconciliation_Output'!B2), 'Reconciliation_Output'!C:C, "Not Found")
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. gstr 2a and 3b reconciliation in excel format download
– Copy the table below into Excel:
: Export your purchase data from your accounting software (e.g., Tally) into a standard Excel format. Use Key Formulas VLOOKUP / XLOOKUP
For professionals managing data for multiple periods or GSTINs, this tool helps consolidate GSTR-2A Excel workbooks. It is designed to work with specific naming conventions ( GSTIN_MMYYYY_R2A.Xlsx ) and uses Microsoft Excel's Power Query to auto-compile data. Create a status column to highlight variances automatically
Disclaimer: This article is for informational purposes only and does not constitute professional tax advice. GST laws and procedures are subject to change. Always consult with a qualified tax advisor for your specific circumstances.
For , download a free automated tool like:
: The supplier amended an old invoice in a later month, changing the data dynamically. How to Set Up Your Excel Reconciliation Worksheet Failing to match these returns can lead to
: Ensure your internal data entry team follows a standardized format for entering invoice numbers.
The practice of reconciling GSTR-3B with GSTR-2A and GSTR-2B is no longer a mere suggestion but a strict requirement for smooth GST compliance. As the system moves towards greater automation and lock-in of returns, the accuracy and timeliness of this process are paramount.