Add a Variance column at the end of your purchase register sheet. Formula: =Book_IGST_Value - GSTR_2A_IGST_Value
Reconciliation ensures that the ITC you claim in your GSTR-3B matches the taxes your suppliers paid to the government. Avoid Statutory Legal Notices
: Login to the GST Portal, go to Services > Returns > Returns Dashboard , select the period, and click Download under the GSTR-2A tile to generate an Excel file. gstr 2a and 3b reconciliation in excel format download
Invoice details and tax amounts match perfectly between books and GSTR-2A. Claim 100% ITC safely.
This comprehensive guide breaks down the reconciliation process, provides a structural framework to build your own Excel matching tool, and explains how to handle discrepancies effectively. What is GSTR-2A and GSTR-3B Reconciliation? Add a Variance column at the end of
Calculate the difference between your books and the portal data: =Books_IGST - Portal_IGST Common Reasons for Mismatches
: Tax authorities actively issue scrutiny notices if the ITC claimed in GSTR-3B exceeds the amount available in your auto-populated GSTR-2A/2B. Invoice details and tax amounts match perfectly between
Ensures you don’t miss out on credit for which you have paid taxes.
: To match invoice numbers and GSTINs between your books and the 2A data.
To begin your reconciliation process in Excel, you must first gather your data sheets from the official government portal. 1. Download GSTR-2A in Excel Format
After running the formulas, you can categorize the results: