Free GST tool
GSTR-2B vs Purchase Register Reconciliation
Upload your GSTR-2B JSON and your purchase register. Get a supplier-wise, invoice-level reconciliation in seconds.
How it works
- 1
Download your GSTR-2B
On the GST portal go to Returns → GSTR-2B, pick the month and click Download JSON. Add several months together for a quarter or a year.
- 2
Fill the purchase register template
Download the Optotax template from the tool. Enter invoices in the B2B sheet and credit or debit notes in the CDNR sheet, then upload it.
- 3
Review and download
See what matched, what differs and what is missing on either side, with the ITC at stake. Download the full report in Excel.
What the result tells you
Every purchase and every 2B document lands in exactly one of these buckets. Documents are matched on supplier GSTIN and invoice / note number, ignoring case, spaces, slashes and leading zeros.
- Matched
- Same supplier, same document, amounts within your tolerance.
- Mismatched
- Same document but the taxable value, a tax head, or the date differs — including IGST charged where you booked CGST + SGST.
- Probable match
- Amounts agree for the same supplier but the invoice number was typed differently. Check these before you claim.
- Missing in GSTR-2B
- In your books but the supplier has not reported it. ITC on these is at risk — follow up with the supplier.
- Missing in books
- Reported by the supplier but not in your register. Either an unrecorded purchase or ITC you have not claimed.
More on Optotax
15 more GST reports, one click each
Optotax pulls your returns straight from the GST portal, so there are no JSON files to download and no spreadsheets to stitch together. Pick a GSTIN and a financial year and get the report in Excel, for every client you manage.
Reconciliations
GSTR-1 vs GSTR-3B
Compare tax declared in GSTR-1 with tax paid in GSTR-3B month by month, and fix gaps before they turn into a DRC-01B notice.
GSTR-2B vs GSTR-3B
Check the ITC you claimed in GSTR-3B against what GSTR-2B allows, before a DRC-01C intimation does it for you.
GSTR-2A vs GSTR-3B
Match ITC claimed against everything your suppliers have reported, including late filers, for annual review and audits.
GSTR-2A vs GSTR-2B
See which invoices reached 2A but not 2B, so you know which credits will arrive in a later month.
E-invoice vs Sales
Find sales invoices with no IRN, and IRNs missing from your sales register.
E-invoice vs E-way Bill
Spot e-invoices without an e-way bill, and e-way bills that do not match the invoice.
Sales (GSTR-1)
GSTR-1 Detailed Report
Every invoice, credit note and amendment you filed for the year, in one Excel file.
GSTR-1 Party & Rate-wise Summary
Outward supplies totalled by customer and by tax rate, ready for review or GSTR-9.
Purchases & ITC
GSTR-2B Detailed Report
Invoice-level 2B for the whole year with ITC availability, without downloading 12 JSON files.
GSTR-2B Party & Rate-wise Report
Your eligible ITC totalled by supplier and by rate.
GSTR-2A Detailed Report
Every purchase your suppliers reported, with their filing status, to chase the ones who have not filed.
GSTR-2A Party & Rate-wise Summary
Supplier-wise and rate-wise totals of your inward supplies.
Returns & ledgers
GSTR-3B Summary Report
Month-wise liability, ITC and tax paid for the whole year on one sheet.
ITC & Cash Ledger Report
Electronic credit and cash ledger balances and movements, without logging in to the portal.
TDS/TCS Credit Received Report
TDS and TCS credited to you by deductors and e-commerce operators, so none of it goes unclaimed.
Reconcile every client automatically
Optotax pulls GSTR-2A, 2B and IMS data directly from the GST portal and reconciles it against your purchase register for all your GSTINs — every month, without downloads.
Sign Up Free