QuickBooks Bank Feed Missing Transactions: How to Fix

TL;DR When a QuickBooks Online bank feed seems to be missing transactions, first check that they aren't simply somewhere else: in another tab, already matched or excluded, filtered out by date, posted to a different account, or still pending at the bank. If they really are missing, find the exact gap by comparing QuickBooks to the bank statement, day by day, using the statement's running balance. Then fill only that gap, either by refreshing or reconnecting the feed or by uploading a file built from the statement for exactly the missing dates. Finish by reconciling the month to the statement's closing balance so you know the gap is closed and nothing has been duplicated.

Bank feeds are one of the best parts of QuickBooks Online, right up to the moment you notice a gap. A client says they paid you on the 12th, but there's no deposit. Your reconciliation is out by an amount that looks like a card payment. Or there's simply a stretch of days with nothing in the feed at all.

This guide covers the usual reasons transactions appear to be missing, how to prove what's actually missing, and how to fill the gap cleanly. We describe QuickBooks Online's screens in general terms because Intuit updates them regularly; for exact menu names, check Intuit's current help articles.

First, make sure it's really missing

A surprising number of "missing" transactions aren't missing at all. Before you reconnect anything or upload a file, check these:

It's in a different tab

The bank transactions screen separates transactions waiting for review from those already categorized or matched, and from those excluded. A transaction you're looking for may already have been added or matched, possibly by a rule or by someone else on your team. Check every tab, and search by amount.

It was excluded

Someone may have excluded the transaction, perhaps thinking it was a duplicate. Excluded items don't post to your books. Look in the excluded tab and restore it if it was excluded by mistake.

A filter is hiding it

Date filters and search terms on the bank transactions screen persist longer than you might expect. Clear all filters and look again.

It's in a different account

If you have several bank and credit card accounts connected, a transaction can show up under a different one than you expect, especially if someone accidentally linked the wrong bank account to a QuickBooks account. Check each account's feed for the amount.

It's still pending

Feeds usually bring in posted transactions, not pending ones. A card payment you made yesterday may show in your banking app but not in QuickBooks until it posts. Give it a few days.

It was recorded manually

Someone may have entered the payment or deposit by hand, such as a cheque recorded as an expense, in which case the feed transaction may have been matched to it. Search the register for the amount and date.

If none of these explain it, the transaction probably never came through the feed.

Why feeds miss transactions

Common reasons include:

• The initial download window. When you first connect an account, QuickBooks typically only pulls in a limited amount of history. Anything before that window won't arrive from the feed. Intuit's help articles state the current limit.
• A broken connection. Feeds can disconnect after a password change, a security update at the bank, or a problem with the third-party connection. Transactions during the disconnection may not arrive when it reconnects, or may arrive only partially.
• Reconnecting with a different start date. If an account was disconnected and reconnected, the date you chose at reconnection decides what comes back. Choose too late, and there's a gap; too early, and you get duplicates.
• Bank-side issues. Banks sometimes have temporary problems sending data, especially for certain transaction types or around system changes.
• The account type isn't fully supported. Some accounts or account types send limited data, or none at all.

You usually can't tell which one caused a particular gap, and you don't need to. What matters is proving what's missing and filling it once.

Find the exact gap using the statement

The bank statement is the source of truth. The goal is a precise list of what's in the statement but not in QuickBooks.

Step 1: get the statement into a spreadsheet

Convert the statement PDF for the month in question so every transaction is one row with date, description, amount and balance. SheetStatement does this and checks that the opening balance plus activity equals the closing balance before export. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more. You can also use the bank's own download if it covers the period.

Step 2: export what QuickBooks has

Run a report showing the transactions in that bank account for the same period, such as a transaction detail report filtered to the account, and export it to Excel. You want date, amount and description at minimum.

Step 3: match the two lists

Put both lists side by side. The simplest approach is to match on amount and date. With the statement in a table called Bank and QuickBooks in a table called QB:

