Catching unscoped bank, credit card, and loan accounts in QBO

CleanupOwl Team

The extra bank account that blows up your cleanup quote

You open a new QuickBooks Online file for a cleanup. The client swears, "We just have one checking and one credit card." You scope, you quote, you start.

Halfway through, you pull a Transaction Detail by Account and notice a second checking account with a 2024 balance and a handful of transfers from the main account. Then you see a "Line of Credit" sitting at $85,000 with interest-only payments flowing through the year.

Now your original quote is wrong, your scope is wrong, and your team is about to eat hours or go back to the client with an awkward change order.

This is what happens when bank, credit card, and loan accounts with real activity sit outside the engagement scope. The transactions are there. The balances are there. But they were never priced, never planned, and sometimes never cleaned.

Where these hidden accounts live in QuickBooks Online

In QBO, this problem hides in plain sight in the Chart of Accounts and in transfer activity between balance sheet accounts.

You’re looking for any bank, credit card, or loan/LOC account that:

  • Has transactions dated in the cleanup period, or
  • Has a non-zero ending balance during that period, or
  • Is connected via transfers to an account you did include in scope.

A typical pattern:

  • Cleanup period: 1/1/2024–12/31/2024
  • Client tells you: "We use Checking-1 and a Visa card."
  • Engagement scope: Checking-1, Visa
  • QBO Chart of Accounts actually has: Checking-1, Checking-2, Visa, Amex, Line of Credit
  • 2024 activity:
    • Checking-2: 40 transactions, mostly transfers from Checking-1
    • Amex: inactive, zero balance
    • Line of Credit: monthly draws and payments

In that scenario, Checking-2 and the Line of Credit are both in play for your cleanup, even if the client "forgot" to mention them.

Concrete red flags to look for:

  • A second checking or savings account with 5–50 transactions in the cleanup period
  • A credit card account with a non-zero balance but no reconciliations in the period
  • A "Notes Payable", "Loan Payable", or "Line of Credit" account with monthly activity
  • Transfers from your scoped checking account to another bank/loan account you didn’t quote
  • An "inactive" bank account that still shows a balance or transactions in the cleanup period

Run a Transaction Detail by Account for the cleanup period, filter to Account Type = Bank, Credit Card, and Loan/Line of Credit, then sort by Account. Any account with more than a couple of lines that isn’t on your scope list deserves a closer look.

What happens if you pretend those accounts don’t exist

Ignoring these accounts isn’t just a pricing problem. It can distort the financials and create real trust issues with the client later.

The damage inside your numbers

When a bank, credit card, or loan account with activity is left out of your cleanup work:

  • Cash is incomplete. Transfers between accounts don’t net out correctly, so total cash and cash flows are wrong.
  • Debt is misstated. LOCs and loans show the wrong principal balance, or sit unchanged for years while payments hit expense accounts directly.
  • Interest and fees go missing. Payments to unscoped credit cards or loans get coded as "Ask My Accountant" or random expenses instead of split between principal and interest.
  • Equity gets messy. Owner contributions or draws routed through an unscoped account never hit equity properly.

Example:

  • Client uses Checking-1 (scoped) and Checking-2 (unscoped).
  • They transfer $50,000 from Checking-1 to Checking-2.
  • You reconcile and clean Checking-1 only.

On paper, you’ve reduced cash by $50,000, but you never picked up the offsetting increase in Checking-2. Total cash is understated by $50,000, and any cash-based analysis is off.

The damage in client conversations

This is also a relationship problem.

You deliver the cleanup, and the client’s banker asks why their LOC balance in QBO doesn’t match the loan statement. Or the tax preparer asks where the second checking account went.

Now you’re explaining:

  • Why some accounts are "clean" and others are untouched
  • Why your quote didn’t include all the accounts they actually use
  • Why you need more time and more fees to fix it

Even if the client forgot to mention the extra accounts, it still feels like you missed something obvious. That’s not where you want to be.

A systematic way to catch unscoped accounts

The firms that avoid this headache treat "bank/credit card/loan completeness" as a pre-engagement diagnostic, not something you discover mid-cleanup.

Here’s a simple workflow you can standardize:

  1. Define the cleanup period. Lock in start and end dates (e.g., 1/1/2023–12/31/2024) before you run any diagnostics.
  2. Pull the Chart of Accounts. Filter to account types that behave like cash or debt: Bank, Credit Card, and the loan/LOC detail types you consider in-scope for cleanup.
  3. Check for activity and balances. For those accounts, run a Transaction Detail by Account (or GL) for the cleanup period and note:
    • Any non-void transactions in the period
    • Any non-zero ending balances at period end
  4. Map against your scope list. Compare that list to the accounts you actually quoted (by QBO account name and type, or ID if you track it). Anything with activity or a balance that’s not on your list is a candidate "unscoped" account.
  5. Scan for transfers. In the same report, filter for Transfer-type transactions and journal entries between balance sheet accounts. If a scoped account is transferring to an unscoped bank/loan account, that unscoped account needs a decision.
  6. Decide: include, exclude, or re-quote. For each unscoped account, decide whether to:
    • Add it to the engagement and adjust pricing
    • Explicitly exclude it and document that decision
    • Treat it as de minimis (e.g., one small transfer) with a note in your workpapers
  7. Document for the client. Summarize: "We identified these additional accounts with activity during the cleanup period. Here’s what we recommend doing with each." That turns a surprise into a controlled scope discussion.

Tools like CleanupOwl can run this kind of check automatically before you even send the proposal, handing you a list of every bank, credit card, and loan account with activity or transfers in the cleanup period.

Baking this into your firm’s standard process

This should live in your firm’s standard intake and scoping checklist, right alongside bank feed status and reconciliation history.

  • Add a line item: "Compare all active bank/credit card/loan accounts with activity/balances to scoped accounts."
  • Require a documented decision for each "extra" account: include, exclude, or re-quote.
  • Save a copy of the supporting report (Transaction Detail by Account or GL) to your workpapers.

This is also a natural place to lean on automation. A diagnostic tool like CleanupOwl can scan the QBO file for the cleanup period, identify all candidate accounts, and flag the ones that have activity or transfers but aren’t on your scope list. Your team then just reviews and decides, instead of hunting.

Set materiality thresholds and rules by engagement type. For example, you might auto-include any unscoped account with more than 20 transactions or a balance over $5,000, and only flag smaller ones for a quick manual decision. Be explicit about how you handle inactive accounts with zero balance and no activity—they usually don’t need to be in scope.

The patterns you’ll keep seeing in client files

SituationWhat you see in QBORisk if you shrug it off
Second checking account with transfersChecking-2 has 30 transactions and multiple transfers from Checking-1 during the cleanup period, but wasn’t on your scope list.Total cash is wrong, transfers don’t net, and you’ve effectively only cleaned half the cash picture. Scope and fee both underquoted.
Active LOC or loan with monthly payments"Line of Credit" or "Loan Payable" shows monthly draws/payments and a year-end balance. Not included in the engagement.Debt and interest are misstated, cash flows are off, and bankers/tax preparers can’t rely on the balance sheet.
Old credit card with small residual balanceA credit card account has a handful of transactions and a $200 balance in the cleanup period, but you only scoped the main card.Small but annoying reconciliation differences later; can create unexplained suspense balances or misclassified expenses.
Inactive bank account with non-zero balanceAccount is marked inactive, but still shows a $5,000 balance at year-end within the cleanup period.Balance sheet is wrong, and you may miss the need for a write-off, transfer, or reclassification.
Truly dormant, zero-balance accountOld bank/credit card/loan account with no transactions and zero balance in the cleanup period.Minimal risk; documenting exclusion is usually sufficient.

Your reaction shouldn’t be the same for all of these.

For accounts with real volume or large balances, you almost always want them in scope. That might mean revising your quote or clearly defining a second phase of work.

For small, low-activity accounts, you can often document the decision, make a quick adjustment (e.g., clear a small residual balance), and move on. The key is that you know they exist and you’ve made a conscious call, instead of discovering them after the fact.

Be careful with closed tax years and prior financials that have already been issued. If you discover unscoped accounts affecting those periods, coordinate with the tax preparer or controller before making changes, and document any decision not to fully restate prior years.

Making this part of your cleanup playbook

This deserves its own line on your cleanup checklist because it protects both your numbers and your margins.

When every bank, credit card, and loan account with activity or balances is identified upfront, you:

  • Avoid mid-engagement surprises and awkward re-quotes
  • Deliver financials where cash and debt actually tie to reality
  • Build trust by showing the client you’ve looked beyond whatever they "remembered" to tell you

If you’re a business owner reading this, this is the kind of question you can ask your accountant: "Have you checked for any other bank, credit card, or loan accounts in QuickBooks that might need cleanup, even if we didn’t list them?" Whether they do that manually or with a diagnostic tool like CleanupOwl, you’ll know they’re not missing half the picture.

For your firm, the goal is simple: no more surprise accounts halfway through a cleanup. Run the completeness check at intake, make clear scope decisions, and document them. Tools like CleanupOwl can hand you the list it used to take an hour to build by hand, so your team can focus on judgment, not hunting through the Chart of Accounts.

Ready to run deeper QuickBooks diagnostics?

Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.

Start Free Trial