Book cash is negative: finding the missing deposits and doubled expenses

Symptom

The balance sheet shows checking at, say, −4,180 while the bank's own app shows 6,250 available. Reports look absurd, and the reconciliation screen shows a difference that has been growing for months. The bank is not wrong about how much money you have; the ledger is.

Why it happens

Two causes account for nearly all of it:

Duplicated expenses. An expense enters once by hand (or from a bill payment) and again from the bank feed, because the feed match was missed or the feed was reconnected and re-imported history. Every duplicate pushes book cash down twice for one real outflow.
Missed deposits. Sales get invoiced and payments received, but nobody records the deposit to the bank account — or deposits post to Undeposited Funds and stay there (/bookkeeping/cleanups-fixes/undeposited-funds-pileup). Real money arrives; book cash never hears about it.

A third, less common cause: transactions posted to the wrong cash account in the software — one account inflates while its sibling sinks.

The fix

Find the last clean month. Open the reconciliation history and identify the most recent month that reconciled to the statement without a forced adjustment. Start there.
Reconcile forward, month by month, against the actual bank statements. Do not skip to the current month; errors compound.
Flag book transactions with no statement match. These are your duplicates. Confirm each pair (same date, amount, payee), then delete the manual copy and keep the feed copy — the safe order is in /bookkeeping/cleanups-fixes/duplicate-transactions-fix.
Flag statement lines with no book match. These are your missing deposits (and occasionally missing fees). Record each against its real source — an invoice payment, a loan draw, an owner contribution — not to a vague income account.
Recheck the balance. After the final month reconciles, the book balance should equal bank balance minus uncleared items. If a gap remains, look for transactions posted to the wrong cash account.

A missing deposit that turns out to be an owner putting personal money in is recorded like this, not as revenue:

Journal entry — Recording a previously missed owner contribution

Account	Debit	Credit
Checking account	2,000
Owner's contributions (equity)		2,000

Booking owner deposits as sales overstates income and taxes; the same trap applies to loan proceeds — see the loan-misposted-to-income brief.

Deposits that were actually loan proceeds carry tax stakes if misbooked — see /bookkeeping/cleanups-fixes/loan-misposted-to-income.

How to prevent it

Reconcile monthly, within a week of the statement. Negative cash cannot survive a current reconciliation habit; the error is caught the month it happens.
One path per transaction. Decide whether expenses enter by feed or by hand, and make the other path a matching step, never a second entry.
Never reconnect a bank feed without checking its import start date. Re-imports of old history are the single biggest duplicate factory.
Watch the dashboard weekly. A book cash figure that disagrees with the bank app by more than uncleared checks is your earliest warning — investigate the week it appears, not at year-end. If the whole file has drifted this way for months, you are past a spot fix and into /bookkeeping/cleanups-fixes/books-cleanup-playbook territory.

Frequently asked questions

Why does my bookkeeping software show a negative cash balance when the bank shows money?

Because the books and the bank have diverged: expenses were recorded twice (once from the bank feed, once manually), deposits were never recorded, or transactions were posted to the wrong bank account in the software. The bank knows your real balance; the negative book number measures how far the ledger has drifted from it.

How do I fix a negative cash balance in my books?

Reconcile the account against actual bank statements, starting from the last month that reconciled cleanly. The reconciliation mechanically surfaces the causes: duplicated expenses appear as book transactions with no statement match, and missing deposits appear as statement lines with no book match. Delete the duplicates, record the deposits, and the balance corrects itself.

Can a business bank account really go negative in the books legitimately?

Briefly, yes — outstanding checks can exceed the bank balance on a given day, and a real overdraft is possible. But a book balance that sits negative for weeks, while the bank shows funds, is a recording error. Legitimate timing differences resolve within days; drift does not.