The scariest things I find in QuickBooks usually aren’t dramatic.
There is no flashing warning that says YOUR BOOKS ARE A DISASTER.
Usually, QuickBooks opens normally. The bank balance looks reasonable. Transactions are coming in. Nothing appears to be on fire.
Meanwhile, one completely ordinary-looking number has been wrong for nine months.
If you haven’t looked closely at your balance sheet or reconciliations lately, this is a good time to do it. Weird balances are much easier to fix before tax season than during it.
Accounts Receivable is negative
Accounts Receivable generally represents money customers still owe you.
So when that balance is negative, I immediately want to know why.
Maybe payments were entered without matching them to invoices. Maybe deposits were recorded twice. Maybe old credits are sitting around.
It doesn’t necessarily mean something catastrophic happened.
It does mean we need to investigate.
Undeposited Funds has become a permanent resident
Undeposited Funds is supposed to be temporary.
Money goes in. The corresponding bank deposit happens. The balance clears.
When I open a balance sheet and see a large Undeposited Funds balance that has been sitting there for months or years, things get interesting.
Maybe deposits were entered incorrectly. Maybe income was duplicated. Maybe payments were never matched properly.
Whatever happened, money should not be setting up permanent residence there.
The bank account hasn’t been reconciled since last winter
This one is sneaky because everything can still look completely normal.
Transactions continue downloading.
The bank balance looks approximately right.
You categorize things.
QuickBooks happily continues existing.
But without reconciliation, there is no confirmation that the transactions in QuickBooks actually match the bank statement.
Missing transactions, duplicates, old checks, incorrect transfers, and other errors can sit unnoticed for months.
The loan balance never changes
Your business has been making loan payments all year.
Your balance sheet shows exactly the same loan balance it showed in January.
That is a problem.
Loan payments often include both principal and interest. The principal portion reduces the loan balance while the interest is generally recorded as an expense.
When the entire payment gets categorized as an expense every month, the loan balance just sits there pretending nothing happened.
Very calm. Very wrong.
Payroll liabilities nobody can explain
Payroll liability accounts can contain legitimate balances.
But when old balances sit there month after month and nobody knows what they represent, I start digging.
Payroll involves wages, withholding, employer taxes, employee taxes, benefits, and payments to taxing agencies.
A lingering balance might mean something hasn’t been paid, something was recorded incorrectly, or payroll activity isn’t posting properly to the books.
This is not an account I like to shrug at.
Sales tax is hanging out in income
Sales tax collected from customers generally isn’t your revenue.
You are collecting that money to send to the appropriate taxing authority.
When sales tax gets recorded as income, your revenue can be overstated and the liability you actually owe may be missing.
That creates a fun little two-for-one bookkeeping problem.
Accounts that should be zero have money in them
Clearing accounts.
Suspense accounts.
Ask My Accountant.
Old payroll clearing accounts.
Random accounts created during a prior cleanup that nobody remembers.
These accounts can have legitimate temporary balances.
The key word is temporary.
When a temporary account contains thousands of dollars that have been sitting there since 2024, I want answers.
The scariest part is how normal all of this looks
That is really the point.
Bad books do not always look obviously bad.
QuickBooks can still open.
Invoices can still go out.
Customers can still pay you.
Your bank account can still contain money.
And your financial reports can still be wrong.
That is why reconciliations matter. It is why the balance sheet matters. It is why occasionally reviewing the books instead of only categorizing transactions matters.
So this Halloween, I’m not particularly afraid of ghosts.
Give me an unreconciled bank account, a six-figure Undeposited Funds balance, and a mysterious payroll liability nobody can explain.
Now you’ve got my attention.
