Bank Transactions Missing in QuickBooks Online? How to Import Them

Short answer: Bank transactions usually go missing in QuickBooks Online for one of four reasons: the bank feed only reaches back about 90 days on a new connection, so anything older never downloads; the transactions were excluded or deleted from the For Review tab; they are still pending at the bank and have not posted; or a feed outage created a gap. The fix for older or dropped transactions is to download the statement from your bank and import the missing period from a CSV or QuickBooks Web Connect file.

A missing transaction throws off everything downstream: your bank balance in QuickBooks stops matching the real account, reports understate income or expenses, and reconciliation refuses to hit zero. Before you assume something is broken, it helps to know that most "missing" transactions are not lost. They simply were never pulled in, or they were set aside. Here is how to tell which case you have and how to backfill the gap cleanly.

Why are my bank transactions missing in QuickBooks Online?

The most common cause is the 90-day limit on bank feeds. When you first connect an account, QuickBooks can only download roughly the last 90 days of history, and many banks pull even less. Anything older than that window never arrives through the feed and has to be added manually. Other causes are transactions you excluded or deleted from For Review, charges that are still pending and have not posted at the bank, or a temporary connection error that skipped a few days.

The four reasons transactions go missing

Step 1: Find the date of your last transaction

Before importing anything, find out exactly where the gap starts so you do not create duplicates. Select Settings, the gear icon, then Chart of Accounts. Find the bank or credit card account, choose View register, and scroll to the oldest transaction QuickBooks has. Note that date. Everything before it is what you need to import. Doing this first is what keeps a backfill from doubling up transactions you already have.

Step 2: Download the missing statements from your bank

Log in to your bank and download the statements that cover the gap, ideally as PDFs, which are the complete official record. If your bank offers a CSV or a Web Connect (.QBO) export for the period, grab that too, but note the export window is often short and may not reach the older months you actually need. The PDF statement almost always goes back further, usually up to seven years, which is why it is the reliable source for filling a long gap.

Step 3: Convert the statement into a file QuickBooks can read

QuickBooks Online will not reconcile against a stack of PDFs, so the missing transactions need to be in an importable format. QuickBooks Online accepts a CSV in one of two exact layouts, a 3-column file with Date, Description, and Amount, or a 4-column file with Date, Description, Credit, and Debit, and it also accepts Web Connect files. You can convert the PDF statement into a QuickBooks-ready file in a couple of minutes rather than retyping months of transactions by hand. If your destination needs an actual Web Connect file, tools that produce a QuickBooks import file from a statement handle that step directly.

Step 4: Import the missing period

In QuickBooks Online, go to Transactions > Bank transactions, select the account, then choose Upload from file from the Link account dropdown. Upload your CSV or QBO file, map the columns if prompted, and confirm the account. Because you noted your oldest existing date in Step 1, only bring in transactions from before that date. QuickBooks will place the imported items in For Review, where you can categorize and add them just like feed transactions.

What about excluded transactions?

If transactions disappeared rather than never arriving, check the Excluded tab. In Bank transactions, the For Review area has an Excluded filter or tab that holds items you or a rule set aside. Excluded transactions do not post to your register and do not show in reports, which makes them feel missing. Review that list, and if anything belongs in the books, you can bring it back in. Deleted transactions cannot be restored from here and have to be re-entered or re-imported.

How do I import transactions older than 90 days into QuickBooks Online?

You import them from a file, because the bank feed cannot reach past roughly 90 days. Download the older statements from your bank, convert them to a QuickBooks-ready CSV or Web Connect file, then use Transactions, Bank transactions, Upload from file. Note your oldest existing transaction date first so the import only adds the missing history and does not duplicate what you already have.

Avoiding duplicates when you backfill

Duplicates are the main risk when filling a gap, and they are easy to avoid. Always know the boundary date before you import, and only bring in transactions on the far side of it. If a few overlap anyway, QuickBooks flags likely matches in For Review, and you can exclude the extras before adding them. It is far easier to trim a handful of overlaps than to hunt down duplicates after they have been categorized and reconciled. Once the full history is in and matched to each categorized transaction, the account balance will finally agree with the bank.

Once the gap is filled, reconcile

Backfilling only pays off if you confirm it. After the missing transactions are in QuickBooks, reconcile each affected month against its statement, oldest first, so the ending balances chain together correctly. Our guide on reconciling a bank statement in QuickBooks Online walks through that, and if the feed itself is the problem rather than a one-time gap, the guide to fixing a QuickBooks bank feed that stopped working covers the connection side.

Frequently asked questions

Why does QuickBooks only import the last 90 days of transactions?

Bank feeds are limited to roughly the last 90 days of history when you connect an account, and some banks share even less. This is a limit on what banks make available to the feed, not a QuickBooks bug. Anything older has to be added by uploading a file rather than through the automatic connection.

Where do excluded transactions go in QuickBooks Online?

Excluded transactions sit in the Excluded tab within Bank transactions, under For Review. They do not post to your register or appear in reports, which is why they can seem missing. Review that tab, and bring any transaction that belongs in your books back into For Review to categorize and add it.

Can I import a full year of missing transactions at once?

Yes. Convert the statements covering the year into a QuickBooks-ready CSV or Web Connect file and upload them. Keep each file under the size and row limits QuickBooks sets, so a long period may need to be split into a few files, usually one per statement or per quarter, then imported in sequence.

Will importing a statement create duplicate transactions?

Only if the import overlaps transactions already in QuickBooks. Find your oldest existing transaction date first, then import only history from before that date. If a few overlap, QuickBooks flags likely matches in For Review so you can exclude the extras before adding them.

Why is a transaction I see at my bank not in QuickBooks?

It is probably still pending. Bank feeds only download posted transactions, so a charge that has authorized but not settled will not appear in QuickBooks until it posts, usually within a day or two. If it has clearly posted and still is not there, update the feed or import that day from a file.

The short version

Missing transactions in QuickBooks Online are rarely lost. They are older than the 90-day feed window, excluded, still pending, or dropped by a feed gap. Identify which case you have, find your oldest existing transaction date, then download the relevant statements, convert them to a QuickBooks-ready file, and import only the missing period. Finish by reconciling each month, and your QuickBooks balance will line up with the bank again.