To spot a duplicate payment to a supplier, search your bank sheet for the same payee and the same amount within a few days of each other, then check each pair against the invoice list. If you find one, record both payments as they happened, mark the second as money to recover, and ask the supplier in writing to refund it or adjust it against your next invoice.
How do duplicates happen?
The usual story is simple. A supplier sends an invoice and a reminder. You pay by UPI on the 6th, then your accountant or a team member pays the same bill by bank transfer on the 8th. Nobody did anything unreasonable; two people each thought the bill was still open. It happens most often when payments are made from more than one phone or app.
What search routine finds them?
- Sort the bank sheet by payee, then by amount.
- Look for two lines with the same amount and the same payee, or the same amount and a payee name that looks similar.
- Check how close the dates are. Same amount within three days is a prompt to look closely.
- Compare each line with your invoice list. Two payments for one invoice are the problem.
The payee name can differ between payment routes, as a UPI ID in one and a registered account name in another, so also search by amount alone.
Can a formula flag the pairs?
In Excel or Google Sheets, put the date in A, payee in B and amount in C, with rows 2 to 500. In D2, write a formula that counts the payments with the same payee and amount in a three-day window either side:
- =COUNTIFS($B$2:$B$500,B2,$C$2:$C$500,C2,$A$2:$A$500,">="&A2-3,$A$2:$A$500,"<="&A2+3)
- Show a warning in E2: =IF(D2>1,"Possible duplicate","")
Any row showing Possible duplicate needs a look. The formula does not prove a double payment, because a supplier may legitimately bill the same amount twice, such as monthly retainers. It only tells you where to look.
Example: one invoice, two payments
| Date | Mode | Amount | Invoice paid |
|---|---|---|---|
| 6th | UPI | ₹38,400 | Invoice 2217 |
| 8th | Bank transfer | ₹38,400 | Invoice 2217 again |
| Excess payment | Second payment | ₹38,400 | To recover or adjust |
What if the second payment was meant for a different bill?
Before you ask for a refund, make sure it really is a double. A supplier may have two open invoices of the same amount, in which case the second payment simply settles the other one. Check the supplier's statement of account, or ask them to list what they show as paid, and only then call it a duplicate.
What do I record and ask?
- Record both payments exactly as the bank shows them. Never delete the second one.
- Tag the second as Supplier credit or To recover, not as an expense.
- Write to the supplier with both dates, amounts and references, and ask whether they will refund it or adjust it against the next invoice.
- Save the reply with the bank lines.
- When the refund or adjustment happens, link it to the original second payment.
A short message works: 'We paid invoice 2217 twice, on the 6th by UPI and on the 8th by transfer, ₹38,400 each. Please confirm how you would like to correct it.' How a refund or an adjustment should be treated in your books is a question for your CA.
Can the tracker catch these automatically?
In SpendixAI the Possible duplicate charges report lists the same amount to the same merchant within two days, which is the shape of this example, and imports flag possible duplicates too. It works on merchant names, so a payee written differently across routes may still need your own search.
A closing checklist
- Search by payee and by amount, within a few days.
- Check each pair against the invoice list.
- Record both payments and mark the second to recover.
- Ask the supplier in writing and keep the reply.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


