Ensure that critical fields like Supplier GSTIN , Invoice Number , Invoice Date , and Tax Amount are formatted identically in both sheets (e.g., remove spaces or special characters from invoice numbers). Step 2: Use the VLOOKUP or XLOOKUP Formula
[Supplier GSTIN] | [Books Taxable Value] | [Portal Taxable Value] | [Difference] | [Status] Step-by-Step Excel Formula Guide
No. As per Section 16(2) of the CGST Act, ITC can be claimed only if the supplier has reported the invoice in their GSTR‑1, which populates GSTR‑2A. You must follow up with the supplier to get the invoice uploaded.
Ensure that critical fields like Supplier GSTIN , Invoice Number , Invoice Date , and Tax Amount are formatted identically in both sheets (e.g., remove spaces or special characters from invoice numbers). Step 2: Use the VLOOKUP or XLOOKUP Formula
[Supplier GSTIN] | [Books Taxable Value] | [Portal Taxable Value] | [Difference] | [Status] Step-by-Step Excel Formula Guide
No. As per Section 16(2) of the CGST Act, ITC can be claimed only if the supplier has reported the invoice in their GSTR‑1, which populates GSTR‑2A. You must follow up with the supplier to get the invoice uploaded.