Delete Imported Bank Transactions in QuickBooks Online and Desktop
No account needed for your first conversions. We never store your bank login.
Short answer: in QuickBooks Online you cannot delete a bank transaction directly from the For review tab. You select the rows, choose Exclude, and then delete them from the Excluded tab. If you already clicked Add, go to the Categorized tab first and select Undo, which sends the transaction back to For review, and then exclude it. In QuickBooks Desktop, unadded Web Connect transactions are removed from the Bank Feeds Center rather than the register.
This comes up constantly after a bad import: the wrong date range, the wrong account, a file uploaded twice, or a CSV whose amounts came in as positives when they should have been negatives. The recovery is straightforward once you know which of the three states each transaction is in, and the order matters.
How do I delete imported transactions in QuickBooks Online?
Go to Transactions, then Bank transactions, and open the account. In the For review tab, tick the checkbox on each transaction you want gone, then choose Exclude from the batch actions. The rows move to the Excluded tab. Open that tab, select them again, and delete. That two step path is the only way to remove a downloaded or uploaded transaction that you have not yet added to the books.
What is the difference between excluding and deleting a bank transaction?
Excluding tells QuickBooks the transaction should never enter your books, and it remembers that. Deleting simply removes the row, and if the transaction came from a connected bank feed rather than a file upload, the bank can send it again on the next sync and it reappears. For a connected account, exclude is the durable choice. For a one off file upload, either works, because nothing is going to re download it.
| State of the transaction | Where it lives | How to remove it | Does it affect the books? |
|---|---|---|---|
| Uploaded, not yet reviewed | For review tab | Select, Exclude, then delete from the Excluded tab | No. Nothing has posted yet. |
| Added or matched | Categorized tab | Select Undo, which returns it to For review, then exclude | Yes. Undoing removes the posted transaction from the register. |
| Already reconciled | Register, inside a closed reconciliation | Do not delete it. Fix it with a journal entry or redo the reconciliation. | Yes, and deleting it breaks the reconciliation. |
| Desktop, downloaded but not added | Bank Feeds Center | Delete the unmatched items in the feed, or delete the whole statement batch | No, until you add them to the register. |
How do I undo transactions I already added in QuickBooks Online?
Open the Categorized tab in Bank transactions, select the rows you added by mistake, and choose Undo. QuickBooks pulls the posted transaction back out of the register and drops the row into For review again. From there you can exclude it. Undo works in batches, so a mis categorized upload of two hundred lines does not have to be unpicked one row at a time.
Can I delete a whole bank statement upload at once?
Not as a single batch action. QuickBooks Online has no button that reverses an entire file upload, which is why people end up in this article. The practical approach is to filter the For review list by date range so it shows only the transactions from the file you regret, select all of them, exclude, then delete from the Excluded tab. Sort by date first, because a bad file usually lands in one contiguous block.
How do I delete imported transactions in QuickBooks Desktop?
Open Banking, then Bank Feeds, then Bank Feeds Center. Transactions imported from a .qbo Web Connect file sit there until you add them to the register. Select the ones you do not want and delete them from the feed. If you already added them, you have to find each transaction in the account register and delete it there, which is why it is worth reviewing a Web Connect import before you accept it.
What if I imported the same file twice?
QuickBooks tries to catch this. A .qbo file carries a unique ID on every transaction, and QuickBooks uses that ID to reject a line it has already seen. A CSV carries no such ID, so a second upload of the same CSV usually creates a clean set of duplicates. Exclude the second batch out of For review and delete it, and read the guide on duplicate transactions in QuickBooks Online before you reconcile.
Can I delete transactions after reconciling them?
You can, but you should not. Deleting a reconciled transaction pulls it out of a closed reconciliation and leaves the beginning balance of every later period wrong, which shows up as a reconciliation discrepancy that is far more work to unwind than the original error. Correct the amount or the account with an adjusting entry instead, or undo the reconciliation deliberately and redo it.
Why did my imported transactions post to the wrong account?
Almost always because the upload was pointed at the wrong bank account in the account picker at the start of the wizard, and the file itself gave QuickBooks nothing to argue with. Undo the added rows in the Categorized tab, exclude them, delete them, and upload again against the correct account. A .qbo file names its own account ID, which makes this particular mistake harder to make in the first place.
How do I stop this from happening again?
Import a file format QuickBooks can police. A CSV is a naked table: no account identity, no transaction IDs, no duplicate protection, and no way for QuickBooks to know it has seen the file before. A .qbo Web Connect file carries all three, so a double import is blocked instead of duplicated. Convert the export first with the CSV to QBO converter, check the parsed totals against the statement, and import the .qbo.
The other half of prevention is catching a bad file before it goes anywhere near the books. Open the converted output, compare the transaction count and the net total to the statement, and confirm the sign convention on the amounts. Cards are where this bites: a credit card export often flips the sign of payments and charges relative to a checking account, and if you also need to reconcile each card line against its receipt that gets much harder once the wrong rows are already posted.
Does excluding a transaction delete it from my bank?
No. Nothing you do inside QuickBooks touches your bank account or your real statement. Excluding and deleting only affect QuickBooks' copy of the data. Your bank balance, your statement and your actual money are untouched, which is worth remembering when a client panics about a cleanup.
What is the fastest cleanup order?
Work backwards through the states. Undo anything in Categorized, so everything sits in For review. Filter For review by the date range of the bad file. Select all, exclude. Open the Excluded tab and delete. Then re import the corrected file. Doing it in that order means you never leave a half posted batch behind, which is what turns a ten minute fix into an afternoon.
If the underlying problem is the file rather than the import, the QuickBooks CSV import template guide covers the exact layout QuickBooks accepts, and opening balance wrong after import covers the balance side of the same mess. For the conversion itself, see CSV to QuickBooks Online or CSV to QuickBooks Desktop.