Cash flow forecasting is one of the most critical skills for small business owners. In fact, a U.S. Bank study found that 82% of business failures are due to poor cash flow management. If you can't predict when money will arrive and when bills are due, you're flying blind—even if your business is profitable on paper.
In this guide, you'll learn how to build a simple cash flow forecast, avoid common mistakes, and use forecasting to make smarter decisions for your business.
Cash flow forecasting is the process of estimating how much money will flow in and out of your business over a specific period—usually weekly or monthly. It's not about profit. It's about liquidity: having enough cash available to pay bills, payroll, and unexpected expenses when they come due.
Think of it like checking your bank account before a big purchase. You might have a high income on paper, but if clients haven't paid yet, you could still come up short when rent is due.
Small businesses are especially vulnerable to cash flow gaps because they often have limited reserves. A QuickBooks Late Payments Report (2025) found that the average U.S. small business carries $17,500 in unpaid invoices at any given time. That's money you've earned but can't use—until it lands in your account.
Forecasting helps you:
You don't need fancy software. A spreadsheet works fine. Here's the basic structure:
Start with all sources of incoming cash:
Be realistic about payment timing. If your average client pays in 30 days, don't count that cash in week one. The QuickBooks report notes that 59% of SMBs have invoices 30+ days overdue—which means you should build in buffer time.
Include every outflow:
Don't forget occasional expenses like annual software renewals or equipment maintenance.
For each week or month:
Net Cash Flow = Total Inflows – Total Outflows
Then add it to your opening balance:
Closing Balance = Opening Balance + Net Cash Flow
Your closing balance becomes next period's opening balance. This shows you exactly when you might dip below zero.
Imagine a small consulting firm with $10,000 in the bank on October 1. Here's a simplified monthly forecast:
| October | November | December | |
|---|---|---|---|
| Opening Balance | $10,000 | $9,500 | $14,000 |
| Cash Inflows | $8,000 | $12,000 | $15,000 |
| Cash Outflows | $8,500 | $7,500 | $9,000 |
| Net Cash Flow | –$500 | +$4,500 | +$6,000 |
| Closing Balance | $9,500 | $14,000 | $20,000 |
October is tight—there's a small shortfall. But because you forecasted it, you can delay a non-urgent expense or follow up on unpaid invoices before the gap hits.
You can absolutely use a spreadsheet. But if you want to save time, consider using accounting or business management software. Tools like Altera let you track invoices, expenses, and cash position in one place—so your forecast is based on real, up-to-date numbers instead of guesses.
With accurate data from your invoicing and expense tracking, you can quickly see which clients are slow to pay, where your money is going, and how much you'll have available next month.
Most small businesses forecast 4–12 weeks ahead. For businesses with stable, predictable income, monthly forecasts may be enough. If your cash flow is volatile, weekly is better.
That's exactly why you forecast—you see the problem before it happens. Options include accelerating collections (see how to chase late payments), delaying non-essential expenses, drawing on a line of credit, or asking clients for deposits.
Be conservative. Only include booked revenue or highly likely deals. If you include speculative sales and they fall through, your forecast will be dangerously wrong.
At minimum, monthly. Many businesses benefit from a weekly review—especially if they're in a tight cash position or expect big swings.
Start building your cash flow forecast today—it's one of the simplest ways to protect your business from surprises. Try Altera free to track invoices, expenses, and your real-time cash position in one dashboard.