How to fix and prevent duplicate bank transactions in QuickBooks
Duplicates appear when the same transaction reaches QuickBooks twice, usually from a file and the live bank feed covering the same dates, or from two files that overlap. Here is how to clean them up and how to stop them coming back.
Columns (only if we guess wrong)
Column numbers in your CSV or Excel file, counting the first column as 1.
No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.
Where duplicates come from
- A file and the bank feed overlap. You uploaded a month the feed had already downloaded.
- Two files overlap. A CSV exported "last 90 days" twice, a few weeks apart, shares most of its rows.
- IDs changed between downloads. QuickBooks recognises a transaction by its ID (FITID). If a converter makes up new IDs each time, the same row looks new on every import.
Removing duplicates that are still in For review
In Banking > For review, select the duplicates and choose Exclude. Excluded transactions stay out of your books and can be restored later if you excluded the wrong one.
Removing duplicates you already accepted
- QuickBooks Online: open the Categorized (or Reviewed) tab, find the transaction and choose Undo. It goes back to For review, where you can exclude it.
- QuickBooks Desktop: delete the duplicate entry from the account register, then reconcile the month again to make sure the balance matches the statement.
Preventing them next time
- Import each statement month once, and stop importing files where the bank feed begins.
- Use files with stable transaction IDs. Files made with the converter above give each row the same ID every time you convert the same statement, so re-uploading a file does not create copies, while two genuinely identical charges on the same day still both import.
- Reconcile each month against the bank statement as you go.
Pricing
Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.
1 file
$9 per file
$9
10 filesBest value
$2.90 per file
$29
Unlimited files every month
$0.08 per file, billed monthly, cancel any time, fair use 500 files a month
$39/mo
Deleted after 24 hours
Your upload and the result are removed automatically.
Never used for training
Files are processed only to make your result.
Refund if it is wrong
If a result is unusable, we fix it or refund you.
Questions
Will uploading the same QBO file twice create duplicates?
Not if the IDs are stable. QuickBooks skips transactions it has already seen. Files from this converter keep the same IDs for the same statement.
Why did one of two identical charges disappear?
Some bank files give both the same ID, so QuickBooks treats the second as a duplicate. A converted file gives each row its own ID.
Is it safe to delete a duplicate?
Delete only the copy that is not matched to an invoice, bill or reconciliation, then reconcile the month to confirm the balance still matches the statement.