Gstr 2a Reconciliation In Excel |best| < VERIFIED >

Need specific for fuzzy matching (like when invoice numbers almost match)? Want a template structure for your columns? Interested in how GSTR 2B differs in this process?

| Status | Action Required | | :--- | :--- | | | ✅ Claim full ITC. | | MISSING | 📧 Contact supplier immediately. Ask them to file GSTR-1 (or correct via GSTR-1/IFF). | | MISMATCH (Value) | 🔍 Check for credit notes, volume discounts, or round-off errors. Reconcile with supplier. | | MISMATCH (Date) | ⚠️ Supplier may have filed in next month. Eligible ITC may be claimed later (GSTR-3B). | | Duplicate in your books | ❌ Remove duplicate entry. Do not claim ITC twice. | gstr 2a reconciliation in excel