Duplicates are the reconciliation problem that looks small and is not. One extra row in a 300-invoice register barely changes the count, but it doubles the ITC on that invoice in your working sheet, and a filter that says “matched” will happily hide it, because the second copy matches the same 2B row as the first.
For the other causes of a GSTR-2B mismatch and how to fix each one, see our guide to common reconciliation errors.
Where duplicates come from
| Source | How it happens | What you see |
|---|---|---|
| Your books: double booking | A bill entered once on goods receipt and again on the supplier’s invoice, two clerks entering the same bill, or an export imported twice | Two rows, same supplier, date and amount, often the same number |
| Your books: variant numbers | The same bill typed once as INV/26-27/0144 and once as INV-144 | Two rows with different numbers that exact-match checks treat as separate invoices |
| GSTR-2B: original and amendment | The supplier amended an invoice; the original sits in an earlier B2B section and the amendment in a later B2BA section | Two rows for one invoice if you stack several months of 2B in one sheet |
| GSTR-2B: supplier reported twice | The supplier reported one supply under two invoice numbers, or issued two invoices for one delivery | Two rows, consecutive numbers, same date and value, one delivery in your records |
The Excel download from the portal has B2B, B2BA, CDNR and CDNRA tables, so amendments are visible as separate rows in the file. Our guide to amended invoices, GSTR-1A and IMS explains how they flow from the supplier’s side.
Step 1: find duplicates in your purchase register
Use two passes. The first catches copies with the same number; the second catches copies with different numbers. Both use only ordinary Excel functions. Assume column A holds the supplier GSTIN, B the invoice number, C the invoice date, D the taxable value.
Pass 1 removes the slash, hyphen and space differences that Rule 46(b) allows a supplier to use (an invoice number of up to sixteen characters made of letters, numerals, hyphen and slash). It does not remove leading zeros; if your numbers carry them, add a second key with the digits only. Pass 2 finds the 0144 and 144 pair that Pass 1 misses.
Two checks before you delete anything. First, make sure dates are real Excel dates in both rows, not one date and one text string, or Pass 2 will not see them as equal. Second, pass 2 also flags legitimate repeat billing: a supplier who invoices the same value every day is not duplicating. Look at the numbers; genuine invoices are consecutive, and under Rule 46(b) the same number cannot be used twice by one supplier in a financial year.
Step 2: decide which copy stays
Keep the entry that agrees with the paper invoice and with GSTR-2B; reverse the other. Then look at what was already claimed. If the extra ITC has only sat in your working sheet, nothing more is needed. If it went into a filed GSTR-3B, the claim exceeded what GSTR-2B showed. Rule 36(4) allows ITC only on invoices communicated in GSTR-2B, ITC claimed above the 2B figure by more than the pre-defined limit brings a Form DRC-01C intimation with a mandatory Part B, and interest at 18% a year applies where ITC is wrongly availed and utilised. Speak to your CA about correcting a filed claim rather than leaving it for the notice; our post on replying to a DRC-01C shows what the department will ask for.
Step 3: read amendments as one invoice, not two
An original in an earlier month’s B2B section and its amendment in a later month’s B2BA section are a single invoice, and the credit is for the amended value. The trap is a sheet that stacks several months of GSTR-2B for a year-end sweep: a simple SUMIF on the supplier then adds both rows. Take the amended row as the invoice and treat the original as superseded.
If the amendment reduces the tax and you had already accepted the original and filed GSTR-3B, IMS offers the recipient an option to declare the amount of ITC to be reduced for records where the credit was already reversed or not availed, including a downward amendment of an invoice. Pending is also available for a downward amendment where the original invoice was already accepted and GSTR-3B filed. Check the screens on the day; the IMS decision tree and the guide on credit notes and IMS keep the rules in one place.
Step 4: when the supplier has duplicated
Two consecutive invoice numbers, same date, same value, and you took delivery once. Section 16(2)(b) makes receipt of the goods or services a condition of ITC, so the second invoice does not carry a credit you can claim, even though it is in your 2B. Ask the supplier to cancel it or issue a credit note for it, and hold the ITC on the second invoice out of GSTR-3B in the meantime. If both deliveries did happen, both invoices are genuine and both are claimable; keep the delivery records that prove it.
Worked example: three duplicates, three different fixes
A building-materials trader is reconciling a stacked April to September 2026 sheet and finds three suspicious pairs.
| Case | In books | In GSTR-2B rows | Correct ITC | Overstated if you trust the rows |
|---|---|---|---|---|
| INV-6120 typed twice as INV-6120 and INV/6120 | 2 × ₹44,100 = ₹88,200 | 1 × ₹44,100 | ₹44,100 | ₹44,100 in books |
| INV-6135 amended: B2B in June, B2BA in September | 1 × ₹18,000 (original) | B2B ₹18,000 + B2BA ₹16,200 | ₹16,200 | ₹18,000 in 2B rows |
| INV-7002 and INV-7003, same date, one delivery | 1 × ₹27,000 | 2 × ₹27,000 = ₹54,000 | ₹27,000 | ₹27,000 in 2B rows |
| Total | ₹44,100 + ₹34,200 + ₹54,000 = ₹1,32,300 | ₹87,300 | ₹45,000 in 2B rows |
Correct ITC for the three invoices is ₹44,100 + ₹16,200 + ₹27,000 = ₹87,300. The 2B rows add up to ₹1,32,300, so a plain total of the 2B column would overstate by ₹45,000 (₹18,000 from the amendment pair and ₹27,000 from the supplier duplicate). Separately, the register in case 1 overstates by ₹44,100, which is why the first job is a duplicate check in the register itself.
Actions: delete one INV-6120 entry; update INV-6135 in the books to the amended values, and if ITC of ₹18,000 was already claimed, the ₹1,800 difference needs reducing; write to the supplier for INV-7003 with the delivery challan number and ask for cancellation or a credit note.
Keeping duplicates out next month
- One booking point. Decide whether purchases are booked at goods receipt or at bill entry, and let the other step reference the entry, not create a new one.
- Type the number as printed. Slashes, hyphens and leading zeros exactly as on the invoice; it stops variant-number duplicates at the source.
- Turn on your software’s duplicate-bill warning if it has one, keyed on supplier plus number. Check your own software’s settings for the option.
- Run Pass 1 and Pass 2 before the match, on the 14th, not after. It is a five-minute check that removes the worst false positives from the exception list. The 14th to 20th timeline shows where it fits.
Let the tool flag duplicates in your register
The tool lists duplicate invoices found in your purchase register in a separate bucket and counts each once, so they do not inflate matched or unmatched totals. It does not automatically judge original-and-amendment pairs or supplier-side duplicates in GSTR-2B; use the checks above for those. Your GSTR-2B and purchase register files are read in your browser and never uploaded to any server.
Related guides
- GSTR-2B mismatch: common reconciliation errors and how to fix each one
- invoice missing in GSTR-2B: what to do when an invoice is in your books but not in 2B
- how to find GSTR-2B mismatches: finding them in three passes: totals, supplier, invoice
- GSTR-2B reconciliation: complete guide to ITC matching
- How accountants can automate GSTR-2B reconciliation
- GSTR-2B rejected invoices fix: how to resolve portal errors
- Invoices in GSTR-2B but not in my books: how to investigate them
- GSTR-2B Table 4D mismatch: unmatched invoices and fixes
- GSTR-2B vendor wise reconciliation guide
Last checked: 30 September 2026. Sources: Notification 40/2021-Central Tax (Rule 36(4)), CGST Rules, Rule 46, CGST Act, Section 16, GSTN FAQ on 2B tables, GSTN IMS changes (FAQ on GSTR-9, October 2025), GSTN advisory on DRC-01C, Notification 13/2017-Central Tax (interest rate).