Gstr 2a Reconciliation In Excel ((better)) ✦ Original & Proven

Usually due to rounding off or incorrect tax rates entered by the supplier. Missing in 2A: Supplier hasn't filed their GSTR 1.

Sometimes "INV-001" is recorded as "001" in the portal. Use Excel functions like TRIM or TEXT to align them.

Stop leaving ITC on the table. Reconcile smartly with Excel.

(Assuming GSTIN is in column B, Invoice Number in column C)

Identify mismatches (missing invoices, wrong GSTIN, incorrect amounts) so you claim only the eligible ITC.

This is the heart of manual reconciliation. You want to see if an invoice from your books exists in the GSTR 2A data.