A cash flow forecast is a forward-looking estimate of cash receipts, cash payments, net cash movement, and the expected closing cash balance over a set period. It answers a simpler question than your income statement: will there be enough money in the bank when the bills come due?
Below are illustrative examples for a small service business, a manufacturer, and a seasonal hospitality business. All figures are hypothetical and meant to show structure, not benchmarks.
Key Takeaways
- Track cash when it's actually received or paid, not when revenue or expenses are recorded
- The core formula: opening balance + inflows − outflows = projected closing balance
- Short-term, 13-week, and long-term forecasts each serve a different planning purpose
- Compare forecasted figures to actual results regularly and adjust assumptions as conditions change
- A positive forecast doesn't guarantee safety; the lowest projected balance matters most
Why Cash Flow Forecasting Matters for Business Owners
Forecasting gives owners a warning system. Instead of discovering a shortfall when a check bounces, a forecast flags the problem weeks in advance, giving time to act.
With enough lead time, owners can:
- Follow up on slow-paying clients before the gap becomes urgent
- Delay nonessential purchases until cash catches up
- Arrange a line of credit on their own timeline, not under pressure
- Decide whether hiring, new equipment, or inventory buildup fits the current cash position
Profit Isn't the Same as Cash
A profitable month on the income statement doesn't mean cash is sitting in the bank. Unpaid invoices, inventory purchases, loan principal payments, and tax timing all affect available cash differently than they affect reported net income. Depreciation reduces profit but never touches a bank account; loan principal does the opposite.
This is where many owners get caught off guard. A business can report a healthy margin and still have most of that money tied up in receivables or inventory.
ZenStrategies builds 13-week cash flow forecasts for established business owners specifically to separate reported profit from actual cash availability. Reliable financial reporting paired with regular forecasting gives owners clearer answers before a tax deadline or payroll run, not after the money is already short.
What a Cash Flow Forecast Includes
Every forecast starts with the same backbone: a verified opening balance, expected inflows, expected outflows, and a resulting closing balance.
| Component | What It Covers |
|---|---|
| Opening cash balance | Verified bank and cash balances at the start of the period |
| Cash inflows | Collected customer payments, cash sales, deposits, loans, owner contributions, grants, tax refunds |
| Cash outflows | Payroll, payroll taxes, rent, utilities, supplier payments, inventory, equipment, debt payments, insurance, marketing, taxes |
| Net cash movement | Total inflows minus total outflows |
| Closing cash balance | Opening balance plus net cash movement |
A few details matter more than they seem:
- Invoices belong in the period you expect payment, not the period you issued them
- Each line item should carry a payment date or forecast period, not just a total
- Assumptions should be written down: expected collection timing, seasonal swings, supplier terms, planned hires, tax due dates, and one-time purchases
Without documented assumptions, a forecast is just a guess that's hard to correct later.
Cash Flow Forecast Examples
These examples use labeled, hypothetical figures to show structure. Replace the numbers with your own data.
Simple Monthly Example: Small Service Business
| Line Item | Amount |
|---|---|
| Opening cash balance | $18,000 |
| Client collections | $42,000 |
| Other receipts | $1,200 |
| Total cash inflows | $43,200 |
| Payroll | $22,000 |
| Operating expenses (rent, utilities, insurance) | $9,500 |
| Tax payments | $4,000 |
| Debt payment | $3,000 |
| Total cash outflows | $38,500 |
| Net cash movement | $4,700 |
| Closing cash balance | $22,700 |
Forecast-vs-Actual Comparison
Say two clients pay 20 days later than expected, and a software subscription increases mid-month.
| Line Item | Forecast | Actual | Variance |
|---|---|---|---|
| Client collections | $42,000 | $31,500 | -$10,500 |
| Operating expenses | $9,500 | $11,200 | -$1,700 |
| Closing cash balance | $22,700 | $10,200 | -$12,500 |
A $12,500 miss like this calls for action: following up on the slow-paying clients directly, pausing a discretionary expense, or drawing briefly on a credit line until collections catch up.
Manufacturing Example
Manufacturers face a specific squeeze: materials and labor get paid before customer invoices get collected, even on strong orders. CLA's 2026 guidance points to exactly this pattern as a reason manufacturers need rolling, weekly visibility rather than a monthly snapshot.
| Line Item | Amount |
|---|---|
| Opening cash balance | $65,000 |
| Customer collections | $180,000 |
| Material purchases | -$95,000 |
| Production payroll | -$58,000 |
| Equipment spending | -$15,000 |
| Debt service | -$10,000 |
| Net cash movement | $2,000 |
| Closing cash balance | $67,000 |
The order book looks great. The cash position barely moved, because materials went out the door weeks before customer checks arrived.
Seasonal Hospitality Example
A seasonal restaurant or brewery lives through feast and famine months on the same forecast.
| Line Item | Peak Month | Slow Month |
|---|---|---|
| Opening cash balance | $20,000 | $38,000 |
| Sales collections | $110,000 | $42,000 |
| Inventory & COGS | -$38,000 | -$16,000 |
| Labor costs | -$42,000 | -$24,000 |
| Repairs & maintenance | -$4,000 | -$3,000 |
| Closing cash balance | $46,000 | $37,000 |
A rolling forecast lets a brewery or restaurant owner see the slow month coming months ahead, and staff, order inventory, and schedule repairs accordingly instead of reacting in the moment.
13-Week Structure
A 13-week forecast uses weekly columns instead of monthly ones:
| Week 1 | Week 2 | Week 3 | ... | Week 13 | |
|---|---|---|---|---|---|
| Opening cash | $X | $X | $X | ... | $X |
| Receipts | $X | $X | $X | ... | $X |
| Payments | $X | $X | $X | ... | $X |
| Net movement | $X | $X | $X | ... | $X |
| Closing cash | $X | $X | $X | ... | $X |
Weekly detail matters because payroll, supplier terms, and loan payments often fall on specific dates, not evenly across a month. A monthly average can hide a Tuesday where three obligations land at once.
Interpretation Checklist
Once a forecast is built, interpretation matters more than the spreadsheet itself:
- Find the lowest projected balance across the period, not just the ending figure
- Confirm essential obligations can still be paid at that low point, like payroll and rent
- Investigate any large variance between forecast and actual results before it repeats
- Decide on action now if a shortage is coming, while there's still time to respond
Types and Methods of Cash Flow Forecasting
Different time horizons answer different questions.
| Type | Horizon | Best For |
|---|---|---|
| Short-term | Daily or weekly | Immediate liquidity, payroll, supplier payments |
| 13-week | Rolling, weekly | Near-term obligations and collections visibility |
| Long-term | Several months to a year+ | Budgeting, capital planning, hiring, debt strategy |
SCORE's 2025 guidance recommends at least a three-month look-ahead, with weekly detail layered in for the next 13 weeks where liquidity is tight. Detail and certainty naturally decline the further out a forecast reaches.
Direct vs. Indirect Forecasting
- Direct forecasting projects actual cash receipts and disbursements line by line, useful for short-term accuracy
- Indirect forecasting starts with projected profit and adjusts for non-cash items (like depreciation) and working-capital changes, more common in longer-range planning
Rolling, Fixed-Term, and Scenario-Based Formats
- Rolling forecasts drop the oldest period and add a new one, keeping the forward window constant
- Fixed-term forecasts cover a set period, like a fiscal year, without extending
- Scenario-based forecasts model best-case, most-likely, and downside assumptions side by side, useful when a business faces real uncertainty in sales or collections
Where the 3-Way Forecast Fits
A 3-way forecast connects a projected income statement, balance sheet, and cash flow statement. It's more comprehensive than a standalone cash schedule because it shows profitability, financial position, and liquidity together, so a profit swing or inventory buildup shows its cash impact automatically.
How to Build, Review, and Use a Cash Flow Forecast
Building a usable forecast starts from a clear sequence rather than a blank spreadsheet.
- Set the purpose and horizon first. Weekly detail serves liquidity questions; monthly detail serves broader planning.
- Gather source data: bank statements, accounting records, open invoices, AR aging, AP schedules, payroll records, loan agreements, and tax calendars.
- Verify the opening balance against actual bank activity before projecting anything forward.
- Schedule outflows by due date, not by month-end averages.
- Use realistic collection assumptions. Not every invoice gets paid on terms; factor in historical delays and known contract milestones.
- Flag any period where cash drops below your required operating cushion.
Reviewing and Responding to Variance
Compare forecast to actual on a consistent schedule, then ask why the gap happened:
- Sales volume, collection timing, or pricing shifts
- Inventory, payroll, or supplier costs running higher than planned
- A one-time tax bill or large purchase
For a projected shortfall: accelerate collections, negotiate payment timing with vendors, cut discretionary spending, or line up financing before it's urgent.
For a projected surplus: confirm upcoming obligations first, then consider debt paydown, reserves, or reinvestment.
Forecasting Tools and Best Practices
| Tool Type | Strength | Watch Out For |
|---|---|---|
| Spreadsheets | Flexible, low cost, good starting point | Manual-entry errors, limited collaboration |
| Accounting software | Connects to real transaction data | May need customization for forecasting detail |
| Dedicated forecasting tools | Scenario modeling, dashboards, automation | Cost and setup time for smaller businesses |
A spreadsheet works fine for a simple, single-location business. As operations grow more complex, connected accounting data, dashboards, and a second set of eyes tend to catch problems a spreadsheet alone misses.
A few habits make any tool more reliable:
- Keep a documented assumptions log, separate from the numbers themselves
- Separate recurring line items from one-time ones
- Build in a best-case and downside scenario, not just one expected number
- Assign one person responsibility for keeping it updated
Update short-term forecasts weekly; review longer-range projections at least monthly, more often during seasonal swings or rapid growth.
At ZenStrategies, Data Intelligence Director Zach George builds dashboards that turn raw accounting data into forecasts owners can read at a glance, rather than leaving them in a spreadsheet only the bookkeeper understands.
Combined with ongoing accounting and fractional CFO support, this gives established Ohio business owners a clearer path from financial data to decisions they can act on.
Frequently Asked Questions
What is in a cash flow forecast?
A cash flow forecast includes an opening balance, expected cash receipts, expected payments, net cash movement, and a projected closing balance, usually paired with the assumptions behind each figure.
What are the different types of cash flow forecasting?
Common types include short-term, 13-week, and long-term forecasts, along with rolling, fixed-term, direct, indirect, and scenario-based approaches. Each serves a different planning horizon or level of detail.
What is a 13-week cash flow forecast?
It's a rolling, weekly projection of cash inflows, outflows, and balances across the next 13 weeks. It's commonly used to plan around payroll, supplier payments, and upcoming debt obligations.
What is a 3-way cash flow forecast?
A 3-way forecast links a projected income statement, balance sheet, and cash flow statement. Together, they show profitability, financial position, and liquidity in one connected model.
What is the best cash flow forecasting tool?
There isn't one universal answer. The right tool depends on business complexity, data volume, forecast frequency, and whether you can reliably maintain accurate inputs.
What is a healthy cash flow for a small business?
There's no single healthy number. It comes down to whether the business can consistently cover essential obligations, hold an appropriate reserve, and manage timing gaps between collections and payments.
