A bill gets entered twice when two different routes record the same purchase, such as a photo you logged by hand and the same payment arriving later in a statement import. To find the doubles, sort your expense list by amount, then look for pairs with the same vendor and a date within a few days. Keep the entry that has the receipt attached, remove the other, and write down what you removed.
How do duplicates sneak in?
- A bill photographed at the counter and the same payment imported from the bank statement a week later.
- A supplier's invoice forwarded by email and the same PDF sent again on WhatsApp, each entered separately.
- A bill entered by you and again by a staff member or family member who also sorts receipts.
- A card swipe and a UPI payment for the same order, when the first one failed and you tried again.
- A hand entry made from a text alert, then the statement import for the same debit.
The date is often different, since the bill shows the day you shopped and the statement shows the posting date. That is why a search that insists on identical dates misses most doubles.
What is the quickest way to find them?
- Sort the list by amount, largest first. Doubles sit next to each other.
- Within each cluster of identical amounts, compare the vendor names. Different spellings such as 'Sharma Stationers' and 'Sharma Stationery' are one shop.
- Check the dates. Within three days is suspicious; a month apart is probably a genuine repeat.
- Open the two entries and look at which has the receipt, the note and the correct category.
Can a spreadsheet find them for me?
In Excel or Google Sheets, keep the date in A, vendor in B and amount in C, with rows 2 to 500. Build a helper key in D2 that joins vendor and amount, then count how often each key appears.
- Key in D2: =LOWER(TRIM(B2))&"|"&C2
- Count in E2: =COUNTIF($D$2:$D$500,D2)
- Warning in F2: =IF(E2>1,"Check","")
Filter column F for Check and compare dates by eye, since the helper key ignores dates on purpose. It will also flag genuine repeats, such as a monthly subscription, so judge each pair rather than deleting blindly.
Example: stationery bought once, entered twice
| Entry | Date | Vendor | Amount | How it arrived |
|---|---|---|---|---|
| First | 14 November | Sharma Stationers | ₹1,260 | Photo of bill, added by hand |
| Second | 16 November | Sharma Stationery | ₹1,260 | Card statement import |
| Keep | Entry one | Same shop | ₹1,260 | The first, because it has the bill photo |
What is the cleanup routine?
- Choose which entry to keep: usually the one with the receipt, the right category and the clearest note.
- Copy anything useful from the other entry, such as a note or the correct date, into the keeper.
- Delete the extra, rather than editing it into something else.
- Write the removal in a short log: date, amount, vendor and which one you removed.
- Recheck the month's total against your bank statement.
When is it a real second purchase?
Two payments for the same amount to the same shop are not always a mistake. A tea stall bill of ₹40 twice in one day is normal. The signs of a real double are an identical amount, a near-identical date, one invoice number and one set of items. If you are not sure, leave both and add a note asking yourself to check against the bank statement.
Where does SpendixAI help?
SpendixAI flags possible duplicate imports, and its Possible duplicate charges report lists the same amount to the same merchant within two days. Receipts are kept with their transactions, so you can see which entry has the bill. Deleted transactions go to a recycle bin for 30 days, which makes a cleanup less risky. A bill you entered by hand and a statement row can still look different, so the final judgement is yours.
A habit that prevents doubles
- Pick one route per bill: either photograph it or wait for the statement, not both.
- If two people enter bills, agree who handles which.
- Look at the month's list sorted by amount before you close the month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


