Finding duplicates is the easy part. There are four scans and they take an afternoon.
Removing them is where files get broken — because the obvious action, deleting the extra transaction, has consequences that depend entirely on something most people don’t check first: whether it’s been reconciled.
Delete a reconciled transaction and you don’t just remove a line. You alter previously issued financial statements, change the beginning balance of the next reconciliation, and create a discrepancy that recreating the transaction won’t reliably fix.
This page covers finding them, and then the order of operations that keeps the fix from costing more than the problem.
Where they come from, briefly
Covered in full elsewhere, so just the shape: Add clicked instead of Match in the bank feed; pending transactions added and then posted again with a different date, most often on credit cards; manual categorization blocking an integration from matching, because QuickBooks treats manually added transactions as cleared; bank rules colliding with connectors; reconnecting an account and re-importing history; and two connectors posting the same transaction, or a payment processor and a bank feed both importing the same payment.
One thing worth repeating because people rely on it and shouldn’t: bank rules can only categorize, not exclude. A rule cannot keep transactions out of the books.
Related: Sync is not accuracy
Four scans that find them
- Same date, same amount. Run Transaction Detail by Account across the period, export to Excel, sort by date and amount. Identical pairs surface immediately. On an inherited file, run a full fiscal year.
- Same amount, a few days apart. This catches pending-then-posted duplicates, which have different dates and therefore never appear in scan 1. Sort by amount and vendor rather than date. Credit cards are where these live.
- Deposit Detail against invoice payments. Catches the payment-processor overlap — where a payment records against the invoice and the bank feed then imports the same deposit. Compare the two for matching dates.
- The accounts that shouldn’t have balances. Check Undeposited Funds, any clearing accounts, and the Reconciliation Discrepanciesaccount. That last one is created automatically and lets users post an unexplained difference to it. It should rarely or never carry a balance — anything sitting there is a plug, and a plug usually means a duplicate somewhere.
Scan 4 takes two minutes and is the one nobody runs.
Before you delete anything
Check whether the transaction is reconciled.
In the register, reconciled transactions carry an R in the checkmark column. C means cleared but not reconciled. Blank means neither.
This single check determines whether you’re doing a five-second job or a controlled procedure.
| Status | What deleting it does |
|---|---|
| Blank (uncleared) | Removes it. Straightforward. |
| C (cleared) | Removes it. Generally safe, but confirm it isn't part of an in-progress reconciliation. |
| R (reconciled) | Alters prior-period financial statements, changes the next reconciliation's beginning balance, and creates a discrepancy. Stop here. |
View data
| Status | What it means | Correct action |
|---|---|---|
| Blank (uncleared) | Neither cleared nor reconciled. | Exclude if still in For Review, or Undo then Find match. |
| C (cleared) | Cleared, but not part of a completed reconciliation. | Confirm it isn't part of an in-progress reconciliation, then remove it. |
| R (reconciled) | Inside a completed reconciliation. Deleting it alters prior periods. | Run the Discrepancy Check, check the Audit Log, and fix only the affected transaction. |
Also check whether it falls inside a locked period. If the books are closed to that date, it isn’t a bookkeeping decision.
Related: What accountants actually complain about in QuickBooks Online
What deleting a reconciled transaction actually does
Three things, and the third is the one that surprises people.
Prior-period statements change. A reconciled transaction sits inside a period that has been closed and, usually, reported on. Deleting or amending it retroactively alters the profit and loss and balance sheet for a period someone has already filed from or lent against.
The next reconciliation breaks. Beginning balance is derived from the previously reconciled position. Remove a transaction from it and the beginning balance no longer matches the bank statement. QuickBooks blocks the next reconciliation until it’s resolved.
Recreating it may not fix it. This is the part worth knowing before rather than after.
A user deleted seven reconciled transactions, recreated all seven exactly from the audit trail, and manually marked them reconciled. The result was seven new discrepancy items, with the original seven deletions still showing on the report. The reconciliation history had recorded both events.
A documented case in Intuit’s own community: a user deleted seven reconciled transactions to resolve duplicate checks, then recreated all seven exactly — matching dates from the audit trail — and manually marked them reconciled. The result was seven new discrepancy items with a change type of Reconciled in Register, while the original seven Deleted entries remained on the discrepancy report. The reconciliation history had recorded both events. Undoing the action did not undo the record of it.
Intuit’s own guidance on this is direct: editing a reconciled transaction causes discrepancies in the entire reconciliation, even small adjustments can put accounts out of balance, and the recommendation is to involve an accountant rather than proceed.
The right order of operations
Almost every duplicate can be handled without undoing a reconciliation. Work down this list and stop at the first step that resolves it.
- Run the Discrepancy Check first. In the Reconcile window, select We can help you fix it. It lists transactions changed, deleted or added since the last reconciliation — often identifying the problem without any further work.
- Check the Audit Log. Gear icon → Audit Log. It shows before and after values for edited transactions and who made the change. If someone modified a reconciled entry, this is where you find out.
- Fix only the affected transactions. Most discrepancies, including a mismatched beginning balance, are resolvable without undoing anything. This is the step most people skip on their way to a full undo.
- If it’s unreconciled, exclude or delete it. For a bank feed item not yet added, mark it Excluded. For one already added, use Undo in the Categorized tab to return it to For Review, then Find match.
- If it must be unreconciled, do one transaction at a time. In the register, click the checkmark column repeatedly to cycle R → C → blank, then Save. Single transactions only — this limits the blast radius.
- A full-period undo is an accountant action. Only QuickBooks Online Accountant users, or those with the In-house accountant role, can undo an entire reconciliation. Standard users cannot, by design.
- Multi-month errors unwind in reverse chronological order. Most recent first. Doing it out of order compounds the problem.
- Back up before any bulk action, and know that a bulk undo permanently deletes the reconciliation reports for those periods.
One trap worth knowing
QuickBooks will occasionally suggest recording a transaction as a transfer posting to an account called Uncategorized Asset. That posting is never correct.
The problem is that a transfer can’t be recategorized into an expense. Fixing it means undoing the reconciliation, deleting the transfer, and entering the expense properly — a full undo caused by accepting a suggestion.
If a client’s file has a balance in Uncategorized Asset, that’s what happened.
Preventing them is cheaper than every fix above
Duplicates found in week two cost minutes. Found in month nine, after reconciliation, they cost a controlled procedure and potentially a restated period.
Related: Nine questions to ask before buying any QuickBooks integration
The short version
- Finding duplicates is easy. Removing them safely is not.
- Four scans: same date and amount; same amount a few days apart; Deposit Detail against invoice payments; and the accounts that shouldn’t have balances.
- Check reconciliation status before deleting anything. R in the register means stop.
- Deleting a reconciled transaction alters prior-period statements, breaks the next reconciliation’s beginning balance, and may not be fixable by recreating it.
- Run the Discrepancy Check first. Most issues resolve without undoing anything.
- Unreconcile one transaction at a time; full-period undo requires accountant access.
- Multi-month errors unwind in reverse chronological order.
- A balance in Reconciliation Discrepancies or Uncategorized Asset is a signal, not a rounding artefact.
- Prevention is dramatically cheaper. Establish what’s already posting before connecting anything.
Frequently asked questions
How do I find duplicate transactions in QuickBooks Online?
Four scans. Run Transaction Detail by Account, export to Excel and sort by date and amount for identical pairs. Then sort by amount and vendor to catch pending-then-posted duplicates, which have different dates. Compare Deposit Detail against invoice payments for payment-processor overlap. Finally, check Undeposited Funds, clearing accounts and the Reconciliation Discrepancies account for balances that shouldn’t be there.
Can I delete a reconciled transaction in QuickBooks?
You can, but it changes previously issued financial statements, alters the beginning balance of the next reconciliation, and creates a discrepancy that recreating the transaction may not resolve. Check the register for an R in the checkmark column before deleting anything. If it’s reconciled, run the Discrepancy Check first and fix only the affected transaction rather than undoing the reconciliation.
What happens if I delete a reconciled transaction?
Prior-period profit and loss and balance sheet figures change, the next reconciliation’s beginning balance no longer matches the bank statement, and QuickBooks blocks that reconciliation until it’s resolved. In a documented case, a user who deleted seven reconciled transactions and recreated them exactly ended up with seven new discrepancy entries alongside the original deletions still showing on the report.
How do I undo a reconciliation in QuickBooks Online?
Individually, open the account register, select the transaction, and click the checkmark column repeatedly to cycle from R to C to blank, then save. A full-period undo is only available to QuickBooks Online Accountant users or those with the In-house accountant role. Multi-month corrections must be undone in reverse chronological order, and a bulk undo permanently deletes the reconciliation reports for those periods.
What is the Reconciliation Discrepancies account in QuickBooks?
An account QuickBooks creates automatically, allowing users to post the difference between a statement amount and what has cleared. It should rarely or never carry a balance — anything sitting in it represents a difference that was plugged rather than investigated, and it frequently indicates a duplicate elsewhere in the file.
Why does my beginning balance not match after fixing duplicates?
Because one of the transactions removed or amended was reconciled. The beginning balance derives from the previously reconciled position, so changing anything inside it breaks the next reconciliation. Use the Discrepancy Check in the Reconcile window and the Audit Log to identify exactly which transaction changed, then correct only that one.
How do I stop duplicate transactions from happening?
Establish what’s already posting to the file before connecting anything — bank feed, payment processor, other apps, manual entry. Connect one source at a time and verify a full cycle before adding the next. Reconcile weekly rather than monthly for the first quarter after any new connection. And match rather than add in the bank feed; bank rules cannot exclude transactions, only categorize them.
QuickBooks Online ProAdvisor and Xero Certified Advisor. Leads delivery for US CPA firm engagements at Nimblechapps Finance.
Duplicates nobody dares touch?
We know which can be deleted, which need a procedure, and which are now a prior-period question.
Book a call