[Insert downloadable link]
In your tab, add a new column named "ITC in 2A". Use this formula to pull corresponding values from the GSTR-2A tab based on the unique Invoice Number:
: A monthly or quarterly self-declared summary return. You use this to declare your outward liabilities, claim ITC, and pay your taxes. Why GSTR-2A and GSTR-3B Reconciliation is Mandatory gstr 2a and 3b reconciliation in excel format download
=IF(H2=0, "Matched", IF(H2>0, "Missing in GSTR 2A", "Excess Claimed in Books")) Use code with caution. Step-by-Step Guide to Download the Excel Template
The Goods and Services Tax Network (GSTN) tracks mismatches between auto-generated data and self-declared returns. If your claimed ITC in GSTR-3B exceeds the ITC available in GSTR-2A/2B, tax authorities will issue automated demand notices (such as Form DRC-01C). Protect Your Cash Flow [Insert downloadable link] In your tab, add a
Go to > Conditional Formatting > Highlight Cells Rules > Not Equal To .
Here is a step-by-step guide to reconciling GSTR 2A and 3B returns using the Excel format: Protect Your Cash Flow Go to > Conditional
: Avoid the risk of accidentally claiming ITC on the same purchase invoice twice. Step-by-Step Guide to Download Data from the GST Portal