=IF(COUNTIFS(GSTR2A!B:B, B2, GSTR2A!C:C, C2, GSTR2A!D:D, D2)>0, "Yes", "No")
Need a ready-made template? Copy the column headers provided in this article into a new Excel sheet, add VLOOKUPs, and you have your own GSTR-2A vs GSTR-3B reconciliation tool – completely free. gstr 2a and 3b reconciliation in excel format download
| Sheet Name | Source | Key Columns | |------------|--------|--------------| | GSTR-2A_Excel | GST Portal download | GSTIN of supplier, Invoice No., Invoice Date, Taxable Value, CGST, SGST, IGST, Cess | | Purchase_Register | Your books (or GSTR-3B Table 4) | Same fields + ITC claimed in 3B | =IF(COUNTIFS(GSTR2A
For Goods and Services Tax (GST) filers in India, one of the most tedious yet critical compliance tasks is reconciling (the auto-drafted purchase statement) with GSTR-3B (the summary self-declared return). Mismatches between these two forms can lead to denied Input Tax Credit (ITC), interest liabilities, and even show-cause notices from tax authorities. Mismatches between these two forms can lead to
: An Excel utility designed for Office 365/Excel 2021 that offers multi-level reconciliation and variance reports.
In the Reconciliation sheet, use:
