How do I stop QuickBooks bank feeds from creating duplicate transactions?

The most common reason for duplicate transactions in QuickBooks is entering something manually and then adding the same transaction again when it comes through the bank feed. QuickBooks treats these as two separate entries because you told it to record both. It doesn’t automatically know they’re the same transaction unless you match them.

Here’s what typically happens. You write a check or record a bill payment, so you enter it in QuickBooks right away. A few days later, the bank feed pulls in that same transaction. Instead of clicking “Match” to connect it to what you already entered, you click “Add” which creates a brand new entry. Now that expense shows up twice in your books.

The simplest way to prevent this is to pick one of two workflows and stick with it consistently.

Workflow one: enter manually, then match. You record transactions as they happen, like invoices, bill payments, or checks. When the bank feed catches up a few days later, you go to the Banking tab and use the “Match” feature to link each feed entry to the transaction you already recorded. This is a good approach if you want real-time books and don’t want to wait for the feed.

Workflow two: wait for the feed, then categorize. You don’t enter anything manually. You let the bank feed pull transactions in, then review and categorize them from the Banking tab. This works well for businesses with straightforward transactions where a short delay in recording doesn’t matter.

Problems start when you mix the two. You manually enter some things but also add from the feed without checking for matches. Or different people are touching the books and one enters transactions while the other processes the bank feed without knowing.

Pay attention to the “Match” and “Recognized” labels in the bank feed. When QuickBooks finds an existing transaction that looks like a match, it will suggest it. Review the suggestion to make sure the amounts and dates align, then confirm the match. This is your safety net against duplicates.

If you already have duplicates in your books, you can spot them by running a Transaction Detail report sorted by amount and looking for identical entries on the same date. Deleting the duplicate (not the original) fixes the issue. But if your books have months of unreviewed bank feed activity, the cleanup gets tedious fast. That’s one of the most common messes we see as bookkeepers in Orlando when new clients come to us.

Going forward, whoever handles your bookkeeping needs a clear process for how bank feeds get reviewed. If you’re not sure your QuickBooks setup is configured properly for your workflow, it’s worth getting that right before the duplicate problem compounds over months of transactions.