QuickBooks Duplicate Transaction Checker — Try a Free Scan
Scan a supported General Ledger CSV for likely duplicate transactions. Try a synthetic example, see how matching works, and preview your own findings free.
By CleanUp for QuickBooks · Updated
Try it without your financial data
A sample ledger, a real scan
This synthetic file contains four expenses: two $280 entries with the same date and supplier, another $280 purchase on a different date, and a $1,200 uncategorized expense. The same detection engine used for uploads analyzes it.
What counts as a possible duplicate?
The checker looks for supported transactions with the same type, date, name, and amount. For example, two Expense records to Example Office Supply for $280 on the same day will be flagged when they have distinct transaction references.
You receive a shortlist to investigate, not an instruction to delete every match. Two legitimate same-day purchases can look identical to this rule. A General Ledger export also cannot establish which record is reconciled or which receipt supports it.
Understand the result before you act
| Pattern | What this checker does |
|---|---|
| Same type, date, name, amount; distinct transaction references | Flags the candidate group for review. |
| Same amount on different dates | Does not match under the duplicate rule. |
| Different spellings of a vendor | Exact-name duplicate matching can miss the pair; vendor-name review is a separate check. |
| Entries grouped under the same type, reference, date, and name | May be interpreted as lines of one transaction rather than separate duplicates. |
| Bank-feed items not posted to the ledger | Not available in this export and not scanned. |
Check your own file
- 1
Export your General Ledger in the supported QuickBooks Online CSV layout. The export guide below shows how to convert an Excel export and check the columns.
- 2
Upload the CSV on the homepage. The free preview shows detected issue types and sample entries.
- 3
If useful, unlock the detailed report for $29 one-time. Review the candidates against your records before correcting anything inside QuickBooks.
No connection and no automatic edits
The scan analyzes the file you upload. It does not sign into QuickBooks or change your books. Your export may contain sensitive business information, so inspect it before uploading and use the synthetic demo first if you only want to evaluate the tool.
The current parser supports the illustrated QuickBooks Online report layout. Desktop, custom, and localized exports are not guaranteed to match. An accepted file is not a guarantee of complete accounting coverage.
Continue your cleanup
Sources and further help
QuickBooks menus vary by plan and interface. Use in-app search if a menu label differs. These sources support the workflows; synthetic examples illustrate the checks.
Need a list of entries to review?
Scan a supported General Ledger CSV for possible cleanup issues. See the preview free; the detailed report is $29 one-time. You review and make any changes in QuickBooks.
No QuickBooks connection. Findings are review prompts, not a complete accounting review.