Free tool

Purchase Register vs GSTR-2B Reconciliation

Paste your purchase register and the GSTR-2B B2B sheet to see what matches, what differs and what is missing on either side.

Purchase register and GSTR-2B

Your data is processed in your browser and never uploaded.

Copy from the single header row (GSTIN of supplier, Invoice number, Taxable Value, Integrated Tax…) downwards.

Applied to taxable value and each tax head.

Invoice number matching

Always case-insensitive and ignores spaces.

How to read the results

  • Matched: same supplier GSTIN and invoice number, with taxable value and each tax head within the tolerance.
  • Value mismatch: the invoice is in both, but amounts differ. The difference is shown as GSTR-2B minus books.
  • In books, not in 2B: the supplier may not have reported it yet, may have reported it under another GSTIN or period, or the invoice number differs.
  • In 2B, not in books: an invoice the supplier reported that is not in your purchase register (missed entry, a later month, or not your purchase).
  • Possible match: same supplier and amount, different invoice number. Usually a typing difference.

Example (illustrative)

A Rajkot pipe manufacturer records invoice “SG/0045” from a glaze supplier; GSTR-2B shows it as “SG/45”. With “ignore leading zeros” on, it matches. Another invoice shows IGST ₹7,200 in the books but ₹6,800 in GSTR-2B, so it appears as a value mismatch of −₹400 to follow up with the supplier.

Common mistake

Treating every matched invoice as eligible credit. GSTR-2B shows what suppliers reported; it does not decide whether the credit is blocked, whether goods were received, or whether the time limit has passed.

Limitations

Only the B2B invoice sheet is compared. Credit/debit notes, amendments, ISD credits and imports are not covered. Use the GST portal for the official GSTR-2B statement.

Frequently asked questions

How are invoices matched?

By supplier GSTIN plus invoice number. Invoice numbers are compared without case and spaces, and you can choose to ignore leading zeros and the "/" and "-" separators. Rows with the same GSTIN and invoice number are added together, so multi-rate invoices match as one.

What is a “possible match”?

An invoice in your books and one in GSTR-2B from the same supplier with the same taxable value and tax (within your tolerance) but a different invoice number. Usually it is a typo in the invoice number on one side. Confirm it against the supplier’s invoice.

If an invoice is matched, can I claim the credit?

Not automatically. A match shows that the supplier reported the invoice. Eligibility also depends on the conditions in Section 16 of the CGST Act and on blocked credits under Section 17(5). Check with your tax adviser.

Can I upload the GSTR-2B Excel file directly?

Open the downloaded GSTR-2B Excel, go to the B2B sheet, and copy the rows from the header row down, then paste here. You can also save that sheet as CSV and upload it. The file never leaves your browser.

Android app

Make your e-way bill workflow simpler

Create the sales invoice, review e-way bill details and generate, all from your phone with E-Way Easy.