RefinePoint

Blog · · 8 min read

GSTR-2B vs purchase register reconciliation: a step-by-step method

A practical method to reconcile GSTR-2B with the purchase register each month: files, cleaning, matching passes, buckets and what to claim in GSTR-3B.

Since 1 January 2022, input tax credit rests on one statement: GSTR-2B. If an invoice is not in your 2B, the credit on it waits, however correct your purchase register is. That makes the 2B reconciliation the most important GST working paper of the month, for an in-house team and for a CA firm filing on behalf of clients. This post sets out a method you can follow every month, with a worked example.

Why GSTR-2B is the basis for credit

Section 16(2)(aa) of the CGST Act, in force from 1 January 2022, allows credit only when the supplier has furnished the invoice or debit note in GSTR-1 or IFF and the details have been communicated to you. Rule 36(4), substituted by Notification 40/2021-Central Tax with effect from the same date, ties that communication to GSTR-2B under rule 60(7). The old 5% (earlier 10% and 20%) cushion for invoices not uploaded by suppliers went away at the same time.

Three portal facts shape the monthly routine:

  • GSTR-2B is generated on the 14th of the following month (for quarterly filers, on the 14th after the quarter). It is a read-only statement built from your suppliers' GSTR-1, IFF, GSTR-5 and GSTR-6, plus import data from ICEGATE.
  • The Invoice Management System (IMS) sits in front of it. Each inward record can be accepted, rejected or kept pending. Records you do not act on are deemed accepted when 2B is generated. You can change actions and recompute 2B until you file GSTR-3B for that period.
  • From the October 2025 tax period, IMS lets you keep certain credit notes pending for one tax period and declare how much credit you actually need to reverse against a credit note, instead of reversing the full tax shown on it. GSTN has said that ITC still auto-populates from 2B into GSTR-3B as before.

So the reconciliation has to be done after the 14th and before the GSTR-3B due date, and its output is two decisions: which IMS action to take on each record, and how much credit goes into table 4 of GSTR-3B.

Step 1: get the two files right

GSTR-2B. From the GST portal, Returns, choose the period, GSTR-2B, and download Excel or JSON. Use the B2B invoices, B2B credit and debit notes, and their amendment sheets. Keep the "ITC not available" section separate: it lists records where the portal has decided credit is not available, such as place-of-supply cases or invoices past the section 16(4) time limit.

Purchase register. From Tally, Zoho Books, Busy or SAP, export the register for the same month with these columns at minimum: supplier GSTIN, supplier name, supplier invoice number (not your voucher number), supplier invoice date, voucher type, taxable value, IGST, CGST, SGST and cess, and a reverse charge flag. If the register only has your voucher number, the match will be poor; fix the export before you start.

Decide the period rule once and write it in your working paper. The common choice is "books for the month of booking against 2B of the same month", with unmatched items carried forward to the next month.

Step 2: clean both sides the same way

Most false breaks come from formatting, not from tax. Apply the same cleaning to both sides:

Field Cleaning
GSTIN Upper case, strip spaces, check the 15th character (the check digit)
Invoice number Compare letters and digits only, drop leading zeros: INV/0042 and inv-42 should agree
Dates One format (DD-MM-YYYY), no time part
Credit notes Negative on both sides, so they net against invoices
Tax Total tax = IGST + CGST + SGST + cess, kept alongside each head

Remove from the books side anything that will never be in the B2B section: imports of goods (they come from bills of entry), import of services, and purchases from unregistered persons, including those under reverse charge. Keep reverse charge purchases from registered suppliers, which do appear in 2B with the reverse charge flag.

Step 3: match in passes, strictest first

Run passes in order, removing matched records before the next:

  1. GSTIN + invoice number + invoice date. The clean matches. Compare taxable value and each tax head.
  2. GSTIN + invoice number, date differs. Usually the books carry the goods receipt date. Match, but note the date.
  3. One portal invoice to several book entries. One supplier invoice booked as two vouchers (goods and freight, say), where the group total of tax agrees.
  4. Probable matches to confirm. Same GSTIN, invoice number that contains the other (2026/118 inside SGS/2026/118), tax within a rupee, date within a month. A person confirms these.
  5. Probable: same GSTIN, same taxable value, date within two weeks. For invoices typed with a completely wrong number. Again, confirm by hand.

A tolerance of about a rupee on tax absorbs rounding. Anything more is a real difference.

Step 4: put every break in a bucket

Each unmatched or partly matched line goes into one bucket with an owner and an action:

