Quick Summary
Learn how to build a cash flow forecast from scratch - covering revenue projections, fixed and variable expenses, scenario planning, and how to spot potential cash shortfalls before they happen.
A profitable business can still run out of cash. That is the core problem cash flow forecasting solves.
Profit tells you whether revenue exceeds expenses over time. Cash flow tells you whether there is enough money in the account to pay this week’s bills. Both matter, but cash flow is the one that keeps the lights on.
Ready-made template: The Cash Flow Forecast Template provides a 12-month structure with built-in formulas for projections, scenario planning, and automatic balance calculations.
What Is Cash Flow Forecasting?
A cash flow forecast is an estimate of money coming in and going out of your business over a future period - usually 12 months.
It answers a simple question: will there be enough cash to cover obligations at any given point?
Unlike a profit and loss statement, which can include non-cash items like depreciation and accrued revenue, a cash flow forecast only tracks actual money movement. When a customer pays, that is cash in. When rent is due, that is cash out.
Cash Flow vs. Profit
These two concepts are related but distinct.
| Cash Flow | Profit | |
|---|---|---|
| What it tracks | Actual money in and out | Revenue minus expenses |
| Timing | When money moves | When transactions are recorded |
| Includes | All cash movements (loans, owner draws, tax payments) | Only revenue and business expenses |
| Time horizon | Week by week or month by month | Usually monthly, quarterly, or annual |
| Key question | Can we pay the bills? | Is the business earning more than it spends? |
A business might show a profit on paper while struggling to meet payroll. This often happens when customers pay on 30, 60, or 90-day terms. The revenue is booked, but the cash has not arrived yet. Meanwhile, suppliers and employees still need to be paid.
Why Cash Flow Forecasting Matters for Small Businesses
Large companies have credit lines and reserves to absorb cash timing gaps. Small businesses typically do not.
Some common situations where a forecast helps:
- Seasonal fluctuations - a landscaping company earning most revenue in spring and summer still has winter expenses
- Late-paying customers - invoices outstanding for 60+ days while fixed costs keep coming
- Growth spending - hiring new staff or buying equipment before the additional revenue arrives
- Tax obligations - quarterly tax payments that can catch business owners off guard
- Loan repayments - regular debt payments that reduce cash but may not show as expenses on a P&L
A forecast turns these from surprises into planned events.
The Basic Cash Flow Formula
Every cash flow forecast builds on this formula:
Opening Balance + Cash In - Cash Out = Closing Balance
The closing balance for one month becomes the opening balance for the next. That is the entire structure - repeated month after month.
| January | February | March | |
|---|---|---|---|
| Opening Balance | $15,000 | $12,500 | $14,200 |
| Cash In | $22,000 | $25,000 | $23,000 |
| Cash Out | $24,500 | $23,300 | $21,800 |
| Closing Balance | $12,500 | $14,200 | $15,400 |
In this example, January shows more going out than coming in - but the opening balance covers the gap. This is exactly the kind of pattern a forecast reveals. Without it, that January dip could cause panic.
How to Project Revenue
Revenue projections are the hardest part. Some approaches that work:
Use Historical Data
If the business has been running for a year or more, past revenue is the starting point. Look at month-by-month revenue for the previous 12 months. Identify seasonal patterns, growth trends, and anomalies.
Three-Scenario Approach
Rather than picking a single number, some business owners find it useful to estimate three versions:
| Scenario | Assumption | Monthly Revenue Example |
|---|---|---|
| Conservative | Slow month, lost clients, delays | $18,000 |
| Expected | Based on current trends and pipeline | $23,000 |
| Optimistic | New clients land, growth continues | $28,000 |
The expected scenario drives the main forecast. The conservative scenario shows what happens if things slow down. More on this in the scenario planning section.
Factor in Payment Timing
Revenue is not the same as cash received. If customers pay on net-30 terms, January’s sales become February’s cash. This timing gap is one of the most common sources of cash flow problems.
For the forecast, enter revenue in the month the cash actually arrives - not when the invoice is sent.
Fixed vs. Variable Expenses
Expenses fall into two broad categories, and separating them makes forecasting more accurate.
Fixed Expenses
These stay roughly the same regardless of how much revenue comes in:
- Rent or lease payments
- Salaries (for permanent staff)
- Insurance premiums
- Loan repayments
- Software subscriptions
- Accounting and legal retainers
Fixed expenses are the easy part of forecasting. They are predictable and change infrequently.
Variable Expenses
These fluctuate with business activity:
- Materials and supplies
- Contractor or freelancer payments
- Shipping and delivery costs
- Sales commissions
- Marketing spend (if tied to campaigns)
- Utilities (partially variable)
Variable expenses are harder to predict but tend to track with revenue. If revenue drops, many variable costs drop too - which provides a natural buffer.
One-Off Expenses
Some costs do not repeat but still need to appear in the forecast:
- Equipment purchases
- Office fit-out or renovation
- Annual license renewals
- Tax payments (quarterly or annual)
- Seasonal inventory stocking
Missing one-off expenses is a common reason forecasts turn out to be overly optimistic.
Building a 12-Month Forecast: Step by Step
Step 1: Set Your Opening Balance
Check the current business bank balance. That is the starting point.
Step 2: List All Revenue Sources
Break revenue into categories that make sense for the business:
- Product sales
- Service revenue
- Recurring/subscription revenue
- Other income (interest, refunds, grants)
Step 3: List All Expenses
Use bank statements and accounting records from the past 12 months. Group them into fixed, variable, and one-off categories.
The Monthly Expense Tracker can help organize expense categories and identify spending patterns from historical data.
Step 4: Enter Monthly Projections
Fill in each month with projected amounts. A 12-month view might look like this:
| Category | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening Balance | $20,000 | $18,200 | $19,700 | $22,100 | $20,600 | $19,100 | $21,300 | $23,000 | $24,500 | $18,800 | $17,300 | $19,800 |
| Revenue | $30,000 | $32,000 | $35,000 | $33,000 | $31,000 | $34,000 | $36,000 | $35,000 | $28,000 | $30,000 | $33,000 | $35,000 |
| Fixed Expenses | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 |
| Variable Expenses | $8,500 | $7,500 | $9,200 | $11,000 | $9,000 | $8,300 | $10,800 | $10,000 | $10,200 | $8,000 | $7,000 | $8,500 |
| One-Off Expenses | $1,300 | $1,000 | $1,400 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Closing Balance | $18,200 | $19,700 | $22,100 | $20,600 | $19,100 | $21,300 | $23,000 | $24,500 | $18,800 | $17,300 | $19,800 | $22,800 |
Step 5: Check for Problem Months
Scan the closing balances. Any month where the balance drops near zero - or goes negative - is a potential problem.
In the example above, January and February show lower balances. That could be seasonal (post-holiday slowdown) and worth planning for - perhaps by building reserves in the stronger months of October and November.
Step 6: Add Running Minimum Balance
Some business owners add a row for a minimum cash threshold - the amount they want to keep available at all times. If the forecast shows the balance dropping below that threshold, it is an early warning to take action.
Scenario Planning
A single forecast shows one possible future. Scenarios show a range of them.
How to Build Scenarios
Take the base forecast and create two variations:
Expected Case - the main forecast, based on current trends and known commitments.
Conservative Case - reduce revenue by 15-25% and keep expenses the same. This shows how long cash reserves last if business slows down.
Optimistic Case - increase revenue by 10-20% and add the variable expenses that come with growth. This shows whether the business can fund its own growth or needs outside capital.
What Scenarios Reveal
| Scenario | Monthly Revenue | Monthly Expenses | Monthly Cash Flow |
|---|---|---|---|
| Conservative | $25,000 | $31,000 | -$6,000 |
| Expected | $33,000 | $32,500 | +$500 |
| Optimistic | $40,000 | $35,000 | +$5,000 |
In this example, the conservative scenario shows a $6,000 monthly cash drain. At that rate, a $20,000 reserve lasts about three months. That is useful information for deciding how much cash to keep on hand.
The gap between conservative and expected is also worth noting. If the business is close to breakeven in the expected case, the margin for error is thin. Some business owners find this view helps them decide whether to delay large purchases or build reserves first.
Common Forecasting Mistakes
1. Being Too Optimistic on Revenue
The natural tendency is to project what the business hopes to earn, not what it is likely to earn. Using historical data as the baseline - rather than aspirational targets - tends to produce more reliable forecasts.
2. Forgetting Irregular Expenses
Annual insurance premiums, quarterly tax payments, equipment replacement cycles. These land in specific months and can cause cash crunches if they are not in the forecast.
3. Ignoring Payment Timing
Recording revenue when invoiced rather than when paid. For businesses with net-30 or net-60 payment terms, this can make the forecast look healthier than reality.
4. Not Updating the Forecast
A forecast created in January and never updated becomes fiction by March. Real data needs to replace projections as each month passes.
5. Confusing Cash Flow with Profit
Including non-cash items like depreciation, or excluding cash items like loan principal payments and owner draws. The forecast tracks cash movement only.
6. Missing Growth Costs
Revenue growth usually requires spending first - hiring, inventory, marketing. If the forecast shows revenue increasing without corresponding expense increases, it may be incomplete.
When to Update Your Forecast
A cash flow forecast is a living document. How often to update depends on the business, but some common rhythms:
- Monthly - replace projections with actual figures for the completed month, then extend the forecast by one month to maintain the 12-month window
- When circumstances change - a large new client, a lost contract, an unexpected expense, or a change in payment terms from a key customer
- Before major decisions - hiring, purchasing equipment, taking on debt, or expanding to a new location
- Quarterly review - compare original projections to actual results and adjust the methodology if patterns emerge
The monthly update is the most important one. It takes 30-60 minutes and keeps the forecast grounded in reality rather than assumptions made months ago.