Gstr 2a And 3b Reconciliation In Excel Format Download [2021] [2025]

Difference = ITC_in_3B - ITC_in_2A Status = IF(Difference=0,"Matched",IF(Difference>0,"Excess Claimed","Under-claimed"))

To perform reconciliation in Excel, you must first extract the raw data from the GST Portal : : Log in to the GST Portal . Navigate to Services > Returns > Returns Dashboard . Select the Financial Year and Month/Quarter. In the Auto Drafted details (GSTR-2A) box, click Download . gstr 2a and 3b reconciliation in excel format download

Reconciliation between (auto-drafted inward supply statement) and GSTR-3B (monthly self-declared summary return) is critical for GST compliance in India. Mismatches can lead to: In the Auto Drafted details (GSTR-2A) box, click Download

Use the ROUND function to ignore small differences (like ₹1 or ₹2) that occur due to decimal points. : While in-house Excel solutions keep data within

: While in-house Excel solutions keep data within the user's system, manual sheets are more prone to formula errors compared to dedicated compliance software. Why This Reconciliation is Mandatory