GSTR-3B is the monthly self-declaration filing where you report the total ITC claimed based on your own purchase registers. 3. The Reconciliation Process
Select the relevant and Return Filing Period (Month/Quarter) . Click on Search . Locate the Form GSTR-2A tile and click Download .
While building custom spreadsheets gives you deep visibility into tax records, manual reconciliation can become overwhelming if your business processes hundreds of B2B invoices monthly.
Approximately your business handles each month? gstr 2a and 3b reconciliation in excel format download
: Month-wise or party-wise comparisons showing total input uploaded vs. recorded in books. Limitations :
Here is a practical workflow for performing the reconciliation using Excel. This can be done manually or with the help of automated templates.
The annual return requires consolidation of monthly data. Performing monthly reconciliations in an Excel format makes the annual filing process significantly smoother, as all discrepancies are already identified and tracked. GSTR-3B is the monthly self-declaration filing where you
: While GSTR-2A is dynamic, GSTR-2B is a static statement generated on the 14th of every month. Use GSTR-2B to lock in your ITC for the specific month's GSTR-3B filing, and use GSTR-2A for year-end tracking and supplier auditing.
Use VLOOKUP or XLOOKUP to compare the two sheets based on the or a Unique Key (GSTIN + Invoice No). Essential Excel Formulas for Reconciliation:
Based on this analysis, you can create a summary table to report your findings, which can be used to communicate with your team or clients. Click on Search
: The GSTZen Consolidated Report provides a structured XLS file that compares GSTR-1, 2A, and 3B data against purchase registers.
Ensures you don’t miss out on credit for which you have paid taxes.
Our recommended Excel reconciliation tool consists of three main sheets:
Detecting unclaimed ITC allows you to reduce your cash tax liability in the subsequent months. The Key Differences: GSTR-2A vs. GSTR-3B Nature of Return Dynamic, read-only auto-populated statement. Static, self-declared summary return. Source of Data Uploaded by your respective suppliers in their GSTR-1. Compiled by you from your internal Purchase Register. Purpose To view and verify the ITC available to you. To claim the ITC and pay your monthly tax liability. Step-by-Step Guide to Reconcile GSTR-2A and 3B in Excel Step 1: Download and Prepare Your Data