How to compare purchase records with GSTR-2B
New to the two statements? Read GSTR-2A vs GSTR-2B: difference and reconciliation first.
GSTR-2B is a reference for reviewing input tax credit against supplier-reported invoices. Compare it with your purchase register to spot missing invoices, incorrect GSTINs, and differences in tax amounts. A match alone does not establish ITC eligibility; check the statutory conditions for your period and facts.
This download is a starting layout for manual review. It does not connect to the GST portal, read your exports, or reconcile records automatically. For a large invoice set, use a spreadsheet or a dedicated reconciliation system that supports your actual file formats.
GSTR-2A vs GSTR-2B: Understanding the Difference
To grasp the importance of reconciliation, one must understand the difference between GSTR-2A and GSTR-2B.
GSTR-2A is a dynamic statement. If a supplier files their January return in July, the invoice will appear in your January GSTR-2A. It constantly changes based on supplier actions. Because of this dynamic nature, claiming ITC based on GSTR-2A became a logistical nightmare for businesses and tax auditors alike.
GSTR-2B is a static statement for a tax period. Supplier reporting dates can affect when an invoice appears. Check the statement for the relevant period and verify the current ITC rules before making a claim.
The Dangers of Mismatched ITC
Unreviewed differences can lead to incorrect return figures. Investigate them before filing rather than assuming every book entry is eligible credit.
- Book entry missing from GSTR-2B: Check the supplier, invoice details and relevant filing period. Determine the appropriate treatment under current rules before claiming credit.
- GSTR-2B entry missing from books: Confirm the invoice belongs to your business and that the underlying supply meets the applicable ITC conditions before recording it.
How to Use the Free CSV Reconciliation Tool
The downloadable CSV shows useful columns for a comparison sheet. It is an example file, so remove its illustrative rows before entering actual data. Your comparison work takes place in the spreadsheet program you choose.
- Download the Template: Click the download button above to get the standard CSV template.
- Export Your Books: Export your monthly purchase register from your accounting software. Ensure you have the GSTIN of the supplier, Invoice Number, Invoice Date, Taxable Value, and Tax Amounts.
- Download GSTR-2B: Log into the official GST Portal. Navigate to Returns Dashboard -> Select Financial Year and Month -> Download GSTR-2B. (We recommend downloading the Excel/CSV version).
- Compare and document: Use your spreadsheet software to compare supplier GSTIN, invoice number, date and tax amounts. Document any difference and verify the source records before deciding what to file.
Handling Mismatches: The 3 Action Buckets
During a manual comparison, you may find these common situations:
1. Matching details: The invoice appears in both sources with consistent figures. Actual ITC entitlement remains subject to the applicable statutory conditions and documentation requirements.
2. Missing in GSTR-2B: An invoice in your books is absent from the statement. Check its period, supplier reporting and current ITC conditions; follow up with the supplier as needed.
3. Value mismatch: Both sources show the invoice but the amounts differ. Review the original invoice, amendments and credit notes, then verify the correct treatment for your return.
Template scope: The CSV is illustrative and performs no calculation or matching. It does not determine legal ITC eligibility, whether interest is payable, or whether a notice will be issued.
Next Steps in Your ITC Workflow
After reviewing your invoice differences, explore our ITC calculator and ITC reversal checker. Verify any filing decision against current official guidance.