Common Red Flags We Look For in a QuickBooks Online Cleanup

When we open a QuickBooks Online file for the first time, we run the same diagnostic scan before touching anything. A short list of red flags tells us almost immediately where the trouble is hiding and how deep the work will go. None of these mean the business is in bad shape — they are simply the signals that the books have drifted away from what actually happened. Here are the ones we check for first, and why each one matters.

A growing Undeposited Funds balance

Undeposited Funds is meant to be a temporary holding spot for payments waiting to be grouped into a deposit. When it keeps climbing instead of clearing to zero, it usually means payments were recorded twice — once from the invoice and again from the bank feed — or deposits were never matched. It is one of the most common reasons income looks overstated on a QuickBooks Online profit and loss.

Accounts that have never been reconciled

Every bank and credit card account should be reconciled to its statement every month. When we find an account that has never been reconciled, or that stopped a year ago, it means nothing has confirmed the books against reality since then. Unreconciled accounts hide duplicates, missing transactions, and balances that quietly stopped matching the bank.

Opening Balance Equity that still has a balance

Opening Balance Equity is a temporary account QuickBooks Online uses when accounts and balances are first entered. It is supposed to be cleared to zero once setup is finished. A balance sitting there long after the file was created is a reliable sign that an opening balance, a loan, or a transfer was never properly assigned to the right account.

Negative balances that should not exist

Some balances can never legitimately go below zero: a vendor you do not owe showing negative accounts payable, a customer showing a negative balance, or an inventory item at negative quantity. When they appear, they point to payments applied to the wrong bill, refunds recorded backward, or items sold that were never received into inventory. Each one distorts a report somewhere.

A swelling Uncategorized or 'Ask My Accountant' account

When transactions are hard to place, they often get parked in Uncategorized Expense or an 'Ask My Accountant' account with the intention of sorting them later. Later rarely comes. A large balance in either account means real spending has not been assigned to the accounts that drive the financial statements, so the profit and loss cannot be trusted until it is cleared.

Duplicate transactions from the bank feed

The bank feed is a huge time-saver, but when transactions are both entered manually and added from the feed, the same expense or deposit lands twice. Duplicates inflate income, expenses, or both, and they are easy to miss because each copy looks legitimate on its own. We look for the telltale pairs during every cleanup.

Personal and business spending mixed together

When personal purchases run through the business account and business costs get paid from a personal card, the books stop reflecting the true cost of running the business. Sorting the two apart — and moving personal activity to owner's draw or contributions where it belongs — is often the single biggest driver of accuracy in a cleanup.

Aging reports full of items that are already settled

An accounts receivable report showing invoices that were actually paid, or an accounts payable report listing bills already covered, means payments were recorded without being applied to what they paid off. The totals look alarming, but the real problem is that the money moved and the books never connected it — so both the aging report and the bank balance are telling a different story.

Sales tax that doesn't match what was filed

When the sales tax liability in QuickBooks Online does not line up with what was actually collected and remitted, something in the workflow is off — tax recorded to the wrong account, payments made outside the sales tax center, or rates that changed mid-year. We flag it during the cleanup and route the filing questions themselves to your CPA.

What we do with what we find

Finding the red flags is the easy part; correcting them in the right order is the work. During a QuickBooks Online cleanup, we clear Undeposited Funds, reconcile every account, trace and zero out Opening Balance Equity, correct the negative balances, recategorize the parked transactions, remove duplicates, and separate personal from business — then reconcile the whole file so the reports finally match reality. If you would rather hand it off entirely, that same work is part of our ongoing bookkeeping services.

Frequently asked questions

How do I know if my QuickBooks Online file needs a cleanup? If your accounts are not reconciled, your profit and loss looks off, or you recognize any of the red flags above, the file has likely drifted from what actually happened. A quick review will tell you how far.

Which red flag is the most serious? It depends on the file, but never-reconciled accounts and a growing Undeposited Funds balance tend to distort income the most, which is why we check those first.

Can I fix these myself? Some, yes — clearing Undeposited Funds or recategorizing an account is manageable. The trouble is the order: correcting one balance can move another, so a professional cleanup fixes them as a connected sequence rather than one at a time.

QBO Cleanups brings Advanced QBO ProAdvisor certification and 20+ years of bookkeeping experience to files that have drifted out of balance. If any of these red flags sound familiar, book a call and we will take a look.