Getting started

What does 'possible duplicate' mean on an imported transaction?

A possible duplicate flag means two rows look alike, not that one is wrong. Learn the signals behind it and a simple test for keeping or removing a row.

Editorial illustration for What does 'possible duplicate' mean on an imported transaction?

A possible duplicate flag on an imported transaction means the tracker noticed a row that looks like one you already have, so it is asking you to take a second look. It is a prompt, not a verdict. Two filter coffees at the same café on the same morning are both real; the same statement imported twice produces rows that really are doubles.

What signals make the tracker flag a row?

SpendixAI flags possible duplicate imports, and it also has a Possible duplicate charges report that lists the same amount paid to the same merchant within two days. The signals are plain ones you could check by eye.

  • The same amount on both rows.
  • The same merchant, or what looks like the same merchant after name clean-up.
  • Dates that are the same or very close.
  • The same account, since a card payment and the matching bank debit are different things.

Because the flag rests on resemblance, it will sometimes catch innocent pairs and it cannot know your day. That is why the decision stays with you.

How do I decide whether to keep or remove it?

Use the printed statement or your bank's own transaction list as the referee. The bank's list is the truth about what left the account. Then ask three questions.

  1. Does the original statement show two separate lines? If yes, both are real and you keep both.
  2. Does only one line exist at the bank? Then the extra row came from importing twice, or from a file that overlapped an earlier one, and you remove the extra.
  3. Did you also add this expense by hand, for instance when you paid in cash and later it showed up on a statement? Keep one, and keep the one with the receipt or the right account.
SituationLikely meaningAction
Two rows of ₹180 at the same café, 9:05 and 9:40 on the statementTwo real ordersKeep both
Two rows of ₹2,499 at the same shop, one line on the bank statementSame file imported twiceRemove one
₹1,200 added by hand and ₹1,200 on the card statement for that shopManual entry plus importKeep the imported one, remove the manual one
Same amount paid twice to a utility within a dayPossible double paymentCheck with the biller before anything else

Is a duplicate flag the same as an error?

No. Think of it as a smoke alarm: sometimes it is toast. Statements can also genuinely contain a double charge, for example a merchant billing you twice by mistake. In that case your tracker is not wrong to flag it, and the useful next step is outside the app: contact the merchant or your bank and keep the two rows until it is sorted.

What should I do before removing anything?

Deleting a transaction is not a one-way door. Deleted transactions go to a recycle bin for 30 days, so if you remove the wrong one you can bring it back in that window. Still, glance at the amount, date and account before you delete, because the safest habit is to remove the extra row that carries less information, such as the one without a receipt or with a messier merchant name.

How do I stop duplicates showing up next month?

Most duplicates come from overlapping date ranges. If you downloaded 1 to 31 October last month and 25 October to 30 November this month, the last week is in both files. A tidy habit is to download each statement from the day after the previous one ended. Keep a note of the last date you imported for each account, and check the import history to see what was uploaded and when. For cash, decide that an expense is either added by hand or comes from a statement, never both.

A short checklist

  • Compare both rows with the bank's own statement.
  • Keep both if the bank shows two lines, remove one if it shows one.
  • Prefer to keep the row with a receipt and the correct account.
  • Remember the 30-day recycle bin if you delete the wrong row.
  • Use non-overlapping date ranges for the next download.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports