Why Your Bank Feed Keeps Creating Duplicate Transactions (and How to Fix It)

A duplicate in your bank feed does not mean QuickBooks or Xero is broken. Something specific caused it, and each cause has its own fix. Please don't disconnect and reconnect the account to fix it. When you reconnect, the bank feed downloads the old transactions again, and you end up with even more duplicates.

Why it happens

A handful of things cause this, and each one has its own fix.

• You reconnected the account. Reconnecting re-downloads the bank's available history, so anything you already entered comes back in as new.
• A CSV import overlapped the feed. Say you import a file that starts three days before your last download. Those three days already came in through the feed, so the import adds a second copy of each one.
• A transaction got added instead of matched. When the amount is off by a cent, or the date is a day apart, the feed can't find the match on its own. Clicking Add instead of Match then creates a second entry.
• The same account is connected twice. This happens more than you'd expect, often after a bank website change or a re-authentication. Every transaction then downloads through both connections.
• An auto-add rule skipped review. A rule that accepts matching transactions on its own will accept two copies just as fast as one.

Fix it in QuickBooks Online

The fix is the same no matter which of those five caused it: find the extra copy and remove it the right way.

1. Open Bank Transactions and go to the For Review tab.
2. Check the box on the extra copy and click Exclude. Don't click Delete. Deleting tells QuickBooks the transaction is missing, so the next sync downloads it again.
3. If the duplicate already got added and is sitting in your register instead, open it and click Undo. That puts it back in the For Review tab, where you can exclude it properly.
4. If a duplicate was entered by hand and never came through the bank feed at all, delete that one instead, from the register. Exclude only works on transactions the feed downloaded.

If you're hunting for the extra copy by eye, sort the register by amount first. Matching figures land next to each other, and the second copy is easy to spot.

Fix it in Xero

Xero's screens look different, but the logic is the same: find the extra line, remove it, and leave the transaction you're keeping untouched.

1. Run the Duplicate Statement Lines report on the account. It compares dates and amounts and flags the likely duplicates for you. It won't catch a close-but-not-exact match, so check those by hand too.
2. On the Reconcile tab, click Options on the extra line, then Delete statement line, and choose a reason.
3. If a whole statement got imported twice, delete the entire statement instead of hunting for the overlap line by line.
4. A deleted line isn't gone for good. Restore it from Bank Statements if you delete the wrong one.

If the duplicate is already reconciled

This is the one that takes more care. In QuickBooks, check the register for a C or R next to each copy. That marks the one that's reconciled, and that's the one to keep. In Xero, deleting a statement line that's reconciled to a transaction reverts that transaction back to unreconciled. That throws off the total you already confirmed matched the bank. When I run into this in a client file, I check which copy is reconciled before I touch anything. If more than one or two transactions are involved, it's worth a second set of eyes before you delete anything.

Keeping it from coming back

A duplicate here and there is a five-minute fix. Finding a dozen of them, spread across months you thought were done, usually means the feed hasn't been reviewed carefully in a while. Left uncaught, duplicates inflate both sides of your profit and loss. Two habits stop most of this before it starts. Match instead of add whenever you recognize a transaction. Check for a duplicate connection any time this keeps happening. Leave a working connection alone unless it has stopped updating.