Gstr 2a And 3b Reconciliation In Excel Format [verified] Download Jun 2026

If the supplier fails to report an invoice in their GSTR‑1 (which populates GSTR‑2A), the buyer cannot claim ITC on that purchase, regardless of whether they have recorded it in their books. Nowadays many clients receive notices for claiming inputs higher in GSTR‑3B than what is represented in GSTR‑2A, making such reconciliation prudent.

: Export your purchase data from your accounting software (e.g., Tally) into a standard Excel format. Use Key Formulas VLOOKUP / XLOOKUP gstr 2a and 3b reconciliation in excel format download