=COUNTIFS(QB[Amount], [@Amount], QB[Date], ">=" & ([@Date]-3), QB[Date], "<=" & ([@Date]+3))

That counts QuickBooks transactions with the same amount within three days of each statement line. A result of 0 flags a statement line that QuickBooks doesn't have. A result above 1 needs a closer look, as there may be duplicates or two genuine transactions of the same amount. Our guide to matching bank transactions in Excel with XLOOKUP has more robust versions.

Step 4: confirm with the running balance

Matching tells you which lines are missing. The running balance tells you when the books went out of step. If you recalculate the QuickBooks balance day by day and compare it with the statement's balance for each day, the first day the two differ is the start of the gap. That's especially helpful when the feed dropped a whole block of days. Our running balance formula guide shows the formula.

At the end of this step you should have a short, specific list: these seven transactions, on these dates, totalling this much. That's what you'll fill.

Fill the gap

Option 1: refresh or reconnect the feed

If the connection is broken, fixing it may bring the transactions in. Refresh the account first. If it needs reconnecting, pay close attention to the date range you choose: pick a start date that covers the gap but doesn't overlap more than necessary with transactions you already have.

After reconnecting, check whether the missing transactions arrived. If they did, good. If some arrived and some didn't, note which are still missing and use option 2 for those only.

Option 2: upload a file for the missing dates

QuickBooks Online lets you upload bank transactions from a file (commonly CSV, and also QBO/OFX-style files) for a connected or unconnected account. Build the file from your list of missing transactions:

• Include only the missing transactions, not the whole month.
• Use a clear date format and either a single signed amount column or separate money in and money out columns.
• Remove totals, headers you don't need, and blank rows.

Our guide to importing a bank statement into QuickBooks Online walks through the upload and column mapping. If the file is rejected, see QuickBooks Online CSV import errors. If you'd prefer a QBO (Web Connect) file, see converting a bank statement PDF to QBO.

Option 3: enter a few transactions manually

If only one or two transactions are missing, entering them by hand is sometimes quickest. Record them against the bank account with the correct date and amount. If the feed later delivers them, match the feed transaction to your manual entry rather than adding it again.

Check for duplicates afterwards

Filling a gap is where duplicates sneak in, especially after a reconnection. Once the missing transactions are in:

1. Re-run your matching formula. Every statement line should now have exactly one match.
2. Look for QuickBooks lines with no matching statement line. Those are duplicates or genuine errors.
3. Remove duplicates by excluding or deleting the extra copy, depending on whether it's still in the review list or already posted.

Our guide to QuickBooks duplicate transactions after import covers the clean-up in more detail.

Reconcile to prove it's fixed

Matching and uploading get the transactions in. Reconciling proves the books agree with the bank. Reconcile the account for the month using the statement's ending balance and date. If the difference is zero, the gap is closed and nothing was duplicated.

If the reconciliation is still out:

• By the value of one transaction: something is still missing or duplicated.
• By the same amount as last month: the problem started earlier. Reconcile the previous month first.
• By an amount matching a previously reconciled transaction: someone changed or deleted a reconciled item. Our guide to finding bank reconciliation discrepancies helps track that down.

A worked example

A bookkeeper notices that a client's QuickBooks Online checking account hasn't reconciled for June. The difference is $3,412.18.

1. Look first. She clears filters and checks the review, categorized and excluded tabs. Nothing obvious.
2. Convert the statement. She converts the June PDF. It balances: opening plus activity equals closing.
3. Export QuickBooks. She exports June's transactions for the account.
4. Match. The COUNTIFS check flags nine statement lines with no QuickBooks match, all between 14 and 19 June.
5. Running balance. The daily balance comparison agrees: QuickBooks and the bank match until 13 June and diverge from 14 June.
6. Total. The nine missing lines total $3,412.18, the same as the reconciliation difference.
7. Fill. The feed had disconnected over that week. Reconnecting brings in only three of the nine. She builds a CSV of the remaining six and uploads it.
8. Check duplicates. Re-matching shows each statement line once. No extras.
9. Reconcile. June now reconciles with a zero difference.

