Click and select Generate Excel File to save the sheet to your local drive. Structural Template: Excel Reconciliation Format
: 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.
Guide to Reconciling GSTR 2A and GSTR 3B in Excel Reconciling GSTR 2A with GSTR 3B is essential for ensuring that the Input Tax Credit (ITC) claimed in your monthly summary return (GSTR 3B) matches the data auto-populated from your suppliers' filings (GSTR 2A). This process helps identify missing invoices and avoid legal notices from tax authorities. Step-by-Step Reconciliation Process GSTR2A & GSTR2B Automatic Reconciliation Excel Tool gstr 2a and 3b reconciliation in excel format download
Contact the supplier to change the status from B2C to B2B in their next return filing. Free GSTR 2A and 3B Reconciliation Excel Template Structure
The Goods and Services Tax Network (GSTN) tracks mismatches between auto-populated credits and claimed credits, triggering automated demand notices for discrepancies. Click and select Generate Excel File to save
. This process matches the ITC declared in your self-summary return (3B) with the invoices uploaded by your suppliers (2A). Importance of Reconciliation
: The supplier accidentally enters a different buyer's GSTIN, routing your credit to someone else. This process helps identify missing invoices and avoid
Regular reconciliation highlights which suppliers are defaulting on their GST filings. You can hold payments or follow up with defaulting vendors before the statutory deadlines close for the financial year. Step-by-Step GSTR-2A vs 3B Reconciliation Process in Excel
You can use these free Excel utilities to automate the matching process: GSTZen Sample Report : A consolidated Excel file for comparing GSTR-1, 2A, and 3B data Finexo Online Tool : A free web-based utility to reconcile GSTR-2A and purchases that exports results to Excel. GSTplus Utility : A comprehensive GSTR-2A reconciliation utility designed for large datasets. 2. Guide: Step-by-Step Excel Reconciliation Step 1: Download Portal Data Log in to the GST Portal Returns Dashboard Select the Financial Year box, click and select Generate Excel File Repeat this for to get your filed summary. Step 2: Export Books of Accounts Export your Purchase Register
The automated sheet showing matches, mismatches, and actions required. Step-by-Step Guide to Reconciling in Excel