Delete Duplicate Transactions in QuickBooks Online

Last updated August 2026

To delete duplicate transactions in QuickBooks Online, open Transactions, then Bank transactions, select the checkbox next to each duplicate in the For Review tab, and choose Exclude. For duplicates you already added to the register, open Transactions, then Chart of accounts, click View register on the account, select the duplicate, and choose Delete. Excluding is the safer of the two, because it removes the line from review without touching your books. Deleting is permanent and should be used only on entries that have already posted.

Duplicates are the single most common mess after a bank import, and they are almost always caused by the same handful of things: a statement imported twice, a bank feed that overlaps a manual upload, or a transaction that was entered by hand and then matched again when the feed caught up. The fix depends entirely on which of those happened, so this guide starts with finding them, then covers the safe removal path for each case.

How do I find duplicate transactions in QuickBooks Online?

Sort the register by date and scan for two identical amounts on the same day. QuickBooks Online has no built-in duplicate finder, so the reliable method is to open Transactions, then Chart of accounts, click View register next to the bank account, set the date range to the period you imported, and sort by Date. Genuine duplicates line up next to each other with the same date, amount, and usually the same description.

Two faster ways to narrow it down when the register is long:

Run a Transaction List by Date report. Go to Reports, search for Transaction List by Date, set the date range, and add the Amount column. Export it to a spreadsheet and sort by amount. Duplicates surface immediately as adjacent identical rows.
Compare your register total to the statement. If the account balance in QuickBooks is higher or lower than the bank statement closing balance by a round figure, that difference is often a single duplicated batch. Divide the discrepancy by two and look for a transaction of that exact amount.

Be careful not to delete legitimate repeats. A business that pays the same vendor the same amount twice in a month, or takes two identical card payments from different customers, will show rows that look like duplicates but are not. Check the reference or check number before removing anything.

Why do duplicate transactions appear in QuickBooks Online?

Duplicates come from an overlap between two sources of the same data. The bank feed pulls a date range, and a file import or manual entry covers part of that same range, so each transaction arrives twice by two different routes. Knowing which route created the copy tells you which removal method is safe.

Where the duplicate came from	What it looks like	Safe way to remove it
The same statement file uploaded twice	A whole block of transactions repeated, identical dates and amounts	Exclude the entire second batch from For Review before adding any of it
Bank feed overlapping a manual file upload	Duplicates only in the days where the two ranges overlap	Exclude the feed copies still sitting in For Review
A transaction entered by hand, then matched later	One entry in the register plus one waiting in For Review	Use Match rather than Add, so the feed line attaches to the entry you already made
Both copies already added to the register	Two posted transactions, both affecting the balance	Delete one from the account register, after checking it is not reconciled
A connected app posting alongside the bank feed	Expense or sales entries doubling up with card charges	Match the feed line to the app entry instead of adding it
Re-connecting a bank after a disconnect	Up to 90 days of history reimported on reconnect	Exclude the overlap in For Review before it reaches the register

How do I delete duplicate transactions in QuickBooks Online?

Use Exclude for anything still in For Review, and Delete only for transactions that have already posted to the register. The two live in different places:

For duplicates still in For Review. Open Transactions, then Bank transactions. Select the account tab. Tick the checkbox on the left of each duplicate row, or tick the header checkbox to select every row on the page. Click Exclude. The rows move to the Excluded tab and never touch your books. You can leave them there permanently.
For duplicates already added. Open Transactions, then Chart of accounts. Find the bank account and click View register. Locate the duplicate, click it to expand, and choose Delete. Confirm when QuickBooks asks. The transaction is removed and the balance corrects itself.
For a duplicate that was matched to an invoice or bill. Open the payment, click Unmatch or Undo first, then delete it. Deleting a matched payment without unmatching can leave the invoice showing as unpaid in a way that is confusing to fix later.

Work through Excluded items rather than deleting them when you have any doubt. Excluded transactions can be restored to For Review, deleted ones cannot be recovered.

Can I delete duplicate transactions in bulk in QuickBooks Online?

You can bulk exclude but not bulk delete. In the For Review tab, ticking the header checkbox selects every transaction on the page and the Exclude button then applies to all of them at once, which handles a doubled import in a few clicks. There is no equivalent multi-select delete in the account register, so posted duplicates have to be removed one at a time.

That asymmetry is the practical reason to catch duplicates before you click Add. A doubled 200-line statement takes seconds to exclude in For Review and the better part of an afternoon to unpick from the register. If a large batch has already posted and the entries are not reconciled, some bookkeepers find it faster to delete the whole batch and reimport a clean file than to pick out individual rows.

What happens if I delete a reconciled transaction?

Deleting a reconciled transaction breaks that reconciliation and changes your beginning balance for every period after it. QuickBooks shows an R in the register for reconciled entries and warns you before it lets one go. The account will then show a reconciliation discrepancy, and the next reconciliation will start from a balance that no longer matches the bank.

If the duplicate is marked R, do not simply delete it. Check first whether the reconciliation itself was done against a doubled balance, which happens when the duplicates were present at the time. In that case you need to undo the reconciliation for that period, remove the duplicates, and reconcile again against the real statement. It is more work, but it leaves the books correct rather than papering over a discrepancy.

How do I undo a bank import in QuickBooks Online?

QuickBooks Online has no single undo button for an import, but it does let you remove an uploaded batch. Open Transactions, then Bank transactions, and look at the For Review tab. If the imported transactions have not been added yet, select them and click Exclude, then delete them from the Excluded tab if you want them gone entirely.

If the batch has already been added to the register, there is no batch undo and each transaction has to be deleted individually from the account register. This is why it is worth reviewing a file before importing it rather than after. Checking the transaction count and the closing balance in the converter, before the file reaches QuickBooks, catches a doubled or overlapping statement while it is still a one-click fix.

How do I stop duplicate transactions from happening again?

Nearly every duplicate is preventable with a date discipline: never let two sources cover the same day. The habits below account for most of the cases we see.

Habit	Why it prevents duplicates
Note the last imported date before every upload	Lets you start the next file the following day so ranges never overlap
Use Match, not Add, when a feed line already exists in the books	Attaches the feed to your entry instead of creating a second copy
Import one statement at a time and check the count	A transaction count that does not match the statement flags a double import instantly
Exclude the overlap after reconnecting a bank	Reconnecting can pull back up to 90 days that you already have
Reconcile monthly rather than quarterly	Duplicates surface within weeks, while they are still easy to remove
Convert statements to a reviewable file before importing	You see every line and the closing balance before anything posts

Monthly reconciling is the habit that catches the rest. Matching every line against the statement is how doubled entries actually get spotted, and if you are doing that across a lot of accounts or client files, software that reconciles the accounts automatically will surface the mismatch faster than working through registers by hand.

Convert the statement first, then import once

The cleanest way to avoid duplicates is to control what enters QuickBooks in the first place. Converting a PDF statement to a QBO file gives you a reviewable list of every transaction and a closing total you can check against the statement before a single line reaches your books. If the count is wrong or a period repeats, you fix it in the file, not in the register.

You can convert a PDF bank statement to QuickBooks here, review each transaction in a table, and export a QBO file for QuickBooks Online or an IIF file for QuickBooks Desktop. If a file does refuse to load, the fixes are in our guide to a QBO file that will not import into QuickBooks, and the full set of accepted formats and their limits is covered in uploading transactions to QuickBooks Online. If you are weighing up desktop converters instead, we compare the two main ones in MoneyThumb vs ProperSoft.

Once the transactions are in, reviewing imported bank transactions properly is what keeps the register clean, and a doubled opening figure has its own fix in wrong opening balance after a QBO import.