Free Cash Flow Forecast Template (Excel)

A cash flow forecast template is the single most important tool in any fractional CFO's toolkit. It's also the #1 reason small business owners hire financial advisors — they need to know whether they'll have enough cash to make payroll next month.

Below you'll find a complete guide to cash flow forecasting plus a professional template kit that includes three models: a 13-week rolling forecast, a 12-month projection, and a scenario analysis tool.

What Is a Cash Flow Forecast?

A cash flow forecast is a projection of your expected cash inflows and outflows over a future period. Unlike a profit and loss statement (which includes non-cash items like depreciation), a cash flow forecast focuses exclusively on when actual cash moves in and out of your bank account.

This distinction matters because profitable companies go bankrupt all the time — not because they lack revenue, but because they run out of cash. A company with $500K in accounts receivable and $0 in the bank can't make payroll, regardless of how "profitable" the P&L says they are.

For a deeper dive into cash flow analysis techniques, see our complete guide.

The 13-Week Cash Flow Forecast: Your Most Important Tool

The 13-week cash flow forecast is the gold standard for short-term cash management. Here's why CFOs and fractional advisors prefer this timeframe:

• 13 weeks ≈ one quarter — aligns with business planning cycles
• Weekly granularity — catches cash crunches that monthly views miss
• Rolling update — each week, drop the oldest week, add a new one at the end
• Actionable — specific enough to inform decisions like "can we hire this month?"

What Your 13-Week Forecast Should Include

Section	Line Items	Notes
Cash Inflows	AR collections, new cash sales, other income	Base on collection history, not invoice dates
Cash Outflows	Payroll, rent, vendors, insurance, utilities, marketing, loan payments, taxes	Include every recurring and known one-time payment
Net Cash Flow	Inflows minus outflows	The critical number — is it positive or negative?
Ending Balance	Beginning cash + net cash flow	Your lifeline — when does this hit danger zone?

The key insight: base inflows on when cash actually arrives, not when you invoice. If your average collection period is 35 days, a $50K invoice sent this week won't hit your bank for 5 weeks. The 13-week forecast makes this visible.

12-Month Cash Flow Projection

While the 13-week forecast manages short-term cash, the 12-month projection supports strategic planning:

• Annual budgeting — ties operating budget to cash reality
• Seasonal planning — identifies cash-tight months before they arrive
• Bank/investor presentations — required for most credit applications and fundraising
• Hiring decisions — shows whether you can sustain additional headcount

Learn more about cash flow forecasting for small businesses and why it's the #1 advisory service to offer.

Scenario Analysis: Best, Expected, and Worst Case

Every serious cash flow forecast should include scenario modeling. What happens if:

• Your biggest client pays 30 days late?
• Revenue drops 20% next quarter?
• You land that big contract you've been chasing?
• A key employee leaves and you need to hire a replacement?

Scenario analysis turns a cash flow forecast from a prediction into a decision tool. Present all three scenarios to clients — it demonstrates sophistication and builds trust. This is how fractional CFOs deliver strategic value beyond basic bookkeeping.

How to Build a Cash Flow Forecast in Excel

Step-by-step process:

1. Start with your current bank balance — this is your beginning cash position
2. Map out known cash inflows — contracts with specific payment dates, recurring revenue, known collections
3. Estimate variable inflows — use historical collection rates to project AR collections
4. List all cash outflows by week — payroll dates, rent due dates, vendor payment terms, tax deadlines
5. Calculate net cash flow per week — inflows minus outflows
6. Calculate ending balance — beginning balance + net cash flow = ending balance (which becomes next week's beginning balance)
7. Set minimum cash thresholds — highlight any week where cash drops below your safety buffer
8. Update weekly with actuals — replace projections with actual numbers, re-forecast remaining weeks

Cash Flow Forecasting Tips for Advisors

• Update before every client meeting — stale forecasts destroy credibility
• Track forecast accuracy — compare projections to actuals. Under 10% variance = good. Over 25% = model needs work
• Build in a cash buffer — most businesses should maintain 2-3 months of operating expenses as reserve
• Separate operating from financing — loan proceeds inflate cash but aren't revenue
• Focus on collections, not revenue — revenue recognition ≠ cash received
• Present visually — charts showing the ending balance trend are more impactful than spreadsheet numbers

For more on how to price and deliver advisory services, see our guide on advisory pricing for bookkeepers.

Who Needs a Cash Flow Forecast Template?

Role	Use Case
Fractional CFO	Deliver weekly/monthly cash reports to 3-5 clients
Bookkeeper adding advisory	Upgrade from compliance to advisory services
Small business owner	Self-manage cash and plan for seasonal fluctuations
Startup founder	Track burn rate and runway for investor conversations
Controller	Weekly cash management for the CFO

Related: Cash Flow Analysis Guide · Cash Flow Forecasting for Small Business · 13-Week Cash Flow Forecast Guide · All Templates