Gstr 2a And 3b Reconciliation In Excel Format Upd Download -

Reconciling GSTR 2A with GSTR 3B is a critical compliance activity for GST-registered businesses to ensure the Input Tax Credit (ITC) claimed in summary returns matches the details uploaded by suppliers. Direct Download Options

3. Common Causes of Mismatches

• Timing differences (supplier filed later / earlier period)
• Data entry errors (GSTIN, invoice number, invoice date, taxable value, tax rate)
• Credit/debit notes not matched or filed in different periods
• Reverse charge, advances, import of services classification differences
• Missing supplier filings or incorrect HSN/tax rate classification
• Rounding differences and reporting thresholds

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")

  4. Reconciliation Objectives and Tolerances

  • Primary objective: map invoice-level GSTR‑2A amounts to GSTR‑3B ITC claimed split by IGST/CGST/SGST/UTGST.
  • Secondary objectives: identify unmatched invoices, quantify timing differences, flag possible non-filing suppliers.
  • Tolerances: allow small differences (e.g., rounding ±1 INR or percentage threshold 0.5%) as configurable.

  Direct creation instructions:

  Which would you prefer?

  • Clear previous MatchFlag values.
  • First pass: exact key match; mark matches.
  • Second pass: date-tolerant matches; mark matches and note reason.
  • Third pass: tolerance/fuzzy matches by GSTIN+value; mark matches.
  • Summarize matched amounts by tax head and output Reconciliation_Report.
  • Log run in Audit_Log with counts and timestamp.