Copy the below CSV into a file named reconciliation.csv and open in Excel:

: Ensures you only claim credit for taxes actually paid to your suppliers, preventing over-claims and potential penalties. Mismatched Identification

: Download your filed GSTR-3B details from the portal (typically Table 4A for ITC).

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

Here is a step-by-step guide to reconciling GSTR 2A and 3B returns using the Excel format: