Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
The same amount appears twice during bank reconciliation, and the accountant cannot tell whether it is a duplicate in the books, a double debit by the bank or two real payments.
Identify which record shows the amount twice: books only points to a duplicate voucher or import, bank only points to a double debit, retry or reversal pair, and both points to possibly two genuine payments; confirm with date, UTR, narration and invoice reference.
The cash book, the bank statement, the import date ranges used, and the invoice each payment or receipt relates to.
Each repeated amount is classified as a duplicate to reverse, a bank double debit to recover, or two genuine transactions that stay.
When the same amount appears twice, the first question is which record shows it twice. Twice in your books only usually means a duplicate voucher or a double import. Twice in the bank statement only means a genuine double debit, a retry or a debit and its reversal. Twice in both may simply be two real payments of the same amount.
What does each pattern usually mean?
| Pattern | Likely cause | How to check | Fix |
|---|---|---|---|
| Twice in books, once in bank | Duplicate voucher, or a statement imported twice | Compare voucher numbers, invoice references and entry dates | Reverse or cancel the duplicate voucher |
| Once in books, twice in bank | Double debit by the bank, a retried payment, or a debit and its reversal | Look for a reversal credit a day or two later | If not reversed, claim a refund from the bank or supplier |
| Twice in both | Two genuine payments, such as two equal invoices | Check each one settles a different invoice | No fix needed |
| Once each, but on different dates | The same transaction, dated differently in books and bank | Compare UTR or cheque number | Correct the book date if needed |
How do you tell a duplicate from two genuine equal payments?
Compare four things for each of the two entries:
- Date. Two entries a day or two apart are suspicious; a month apart is often rent or an EMI.
- Reference or UTR. Two different UTRs mean two different transfers. The same UTR twice means the same transfer recorded twice.
- Narration. Look for words such as “REV” or “RETURN”, which mark a reversal.
- Invoice. Each genuine payment should settle a different invoice.
Never delete an entry only because the amount repeats. Equal amounts are common in business.
Worked example
You paid a supplier ₹31,800 against invoice INV-778 by NEFT. In your books you find two payment vouchers for ₹31,800: one dated 5 April and one dated 7 April. Both refer to INV-778.
The bank statement shows only one NEFT debit of ₹31,800, on 5 April, with one UTR.
So the 7 April voucher is a duplicate. Reverse it. Your bank ledger rises by ₹31,800, and the supplier’s ledger shows INV-778 paid once.
Now suppose instead the bank statement showed two debits of ₹31,800 with two different UTRs, and the supplier confirms receiving both. Then you have paid twice. Keep both entries in the books as payments, and ask the supplier to refund ₹31,800 or adjust it against the next invoice.
If the bank shows two debits but the supplier received only one, the second may have failed and should come back as a reversal credit. If it does not, raise it with your bank.
Can overlapping statement imports create duplicates?
Yes, and this is one of the commonest causes. Suppose you import a statement for 1 to 15 April and later another for 10 to 30 April. The days from 10 to 15 April are now in your software twice.
To avoid it, always import non-overlapping periods, such as 1 to 15 April then 16 to 30 April. If your software warns about possible duplicates during import, read the warning before accepting.
What mistakes should you avoid?
- Removing the older of two entries by habit. Check which one the bank line actually matches.
- Assuming the bank is always right. Banks do debit twice occasionally, and only you will notice.
- Ignoring the supplier ledger. A duplicate payment voucher also makes the supplier look underpaid or overpaid.
What does RBI say about failed transfers?
Sometimes the statement, not the books, shows the duplicate: a UPI payment debited twice where only one reached the payee. The RBI circular of 20 September 2019 on turnaround time for failed transactions (in force from 15 October 2019) sets outer limits. If your account is debited for a UPI or IMPS transfer that never reaches the beneficiary, the beneficiary’s bank must reverse it by T+1, one day after the transaction date. For ATM cash not dispensed, the limit is T+5. For every day of delay beyond the limit the bank owes ₹100 per day, credited automatically without a complaint. Wait for the reversal credit, match it against the second debit, and do not book a second expense.
What to read next
Next, read the carelessness family of reconciliation errors, where duplicates are one named group, and the invoice-to-bank reconciliation failure modes. If a gap remains, see how to narrow down the difference.
TransactIG matches each bank statement line to the books once, so repeated or unmatched lines show up in an exception queue for review; see bank reconciliation software for India.