How to Fix Duplicate Transactions in QuickBooks (Step-by-Step)
Duplicate transactions can quickly throw off your numbers in QuickBooks. They often happen without you realizing it: bank feeds import the same transaction twice, manual entries overlap with imports, syncing issues create extra entries. The result: expenses or income are overstated, reports don't match reality, reconciliation becomes difficult. This guide walks you through how to find and fix duplicate transactions safely.
What you're fixing
A duplicate transaction means the same transaction has been recorded more than once.
For example: a $250 expense appears twice, so QuickBooks now shows $500 instead of $250.
These errors don't always stand out — especially in large files.
Want to skip the manual scan?
Upload your QuickBooks file and find every duplicate instantly — or follow the manual steps below.
Step 1: Find duplicate transactions
Start by identifying possible duplicates. There are two ways to do this in QuickBooks Online.
Option A: Review transactions manually
- 1
Go to Expenses or Bank Transactions.
- 2
Sort by amount.
- 3
Look for identical values and dates.
Option B: Use reports
- run expense or transaction reports
- scan for repeated amounts
- compare vendors and details
This works, but can take time as your file grows.
Step 2: Confirm which entry is correct
Before deleting anything:
- review both transactions carefully
- check dates, accounts, and sources
- confirm which entry reflects the real transaction
Important: never delete both entries — always keep one correct transaction.
Step 3: Remove the duplicate
- 1
Open the duplicate transaction.
- 2
Click Delete or Exclude (depending on source).
- 3
Save changes.
After removing, totals should update immediately and reports should become more accurate.
Step 4: Verify your totals
After cleaning duplicates:
- check account balances
- review reports
- confirm totals match expectations
This step ensures nothing important was removed by mistake.
Common mistakes to avoid
When fixing duplicates:
- Don't delete both entries
- Don't remove transactions without verifying them
- Don't ignore small duplicates — they add up over time
Taking a few extra seconds to verify prevents bigger issues later.
When this becomes time-consuming
Fixing a few duplicates is easy. But if your file has:
- months of data
- multiple imports
- large transaction volume
…it becomes difficult to spot everything manually. Duplicates can be scattered across accounts, slightly different in formatting, and easy to miss.
Faster way to find and fix duplicates
Instead of scanning your entire file, upload your QuickBooks export and instantly detect duplicate transactions.
You'll see grouped duplicate entries, the amounts involved, and exactly what should be removed. This makes cleanup much faster and more reliable.
$2,800 in duplicate transactions
The same expenses were recorded twice through imports and manual entry. Expenses are overstated and profit appears lower than it should.
- 1Identify each duplicate pair by matching amount, date, and payee.
- 2Decide which entry to keep — usually the one matched to your bank feed.
- 3Delete or exclude the duplicate entry, leaving the correct one in place.
- 4Recheck reports to confirm totals update correctly.
Fix duplicate transactions in minutes.
Upload your QuickBooks file and get a complete list of duplicates with clear instructions.
$29 per report. One-time. No subscription.
Related guides
This tool helps you identify and fix common QuickBooks issues. It does not replace professional accounting advice.