Gstr 2a And 3b Reconciliation: In Excel Format ((top)) Download

Before jumping into Excel formulas, it is important to understand what these two components represent:

: You can download GSTR 2A data directly in Excel format by navigating to the Returns Dashboard , selecting the period, and clicking "Generate Excel File to Download" in the GSTR 2A tile.

Set up these identical headers in both data tabs to ensure your comparison formulas work perfectly: Supplier Name Invoice Number Invoice Date Taxable Value CGST SGST IGST 2. Reconciliation Summary Tab Layout

=IF(B2=C2, "Matched", "Difference") – To flag discrepancies. gstr 2a and 3b reconciliation in excel format download

: To total supplier-wise ITC to compare with the consolidated 3B claim. : To identify small rounding differences: =IF(ABS(A2-B2)<=1,"Matched","Mismatch") Identify Mismatches : Invoices present in both books and 2A. Missing in 2A : Supplier hasn't filed; follow up with them immediately. Missing in Books

Step-by-Step Process to Download GSTR-2A in Excel Format Step 1: Log in to the GST portal with your username and password. Step 2: GSTR 2A Reconciliation with GSTZen

Our recommended Excel reconciliation tool consists of three main sheets: Before jumping into Excel formulas, it is important

means matching the eligible ITC available in GSTR-2A with the ITC you actually claimed in your GSTR-3B return. Why You Must Reconcile GSTR-2A and GSTR-3B

Columns (one column per letter):

What you are using (Microsoft 365, Excel 2016, etc.)? : To total supplier-wise ITC to compare with

: Highlight rows where the tax amount in your books differs from the portal data. Importance of Regular Reconciliation Comparison and Reconciliation of GSTR 3B and GSTR 2A

When analyzing your column, you will likely encounter these standard categorization issues:

(Assuming Column C contains Invoice Numbers and Column F contains IGST values). Step 5: Identify Discrepancies

Supplier reported the invoice with a wrong GSTIN.