Catching unsupported balance sheet balances in QuickBooks Online

The balance sheet line items nobody wants to touch

You open a new QBO file and the P&L looks… fine-ish. Then you flip to the Balance Sheet and see it:

• "Loan Payable" sitting at exactly $50,000, untouched all year.
• "Prepaid Expenses" with a chunky balance and a long list of monthly utility bills.
• A generic "Other Current Liabilities" account that seems to catch everything the prior bookkeeper didn’t know what to do with.

The client says, "But my bank is reconciled every month." And maybe it is. But the balance sheet is full of numbers that no one can actually explain.

This is where a lot of cleanups go sideways. Firms focus on cash, A/R, and A/P, but leave legacy balance sheet accounts largely unchallenged. The file ends up with a shiny P&L sitting on top of a balance sheet full of unsupported or misclassified balances.

If you want your cleanups to hold up under tax prep, lender reviews, or due diligence, you need a systematic way to ask: for every single balance sheet account, "What is this, and what supports it?"

Where this problem hides inside QuickBooks Online

In QBO, the mess usually doesn’t scream at you. It hides in accounts that technically tie out, but don’t make sense once you look under the hood.

The basic pattern:

1. Run a Balance Sheet as of your review date (say 12/31/24).
2. For each asset, liability, and equity account with a non-zero balance, drill into a Transaction Detail by Account for your cleanup period.
3. Look at transaction volume, types, memos, and attachments.

You’ll start seeing the same red flags:

• A "Loan Payable" with a $50,000 balance, no current-year activity, and no loan statements attached or referenced.
• A "Prepaid Expenses" account where 80% of the debits are monthly utility bills coded from Expense transactions, offsetting Utilities Expense.
• A "Payroll Liabilities" account that’s just a dumping ground for payroll and tax payments, with generic vendors like "Payroll" or "Tax" and no clear sub-ledger.

In practice, here’s what you’re scanning for:

• Accounts with non-zero balances and zero current-period transactions.
• Accounts with only one or two transactions in the period, but balances that are material for the client.
• Accounts where there are no attachments and no memos like "loan statement", "tax notice", "bank rec", or "reconciliation" anywhere in the period.
• Asset accounts whose activity looks like recurring operating expenses.
• Liability accounts that are mostly direct payments with vague vendors and no detail.

Summarized as quick red flags:

• Non-zero balance, no current-year activity.
• Very low activity but a big ending balance.
• No attachments or support-related memos on any recent transactions.
• Asset accounts full of Bills/Expenses/Checks tied to normal operating expenses.
• Liability accounts used as catch-all codes for payroll or tax payments.

What happens if you just live with it

Letting these balances ride is tempting, especially when you’re under a fixed-fee cleanup and the client is impatient. But the fallout shows up later, when someone finally asks, "What exactly is in that $50,000?"

The damage inside your numbers

Unsupported or misclassified balance sheet balances can:

• Overstate assets (e.g., prepaid or fixed assets that are really expenses).
• Understate expenses (operating costs buried in assets or liabilities).
• Misstate liabilities (catch-all payroll or sales tax accounts that don’t match filings).
• Distort equity (plug entries and old cleanup adjustments no one understands).

Take that $50,000 "Loan Payable" with no current-year activity or documentation. Is it:

• A real loan that’s just not being amortized?
• An old owner advance that should be in equity?
• A prior-year plug to make the balance sheet balance?

Until you know, you can’t confidently sign off on the financials. And if you push it forward year after year, the problem compounds.

The damage in client conversations

The other cost is credibility.

When a banker or tax preparer asks your client about a balance and they look to you for the answer, you want to be able to say, "Here’s what that is, here’s the support, and here’s how it’s being handled."

If instead you’re saying, "That’s just how it was when we got the file," it undermines the value of your cleanup work. It also makes future advisory harder—no one wants to build forecasts on top of a balance sheet full of question marks.

A practical way to review every balance sheet account

The goal isn’t to prove every dollar with forensic-level documentation. The goal is to systematically surface accounts that need human judgment, and then make a clear call: keep, reclass, write off, or document.

Here’s a simple workflow you can standardize:

1. Define your cleanup period and review date. For example, 1/1/24–12/31/24 with a review date of 12/31/24.
2. Pull a Balance Sheet as of the review date. Include all asset, liability, and equity accounts, even the tiny ones.
3. Triage by size and activity. Start with accounts that have a non-zero balance and either (a) no transactions in the cleanup period, or (b) only 1–2 transactions but a meaningful balance.
4. Drill into transaction detail. For each account you’re reviewing, run Transaction Detail by Account for the cleanup period. Scan for:
   • Transaction types (Bills, Expenses, Checks, Credit Card Charges, Journal Entries).
   • Offsetting accounts (are these normal expenses hitting an asset or liability?).
   • Memos and attachments (any sign of statements, notices, reconciliations?).
5. Identify misclassification patterns. If more than half of an asset account’s activity is recurring expenses (utilities, rent, office supplies), you likely have operating costs sitting on the balance sheet. Same idea for liabilities used as catch-alls.
6. Decide and document. For each questionable account, decide whether to:
   • Reclass to proper expense or equity.
   • Split between supported and unsupported portions.
   • Leave as-is but add clear notes and attach support.
   • Flag for client follow-up when documentation is missing.
7. Summarize in your workpapers. One line per account: what you saw, what you did, and what still needs client input.

Tools like CleanupOwl can do the first pass here—scanning every balance sheet account for low activity, lack of support indicators, and suspicious transaction patterns—so your team spends time on judgment calls instead of hunting.

Turning this into a repeatable firm standard

The firms that avoid balance sheet surprises treat this as a standing checklist item, not a one-time hero move.

A few ways to operationalize it:

• Add a "Balance sheet account review" section to your cleanup workpapers with columns for: balance, activity level, support present (Y/N), issues, resolution.
• Set materiality thresholds by client size so you’re not chasing every $37 balance.
• Standardize memo language when you add support (e.g., "2024 loan statement on file", "2024 payroll tax tie-out completed").
• Use a diagnostic tool like CleanupOwl early in onboarding to auto-flag accounts with non-zero balances and suspicious patterns before you quote or start.

The patterns you’ll keep seeing in client files

Here are some common situations and how they typically show up in QBO:

Not every odd-looking balance is a fire drill. Some will be legacy items that were already vetted in a prior year. Others will be small enough that you consciously decide not to chase them.

But when you see big balances with no recent activity, no obvious support, or transaction patterns that don’t match the account type, that’s where you dig. Those are the ones that can blow up later in a tax exam, bank review, or sale process.

Making this part of your cleanup playbook

Balance sheet reviews are where cleanups stop being cosmetic and start being real. If you only fix the P&L and bank recs, you’re leaving landmines in the file for the next professional who touches it—which might be you, a year from now.

Building a simple, repeatable review of every balance sheet account into your onboarding and cleanup process protects your firm and your client. It also makes your work easier to defend when someone asks, "How do you know these numbers are right?"

This doesn’t have to be a manual slog. A diagnostic tool like CleanupOwl can scan all balance sheet accounts up front and hand you the short list that actually needs your attention, instead of you hunting through every account by hand.

If you’re a business owner reading this, this is exactly the kind of question to ask your accountant: "How do you review my balance sheet accounts to make sure every balance is supported and correctly classified? Are you using any automated diagnostics to help?"

When your firm treats unsupported or odd balance sheet balances as a standard diagnostic step—not an optional extra—your cleanups get faster, your files get safer, and your clients get numbers they can actually rely on.