If you download a standard reconciliation utility, the workflow generally looks like this:

Implementing a structured Excel-based reconciliation with clear matching rules, tolerances, audit trails, and automation via Power Query/VBA provides an effective way to validate GSTR‑3B ITC claims against GSTR‑2A. Governance and regular supplier engagement are critical to resolving persistent variances.

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

Reconciliation = Matching each purchase invoice in GSTR-3B with entries in GSTR-2A to ensure:

Create a new Excel file with 3 worksheets: