How to Find and Fix Duplicate Transactions in QuickBooks Online
Duplicate transactions are one of the most common problems I find when I open up a small business's QuickBooks file. They're also one of the sneakiest, because nothing looks broken. The reports run. The numbers look reasonable. They're just wrong.
When the same sale shows up twice, your income looks higher than it really is. When the same bill shows up twice, your expenses do. Either way, you end up making decisions (and possibly paying taxes) based on numbers that don't reflect what actually happened.
The good news is that duplicates follow predictable patterns, and once you know what to look for, they're usually fixable.
What Causes Duplicate Transactions in QuickBooks Online
Bank Feed Plus Manual Entry
This is the most common cause by far. You (or someone on your team) enter an expense or invoice payment by hand. Then the same transaction comes in through the bank feed a day or two later. If it gets added from the bank feed instead of matched to the entry that's already there, you now have two.
Clicking "Add" When You Should "Match"
When a transaction comes into the bank feed, QuickBooks often suggests a match to something already recorded. Matching tells QuickBooks, "This bank transaction is the same as the one I already entered." Adding tells QuickBooks, "This is new. Record it."
If the transaction was already entered and you choose Add, it gets recorded a second time. This one small click accounts for a lot of duplicates.
Sales Receipts and Deposits Recorded Separately
If you record a sales receipt (or receive an invoice payment) and then also record the bank deposit as income, the same money gets counted twice. The sale already created the income. The deposit should simply be matched to it, not categorized as income again.
E-Commerce and Payment Processor Double Recording
If you sell through Shopify, Square, Stripe, PayPal, or a similar platform, you may have an app sending sales into QuickBooks and a bank feed showing the payout deposits. When both are recorded as income, you've doubled your sales. A clean setup usually uses a clearing account (a holding account in QuickBooks where sales land before the payout is matched to them), so each dollar is recorded once.
A Reconnected Bank Feed That Re-Imported History
When a bank connection breaks and gets reconnected, or the same account gets connected twice, QuickBooks may pull in transactions you've already reviewed. Suddenly there are dozens of old transactions sitting in your review list again.
How to Spot Duplicates
You don't need to scroll through every transaction to know there's a problem. A few signals usually point the way:
Your reconciliation won't balance. If QuickBooks shows more activity than your bank statement, duplicates are a likely suspect.
Income or expenses look higher than you expected. If your Profit and Loss says you had a great month but your bank account disagrees, it's worth a closer look. (I explain more about that gap in why your bank balance doesn't match your profit.)
The same vendor or customer shows the same amount on back-to-back dates. Run a Transaction Detail by Account report or a vendor or customer report for the month and sort by amount. Pairs tend to jump out.
Undeposited Funds keeps growing. If payments are sitting in Undeposited Funds (sometimes labeled Payments to deposit) while the deposits were recorded separately as income, those payments were likely never matched.
How to Fix Duplicates Safely
Before you start deleting things, slow down. Fixing duplicates the wrong way can create a new problem that's harder to find than the first.
Start in the Bank Transactions Screen
In QuickBooks Online, go to your Bank transactions page. Depending on your version and layout, you'll find it under Transactions, Banking, or Accounting in the left menu. Transactions waiting for your decision live on the Pending tab.
For a bank transaction that's already recorded in your books, choose Match rather than Add, and confirm it's matching to the right entry.
For a downloaded transaction that's a true duplicate (for example, one that re-imported after a reconnect), select it and choose Exclude. Excluded transactions move to the Excluded tab and aren't added to your books. If you exclude something by mistake, you can find it on that tab and choose Undo. Intuit's own help article on excluding duplicate transactions walks through the current steps.
When a Duplicate Is Already in Your Books
If both copies were already added, decide which one to keep. Usually you want to keep the one that's connected to something else, like an invoice, a bill, or a matched bank transaction, and remove the extra one.
For a transaction that came in from the bank feed, the cleaner fix is often to undo it from the Posted tab so it returns to Pending, then match or exclude it properly. For a manually entered duplicate, deleting or voiding the extra entry may be appropriate.
Don't Touch Reconciled Transactions Without a Plan
If a transaction has been reconciled (it shows an "R" in the register), deleting or changing it will throw off a reconciliation that was previously finished. Sometimes that's the right call, because the earlier reconciliation was wrong. But it should be a deliberate decision, not an accident.
Check for Closed Periods
If your books have been closed for a prior period, or your tax return for that year has already been filed, changing those transactions can create a mismatch between QuickBooks and what was reported. Corrections in closed periods should be handled carefully, and in some cases with your tax preparer involved.
How to Prevent Duplicates Going Forward
Pick one method for each type of transaction. Either enter it manually and match it, or let the bank feed bring it in. Not both.
Read the suggestion before you click. If QuickBooks shows a possible match, check it.
Record customer payments against invoices, then match the deposit.
Set up e-commerce integrations with a clear data flow and a clearing account before turning them on.
Review your bank feed weekly so it never piles up into hundreds of transactions.
Reconcile every month. A monthly reconciliation catches duplicates while they're still easy to fix.
When It's More Than a Few Duplicates
A handful of duplicates is a quick fix. Hundreds of them, especially across reconciled months or alongside other issues, is a sign the file needs a closer look. That's often where a bookkeeping cleanup starts.
Not sure what condition your books are actually in? That's exactly what my Diagnostic Review is designed to figure out. I'll look at what's happening in your QuickBooks file, show you what I find, and recommend what needs to be done next.
