Bank feeds, For Review, and the hidden gaps in QBO cash

When the bank says one thing and QuickBooks swears another

You open a new QBO cleanup file. The client proudly tells you, "But my bank is reconciled every month." You click into Banking > Bank transactions and see it: 143 items sitting in For Review going back six months.

On top of that, you pull the January bank statement for their main checking account. The statement shows $50,000 of debits. Transaction Detail by Account for the same dates shows $37,000. The register balance might tie to some prior reconciliation, but you already know: this file is not complete.

This is one of the most common traps in QuickBooks Online cleanups:

• Bank feeds are connected, but For Review is half-processed.
• Manual entries and bank feed entries overlap.
• The reconciled balance hides the fact that not all statement activity ever made it into QBO.

If you don’t catch this early, you can spend hours "cleaning" downstream issues that are really just missing or duplicated bank activity.

Where this problem hides inside QuickBooks Online

There are two places you need to look:

1. The Banking/Transactions screen (For Review tab).
2. Statement totals vs. what actually hit the bank or card register.

1. The For Review backlog

For each connected bank or credit card account:

• Go to Transactions > Bank transactions (or Banking).
• Filter to one account at a time.
• Stay on the For review tab.
• Set the date filter to your cleanup window (e.g., 1/1/2024–12/31/2024).

Red flags:

• 20+ items in For Review for a "closed" month.
• Old items (90+ days) still sitting there.
• A mix of deposits and payments that obviously belong in the books (payroll, merchant deposits, loan payments) but were never added or matched.

Example:

• Cleanup period: Jan–Mar.
• Checking account is connected.
• January has 20 transactions still in For Review totaling $3,000.
• January bank statement shows $10,000 of debits.
• Transaction Detail by Account for January shows only $7,000 of debits.

You already know at least some of those 20 items are the missing $3,000.

2. Statement vs. register activity

Even if For Review is empty, you can still have gaps. Maybe the client disconnected/reconnected feeds, or manually entered some items and ignored others.

For each connected bank/credit card account and each statement period in your cleanup window:

1. Get the bank or card statement (PDF or downloaded data).
2. Note total debits and total credits for the period.
3. In QBO, run Transaction Detail by Account for that account, same dates.
4. Sum total debits and total credits.
5. Compare statement totals to QBO totals.

If debits or credits differ by more than your materiality threshold (say $100 or 2–3% of total activity), you’ve got a completeness problem, even if the ending balance happens to match.

Key red flags to summarize:

• Items in For Review dated inside your cleanup period.
• "Reconciled" accounts with a non-zero For Review count.
• Statement debits/credits materially higher than QBO debits/credits.
• Gaps for just one or two months in an otherwise clean year.
• A sudden drop in QBO activity vs. statements right after a feed reconnect.

What happens if you just live with it

Ignoring unprocessed bank feeds and statement gaps doesn’t just make the bank section messy. It undermines everything built on top of cash.

The damage inside your numbers

When For Review is not cleared and statement activity doesn’t match the register, you can end up with:

• Understated expenses and income – Missing debits/credits mean your P&L is incomplete. That "profitable" year might just be missing vendor payments, payroll, or credit card charges.
• Duplicated transactions – Client manually enters checks and then later Adds them from the feed. The bank still reconciles if they force it, but expenses are doubled.
• Misclassified cash flows – Loan payments sitting as uncategorized expense, merchant deposits split incorrectly, transfers treated as income.
• Broken audit trail – You can’t tie activity from the statement to QBO without guesswork. That makes reviews, due diligence, and audits painful.

From a tax and compliance standpoint, missing or duplicated bank activity means:

• Wrong taxable income.
• Unreliable basis for sales/use tax, payroll reconciliations, and 1099s.
• Year-end tie-outs that don’t reconcile to bank statements without manual patches.

The damage in client conversations

This is also a trust issue.

You don’t want to be the firm that:

