Gstr 2a Reconciliation In Excel

Ensure both sheets have tax columns (CGST, SGST, IGST) formatted as numbers. 2. Consolidate Data

Once the data is linked, compare the tax amounts. You can create a "Difference" column: = (Tax_in_Books) - (Tax_in_GSTR2A) Perfect match. gstr 2a reconciliation in excel

(in M2): =IF(ISNA(VLOOKUP(A2, GSTR2A_Data!A:A, 1, FALSE)), "MISSING", "FOUND") Ensure both sheets have tax columns (CGST, SGST,

Correct discrepancies in invoice numbers, dates, or tax amounts. Prevent the loss of ITC due to supplier negligence. "FOUND") Correct discrepancies in invoice numbers