How to Forecast Cash Flow for a Small Business

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.

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, which is one reason cash flow ranks among the financial pressures tracked in the Federal Reserve’s Small Business Credit Survey.

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 estimated 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.

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:

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.

Weight Uncertain Pipeline Revenue

Not all projected revenue carries the same certainty. Signed contracts and active retainers are dependable. Work still sitting in the sales pipeline is not. One approach that keeps projections grounded is to apply a probability multiplier to unsigned work, based on how often similar deals have closed in the past.

A services firm might separate its inflows like this:

The pipeline row multiplies the value of open opportunities by an expected close rate, 60 percent in this example. Businesses without a track record often start with a lower figure and raise it as real conversion data accumulates. Keeping signed and unsigned revenue on separate rows makes it easy to see how much of the forecast rests on work that has not been won yet.

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, the kind covered in budgeting for irregular 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:

The Cash Flow Forecast template (Premium tier) builds this 12-month view automatically: the closing balance rolls into the next month’s opening balance, and net cash flow turns red the moment outflows outrun inflows.

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.

Cash Runway: How Long the Money Lasts

The closing balance answers where cash stands at the end of each month. Runway answers a sharper question: how many months until the money runs out at the current pace. It is the single number that turns an abstract worry into a specific deadline.

Start with net cash flow for each month, which is total cash in minus total cash out.

Six straight months of negative net cash flow. On their own the monthly figures look manageable, but they accumulate. Running cumulative cash forward from an opening balance shows the real trajectory.

At this pace the balance approaches zero within about eight months. If the minimum operating buffer is one month of expenses, roughly $26,000 here, cash drops below that line in September. That is the point the forecast flags for action, well before the account actually empties. Spotting it in the spring leaves room to accelerate the pipeline, trim expenses, or arrange a line of credit while there is still time to choose.

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

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.

The Cash Flow Forecast template (Premium tier) runs the three cases side by side, each driven by its own revenue, expense, and collection-rate assumptions, and plots all three against an alert threshold on one chart.

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:

• Weekly - for businesses in a tight cash position, some owners reconcile once a week, adding an actual figure beside each planned line for the current month and adjusting the rest of the month where the variance is meaningful
• Monthly - replace projections with actual figures for the completed month, then extend the forecast by one month to maintain the rolling 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 baseline for most businesses. It takes 30-60 minutes and keeps the forecast grounded in reality rather than assumptions made months ago. Whatever the cadence, the value comes from comparing actual figures against the plan. A forecast that is never checked against what really happened tends to drift into fiction within a quarter.

The 13-Week Cash Flow Forecast

Most small businesses forecast month by month. Some, especially startups working from investor capital, use a 13-week rolling forecast instead. The structure is identical; the granularity is finer, showing each week rather than each month.

A weekly view tends to earn its extra effort in a few situations:

• Cash is within about six months of running out, so the timing of individual payments matters
• A near-term liquidity event is in play, such as a funding round, a sale, or a single large customer payment
• Cash flows swing sharply from week to week, as with lumpy enterprise contracts

Outside those cases, a monthly forecast usually captures enough and takes far less upkeep.

Every version of this, whether monthly, weekly, or 13-week, runs on the same four lines and the same habit of replacing projections with real figures as they land. The Cash Flow Forecast template has that structure, the scenario tab, and the runway math already built, so a first pass is mostly entering your own numbers into the model shown above.

Related

• Monthly vs. Annual Budgeting: Which Works Better?
• How to Build a Rolling 12-Month Budget
• Budget for Irregular Expenses
• Track Subscriptions and Recurring Expenses