Bucket Meaning Action
Not in 2B In books, not on the portal Hold the credit; ask the supplier to file GSTR-1 or IFF; check for a wrong GSTIN
Not in books In 2B, not booked Book it if it is yours; reject in IMS if it is not
Tax head differs IGST in 2B, CGST + SGST in books, or the other way Ask the supplier which is right; a wrong head needs a credit note and fresh invoice
Rate or value differs Different taxable value or rate Check the invoice copy; correct books or ask for a debit or credit note
Credit or debit note Note in 2B not reflected in books Book the note; decide the IMS action and the credit to reverse
Amendment Original changed by the supplier Compare with the original line and take the net
ITC not available Portal marks credit unavailable Read the reason; usually no credit
Reverse charge Credit after you pay the tax Claim in the month the tax is paid

Step 5: a worked example

Ravi Engineering Pvt Ltd, Bengaluru (GSTIN 29AABCR1234K1ZD), October 2026. Names, GSTINs and numbers are illustrative.

# Supplier GSTIN 2B invoice Books invoice 2B tax (₹) Books tax (₹) Result
1 29AAGFS5521M1ZR SGS/2026/118 SGS/2026/118 27,000 27,000 Matched
2 27AACCB7788Q1ZP BP-0042 bp/42 9,000 9,000 Matched after cleaning
3 29AAKCM4410H1ZG ML/771 ML/771 + ML/771-F 4,500 3,600 + 900 Matched as a group
4 24AADFP9032L1Z3 PP/26-27/310 PP/26-27/310 18,000 IGST 9,000 CGST + 9,000 SGST Partly matched: tax head
5 07AAECT3156P1ZV none TS/9981 none 5,400 Not in 2B
6 29AAGFS5521M1ZR CN/2026/14 none (2,700) none Not in books: credit note

What the team does with this:

  • Lines 1 to 3: ₹40,500 of credit is supported by 2B.
  • Line 4: the supplier is in Gujarat and the goods came to Karnataka, so IGST in 2B is right. The books are wrong; correct the voucher. Credit of ₹18,000 is supported.
  • Line 5: ₹5,400 is not claimable this month. The supplier in Delhi has not filed; email them, and carry the line forward.
  • Line 6: book the credit note. If you already claimed the full ₹27,000 on the original, accept the note in IMS and reverse ₹2,700.

Credit supported by 2B for the month: ₹40,500 + ₹18,000 − ₹2,700 = ₹55,800, against ₹63,900 in the books (₹27,000 + ₹9,000 + ₹4,500 + ₹18,000 + ₹5,400, with the credit note not yet booked).

Step 6: decide the IMS actions and the GSTR-3B figure

Before filing GSTR-3B:

  • Accept records that matched or that you have now booked.
  • Reject records that are not yours (wrong buyer GSTIN, a supplier's mistake). Rejected records leave 2B and do not flow to GSTR-3B.
  • Keep pending records you are still checking, within the limits IMS allows (for credit notes, one tax period).
  • Recompute 2B after changing actions, then check the auto-populated table 4 against your reconciliation.

Credit you hold back is not lost if the supplier files later; it appears in a later 2B, subject to the section 16(4) time limit (30 November after the end of the financial year, or the annual return date if earlier). Separately, the 180-day payment condition in the second proviso to section 16(2) and rule 37 still applies to matched invoices. The GSTR-3B vs GSTR-2B check covers the next step.

Step 7: carry forward and keep the evidence

"Not in 2B" lines roll into next month's reconciliation and clear when the supplier's invoice appears. Keep the working paper, supplier emails and IMS actions: section 36 requires records to be kept until 72 months from the due date of the annual return. For why lines refuse to match, see why GSTR-2B and books never match and invoice number formats.

Sources

How RefinePoint does it

RefinePoint's GSTR-2B against purchase register template follows this method. You add the 2B download and your Tally, Zoho or SAP register export; columns are read by heading, and title rows and total lines are ignored. Supplier GSTINs are cleaned and checked for a valid check digit, invoice numbers are compared as letters and digits without leading zeros, and credit notes count as negative on both sides. The five passes above run in order, with the two probable passes left for you to confirm. Taxable value and each tax head are compared, so a partial match names the head that differs. Open lines are labelled with reasons such as Not in portal, Not in books, Rate or tax head, Amendment, Credit note, Credit not available and Reverse charge, and they carry forward to next month's run. Request a demo at refinepoint.com, or start free at app.refinepoint.com.

Filed under GST, GSTR 2b, Itc, Reconciliation

Reconcile it in RefinePoint

Templates for bank, vendor, GST, payroll, card and payment reconciliations. Upload two files and see the matches, the differences and why.

Request a demoStart free