How to Find (and Fix) Duplicate Transactions in QuickBooks
You're reconciling and something doesn't add up. The bank balance and QuickBooks are off — not by a lot, but enough to make you suspicious. You dig in and eventually find it: a payment posted twice. Here's how to track them down and what to do once you find them.
Step 1: Run a Transaction Detail Report by Vendor or Account
The fastest starting point is a Transaction Detail by Account report — or Transaction List by Vendor if you suspect a specific payee.
- → Go to Reports → Transaction Detail by Account
- → Filter by the date range you're investigating
- → Sort by Amount, then scan for amounts that appear more than once on the same or adjacent dates
- → Go to Reports → Accountant & Taxes → Transaction Detail by Account
- → Sort by the Amount column
- → Look for repeated dollar amounts from the same vendor within a narrow date window
Step 2: Check the Bank Feed Matching Log
If you use bank feeds, QuickBooks can inadvertently create duplicates when a manually entered transaction and a bank-imported transaction both get recorded rather than matched.
- → Go to Banking → Bank Transactions
- → Look in the Reviewed tab for transactions marked "Added" that closely match amounts and dates of existing entries
- → If you see a match between what was added and what already existed, one of them is a duplicate
Step 3: Use the Find / Search Tool for Specific Amounts
If you already know the amount in question, search for it directly.
- → Use the Search bar (magnifying glass, top right)
- → Enter the dollar amount
- → Filter results by date range and transaction type
- → Any amount appearing more than once in the same period from the same vendor is a candidate
- → Go to Edit → Find
- → Search by amount, date, and payee simultaneously
- → Compare results to identify entries that shouldn't both exist
Step 4: Confirm Before Deleting
Before you delete anything, confirm which entry is the "real" one.
- → Check against the original invoice or bill from the vendor
- → Cross-reference the bank statement to see which date the payment actually cleared
- → Look at the reference or check number — the correct entry usually has it; the duplicate often doesn't
Once you've identified the duplicate, void it rather than delete it when possible. Voiding preserves the audit trail. Deleting removes it entirely, which can create questions during a future audit.
Step 5: Reconcile to Confirm
After voiding or deleting, re-run your reconciliation for the affected period. If the difference clears, you found it. If you're still off, you either have more duplicates or a different issue — misposted amount, wrong period, or a timing difference.
Why Duplicates Keep Happening
One-time duplicates are usually a data entry accident. Recurring duplicates are a process problem. Common culprits:
Payments go out without being matched to an approved bill, so the same expense gets entered twice by different people.
Someone enters a bill payment manually, then the bank feed imports the same transaction as a new entry rather than matching it.
Vendors who re-use or slightly vary invoice numbers make it hard for QuickBooks to flag them as potential duplicates.
Without a clear approval and entry ownership process, the same invoice can get touched by two people — and posted twice.
If you're seeing duplicates regularly, the fix isn't just finding them — it's building a pre-posting check into your close process.
The Faster Way
Hunting for duplicates manually works, but it takes time — and it only catches what you know to look for. Controllers running a clean month-end close need a systematic check that flags anomalies before they compound.
Cavryon catches duplicate transactions automatically — scanning your GL for repeated amounts, vendors, dates, and reference numbers so they surface before you reconcile, not after.