Gstr 2a And 3b Reconciliation In Excel Format Free Download Link

📥 Excel Template Structure

Sheet 1: GSTR-2A Data (Purchase Register as per Govt)

| Columns | Description | |---------|-------------| | GSTIN of Supplier | 15-digit | | Invoice No. | | | Invoice Date | | | Taxable Value | | | CGST | | | SGST | | | IGST | | | Cess | | | Total Tax | | | Month | (e.g., Oct 2024) |

Ensure that GSTINs, Invoice Numbers, and Dates are in the same format across both sheets. Use Excel functions like TRIM to remove extra spaces. 3. Match Invoices Compare the data points. Look for: Exact matches (GSTIN + Invoice No + Amount). Partial matches (Different invoice numbering styles). Missing invoices (In books but not in 2A, or vice versa). 4. Identify Discrepancies Categorize differences into: Timing differences: Supplier filed in a later month. Data entry errors: Wrong GSTIN or invoice amount. Non-compliance: Supplier has not filed at all. Building Your Excel Reconciliation Tool gstr 2a and 3b reconciliation in excel format download

2) Useful Excel formulas (apply per row)

• Total Tax (GSTR-2A): in H2 -> =E2+F2+G2
• Total Tax (GSTR-3B): in M2 -> =J2+K2+L2
• Difference (Tax): in O2 -> =IF(AND(H2="",M2=""),"",M2-H2)
• Invoice Match Status: in N2 -> =IF(AND(A2<>"",B2<>"",ABS(M2-H2)<=1),"Match","Mismatch")

  Disclaimer: GST rules and portal features change frequently. Always refer to the latest GST Act and circulars. 📥 Excel Template Structure Sheet 1: GSTR-2A Data

  1. Sheet1: GSTR-2A Data (invoice-level)
  2. Sheet2: GSTR-3B Data (summary or invoice-level if maintained)
  3. Sheet3: Reconciliation Summary (match status)
  4. Sheet4: Mismatch Report

  ICAI Bangalore Summary Template: Provides a structured layout for monthly inward supply reconciliation against the electronic credit ledger. ⚡ Key Features to Look For Total Tax (GSTR-2A): in H2 -&gt; =E2+F2+G2 Total