The Global Lens
Home

Gstr 2a And 3b Reconciliation In Excel Format Download

If you want to build a robust GSTR-2A and 3B reconciliation Excel format yourself, include these features:

  • Alert system – if 3B claimed > (2A total + 5%), trigger warning

    • | Feature | GSTR-2A | GSTR-3B | |---------|---------|---------| | Nature | Dynamic, purchase-wise statement | Summary monthly return | | Source | Auto-populated from supplier’s GSTR-1 | Self-declared by taxpayer | | ITC Relevance | Eligible ITC as per supplier records | Claimed ITC (may include ineligible items) | | Amendability | Not editable by recipient | Fully editable before filing | | Due Date | Available on 11th of next month | Filed by 20th of next month | gstr 2a and 3b reconciliation in excel format download

    Reconciliation = Matching each purchase invoice in GSTR-3B with entries in GSTR-2A to ensure: If you want to build a robust GSTR-2A

  • Ensure numeric columns are VALUE() converted.
  • Aggregate GSTR‑2A by invoice key and compute tax totals if duplicates exist.
  • Map GSTR‑3B claimed totals to invoice-level: Ideally start with purchase register matching; otherwise, allocate proportionally.
  • Multi-pass matching strategy:
  • Reconcile totals to GSTR‑3B by tax head (IGST/CGST/SGST/Cess) and compute residual unreconciled amount:
  • Age unmatched invoices by invoice date to identify older supplier delinquencies.

    • Featured Posts

    close