She notes in the client file what happened and the dates affected, which helps if the same thing happens again.

Credit card feeds

Credit card accounts go missing in the same ways, with a couple of extra twists.

Sign confusion. On a card account, purchases increase what you owe. If you build an upload file from a card statement, make sure the signs match what QuickBooks expects for a credit card account, or map separate charge and payment columns during upload. A file with reversed signs will import without complaint and then wreck the reconciliation by exactly twice the value of each transaction.

Payments from the bank account. A card payment appears in both the checking feed and the card feed. If one side is missing, the other side may have been categorized as an expense instead of a transfer. Fix it as a transfer between the two accounts once both sides are present.

Several cards on one account. Business cards with employee cards may report activity for all cards under one account, or separately. Check that you're comparing against the right statement. Our guide to importing credit card transactions into QuickBooks Online covers card uploads in more detail.

When months or a whole year are missing

Sometimes the gap isn't a week; it's everything before the feed was connected. That's common when a business moves to QuickBooks partway through a year, or when a bookkeeper takes on a client who has been ignoring the books.

The method scales. Convert each month's statement, prove each one balances, and check that each closing balance equals the next opening balance so you know no month is missing. Then upload month by month, oldest first, reconciling each month before moving on. Don't upload a whole year in one file: if something goes wrong, you'll have twelve months to untangle instead of one. Our guide to catching up on bookkeeping from bank statements walks through the full process, including how to set the opening balance.

When the bank changes something

Account migrations, bank mergers and new account numbers can all cause feeds to stop or restart. If your bank has told you about a change, expect to reconnect, and check the dates on either side of the switch carefully. Transactions near the change are the most likely to go missing or appear twice.

Prevent the next gap

• Reconcile monthly. Gaps are much easier to find a few weeks after they happen than at year end. A month-end close checklist keeps it on the calendar.
• Watch for connection warnings. Fix disconnections promptly.
• Keep statements. Save every month's PDF. When a gap appears, you'll need it.
• Check the feed weekly. A quick look at the date of the most recent transaction in each account takes a minute. If the newest item is a week old on a busy account, the connection probably needs attention, and you've caught it before the gap gets large.
• Record what you uploaded. A short log of manual uploads and reconnection dates makes later troubleshooting much faster.

The same approach in other software

Feeds in Xero and other packages can have gaps for similar reasons, and the method is the same: compare to the statement, find the exact gap, fill only that, then reconcile. See Xero bank reconciliation step by step for the Xero side.

Fill a feed gap from your statement

Upload the month's statement PDF to SheetStatement, check the rows and balance, and download a CSV or QBO file to fill the gap. The free plan covers 3 pages a month, enough to fix a typical gap.

FAQ

Why are transactions missing from my QuickBooks bank feed?

Common causes are a limited history window when the account was first connected, a disconnection or reconnection with a later start date, bank-side issues, or account types that aren't fully supported. Also check whether the items are in another tab, excluded, filtered, or still pending.

How far back does a QuickBooks bank feed go?

When you connect an account, QuickBooks typically downloads a limited amount of history. Check Intuit's current help article for the limit. For older transactions, upload a file built from your statements.

Will reconnecting the bank feed bring back missing transactions?

Sometimes, depending on the date range you choose and the bank. Check what arrives, and fill anything still missing with a file upload or manual entries.

Can I upload just the missing transactions?

Yes. Build a CSV or QBO file containing only the missing transactions and upload it to the bank account. Uploading the whole month risks duplicates.

How do I avoid duplicates when filling a gap?

Match the statement against QuickBooks before and after, include only missing items in your upload, and reconcile afterwards. Each statement line should match exactly one QuickBooks transaction.

How do I know the problem is fixed?

Reconcile the account to the statement's ending balance. A zero difference confirms the books and the bank agree.

Is it safe to upload statements to a converter?

See the security page for how SheetStatement processes and stores files, and review any service's policy before uploading financial documents.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.