• Signs off on "clean" books that later turn out to be missing months of card charges.
• Delivers advisory or cash flow planning based on incomplete data.
• Has to call the client back three months later to explain a big adjustment because someone finally processed old For Review items.

When you can show a client, "Your January statement has $50,000 of debits; QBO only shows $37,000, and you still have 20 items in For Review," the conversation shifts. It’s no longer subjective; it’s a clear, fixable gap.

A practical way to lock down bank feed completeness

The goal is simple: before you go deep on cleanup or advisory, confirm that all bank and card activity for your cleanup window is actually in QBO.

Here’s a straightforward process you can standardize:

1. Define the cleanup window.

   • Use the engagement’s start/end dates (e.g., 1/1/2024–9/30/2024).
   • Apply this consistently to every bank and card account.

2. List all active bank and credit card accounts.

   • From the Chart of Accounts, filter to Type = Bank or Credit Card, Status = Active.
   • Note which ones are connected to feeds (visible in Banking/Transactions with a connected status).

3. For each connected account, check For Review.

   • Filter For Review to the cleanup dates.
   • Count the items and eyeball the total amount.
   • If count > 0 for a "closed" period, mark that account/month as incomplete.

4. Cross-check statements vs. QBO for connected accounts.

   • For each month in the cleanup window where you have a statement:
     • Compare total debits and credits from the statement to Transaction Detail by Account.
     • If the difference exceeds your materiality threshold, flag that month.

5. Resolve the gaps.

   • Process or exclude For Review items appropriately (match to existing, add new, or exclude true duplicates/non-book items).
   • For statement mismatches, identify missing or duplicated entries and adjust.

6. Document your conclusion.

   • For each account, note: For Review cleared? Statement totals aligned within threshold? Any known exceptions?

Tools like CleanupOwl can run these checks across all connected bank and card accounts before you even start quoting the project, handing you the list of accounts and periods with unprocessed feeds or statement mismatches.

Turning this into a repeatable firm standard

This shouldn’t depend on which staff accountant happens to pick up the file. Build it into your standard diagnostic and cleanup workflow:

• Add a checklist item: "Bank feeds cleared and statement activity matched for cleanup window."
• Define your thresholds: e.g., "No more than 0 unprocessed For Review items in closed months" and "Statement vs. QBO differences under $100 or 2% of activity."
• Require a short workpaper or note per account summarizing the check.

If you’re using a diagnostic tool like CleanupOwl, you can have it run this check up front and attach the output to your workpapers, so reviewers can see exactly which accounts had For Review items or material statement gaps.

The patterns you'll keep seeing in client files

Your response doesn’t have to be the same for every situation.

For small, consistent differences that are clearly bank fees or rounding, you may decide they’re not worth chasing if they’re under your defined threshold. For a single month with a $3,000 gap, you probably dig in and fix it. For a massive For Review backlog, you may re-scope the engagement or require the client to help categorize.

Making this part of your cleanup playbook

Bank feeds make QBO look "easy," but they also make it easy to hide incompleteness behind a reconciled balance and a tidy dashboard. A quick, systematic check of For Review and statement vs. register activity is one of the highest-leverage diagnostics you can run before committing to a cleanup.

When this is a standard line item in your firm’s checklist, you:

• Catch missing and duplicated cash activity before it pollutes the P&L.
• Protect your team from rework when old For Review items suddenly get processed.
• Give clients a clear, evidence-based explanation of why their books aren’t as "caught up" as they thought.

If you’re a business owner, this is the kind of question to ask your accountant: "Have you checked that all my bank and card statement activity is actually in QuickBooks, not just that the accounts are reconciled?" A diagnostic tool like CleanupOwl can help your accountant answer that confidently and quickly.

The firms that consistently deliver clean, reliable QBO files aren’t just good at fixing what they see. They’re good at proving what isn’t there yet—and making sure every bank and card transaction that belongs in the books actually made it in.