Ask a small business owner why they went under, and "we ran out of cash" comes up far more often than "we weren't profitable." Those are two different problems, and a cash flow forecast is the tool that catches the first one before it becomes a crisis. It doesn't require a finance background or complicated software — just a simple spreadsheet and the discipline to update it regularly.
What a cash flow forecast actually is
A cash flow forecast is a projection of the money moving in and out of your business over a future period — typically the next 13 weeks or the next 12 months. Unlike your income statement, which shows profit on an accrual basis, a cash flow forecast tracks only actual cash: when money really lands in the bank and when it really leaves. That distinction is exactly why a profitable business can still run dry — profit and cash timing are not the same thing.
The three sections every forecast needs
| Section | What goes in it |
|---|---|
| Starting cash balance | What's actually in the bank on day one of the forecast period |
| Cash inflows | Customer payments received, loan proceeds, owner contributions — money that actually arrives |
| Cash outflows | Payroll, rent, supplier payments, loan payments, taxes — money that actually leaves |
Ending cash balance for each period becomes the starting balance for the next, rolling forward week by week or month by month.
A simple five-step method
- Pick your time horizon and interval. Tight cash situations call for a 13-week forecast broken out weekly; a stable business can often work monthly over 12 months.
- Start with actual cash on hand from your bank balance today — not a projected or rounded number.
- Project inflows based on timing, not invoicing. If you invoice on 30-day terms and customers typically pay in 45, model the 45 — not the optimistic 30.
- Project outflows by category, separating fixed costs (rent, loan payments, subscriptions) from variable ones (payroll that scales with hours, inventory purchases) since they behave differently month to month.
- Roll the balance forward and flag any period where it dips below your comfort threshold — that's the early warning the whole exercise exists to produce.
Start rough, then refine. A forecast built from reasonable estimates and updated weekly beats a perfectly precise one built once and never touched. The value is in catching a shortfall four to six weeks out, not in the decimal-point accuracy of any single number.
Where most first-time forecasts go wrong
- Using invoice date instead of expected payment date. This is the single biggest source of an overly optimistic forecast — model when customers actually pay, based on their real history, not your payment terms.
- Forgetting irregular, large outflows. Quarterly estimated tax payments, annual insurance renewals, and loan balloon payments are easy to miss because they don't happen every month, but they can wipe out a healthy-looking balance overnight.
- Not updating it. A forecast built once in January and never revisited is a snapshot, not a forecast. It needs fresh actuals plugged in on a regular schedule to stay useful.
A simplified example
| Week | Starting cash | Inflows | Outflows | Ending cash |
|---|---|---|---|---|
| 1 | $18,000 | $12,000 | $9,500 | $20,500 |
| 2 | $20,500 | $6,000 | $14,000 | $12,500 |
| 3 | $12,500 | $4,000 | $15,500 | $1,000 |
| 4 | $1,000 | $22,000 | $9,000 | $14,000 |
Week 3 is the number that matters here — it's the early warning that lets you delay a discretionary purchase, follow up on a slow-paying invoice, or arrange short-term financing weeks before it becomes an actual problem, rather than discovering it the day a payment bounces.
How this connects to the rest of your books
A cash flow forecast is only as good as the data feeding it, which means it depends on current, accurate bookkeeping — not books that are two months behind. It also pairs naturally with understanding your balance sheet, since outstanding receivables and payables are exactly what a forecast is trying to predict the timing of.
A cash flow forecast is one of the highest-leverage habits a small business owner can build — it turns "I hope we're okay" into an actual answer, weeks before the number would otherwise surprise you. Get in touch if you'd like help setting one up for your business.
Frequently Asked Questions
How is a cash flow forecast different from a budget?
A budget is a plan for what you intend to spend and earn. A cash flow forecast tracks the actual timing of money moving in and out of the bank, which can differ significantly from a budget if customers pay late or expenses shift timing.
How often should I update my cash flow forecast?
Weekly if cash is tight or the business is young; at least monthly otherwise. The forecast loses its value quickly if it isn't refreshed with actual results and updated projections on a regular schedule.
What's the biggest mistake businesses make when forecasting cash flow?
Assuming customers pay exactly on the invoice terms rather than modeling how they actually pay historically. This single assumption is responsible for most overly optimistic forecasts that miss a real shortfall.
This article is general information, not personalised tax, legal or accounting advice. Rules and thresholds change — confirm current-year figures with the IRS or a qualified professional before acting. Ask Accounts Buddy if you'd like help applying any of this to your business.