Overdrawn by $700,000. On Paper.

The balance sheet said the business was overdrawn by about $707,000.

Total assets: below zero.

The business was a home care agency. It had clients, caregivers, payroll going out every week. It was not $707,000 in the hole. The bank was fine.

The books were not.

How books get that far from the bank

Nobody had ever connected the bank to QuickBooks. For years, everything was typed in by hand, and nothing was ever checked against a statement.

That’s all it takes. Without a reconciliation, a mistake doesn’t get caught. It just sits there, and the next one lands on top of it.

Here is some of what had piled up.

• Checks entered more than once. One shows up in the file four separate times.
• Fifteen checks that cleared the bank and never made it into the books at all. About $18,500.
• A savings account the books said had 164 transactions in eight months. The bank said 38. Sixty-nine of the extras were checks already recorded in checking, about $94,000 of expenses counted twice.
• Invoice numbers reused across unrelated clients, so payments landed on the wrong people.
• About $73,000 sitting in Undeposited Funds.

The waiting room

That last one deserves a minute.

When a customer pays you, QuickBooks puts the payment in a holding account called Undeposited Funds. When you record the bank deposit it went into, the payment moves out. Payment in, deposit out, and the account empties.

Think of it as a waiting room. People come in, their name gets called, they leave.

In this file, people came in and nobody called their names. Some deposits were recorded straight to income, or straight to what customers owed, while the matching payments stayed in the waiting room. The same dollar got counted on the way in and never cleared on the way out.

The books said the money was on its way to the bank. Nobody had ever checked whether it arrived.

How you untangle it

There’s no button for this. There’s a rule, and then there’s the work.

The rule: the bank statements are the truth. If it isn’t on a statement, it doesn’t stay in the books.

The work: every deposit, check by check. The statement tells you the amount. The deposit slip tells you whose check it was. When the slip doesn’t say, you pull the check image and read it off the paper.

Matching on amounts alone doesn’t work, and home care is the worst place to try it. The same client pays the same amount every week, and so do a dozen others. On the deposits I checked slip by slip, going by amount alone would have gotten eleven of them wrong.

A lot of it meant rebuilding what should have been recorded in the first place, one line at a time. It was slow. It was tedious. Some weeks it felt more like detective work than bookkeeping.

Why it had to be done

The owners needed the business appraised. Nobody can put a value on a company whose books say its checking account is $700,000 overdrawn. The books had to be true before anyone could talk about what the business was worth.

For the year we cleaned, both bank accounts reconcile to the penny at both ends of the year. The credit cards tie to their statements. What customers owe is a real list of real people.

What clean books gave her

• She can see what’s actually in the bank, what she’s owed, and exactly who owes it.
• Her CPA files from the books instead of rebuilding them first.
• Hiring and pay decisions get made on real numbers, not on a feeling about the bank balance.
• GET gets paid on what actually came in.
• When an appraiser, a lender or a partner asks to see the books, she doesn’t have to hold her breath.

Before, she was running the business in the dark. Now she opens a report and believes it.

She was so happy to close that chapter that she’s flying me over to celebrate. In this line of work, that’s about as good as it gets.