Duplicate Transaction Detection

Duplicate Detection

When importing bank statements, it's common to have overlapping date ranges that create duplicate transactions. Finance Frank automatically detects and flags potential duplicates before you save.

How It Works

1. After uploading and parsing a CSV file, Frank compares each new transaction against your existing transactions
2. A transaction is flagged as a possible duplicate if it matches an existing transaction on:
   • Date within 1 day (to account for processing delays)
   • Amount within $0.01
   • Similar description (normalised — ignoring case and long reference numbers)
3. Flagged transactions show an amber warning badge in the import preview
4. Duplicates are pre-unchecked so they won't be imported by default
5. You can override by checking the box if a flagged transaction is actually unique

Tips

• Always review flagged duplicates before importing — the detection is conservative to avoid false positives
• If you're importing from multiple CSV files, duplicates are especially common for overlapping date ranges
• The detection works across all your existing transactions, not just the current import batch