Introduction
A business can post a profitable month and still miss payroll. That contradiction trips up more owners than most financial statements ever reveal. Profit and cash are not the same thing, and the gap between them is where cash flow forecasting earns its keep.
A cash flow forecast is a forward-looking estimate of cash receipts, cash payments, net cash movement, and the resulting ending balance. It tells you what your bank account will look like in two weeks, two months, or next year, not just what your income statement says you earned.
This article walks through several forecasting examples: a monthly operating model, a 13-week liquidity forecast, a 12-month projection, and industry-specific variations. Treat every number here as illustrative. Your actual forecast should reflect your real payment terms, seasonality, and accounting records.
Key Takeaways
- Cash flow forecasts track cash timing, not reported revenue or profit
- Start with an accurate opening balance, then separate inflows, outflows, and closing balance
- Short-term, 13-week, and 12-month forecasts answer different questions—don't treat them as interchangeable
- Comparing forecast to actual results sharpens future assumptions
- Messy books or complex cash timing often call for outside help
What a Cash Flow Forecast Shows
A cash flow forecast follows one formula:
Opening cash balance + total cash inflows − total cash outflows = closing cash balance
Net cash flow (inflows minus outflows) and closing cash balance are related but different figures. Net cash flow shows the direction of movement for a period; the closing balance shows where you actually stand.
Typical Cash Inflows
- Customer collections (paid according to actual expected receipt date, not invoice date)
- Point-of-sale receipts for cash and card sales
- Financing proceeds, loans, and owner contributions
- Grants, tax refunds, and investment proceeds
Typical Cash Outflows
- Payroll and payroll taxes
- Supplier and inventory payments
- Rent, utilities, and insurance
- Estimated tax payments and debt service
- Subscriptions, equipment purchases, and owner distributions
Why accrual profit and cash rarely match: accounts receivable, accounts payable, inventory, and deferred revenue create timing gaps.
- Receivables up: sales already counted as profit, cash not collected yet
- Payables up: expenses already reduced profit, cash still in the bank
- Inventory purchases: cash leaves before the cost hits the income statement
- Deferred revenue: cash arrives before revenue is recognized
Wolters Kluwer explains this cash-versus-profit distinction in detail.
A basic forecast uses a column per week or month and rows for:
- Opening balance
- Inflows by category and total inflows
- Outflows by category and total outflows
- Net cash movement and closing balance
How to Build a Cash Flow Forecast
Start with purpose. Your goal sets the time horizon and level of detail—near-term liquidity, payroll and supplier timing, financing readiness, or a planned investment.
Choose Your Period and Granularity
- Weekly or daily when payroll, rent, or supplier payments are due soon
- Monthly for annual budgeting, seasonal trends, or capital purchases
Gather Reliable Source Data
Before you build the model, pull together:
- Current bank balances and recent bank statements
- Open invoices and customer payment history
- Sales pipeline and purchase commitments
- Payroll schedules and tax due dates
- Debt agreements, recurring bills, and planned capital expenditures
Project Inflows and Outflows Separately
Project inflows by customer or revenue stream using realistic collection dates, not invoice dates. A sale booked in March might not become cash until May.
Include deposits, milestone billing, recurring subscriptions, and a realistic allowance for late payments.
Project outflows by category and due date. Split costs so you know what you can delay if a shortfall appears:
- Fixed: rent, loan payments, core insurance
- Variable: hourly labor, supplier orders tied to volume
- Discretionary: equipment upgrades, marketing pushes
Roll Forward Balances and Stress-Test
Once inflows and outflows are mapped, calculate net movement for each period. Carry the prior period’s closing balance forward as the next period’s opening balance.
Then build three views—most likely, downside, and upside—to test what happens if collections slip, sales soften, or costs spike.
Close the loop with a simple review cadence:
- Compare forecast to actual by category
- Document why variances occurred
- Assign clear ownership for keeping the model current
Cash Flow Forecasting Examples
Example 1: Basic Monthly Operating Forecast
This model suits a small business tracking overall cash health month to month.
| Line Item | March (Illustrative) |
|---|---|
| Opening balance | $42,000 |
| Customer receipts | $58,000 |
| Other inflows | $2,000 |
| Total inflows | $60,000 |
| Payroll | $28,000 |
| Suppliers | $19,000 |
| Overhead & rent | $9,500 |
| Taxes | $4,000 |
| Debt payment | $3,200 |
| Total outflows | $63,700 |
| Net cash movement | ($3,700) |
| Closing balance | $38,300 |
What this reveals: the business shows a negative monthly movement, but the opening balance comfortably absorbs it. A single negative month isn't a crisis on its own. It's only a warning sign if the trend continues or the buffer keeps shrinking.
Example 2: 13-Week Cash Flow Forecast
A weekly model built for near-term liquidity monitoring, using expected collection and payment dates rather than monthly summaries.
| Week | Opening Balance | Inflows | Outflows | Closing Balance |
|---|---|---|---|---|
| Week 6 | $31,000 | $22,000 | $19,500 | $33,500 |
| Week 7 | $33,500 | $14,000 | $24,000 | $23,500 |
| Week 8 | $23,500 | $12,000 | $27,000 | $8,500 |
| Week 9 | $8,500 | $26,000 | $18,000 | $16,500 |
What this reveals: Week 8 shows a sharp dip. With this level of visibility, management can accelerate collections on open invoices, delay a discretionary purchase, or arrange a short-term line of credit before the low point actually hits. A rolling weekly view flags that dip early enough to act before cash gets tight.
Example 3: 12-Month Cash Flow Projection
A monthly strategic view incorporating seasonality, hiring plans, and larger purchases.
| Month | Net Cash Movement | Key Driver |
|---|---|---|
| January | ($8,000) | Slow season, annual insurance renewal |
| June | $15,000 | Peak sales season begins |
| August | ($22,000) | New hire onboarding + equipment purchase |
| November | $18,000 | Holiday sales surge |
What this reveals: the farther out you project, the less precise the numbers get. Near-term months (January, June) reflect known contracts and confirmed schedules. Later months, like August's equipment purchase, depend on assumptions that could shift. Treat distant months as directional, not exact.
Example 4: Industry-Specific Cash Timing
Horizon is only half the picture. Cash timing also varies by business model:
- SaaS companies invoice annually or quarterly in advance, but recognize revenue ratably. Deferred revenue means cash often arrives before it shows up as recognized revenue.
- E-commerce and consumer packaged goods (CPG) businesses pay for inventory well before it sells, so purchase timing and supplier terms drive short-term cash needs more than sales volume alone.
- Franchise operators need location-level inflows and payroll rolled up into a consolidated view, since timing can vary unit by unit.
- Construction and manufacturing businesses rely on milestone or progress billing, so cash follows project completion percentages rather than a steady monthly rhythm.
Forecast vs. Actual: A Quick Comparison
Using Example 1's monthly model, suppose actual customer receipts came in at $51,000 instead of the forecasted $58,000, while supplier payments matched. The $7,000 shortfall traces back to two customers paying 15 days late. The next forecast cycle should adjust collection assumptions for those accounts and, if the pattern repeats, tighten payment terms going forward.
Choosing the Right Forecasting Method and Time Horizon
Direct vs. Indirect Forecasting
| Method | How It Works | Best For |
|---|---|---|
| Direct | Lists expected cash receipts and disbursements by date | Short-term liquidity, weekly/daily planning |
| Indirect | Starts with projected net income, adjusts for non-cash items and working capital | Longer-term, strategic planning |
Three-way forecasts go a step further: they link the income statement, balance sheet, and cash flow statement so profitability and working-capital changes feed straight into liquidity. That integration matters most when you manage debt covenants or prepare for investor due diligence.
Matching Horizon to Purpose
- Daily, weekly, 13-week models support immediate liquidity, payroll, and supplier planning. AICPA & CIMA recommend a weekly 13-week cycle because it leaves enough runway to react without losing precision.
- 12-month projections support annual budgeting, hiring plans, financing talks, and capital expenditure decisions.
- 12-month rolling forecasts keep a constant forward window by adding a new period as each one closes; a fixed projection simply ends on a set date.
- Three-year projections fit strategic planning, major financing, or expansion—but treat year three as a hypothesis, not a commitment. Assumptions weaken the further out you go.
A layered approach often works best: a detailed near-term direct forecast paired with a broader monthly or annual model, instead of one forecast answering every question.
How to Use and Improve the Forecast
Read the forecast as a decision signal, not a static report:
- Projected surplus: Room to invest or build reserves
- Projected shortfall: Accelerate collections, delay discretionary spending, or line up financing before the gap hits
- Declining trend across periods: Revisit underlying assumptions, even if no crisis is immediate
Common Accuracy Problems
- Overly optimistic sales assumptions
- Confusing invoice dates with actual collection dates
- Ignoring annual tax bills or one-time expenses
- Omitting owner distributions
- Failing to model inventory purchases or debt payments
- Forgetting to update the opening cash balance each cycle
Review cadence should match cash volatility. Seasonal, project-based, or inventory-heavy businesses need more frequent updates, sometimes weekly. Stable operations can often hold to a monthly review.
None of this holds up without clean financial data. Financial cleanup, accurate reporting, and integrated accounting processes improve forecast reliability. A messy general ledger produces a forecast that guesses instead of projects.
Document your assumptions and state uncertainty clearly to owners, lenders, and department leaders. Call out ranges and confidence levels so they can act before the next review cycle.
When Forecasting Moves Beyond Bookkeeping
A simple direct forecast can run off well-kept books. A three-way forecast is different: it needs an accrual-basis balance sheet, a consistent month-end close, and working-capital balances you trust. If you bill subscriptions or long-term contracts in advance, it also needs a deferred revenue schedule that follows ASC 606, so the projected income statement and the cash line tell a consistent story (our SaaS accounting guide explains how that works). Lenders and investors who review your forecast will usually compare it with GAAP financial statements, so gaps between the two raise questions quickly. That is typically the point where controller-level close and CFO-level forecasting start to matter more than transaction entry.
Porter Accounting LLC works with growing U.S. businesses on cash-flow forecasting, financial cleanup, controller-level close, and GAAP reporting so forecasts rest on numbers that hold up. If you need someone to own the model and explain it to lenders or your board, our fractional CFO services start with exactly this kind of forecast.
Frequently Asked Questions
Can you provide an example of a cash flow forecast?
A cash flow forecast shows how cash moves in and out over a set period: opening balance, expected inflows, expected outflows, net movement, and closing balance. See the monthly, 13-week, and 12-month examples above for detailed illustrations.
What is cash flow forecasting in business?
It's estimating when cash will actually be received and paid—not when revenue or expenses hit the books under accrual accounting. That timing gap is often where cash surprises come from.
Why would a business do a cash flow forecast?
Forecasting flags shortfalls before they hit, helps time payments and investments, supports debt management, and prepares you for financing conversations. It also clarifies day-to-day spending and hiring decisions.
What is a 12-month cash flow projection?
A month-by-month estimate of expected cash inflows, outflows, and ending balances over the coming year. It's commonly used for budgeting, hiring plans, and strategic planning.
What is a 12-month rolling forecast?
A forecast that's continuously updated: as one month closes, a new future month gets added at the far end. This keeps a constant 12-month forward view instead of a shrinking one.
What is a 3-way cash flow forecast?
An integrated model linking the projected income statement, balance sheet, and cash flow statement. It shows how profitability and working-capital changes translate directly into liquidity.
