Duplicate Transactions in QuickBooks: How They Happen and How to Find Them
By Derek J. Hartsfield, CFO · Published October 18, 2026 · Last reviewed October 19, 2026
A duplicate transaction is the same event recorded twice. It overstates income or expenses, throws off the bank balance, and makes reconciliations fail by exactly the duplicated amount.
Where duplicates come from
- A bank feed imports a transaction that was already entered by hand.
- A bank connection is broken and reconnected, and previously imported items arrive again.
- A statement is uploaded in addition to a live feed.
- An invoice or bill is entered twice by different people.
- A payment from a sales platform appears both in the platform’s own sync and in the bank feed.
How to find them
Open the register for the account and sort by date and amount. Two entries with the same date and the same amount are suspects. Then confirm against the bank statement. A real duplicate appears twice in the books but only once at the bank.
Be careful: two genuine transactions can share a date and an amount. Recurring subscriptions and daily sales are common examples. Always confirm with the statement before removing anything.
How to remove them correctly
If neither copy has been reconciled, delete the extra one. If one has been reconciled, keep that one and remove the other. Deleting a reconciled transaction changes past reconciliations, so check that month again afterward.
Why duplicates return
Most duplicates come back because of a process problem, not a one-time mistake. Decide which source is the source of truth for each account and stop entering the same transaction two ways.
The three places duplicates come from
Most duplicates have one of three origins. The first is double entry: a transaction typed by hand and then brought in again by a bank feed or an app. The second is a repeated import, such as uploading a file that overlaps a period already loaded. The third is the same event recorded in two different forms, for example a customer payment entered as a sales receipt and again as a deposit.
What duplicates do to your numbers
A duplicated expense lowers profit. A duplicated deposit inflates income and cash. Because the amounts look ordinary, the problem usually surfaces only when a reconciliation fails or a financial statement looks off against what the owner expects. By then the duplicates may be spread across several months and mixed in with legitimate transactions of the same amount.
How to find them methodically
- Sort the bank register by amount, not by date, so identical amounts sit side by side.
- Look for pairs with the same amount and a date within a few days of each other.
- Check the source of each: one entered by hand and one from the feed is the classic pattern.
- Compare against the bank statement. If the bank shows one transaction, only one belongs in the register.
Why not every repeat is a duplicate
Recurring charges, split payments and two purchases of the same amount on the same day are legitimate. The statement is the authority. Each item deleted should be supported by the bank record showing it occurred once, so the correction can be explained to anyone who asks.
Prevent the next one
Pick one path for each kind of transaction. If payments are matched from the feed, do not also enter them manually. Match before you add. Reconcile every month so a duplicate is caught within weeks, not years.
Questions we hear most often
Can QuickBooks find duplicates for me? It flags some possible duplicates during feed review, but it cannot know whether two matching amounts are one event or two. A person comparing against the statement makes that call.
What if a duplicate is in a reconciled month? It can still be corrected. The reconciliation is redone for the affected months so the register again agrees to the statements.
A worked example
A restaurant’s deposit of $2,860 appears twice in March, once entered from the daily sales report and once pulled in by the bank feed. Income is overstated by $2,860 and the bank register is $2,860 higher than the statement. Removing the duplicate corrects revenue, cash and the reconciliation in a single step, which is why finding the cause is better than posting an adjustment.
Large files
In files with thousands of transactions, finding duplicates by eye is not practical. We review the full history, document what was removed, and confirm every account agrees to its statements afterward.
See what it takes to get your books right
Start for as little as $99*, or get your price in about a minute.
Related service: QuickBooks cleanup
* The $99 starter covers one bank or credit card account in QuickBooks Online with fewer than 100 transactions in one month. Transactions are categorized and the account is reconciled for that month. Starter rate available through the date shown on the home page.