Quick Summary
How to forecast cash flow for a small business in 6 steps, with a 12-month rolling template, runway calculation, and worked example for a 3-person services firm.
Quick answer. To forecast cash flow for a small business: (1) start with current cash balance, (2) project monthly inflows from invoices and recurring revenue, (3) project monthly outflows by category, (4) compute net cash flow per month, (5) calculate cumulative cash and runway, (6) update weekly with actuals. Our Cash Flow Forecast template automates the math; this post walks through the six steps.
Cash flow forecasting matters most for service businesses with 1 to 10 people, where one delayed payment or one unexpected expense can move the company from comfortable to anxious in a month. This post covers the six steps any small business can execute in a Google Sheet.
The thing that separates businesses that get through their first real cash crunch successfully from those that don’t is rarely cleverness or luck, and almost always whether someone had been running a cash flow forecast long enough in advance that the crunch appeared as a slow-moving problem in August rather than a sudden emergency in October. The forecast doesn’t prevent the crunch, but it converts surprise into lead time, which is the thing that lets you actually do something about it.
Why forecast at all
Three reasons.
Cash runway visibility. How many months of operating expenses can you cover at the current burn rate? Without a forecast, this is a vibe; with one, it’s a number.
Decision support. Should you hire? Take the lower-margin client to fill capacity? Buy the equipment now or finance? All three depend on cash flow projections, not on profit.
Banker, investor, or accountant communication. When someone external asks “what does your cash position look like over the next 12 months,” you want a chart, not a guess.
The 6-step process below produces both.
Step 1: start with current cash balance
The opening balance for the forecast. Pull the current cash position from your business bank account(s).
| Cash account | Balance |
|---|---|
| Operating account | 28,400 |
| Tax reserve account | 12,000 |
| Total cash | 40,400 |
Most forecasts use total cash; some segregate (the tax reserve isn’t really available for operations). Either approach works as long as you’re consistent.
Step 2: project monthly inflows
By revenue source. The structure depends on your business model.
For project services (consultancy, agency, freelance):
| Inflow source | Jun | Jul | Aug | Sep | Oct | Nov |
|---|---|---|---|---|---|---|
| Retainer client A | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 |
| Retainer client B | 4,500 | 4,500 | 4,500 | 4,500 | 4,500 | 4,500 |
| Project work (signed) | 12,000 | 8,000 | 5,000 | 0 | 0 | 0 |
| Pipeline (60 percent) | 0 | 4,000 | 8,000 | 12,000 | 9,000 | 6,000 |
| Total inflow | 22,500 | 22,500 | 23,500 | 22,500 | 19,500 | 16,500 |
The Pipeline row uses a probability multiplier (here, 60 percent of pipeline value). Adjust by your historical close rate.
For product businesses:
Recurring revenue (subscriptions), one-time sales, and any seasonal patterns. Use historical averages plus growth assumption.
For agencies billing on milestones:
Specific milestone-based payment expectations from each project. More variable but more accurate.
Step 3: project monthly outflows
By category. The structure mirrors your P&L expense lines.
| Outflow category | Jun | Jul | Aug | Sep | Oct | Nov |
|---|---|---|---|---|---|---|
| Payroll (employees) | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 |
| Contractor costs | 3,500 | 3,000 | 2,500 | 4,000 | 4,500 | 3,000 |
| Software subscriptions | 850 | 850 | 850 | 850 | 850 | 850 |
| Office rent | 1,800 | 1,800 | 1,800 | 1,800 | 1,800 | 1,800 |
| Insurance | 350 | 350 | 350 | 350 | 350 | 350 |
| Professional services | 800 | 0 | 800 | 0 | 800 | 0 |
| Marketing | 1,200 | 1,200 | 1,500 | 1,500 | 1,500 | 1,500 |
| Owner draw / salary | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 |
| Tax (quarterly Q3 estimate) | 0 | 0 | 0 | 4,500 | 0 | 0 |
| Total outflow | 26,500 | 25,200 | 25,800 | 31,000 | 27,800 | 25,500 |
Don’t forget:
- Quarterly tax payments (April, June, September, January for federal estimates)
- Annual insurance renewals
- One-time expenses (equipment, conference, hire)
- Loan principal payments
Step 4: compute net cash flow per month
Net cash flow = Total inflow - Total outflow| Month | Inflow | Outflow | Net |
|---|---|---|---|
| Jun | 22,500 | 26,500 | -4,000 |
| Jul | 22,500 | 25,200 | -2,700 |
| Aug | 23,500 | 25,800 | -2,300 |
| Sep | 22,500 | 31,000 | -8,500 |
| Oct | 19,500 | 27,800 | -8,300 |
| Nov | 16,500 | 25,500 | -9,000 |
Six straight months of negative net cash flow. Action required: pipeline acceleration, expense cuts, or both. Better to know now than discover in November.
Step 5: cumulative cash and runway
Cumulative cash = current balance + sum of all net cash flows so far.
| Month | Net | Cumulative cash |
|---|---|---|
| Start | 40,400 | |
| Jun | -4,000 | 36,400 |
| Jul | -2,700 | 33,700 |
| Aug | -2,300 | 31,400 |
| Sep | -8,500 | 22,900 |
| Oct | -8,300 | 14,600 |
| Nov | -9,000 | 5,600 |
| Dec | -3,000 | 2,600 |
| Jan | -1,000 | 1,600 |
Runway is the number of months until cumulative cash hits zero (or your minimum operating buffer).
In this case, runway is approximately 8 months at the current pattern. If your minimum operating buffer is 1 month of expenses (about $26,000), you’re already past the comfort threshold by August.
This is the number that drives action. The forecast turned an abstract worry into a specific deadline.
Step 6: update weekly with actuals
A forecast is a hypothesis. Actuals are the test.
Each Friday (or your chosen day):
- Open the forecast.
- Add a new “Actual” row alongside the planned row for the current month.
- Fill in actuals for the week (inflows received, outflows paid).
- Compare to plan.
- Adjust the rest of the month if there’s meaningful variance.
- At month-end, lock that month’s actuals and forecast the next month if it isn’t already in the model.
Total time: 30 minutes a week. Less if you have accounting software that exports cleanly.
The weekly update is what makes the forecast useful. A forecast updated quarterly is mostly fiction by mid-quarter.
A worked example: 3-person services firm
Maya runs a 3-person UX consultancy. Two employees (Maya as CEO, designer, developer) plus one part-time contractor. Late spring 2026.
Current state (May 31):
- Cash: $48,000 in operating, $14,000 in tax reserve
- Monthly recurring revenue: $14,500 (two retainer clients)
- Active projects: $42,000 in signed but unbilled work
- Pipeline: $85,000 weighted at 50 percent close rate
- Monthly burn: ~$24,000
12-month forecast highlights:
- Months 1 to 3: tight but positive. Monthly net around -$1,500 (drawing from cash buffer).
- Months 4 to 6: critical. September quarterly tax payment, two project completions reducing inflow. Net around -$8,000/month. Cash drops from $58K to $34K.
- Months 7 to 12: depends on pipeline. If 50 percent of pipeline closes as forecast, recovery to neutral. If close rate drops, runway crisis by January.
Decisions the forecast informs:
- Add a junior designer (would help capacity for pipeline work) only after Q3 close rate is confirmed at 50 percent or above.
- Push for advance payment on one of the September project closes (would avoid the late-summer cash dip).
- Defer the annual conference travel ($4,500) from August to October if cash is tight.
- Open a small business line of credit as insurance, not because they need it now.
That’s planning, not panicking. The forecast made it possible.
The 13-week variant
Some businesses (especially startups with investor capital) use a 13-week rolling cash flow forecast instead of monthly. The structure is the same; the granularity is finer.
When to use 13-week:
- You’re within 6 months of running out of cash.
- You’re managing a near-term liquidity event (raise, sale, large customer payment).
- Your cash flows are highly variable week to week (e.g., enterprise sales with lumpy contracts).
Otherwise, monthly is sufficient and less work.
Common mistakes
Confusing accrual with cash. Profit (accrual basis) doesn’t equal cash. You can be profitable on paper and still bankrupt. The forecast must be cash, not P&L.
Ignoring tax payments. Quarterly federal taxes (and state where applicable) are real cash outflows. Many forecasts forget them.
Optimistic pipeline assumptions. Defaulting to 80 percent close rate on pipeline produces fantasy. Use historical close rate; for new businesses, use 30 to 40 percent until you have data.
Not modeling A/R timing. Invoiced revenue is not received revenue. If clients pay net-60 in practice, model it that way; not as net-30.
No buffer. The forecast should include a minimum operating buffer (1 to 3 months of expenses). Crossing into the buffer is the trigger for action; running to zero is too late.
What our paid template adds
The Cash Flow Forecast template is $29 and includes:
- 12-month rolling forecast with inflows and outflows by category
- Cumulative cash and runway calculation
- Pipeline weighting (configurable close rate)
- Tax payment scheduling
- Variance reporting (planned vs actual per week)
- Dashboard with key metrics: runway, monthly burn, cash conversion cycle
- Excel and Google Sheets versions
For a 1 to 10 person business, this is sufficient. Larger businesses (50 plus people) need accounting software with cash flow modules; the spreadsheet stops scaling well.
Get the template
- Cash Flow Forecast — 12-month small-business cash flow with runway and pipeline weighting.
- Cash Flow Forecast — 12-month small-business cash flow with runway and pipeline weighting.