A profitable business can still run out of cash. You can post a strong year on paper and still miss payroll in week three of a slow month. The gap between profit and the balance in your checking account is exactly what cash flow forecasting exists to close. Done well, a forecast tells you weeks ahead of time when money is about to get tight, so you can act before it becomes a crisis instead of after.
Cash flow is also the single biggest reason small businesses fail. A widely cited U.S. Bank study, popularized by SCORE, found that poor cash flow management was a factor in roughly 82% of small business closures. The good news: most forecasting failures come down to a handful of fixable mistakes. Here are the six I see most often, and the simple fix for each.
Mistake 1: Forecasting revenue instead of cash
This is the mistake underneath most of the others. Revenue is recorded when you send the invoice. Cash arrives when the customer actually pays, which can be 30, 45, or 60 days later. A forecast built on invoice dates will show money you do not have yet.
The fix: Forecast collections, not sales. Pull your accounts receivable aging report and project each invoice based on when that customer typically pays, not when the terms say they should. If your terms are Net 30 but your customers average 45 days, model the cash 45 days out. This single change is often the difference between a forecast that protects you and one that lies to you. It is also one of the cash flow mistakes that quietly kill small businesses.
Mistake 2: Running a single best-case scenario
One forecast line, built on everything going right, is a wish, not a plan. Real businesses have months where a big client pays late, a sale slips, or an expense lands early. If your forecast has no room for any of that, it cannot warn you about the months that matter.
The fix: Build three lines: expected, conservative, and downside. The conservative case might assume collections run 15% slower and one major receivable lands two weeks late. If the downside case still keeps you above zero with a cash cushion, you can sleep. If it does not, you have just found a problem early enough to solve it.
Mistake 3: Leaving out the lumpy, irregular outflows
Monthly rent and payroll are easy to remember. The payments that wreck forecasts are the irregular ones: quarterly estimated taxes, annual insurance renewals, payroll tax deposits, equipment purchases, and loan principal that does not show up on the profit and loss statement at all. Miss two or three of these and a forecast that looked comfortable suddenly is not.
The fix: Build a 12-month calendar of every known irregular outflow and drop each one into the week it is actually due. The IRS estimated tax due dates, your insurance renewal month, and your debt amortization schedule are all predictable. Put them on the calendar once and they stop surprising you.
Mistake 4: Building it once and never updating it
A forecast you wrote in January is fiction by March. The single most useful format for a small business is a rolling 13-week cash flow forecast. Thirteen weeks is a full quarter, long enough to see a shortfall coming and short enough that your numbers still mean something. It is also the format banks and lenders recognize.
The fix: Make it rolling. Each week, drop the completed week off the front, add a new thirteenth week on the back, and update every column with what you actually learned. Pick a fixed time, Monday morning is the classic choice, and protect that hour. The SBA treats this kind of regular review as a core part of managing your finances, not an optional extra. If a weekly rhythm is hard to keep alone, this is exactly the kind of work cash flow services are built to handle.
Mistake 5: Assuming customers pay on time
Optimism about collections is the most expensive bias in forecasting. If 20% of your receivables are already 60 days past due, forecasting 100% collection next week is not a forecast, it is hope. Slow-paying customers are a pattern, not an accident, and the pattern is sitting in your AR aging report.
The fix: Use your actual payment history. Apply realistic collection percentages by aging bucket: maybe 95% of current invoices land on schedule, 80% of the 30-day bucket, far less of anything past 90 days. Then tighten the process feeding the forecast: clear terms, invoices sent the day work is done, and a follow-up sequence the moment an invoice goes past due.
Mistake 6: Confusing profit with cash during growth
Growth feels like the opposite of a cash problem, which is exactly why it catches owners off guard. Scaling up means buying inventory, hiring, and fronting labor and materials before the related invoices get paid. You can be more profitable every month and still watch your bank balance shrink, because the cash is going out ahead of coming in.
The fix: Forecast the timing of growth, not just the upside. Before you take on a big new contract or a new hire, model the cash out and the cash in week by week and find the low point. Knowing you will dip to a $4,000 balance in week six lets you arrange a line of credit or stage the spend now, instead of scrambling later. Catching this gap is one reason a structured quarterly financial review pays for itself.
Your cash flow forecasting checklist
Put these six fixes to work in order:
- Forecast collections, not invoices. Project cash by when customers actually pay.
- Build three cases: expected, conservative, and downside.
- Calendar every irregular outflow: taxes, insurance, loan principal, big purchases.
- Use a rolling 13-week format and update it the same hour every week.
- Apply real collection rates by AR aging bucket, not 100% optimism.
- Model the cash timing of any growth before you commit to it.
Do these consistently and your forecast stops being a guess and starts being an early warning system. That is the whole point: see the pressure point three months out, and adjust while you still have options.
Get a cash flow forecast that actually warns you
If building and maintaining a 13-week forecast sounds like one more thing you do not have time for, you do not have to do it alone. Start with a plug-and-play cash flow projection template, or have it built and run for you through fractional CFO services. Either way, book a free 20-minute consultation and we will map out where your cash gets tight and how to stay ahead of it.
About Simply Spreadsheets: Founded by Erin Onsager, a fractional CFO with four years of experience as a chief financial officer, Simply Spreadsheets helps small business owners and real estate investors turn their numbers into clear, confident decisions. From cash flow forecasting and bookkeeping cleanup to custom dashboards and ready-made templates, we make the financial side of your business simple.
Simply Spreadsheets 
Leave a comment