When imported transactions disappeared in QuickBooks Online, they are almost always still in the company, just out of view. Look in four places: the Excluded tab, the filters on the review tab, the accepted tab where matched lines go, and the account tile itself. Only import the file again once every one of those comes up empty.
Where do imported transactions go when they vanish from review?
Imported lines leave the review tab in only a few ways, and each one leaves a trace. Someone excluded them, someone accepted them, a filter hides them, or they were imported to an account you are not looking at. A line rarely vanishes without a trace, so the job is a search, not a re-import.
Start by writing down what you expect to find: the account, the date range of the file and the number of lines it held. Then work through the places in the table. The table is a checklist, not a record of any real company.
| Where to look | What you see if the lines are there | What to do |
|---|---|---|
| Excluded tab, same account | The lines with their original dates and amounts | Select them and choose Undo |
| Review tab with filters cleared | Lines that a date or type filter was hiding | Review them as normal |
| Accepted tab (Categorized or Posted) | Lines added as records or matched to entries | Leave them, or undo the wrong ones |
| Other account tiles | The file's lines under a different bank or card | Move or remove them |
| The account register | Records created when the lines were accepted | Compare with the bank statement |
Count as you go. When the lines found across those places add up to the file's line count, the search is over.
Checking the Excluded tab for missing imported transactions
The Excluded tab is the first place to look, because excluding is a one-click action that is easy to do by accident. A batch exclude with the wrong boxes ticked can send dozens of good lines there at once. They stay on that tab, untouched, until someone restores them.
Intuit's help article on excluding a downloaded transaction explains the undo. Open the Excluded tab, tick the line and select Undo, and it returns to the review tab. The same article says excluded lines appear in no account history or financial report, which is why a report run after an accidental exclude makes the transactions look as if they were never imported.
Restore only the lines that were excluded by mistake. Some lines on that tab may be genuine duplicates someone excluded on purpose. Compare each one with the bank statement before you restore it.
Date filters and account tiles that hide imported transactions
The review tab shows lines for one account at a time, and it can be filtered by date and type. A file imported to the savings tile will not appear while you are looking at checking. A date filter left on from last month's work hides anything outside it, including a file of older history.
Check the tile first. The tiles across the top of the Bank transactions page each stand for one bank or card account. Click through each one and look for the file's dates. A CSV imported in a hurry often goes to whichever account was selected last, and a QBO file can be attached to an account with a similar name.
Then clear the filters. Look for a filter or date control above the list and reset it to all dates. Sort by date and scroll to the file's range. Older history is the usual victim here, because people expect a file of last year's transactions to appear at the top, where the newest lines sit.
Lines that landed in another year
A file can also arrive with the wrong dates, which looks exactly like a disappearance. Statements that print dates as month and day only leave the year to whoever built the file. If a December statement was converted in January and the converter assumed the current year, its lines sit eleven months in the future, far from where you are scrolling.
Search by amount instead of by date to catch this. Pick one distinctive line from the file, such as an odd-cent deposit, and look for it across all dates. If it turns up with the right day and month but the wrong year, every line in that file is probably shifted the same way. The post on imported transactions with the wrong year in QuickBooks covers the clean-up.
Were the imported transactions matched to entries already in the books?
Lines that were matched no longer wait for review, and they do not create new records, so they can look as though they vanished. Matching links an imported line to an entry that was already in QuickBooks, such as an invoice payment or a check you typed in. The entry stays, and the imported line moves to the accepted tab.
QuickBooks suggests matches automatically, and accepting several suggestions in a hurry can match lines nobody looked at. Intuit's article on unmatching and moving downloaded transactions shows where they go: the Posted tab, where a blue link in the Added or Matched column opens the record each line was matched to.
Here is an example of how that plays out. The figures are made up. A CSV with 30 lines was uploaded, and the next morning only 24 sit on the review tab. Six customer payments had invoices with the same amounts, QuickBooks offered each invoice as a match, and a colleague accepted all six suggestions in one pass. The six lines are on the Posted tab, each linked to an invoice now marked paid.
A correct match is not a problem, even if it surprised you. The bank line and your entry describe the same payment, and the books count it once. A wrong match is different. If a deposit was matched to the wrong invoice, the post on unmatching a transaction in QuickBooks Online shows how to separate them. If the match is right but the details need correcting, see editing imported transactions in QuickBooks Online.
Imported transactions after a bank feed is disconnected
A disconnected bank feed matters most for lines nobody reviewed yet. Lines already added are ordinary records in the register and do not depend on the connection. Intuit's article on disconnecting accounts from online banking says QuickBooks removes any transactions still in the Pending tab when you disconnect.
So unreviewed lines can be truly gone after a disconnect. The same article says lines older than 90 days can't be downloaded from the bank again when you reconnect, though you can still upload them by hand. It also warns that disconnecting while the account shows a connection error can bring duplicates when you reconnect, and that a reconnect may create a brand-new account in your chart of accounts.
Files you uploaded by hand share the account's review tab, so uploaded lines still waiting there at the disconnect are affected too. If the account was set up again as a new account, look for lines you already added under the old account's name in the chart of accounts, not only under the new tile.
Why not upload the file again before searching?
A second upload before the search finishes usually gives you two copies of every line. The first copy was never gone. It was excluded, matched, filtered or filed under another account. Once both copies surface, you have a duplicate clean-up on top of the original question.
The safe rule for uploads is to start each file after the newest transaction already in QuickBooks. A file covering dates that are already present breaks that rule, even if the earlier lines are hidden on the Excluded tab. Restoring from the Excluded tab is one click. Unpicking a duplicate import is many.
There is one case where a new upload is right. If you searched every place in the checklist and the count is still short, part of the file may never have gone in. Upload only the missing dates, as a new file, rather than the whole original.
Proving the imported transactions are all present with the running balance
Once you think every line is accounted for, prove it with balances rather than by counting rows. Take the account's balance on the last date of the file and compare it with the closing balance printed on the bank statement for that date. If they agree, every movement in the period is present once.
A running balance helps you find a gap when the totals disagree. Go down the statement a week at a time and compare its balance with QuickBooks on the same dates. The first week where they part is where a line is missing, duplicated or reversed. The post on the PDF bank statement running balance explains how to use that printed column as a check.
If the original file has to be rebuilt from a PDF statement, the balance check is worth doing on the file before it goes in. SimpleBankConvert is being built to turn PDF statements into CSV or QBO files for QuickBooks Online. It has not opened accounts yet; the get started page puts you on the list.