Notice: This website will be closing on March 31st. Our ticketing system and knowledge base will continue on a new website. More information will follow soon.

Gstr 2a And 3b Reconciliation In Excel Format !link! Download

Reconciling GSTR 2A and GSTR 3B is a critical compliance process to ensure that the Input Tax Credit (ITC) you self-declare in your summary return (GSTR 3B) matches what your suppliers have reported (GSTR 2A). Download GSTR 2A and 3B Data

Reconciliation Category (example): in R2 -> =IF(H2=0,"Only in 3B",IF(M2=0,"Only in 2A",IF(ABS(M2-H2)<=1,"Matched","Partial/Discrepancy")))

GSTR 3B

Performing this reconciliation in Excel is the most efficient method, as it allows sorting, filtering, and identifying discrepancies easily. gstr 2a and 3b reconciliation in excel format download

📌 Step 1: Download Your Data

GSTR-2A (JSON → Excel): Go to GST Portal → Returns → GSTR-2A → Download JSON → Use a free online converter (e.g., ClearTax 2A to Excel converter or MasterGST) to convert JSON to Excel.
GSTR-3B Data: Download your filed GSTR-3B from the portal (Excel format available in the returns dashboard).

Reconciliation Category (example): in R2 -> =IF(H2=0,"Only in 3B",IF(M2=0,"Only in 2A",IF(ABS(M2-H2)<=1,"Matched","Partial/Discrepancy")))

GSTR 3B

Performing this reconciliation in Excel is the most efficient method, as it allows sorting, filtering, and identifying discrepancies easily.

📌 Step 1: Download Your Data

GSTR-2A (JSON → Excel): Go to GST Portal → Returns → GSTR-2A → Download JSON → Use a free online converter (e.g., ClearTax 2A to Excel converter or MasterGST) to convert JSON to Excel.
GSTR-3B Data: Download your filed GSTR-3B from the portal (Excel format available in the returns dashboard).