TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.
QuickBooks help · duplicate transactions
Duplicate transactions in QuickBooks: causes & how to fix them.
“Duplicate transactions” means the same transaction appears more than once — inflating income or expenses, distorting reports, and breaking reconciliation. Most cases trace to a handful of causes, and the self-fix steps below work in order of likelihood. One rule first: deleting transactions is irreversible — back up before you touch anything. Below that: when duplicates that span months and broke reconciliation or tax figures mean it’s a ProAdvisor call.
§ TL;DR
“Duplicate transactions in QuickBooks” means the same transaction has been recorded more than once — the same deposit, expense, or transfer appearing twice (or more) in your file. Duplicates inflate income or expenses, throw off your reports, and break reconciliation because the register no longer matches the bank statement.
The most common single cause is the same period being downloaded twice from the bank feed — often after re-linking an account with an overlapping “from” date. Many cases clear by identifying the doubled entries and carefully removing the duplicate copy, but deleting transactions is permanent, so the first move is always a backup. Duplicates occur in both QuickBooks Online and QuickBooks Desktop; the fixes differ slightly but follow the same order of likelihood.
§ 01 · What creates duplicate transactions
Common causes, in order of likelihood.
The self-fix steps address these in the same order — so working through them in sequence resolves most duplicates efficiently and safely.
Cause 01 · The same period downloaded twice from the bank feed
The single most common cause. The same date range comes down from the bank feed twice — very often after disconnecting and re-linking an account with an overlapping “from” date, so transactions you already had get pulled in again. The feed is working; it just delivered the same window twice.
Cause 02 · Entered manually, then also imported from the feed
A transaction is keyed in by hand — a check, a deposit, an expense — and later the same transaction arrives through the bank feed. If it isn’t matched to the manual entry in the For Review tab, you end up with two copies of one real transaction.
Cause 03 · The same account connected through two bank-feed connections
The same bank or credit-card account is linked twice — two connections feeding the same register, often after a reconnect created a second link instead of repairing the first. Every transaction then downloads through both connections and lands in the books twice.
Cause 04 · Importing the same .QBO or .CSV file twice
Manually importing a bank file (a .QBO/Web Connect or a .CSV) and then importing the same file again — or importing a file that overlaps a range already downloaded by the feed — duplicates every transaction in the overlap. Easy to do when re-running an import that appeared to fail.
Cause 05 · A duplicated recurring or memorized transaction
A recurring (QuickBooks Online) or memorized (Desktop) transaction set up twice, or running more often than intended, posts the same entry repeatedly. The duplicates look legitimate because each one was created by an automation — so they’re easy to miss until reports look off.
Less common · Less common: matching mistakes in the For Review tab
In the For Review tab, a downloaded transaction is added as new instead of matched to the existing entry, or matched to the wrong one. The result is a duplicate alongside the real transaction. These compound quietly and are where surface fixes stop working and a file review is warranted.
§ 02 · The self-fix
How to fix duplicate transactions yourself.
Six steps, in order — and step one is a backup, because deleting transactions is irreversible. If the duplicates span months or the books are already behind, stop and get the file reviewed before deleting anything.
- 1
Back up first, then identify the duplicates
Deleting transactions is irreversible — back up the company file (or export the data) before changing anything. Then identify the duplicates with a report sorted by date and amount, or use the Audit Log, so you can see exactly which entries are doubled and which copy is correctly categorized.
- 2
Exclude or delete the duplicate downloaded copies
In the For Review / banking area, exclude or delete the duplicate downloaded copies — carefully — keeping the one that is correctly categorized and reconciled. Work from your report so you remove the extra copy and never the real transaction. Go slowly; each deletion is permanent.
- 3
Un-match anything matched in error
If a download was matched to the wrong existing transaction (or added as new when it should have matched), un-match it and re-match it to the correct entry. This resolves duplicates created in the For Review tab without deleting a real transaction.
- 4
Remove the duplicate bank-feed connection
If the same account is linked through two bank-feed connections, disconnect the duplicate connection so transactions stop arriving twice going forward. Confirm the connection you keep is the one tied to your correctly-categorized register.
- 5
Fix the import process going forward
Stop the source of new duplicates: set the correct “from” date when reconnecting so you don’t re-pull transactions you already have, don’t re-import a .QBO/.CSV file that already loaded, and check recurring/memorized transactions aren’t set up twice. Prevention is what keeps the cleanup from repeating.
- 6
Re-reconcile the affected periods
Once the duplicates are gone, re-reconcile the affected months so the register ties to the bank statement again and reports are accurate. If removing duplicates broke a previously-closed reconciliation, or the figures fed a tax return, stop and get the file reviewed before going further.
§ 03 · When to call
Three signals it’s a ProAdvisor call.
Duplicates are widespread or span months
The doubling isn’t a handful of entries — it runs across weeks or months, or across multiple accounts. Cleaning that by hand without deleting real transactions is painstaking, and one wrong permanent deletion makes it worse. That’s cleanup work, not a quick delete.Reconciliation or tax figures are off
The duplicates have inflated income or expenses, thrown off a reconciliation that previously tied, or distorted figures that fed a filed return. Untangling that correctly — without breaking prior closed periods — is bookkeeping repair, not a reconnect.You’re unsure which copy to keep
When you can’t tell which copy is the correct, reconciled, correctly-categorized one, deleting is a gamble — and it’s irreversible. That’s the moment to have a ProAdvisor review the file before anything is removed.§ 04 · Software, or the books?
When a duplicate is no longer a software problem.
Deleting one duplicate is a quick fix. When duplicates run across months or have already been reconciled, it becomes a question of which records are real — and that is bookkeeping.
- Duplicates sit inside months that were already reconciled.
- Income or expense for the year is overstated and you cannot tell by how much.
- Some of the copies are matched to invoices or bills, so deleting them breaks something else.
Start with the free QuickBooks file review — a limited review that identifies likely issues and the information needed for a written scope, with the findings in plain English. If the findings show that the books themselves need work, that is QuickBooks cleanup, quoted as a fixed fee against a written scope before any work starts.
Duplicates span months, or you’re not sure which copy to keep?A QuickBooks ProAdvisor reviews the file free, then removes the right copy safely and re-reconciles the books — a focused diagnostic is a fixed-fee scope from $450; bookkeeping cleanup runs $1,200–$15,000+ if the books are behind. Independent firm — and deleting is irreversible, so we look before we touch.
Get the free file review
§ 05 · Who fixes it
A QuickBooks ProAdvisor removes duplicates safely — and the damage behind them.
Deleting a duplicate is the easy part; doing it without making things worse is the real work. Because deleting transactions is permanent, the job is to confirm which copy is the correct, reconciled, correctly-categorized one, remove only the duplicate, un-match anything matched in error, shut off whatever source kept creating them — an overlapping re-link, a second connection, a repeated import, a doubled recurring entry — and then re-reconcile each affected month until it ties to the bank statement again. A QuickBooks ProAdvisor holding the Intuit QuickBooks Certification Level 2 does that against a written scope, backs the file up before changing anything, and verifies the books tie before closing.
Freefile review first — we look before we scope
From $450fixed-fee diagnostic for a focused duplicate + reconciliation fix
§ 08 · Questions
What people ask about duplicate transactions.
Why are there duplicate transactions in my QuickBooks?
Most often the same period was downloaded twice from the bank feed — commonly after re-linking an account with an overlapping “from” date. Other common causes: a transaction entered manually and then also imported from the feed; the same account connected through two bank-feed connections; importing the same .QBO or .CSV file twice; a duplicated recurring or memorized transaction; or matching mistakes in the For Review tab.
How do I delete duplicate transactions in QuickBooks safely?
Back up the company file first — deleting transactions is irreversible. Identify the duplicates with a report sorted by date and amount (or the Audit Log), then in the For Review / banking area exclude or delete the duplicate downloaded copies carefully, keeping the correctly-categorized one. Un-match anything matched in error rather than deleting it, and re-reconcile the affected periods afterward.
Why is the same transaction downloading twice?
Usually the bank feed delivered the same date range twice — often after a reconnect with an overlapping “from” date — or the same account is linked through two bank-feed connections so every transaction arrives via both. It can also be a manual entry that was later imported from the feed without being matched. Check for a duplicate connection and watch the “from” date when re-linking.
Will deleting duplicates mess up my reconciliation?
It can. If a duplicate was part of a reconciliation that previously tied, deleting it will break that closed period until you re-reconcile. That’s why you back up first, remove only the correct copy, and re-reconcile the affected months afterward. If the figures fed a filed tax return, stop and get the file reviewed before deleting — undoing the wrong copy is irreversible.
Does this affect QuickBooks Online and QuickBooks Desktop?
Both. Duplicate transactions occur in QuickBooks Online and QuickBooks Desktop, and the same causes apply — a feed delivering an overlapping range, a double import, two connections, a duplicated recurring/memorized transaction, or a matching mistake. The steps differ slightly between the two but follow the same order: identify, remove the duplicate carefully, fix the source, and re-reconcile.
When does duplicate transactions need a ProAdvisor?
When duplicates are widespread or span months; when they’ve thrown off reconciliation or your tax figures; or when you’re unsure which copy is the correct one to keep. Deleting the wrong copy is irreversible. We start with a free file review, then a focused diagnostic is a fixed-fee scope from $450, or a cleanup ($1,200–$15,000+) if the books are behind.
Can you fix my Intuit account or stop the feed at the source?
No — an Intuit account, login, subscription, or billing matter stays with Intuit, and an independent firm can’t access it. For those, contact Intuit directly. We work inside your own QuickBooks file: identifying the duplicates, removing the right copy safely, fixing the import or connection that created them, and re-reconciling the affected periods.
TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.Call (877) 751-5575Book a discovery call
Duplicates everywhere, or the books no longer tie?