: A supplier records an interstate sale (IGST) as an intrastate sale (CGST/SGST), creating a structural mismatch.
Ask the supplier to amend the invoice via their next GSTR-1 amendment cycle. Pro-Tips for Seamless Monthly Matching gstr 2a and 3b reconciliation in excel format download
If you are setting up your own downloadable tracking sheet, structure it using this clean layout: Supplier GSTIN Supplier Name Invoice No. Invoice Date CGST (Books) Action Required 07AAAAA1111A1Z1 01-May-2026 08BBBBB2222B2Z2 05-May-2026 Missing in 2A Follow up with Vendor 09CCCCC3333C3Z3 12-May-2026 Amount Mismatch Check invoice copy Best Practices for Seamless Matching : A supplier records an interstate sale (IGST)
Using Excel for reconciliation is highly effective for most small to medium enterprises but requires specific data-handling techniques: : gstr 2a and 3b reconciliation in excel format download