Why the model says $85K and the bank says empty

How to find the gap between a cash forecast and your real bank balance — the cash tied up in work in progress, the scattered supplier terms, and the untracked partial payments that drain it — and line up affordable credit before a tight week forces your hand.

After this you can take a forecast that promises money and a bank balance that shows none, and account for every dollar of the difference. You will know the three places the cash usually hides, how to track the obligations that close the gap for good, and how to line up affordable credit before a tight week forces your hand.

The model says $85,000. The account says $9,000.

You built the cash forecast the last lesson asked for. It carried a running balance forward week by week, and at the end of the quarter it lands on $85,000 in the account. Then you open the bank and the real number is $9,000. Nothing was stolen and the arithmetic in the model is fine. The gap is real cash the model never saw.

That gap is the most disorienting thing in a growing operation: the plan says you have room, and the account says you are nearly out. It is not one big mistake. It is a pile of ordinary things the forecast left out or got slightly wrong — each small enough to miss, and large enough together to erase $76,000 of headroom. The fix is not a cleverer spreadsheet formula. It is finding out exactly which real obligations went untracked, and then tracking them.

Where the $76,000 went: three culprits

Almost every model-versus-bank gap decomposes into the same three culprits. Run the barbecue sauce maker from the true-COGS lessons through a quarter and the missing $76,000 splits cleanly among them.

Cash buried in work in progress — $34,000

The day a batch starts, the cash for its ingredients, jars, and the hours to run it is already leaving the account — often before any supplier invoice the model is watching comes due. The pallet of tomato paste you bought ahead to lock in the price is cash gone now, for stock that will sell over the next two months. That money is tied up in and in raw stock on the shelf. A forecast keyed to invoice due dates and sale dates never sees it go. Three batches in flight and one bulk buy put $34,000 out of the account that the model still counts as available.

Scattered supplier terms — $27,000

You do not owe a round number to "suppliers" once a month. You owe a dozen different suppliers on a dozen different terms — some Net 30, some Net 15, one on a deposit-and-balance schedule for a custom label run — each with its own due date. A forecast that lumps them into one tidy monthly line undercounts the real total and misses the deposit tranche entirely. Set against every actual invoice on its actual due date, $27,000 more left the account this quarter than the model planned for.

Untracked partial payments — $15,000

The model counted your wholesale receivables as collected in full, on the day the terms said. Reality ran short and late. One $18,000 invoice came back as a $15,000 payment after the grocer deducted for a short shipment; a separate $12,000 invoice landed after quarter-end. So the model booked $15,000 of cash that, this quarter, never arrived — $3,000 lost to the deduction and $12,000 that simply had not shown up yet.

Add them up: $34,000 plus $27,000 plus $15,000 is $76,000. Put the $9,000 still in the account on top and you are back to the $85,000 the model promised. None of it is exotic. All of it is trackable.

Track every obligation, especially the partials

The cure for the gap is boring, and it works: one running list of every payment obligation the operation carries, each on its real due date — every open supplier invoice, every deposit and tranche, payroll, rent, loans, taxes — reconciled against the actual bank balance on a set day each week. Most of the $76,000 above never went into the model because it never went onto a list.

One kind of entry does more damage than the rest. A is wrong in two directions at once. When the $18,000 invoice pays $15,000, a model that still shows $18,000 collected overstates cash by $3,000 and quietly tells you the account is healthier than it is. Leave it untracked and the next partial stacks on the last, and the model drifts a little further from the bank every month — until the quarter-end surprise.

So log the partial the moment it lands: enter the $15,000 that came in, keep the $3,000 open until you collect it or write it off, and move the late invoice to the date you now expect it. Treat a tranche the same way — a deposit paid and a balance still scheduled is two entries, not one. The list is only as honest as the day you last reconciled it against the bank.

Line up affordable credit before you need it

Even a well-tracked operation hits a genuinely tight week — a big order's cash lands three weeks after the payroll it was supposed to cover. What you reach for in that moment decides what the crunch costs you.

The fastest cash is the most expensive. A can fund in a day, which is exactly why an operation in a crunch grabs one. It is not legally a loan — the funder buys a chunk of your future receivables — so it sits outside most lending rules and shows no interest rate on the paper. Instead it carries a . The Federal Trade Commission, which has brought cases against MCA funders for abusive collection practices, describes that factor as commonly 20% to 50% of the amount advanced.

Run the numbers. Advance $40,000 at a factor rate of 1.4 and you repay $56,000 — $16,000 to rent that cash, pulled straight out of your daily deposits over the next few months. Charge 40% of the principal across a few months and the annualized cost runs far above anything a bank would quote.

Now the same $40,000 arranged in advance. A bank term loan, a line of credit, or an SBA 7(a) loan is priced off a base rate — the prime rate, say — plus a spread the SBA caps by loan size. The all-in rate lands in the single digits to low teens, and a full year of interest on that $40,000 is a few thousand dollars, not sixteen. Same cash, several times the bill — and the only thing that changed is whether you arranged the credit before the crunch or grabbed the fastest option during it. Rates move, so confirm the current prime rate and the SBA's published spread with your bank before you count on a number.

The forecast is what buys you the cheap money

A line of credit takes weeks to arrange and an advance takes a day, so the operation that only learns it is short when the account runs dry has already lost the choice. The 90-day forecast from the last lesson is what surfaces the tight week while there are still weeks left — enough runway to draw on credit you set up calmly, months earlier, at a rate you agreed to before you were desperate for the cash.

Get this discipline right and the cash picture stops being a source of dread. You can say yes to a big new retail account knowing exactly which weeks it will stretch you and how you will cover them — which is precisely what the buyers on the other side of that account are about to ask you to prove.

Do this in your operation

Take last month's cash forecast and set it against your real bank balance on the same day. Write down the gap, then account for every dollar of it — which obligations, which partials, and which committed cash the model missed.
Start one running list of every payment obligation the operation carries — each open supplier invoice, every deposit and tranche, plus payroll, rent, loan, and tax dates — each on its real due date.
Log every partial the moment it lands: enter what actually came in, keep the shortfall open until you collect or write it off, and move any late invoice to the date you now expect it. Reconcile the list against the bank on a set day each week.
Before you need it, ask your bank what a line of credit or term loan would cost you, and compare it to what an emergency advance would cost. Line up the affordable option now, so a tight week never forces the expensive one.

Mark this lesson complete