Gstr 2a And 3b Reconciliation In Excel Format Download [repack] -

GSTR-2A and GSTR-3B Reconciliation in Excel: A Complete Guide Introduction Reconciliation between GSTR-2A (auto-drafted inward supply statement) and GSTR-3B (monthly self-declared summary return) is critical for GST compliance in India. Mismatches can lead to:

Loss of Input Tax Credit (ITC) Show cause notices from tax authorities Interest and penalties

Performing this reconciliation in Excel is the most efficient method, as it allows sorting, filtering, and identifying discrepancies easily.

What is GSTR-2A and GSTR-3B? | Return | Description | |--------|-------------| | GSTR-2A | Purchase-related auto-populated statement based on supplier’s GSTR-1 and GSTR-5. Read-only. | | GSTR-3B | Monthly summary return filed by taxpayer declaring sales, purchases, ITC claimed, and tax payable. | gstr 2a and 3b reconciliation in excel format download

Why Reconcile GSTR-2A with GSTR-3B?

ITC Eligibility – Only ITC appearing in GSTR-2A (or 2B) can be claimed in GSTR-3B (Rule 36(4)). Mismatch Detection – Identify missing invoices, incorrect GSTINs, or wrong tax amounts. Vendor Follow-up – Track which suppliers have not filed their GSTR-1. Audit Readiness – Maintain a clear trail of ITC claimed vs. available.

How to Download GSTR-2A and GSTR-3B in Excel Format 1. Download GSTR-2A as Excel GSTR-2A and GSTR-3B Reconciliation in Excel: A Complete

Log in to the GST Portal (https://www.gst.gov.in). Go to Services → Returns → Returns Dashboard . Select the financial year and month . Click on GSTR-2A (Inward Supplies). Click Download → Select Excel format. Save the file – it contains multiple sheets (B2B, B2BA, CDNR, etc.).

2. Download GSTR-3B as Excel As of now, the GST portal does not provide a direct Excel download of GSTR-3B. However, you can:

Option A (Recommended) : Download GSTR-3B as JSON/PDF and manually create an Excel extract of ITC claimed (Table 4). Option B : Use the Offline Utility for GSTR-3B (Excel-based) available on the portal under Downloads → Offline Tools . | Return | Description | |--------|-------------| | GSTR-2A

Alternatively, export your ERP or accounting software (Tally, Busy, Zoho, etc.) purchase register as Excel.

Step-by-Step Reconciliation in Excel Step 1: Prepare Your Data | Sheet Name | Source | Key Columns | |------------|--------|--------------| | GSTR-2A_Excel | GST Portal download | GSTIN of supplier, Invoice No., Invoice Date, Taxable Value, CGST, SGST, IGST, Cess | | Purchase_Register | Your books (or GSTR-3B Table 4) | Same fields + ITC claimed in 3B | Step 2: Standardize Columns Ensure both sheets have consistent headers: