Duplicate transactions are one of the sneakiest bookkeeping problems in QuickBooks Online. Unlike a glaring error that shows up immediately, duplicates quietly inflate your numbers in the background — overstating income, overstating expenses, or both — until something finally doesn't add up.
The frustrating part is that QBO can create them automatically, often without any obvious indication that anything went wrong.
Here's how to understand why they happen, how to find them, and how to clean them up.
There are a few common scenarios that create duplicates in QBO:
The bank feed + manual entry combination. You enter an expense manually — say, a $500 software payment — and then your bank feed downloads the same transaction a day later and you (or QBO) match it as a new entry instead of recognizing it as already recorded. Now you have two $500 expenses for the same payment.
Importing and re-importing. If you import a CSV of transactions and then run the same import again, or if you import a date range that overlaps with one you've already imported, every transaction in the overlap gets recorded twice.
Third-party app syncs. Apps connected to QBO — payment processors, e-commerce platforms, POS systems — sometimes push the same transaction twice, especially after a sync error or reconnection.
Manually entering what's already in the bank feed. A common workflow mistake: you see a transaction in your bank feed, record it manually before accepting it, then accept the bank feed version separately.
Duplicates distort every financial report you run.
If a $5,000 payment from a customer gets recorded twice, your revenue is overstated by $5,000. Your tax liability goes up. Your bank reconciliation won't close. And if you're using your Profit & Loss to make business decisions — pricing, hiring, cash planning — you're working from fiction.
The same applies to expenses. Duplicate vendor payments inflate your costs and understate your real profitability.
Because QBO's bank reconciliation compares QBO's records against your actual bank statement, duplicates will almost always surface there — but by then you may have months of compounding errors to untangle.
This is the most thorough method for a full file review.
When you reconcile a bank account in QBO (Accounting → Reconcile), QBO shows you every transaction in QBO alongside your bank statement. If you see two QBO entries for one bank statement line, you have a duplicate.
Go to Settings (gear icon) → Audit Log and filter by the date range you're concerned about. If you see the same transaction created twice in a short window — especially by a connected app — that's a strong signal.
QBO has a basic duplicate detection feature for bank feed transactions. When you review new bank feed items, QBO will sometimes flag "possible duplicate" in yellow. Don't ignore these — click through to confirm before accepting or dismissing.
Once you've identified a duplicate, here's how to handle it:
If neither transaction has been reconciled: Simply delete the duplicate. Open the transaction, click More at the bottom, and choose Delete. Confirm the deletion.
If one transaction has been reconciled and one hasn't: Delete the unreconciled one. Never delete a reconciled transaction — that will throw off your reconciliation and create a new discrepancy.
If both transactions have been reconciled: This is the trickiest situation. Don't delete either one without first understanding how your bank reconciliation was completed. You may need to undo the reconciliation, remove the duplicate, and redo the reconciliation for that period. If you're not comfortable with this, bring in a bookkeeper — reconciliation errors compound quickly.
If the duplicate came from a connected app: After deleting the duplicate, go into the app's sync settings and check for any options related to duplicate prevention. Contact the app's support if the issue repeats.
Commit to one workflow for entering transactions. Either use the bank feed exclusively, or enter transactions manually before the bank feed downloads — but not both. Mixing methods is the single biggest cause of duplicates for small business owners.
Review bank feed items before accepting them. Don't click "Accept All" on bank feed suggestions. Review each one to confirm it doesn't already exist in QBO.
Pause before importing. If you're importing a file, check what date range you've already imported and make sure the new file doesn't overlap.
Vet connected apps before linking them. Before connecting a payment processor, e-commerce platform, or POS system to QBO, check user reviews for mentions of duplicate transaction issues. It's a known problem with certain integrations.
Reconcile every month. Monthly reconciliation is your safety net. It forces a comparison between QBO and your actual bank statement, catching duplicates (and other errors) before they stack up.
Duplicate transactions are often connected to recording workflow errors in QuickBooks Online — things like bank feed items accepted after being manually entered, overlapping date ranges in imported files, or connected apps syncing the same transaction twice. BooksCheckup checks for common recording problems like these and gives you a free Health Score in seconds.
Check your books at BooksCheckup.com →
If recording errors show up in your Health Score, the Fix Guide ($49) explains each one and walks through suggested corrections in priority order.
This article is for educational purposes and does not constitute accounting, tax, or legal advice. For guidance on your specific situation, consult a qualified bookkeeper, CPA, or tax professional.
Upload your QuickBooks Online reports and find out in seconds — free.
Check My Books Free →