Duplicates appear when the same expense gets entered twice, typically once by hand when you paid and again when the bank statement was imported. Find them by looking for the same amount at the same merchant within a day or two, remove the manual copy and keep the statement row. Then choose one source for each account so it does not recur.
How does a duplicate happen?
A salaried person pays a ₹420 lunch by UPI and types it into the app that evening, dated the 4th. A day later, the bank statement shows the debit as posted on the 5th. When you import the statement, the app sees a new row. Both stay, and your total is ₹420 too high. Do that forty times a month and the figure becomes meaningless.
What does a duplicate look like?
- Same amount, same merchant or description, dates one or two days apart.
- One entry added manually and the other imported.
- Amount matches exactly, which is rare for two real purchases of odd amounts such as ₹417.
Be careful with amounts that repeat in real life. Two ₹60 teas on the same day are not duplicates. The signal is a manual entry and an imported entry for the same payment.
A worked month: finding ₹3,150
Say your total for the month shows ₹61,300. You suspect it is too high because your statement's debits add to less. You sort by amount and find 11 pairs that match, totalling ₹3,150. Remove one of each pair.
| Step | Amount |
|---|---|
| Total shown in your tracker | ₹61,300 |
| Eleven duplicate entries removed | ₹3,150 |
| Corrected total (61,300 minus 3,150) | ₹58,150 |
Check it against the bank statement's debits for the same accounts. If they now agree, the clean-up is complete.
Can a formula find them for me?
If you keep your records in a spreadsheet, add a helper column. Say dates are in column A, amounts in B and merchants in C, with data to row 500. In D2 write:
=COUNTIFS($A$2:$A$500,">="&A2-2,$A$2:$A$500,"<="&A2+2,$B$2:$B$500,B2,$C$2:$C$500,C2)>1
Fill it down. It returns TRUE when another row has the same amount and merchant within two days either side. Filter column D for TRUE and review. It will also flag real repeats, so judge each pair yourself. It works in Excel and Google Sheets, and the dates must be real dates, not text.
What should I keep and what should I delete?
Keep the imported row, because it carries the exact posting amount and the account. Delete the manual one, unless the manual entry holds a note or receipt you want, in which case move it across first. SpendixAI keeps deleted transactions in a recycle bin for 30 days, so a wrong removal can be undone.
How do I stop it happening again?
- For each account, decide whether it is imported or typed. Do not do both.
- If you import, stop typing entries for that account, apart from cash.
- Review the rows during import, before saving.
- Check any report listing the same amount to the same merchant within a couple of days.
SpendixAI flags possible duplicate imports, and its Possible duplicate charges report lists the same amount to the same merchant within two days. The report is useful for spotting genuine double charges by a merchant too, so look at both causes.
A ten-minute routine
Once a month, sort the month by amount, scan for pairs, remove the manual twin and compare the corrected total with your statement. If the two agree, you are done.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


