In Excel - Gstr 2a Reconciliation

(in N2): =IF(M2="MISSING", "N/A", IF(VLOOKUP(A2, GSTR2A_Data!A:F, 5, FALSE)=E2, "MATCH", "MISMATCH"))

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

Sub ReconcileGSTR2A() 'Refresh Power Query ActiveWorkbook.RefreshAll 'Add formulas for new rows Range("M2").AutoFill Destination:=Range("M2:M" & Range("A" & Rows.Count).End(xlUp).Row) 'Filter for MISSING ActiveSheet.Range("A1:M1").AutoFilter Field:=13, Criteria1:="MISSING" End Sub gstr 2a reconciliation in excel

Before you begin, ensure you have the following:

GST Council mandates that businesses can only claim Input Tax Credit (ITC) if the details are uploaded by their suppliers. This makes GSTR 2A reconciliation in Excel a critical monthly task for every taxpayer to ensure tax compliance and maximize cash flow. (in N2): =IF(M2="MISSING", "N/A", IF(VLOOKUP(A2, GSTR2A_Data

Copy-paste the respective data into these sheets.

Clean your Purchase Register first. Remove duplicates and ensure date formats are consistent ( DD-MM-YYYY ). This makes GSTR 2A reconciliation in Excel a

Why? Because the golden rule of GST is simple: