Cash Flow Forecasting for Small Business: A Step-by-Step Guide

A business can be profitable and still run out of cash.

That may sound contradictory, but it happens when the timing of cash coming into the business does not match the timing of cash going out.

A customer may owe you $20,000 but not pay for another 45 days. Meanwhile, payroll, rent, supplier bills, taxes, software subscriptions, and other expenses may be due this week.

This is where cash flow forecasting becomes useful.

A cash flow forecast estimates how much cash a business expects to have available at future points in time by projecting expected cash inflows and cash outflows.

Instead of asking only:

"How profitable will the business be?"

a cash flow forecast asks:

"How much cash are we likely to have, and when?"

For small businesses, this can provide an early warning system for potential cash shortages and help owners make better decisions about spending, hiring, purchasing, collections, and financing.

This guide explains how to create a cash flow forecast step by step, how to choose the right forecasting period, how to estimate inflows and outflows, how to build scenarios, and how to compare the forecast with actual results.

What Is a Cash Flow Forecast?

A cash flow forecast is a forward-looking estimate of a business's expected cash position.

It normally starts with the cash currently available, adds expected cash inflows, subtracts expected cash outflows, and calculates the projected ending cash balance.

A basic formula is:

Beginning Cash
+ Expected Cash Inflows
- Expected Cash Outflows
= Projected Ending Cash

For example:

Beginning cash:             $15,000
Expected inflows:           $25,000
Expected outflows:          $30,000
Projected ending cash:      $10,000

The forecast does not guarantee that the business will actually end the period with $10,000.

It is a planning estimate based on assumptions.

The quality of the forecast therefore depends heavily on the quality of those assumptions.

Why Cash Flow Forecasting Matters

Cash-flow forecasting helps a business look ahead instead of reacting only after a problem occurs.

1. It can identify cash shortages early

Suppose your forecast shows:

Week 1:  $18,000
Week 2:  $14,000
Week 3:   $7,000
Week 4:  -$2,000

The business can see that a potential shortfall may occur before the cash balance becomes negative.

That gives management time to investigate options.

2. It improves spending decisions

Before buying equipment, hiring another employee, or committing to a large supplier order, the business can check the expected effect on future cash.

3. It supports working-capital management

Accounts receivable and accounts payable affect cash timing.

A business may have significant customer invoices outstanding while also having supplier bills due soon.

A forecast brings those timing differences together.

See:

• Accounts Receivable Management
• Accounts Payable Management

4. It helps with seasonal planning

Some businesses experience predictable periods of high and low demand.

Forecasting can help identify when additional cash reserves may be needed.

5. It creates an objective basis for financial decisions

Instead of saying:

"I think we can afford it."

you can ask:

"What does the forecast show?"

That distinction can significantly improve financial discipline.

Cash Flow Forecast vs. Cash Flow Statement

These are not the same thing.

A cash flow statement is generally a historical financial statement showing cash movements over a past reporting period.

A cash flow forecast is a forward-looking planning tool that estimates future cash movements.

Think of the difference this way:

Cash flow statement
        ↓
What happened?

Cash flow forecast
        ↓
What may happen?

You can use historical cash-flow information to improve future forecasts, but the forecast itself is not a record of actual results.

Cash Flow Forecast vs. Business Budget

A budget and a cash-flow forecast also serve different purposes.

A business budget generally focuses on planned financial performance over a period.

A cash-flow forecast focuses specifically on cash timing and liquidity.

For example:

Budget:
Expected revenue = $100,000
Expected expenses = $75,000

Forecast:
When will customers actually pay?
When will suppliers need to be paid?
When will payroll leave the bank?
When will taxes be due?
How much cash will remain each week?

A business can therefore have:

• a profitable budget,
• a positive projected annual profit,
• and still experience a temporary cash shortage.

For more on budgeting, see How to Create a Business Budget.

How Far Ahead Should a Small Business Forecast?

There is no single forecasting period that works for every business.

The appropriate horizon depends on transaction volume, cash-flow volatility, seasonality, and management needs.

Short-term: 4 to 13 weeks

A short-term forecast is useful when the main concern is liquidity and upcoming payments.

A 13-week cash flow forecast is commonly used because it provides visibility over approximately one quarter while remaining detailed enough for weekly planning.

Medium-term: 6 months

A six-month forecast can help with:

• Hiring
• Equipment purchases
• Expansion
• Seasonal planning
• Debt payments
• Larger projects

Long-term: 12 months or more

Annual forecasting can help identify:

• Seasonal patterns
• Major capital expenditures
• Expected tax obligations
• Long-term financing needs
• Growth-related cash requirements

Many businesses benefit from using more than one horizon.

For example:

13-week forecast → operational cash management
12-month forecast → strategic planning

Step 1: Determine Your Starting Cash Balance

Start with the amount of cash actually available at the beginning of the forecast period.

Depending on your reporting approach, this may include appropriate cash and cash-equivalent balances available to the business.

Example:

Bank account:       $22,000
Cash on hand:        $1,000
Starting cash:      $23,000

Use actual figures rather than estimates whenever possible.

Do not count money that has not yet been received simply because an invoice exists.

That distinction is fundamental.

Step 2: List Expected Cash Inflows

Next, identify cash that you reasonably expect to receive during the forecast period.

Possible inflows include:

• Customer payments
• Cash sales
• Online payments
• Deposits
• Loan proceeds
• Owner contributions
• Grants
• Refunds
• Investment proceeds
• Other legitimate cash receipts

For many small businesses, customer collections are the largest source of cash.

That means the forecast should account for when customers are likely to pay, not simply when invoices are issued.

Example

Suppose you have:

Invoice A: $10,000 → expected payment Sept. 8
Invoice B: $6,000  → expected payment Sept. 20
Invoice C: $8,000  → expected payment Oct. 5

Your September forecast should not automatically include the entire $24,000.

The timing of each expected collection matters.

Step 3: Estimate Customer Collection Timing

This is one of the most important parts of cash-flow forecasting.

An invoice is not cash.

Consider:

Invoice issued:     $12,000
Customer pays:      30 days later

Revenue may be recognized according to the applicable accounting method before the business receives the cash.

The forecast should therefore estimate the expected payment date.

Historical customer behavior can be useful.

For example:

Customer A:
Terms = Net 30
Typical payment = 32 days

Customer B:
Terms = Net 15
Typical payment = 17 days

Customer C:
Terms = Net 30
Typical payment = 52 days

These patterns may make your forecast more realistic than simply assuming every invoice will be paid on its contractual due date.

However, historical behavior is not a guarantee.

Customer payment timing can change.

Step 4: Separate Certain and Uncertain Inflows

Not all expected cash receipts have the same level of confidence.

You can classify them as:

This makes the forecast more useful.

For example:

High-confidence inflows:     $30,000
Medium-confidence inflows:   $8,000
Low-confidence inflows:      $15,000

Management can then see that the full $53,000 should not necessarily be treated as equally reliable.

Step 5: List Expected Cash Outflows

Next, estimate when cash is expected to leave the business.

Common outflows include:

• Supplier payments
• Payroll
• Rent
• Utilities
• Taxes
• Loan payments
• Insurance
• Software
• Contractor payments
• Inventory purchases
• Advertising
• Equipment purchases
• Professional services
• Owner withdrawals
• Other operating payments

Again, timing matters.

An annual insurance payment of $12,000 does not create a $1,000 cash outflow every month if the actual policy is paid once a year.

A forecast should reflect the real timing of cash movements.

Step 6: Include Accounts Payable

Accounts payable should feed into your forecast.

Suppose:

Supplier invoice:      $8,000
Invoice date:          September 2
Due date:              October 2

The forecast should reflect the expected cash payment around the actual payment date rather than treating the invoice as an immediate cash outflow.

This is one reason a well-maintained accounts payable system is valuable.

Read Accounts Payable Management for Small Business.

Step 7: Include Recurring Expenses

Recurring expenses are often easier to forecast because they follow established patterns.

Examples include:

Rent                  $2,000/month
Software              $400/month
Payroll              $12,000/month
Internet               $150/month
Insurance              $300/month

Record the expected payment timing.

Do not assume that every recurring expense occurs on the same date unless that matches your actual payment schedule.

Step 8: Include Irregular Expenses

A common forecasting mistake is to include only routine monthly expenses.

Businesses may also face less frequent cash payments such as:

• Annual insurance
• Tax payments
• Equipment purchases
• Loan principal repayments
• Repairs
• Legal expenses
• Annual licenses
• Bonuses
• Inventory purchases

These can create significant temporary cash pressure.

For example:

Normal monthly outflows:       $18,000
One-time equipment purchase:   $15,000
Total outflows that month:     $33,000

Ignoring the equipment purchase could make the forecast look far healthier than reality.

Step 9: Calculate Net Cash Flow

Once expected inflows and outflows are listed, calculate the difference.

Formula:

Net Cash Flow = Cash Inflows - Cash Outflows

Example:

Inflows:       $40,000
Outflows:      $32,000

Net cash flow:  $8,000

If inflows are smaller than outflows:

Inflows:       $25,000
Outflows:      $31,000

Net cash flow: -$6,000

A negative monthly cash flow is not automatically a financial failure.

A business may intentionally use cash for growth, equipment, inventory, or other investments.

The important question is whether the business can fund the negative cash period without creating an unacceptable liquidity problem.

Step 10: Calculate the Ending Cash Balance

Now combine the beginning cash balance with projected net cash flow.

Formula:

Ending Cash
= Beginning Cash + Net Cash Flow

Example:

Beginning cash:     $20,000
Net cash flow:       -$6,000
Ending cash:        $14,000

Repeat this calculation for every forecast period.

Example: Four-Week Forecast

The business does not necessarily have a problem simply because weeks 2 and 3 show negative net cash flow.

The key observation is that the cash balance remains positive.

If the ending balance fell below the amount needed to meet obligations, management would need to take action.

Step 11: Establish a Minimum Cash Buffer

A forecast becomes more useful when management defines a minimum acceptable cash balance.

For example:

Minimum desired cash balance: $10,000

Then:

Forecast week 1: $18,000 → OK
Forecast week 2: $14,000 → OK
Forecast week 3: $11,000 → OK
Forecast week 4:  $7,500 → Warning

The exact buffer should depend on the business.

Factors may include:

• Payroll size
• Supplier obligations
• Revenue volatility
• Seasonality
• Access to financing
• Customer concentration
• Industry risk
• Tax obligations

A cash buffer is not a universal number.

It is a management decision based on the business's risk profile.

Step 12: Build Best-Case, Base-Case, and Worst-Case Scenarios

One forecast may not be enough.

Instead, create several scenarios.

Best case

Customers pay faster and sales are stronger than expected.

Base case

Collections and expenses behave approximately as expected.

Worst case

Customers pay later, sales are weaker, or an unexpected expense occurs.

Example:

This shows management how sensitive the cash position is to changing assumptions.

Scenario analysis is particularly useful for businesses with unpredictable revenue.

Step 13: Stress-Test the Forecast

Do not stop at three scenarios.

Ask questions such as:

• What if the largest customer pays 30 days late?
• What if sales fall by 20%?
• What if rent increases?
• What if payroll rises after hiring?
• What if a major supplier requires earlier payment?
• What if an important project is delayed?
• What if an unexpected $10,000 repair occurs?

Then update the forecast.

The objective is not to predict the future perfectly.

The objective is to understand how much financial pressure the business could withstand.

Step 14: Compare Forecast With Actual Results

A forecast is only useful when it is reviewed.

At the end of each period, compare:

Forecast
vs.
Actual

Example:

Forecast customer collections:    $25,000
Actual collections:               $19,000

Variance:                          -$6,000

Then investigate why.

Possible explanations include:

• Customer paid late
• Sale was smaller than expected
• Invoice was disputed
• Payment was received in the next period
• Forecast assumption was too optimistic

Do the same with expenses.

Forecast expenses:                $20,000
Actual expenses:                  $23,500

Variance:                           $3,500

Perhaps an unexpected repair, tax payment, or supplier increase caused the difference.

The purpose of variance analysis is to improve future forecasts.

Step 15: Update the Forecast Regularly

A forecast should not be created once and forgotten.

A business should update it as new information becomes available.

For example:

Monday:
Customer confirms payment delay

Tuesday:
Supplier changes delivery terms

Wednesday:
New contract signed

Thursday:
Unexpected equipment repair

Friday:
Customer payment received

Each of these changes can affect future cash.

A rolling forecast keeps the planning model current.

For businesses with tight liquidity, weekly updates can be particularly useful.

A Simple 13-Week Cash Flow Forecast

A practical weekly forecast could look like this:

This example shows why weekly forecasting can be powerful.

The business may have a positive annual outlook while still approaching a low-cash period in weeks 6 and 10.

What to Do When a Cash Shortage Appears

Finding a projected shortage is useful only if management responds.

Possible actions may include:

Accelerate customer collections

Review outstanding invoices and follow up on legitimate overdue balances.

See Accounts Receivable Management.

Delay non-essential spending

Consider whether planned purchases can be postponed without harming operations.

Review supplier terms

Where commercially appropriate, discuss payment timing with suppliers before problems arise.

Review inventory purchases

Avoid tying up more cash in inventory than the business currently needs.

Adjust hiring plans

A new employee creates an ongoing cash commitment.

Review recurring subscriptions

Remove unnecessary recurring costs.

Restructure project billing

For appropriate contracts, deposits or milestone billing may improve cash timing.

Consider financing

Depending on circumstances, businesses may evaluate appropriate credit or financing options.

Financing decisions should be based on the business's expected ability to repay and the actual cost of financing.

Cash Flow Forecasting for Seasonal Businesses

Seasonality makes forecasting especially important.

Suppose a business earns most of its annual revenue during November and December but has relatively low sales during January and February.

A simplistic annual budget might look healthy.

But a monthly cash forecast may reveal:

November:     +$30,000
December:     +$40,000
January:      -$15,000
February:     -$12,000

The business may therefore need to plan for the January and February cash requirements while it has stronger cash generation in November and December.

Seasonality should be reflected explicitly rather than hidden in annual averages.

Cash Flow Forecasting for Freelancers

Freelancers often experience irregular income.

Projects may start and finish at different times, and customers may pay at different speeds.

A useful freelance cash forecast can track:

• Current cash
• Invoices outstanding
• Expected client payments
• Upcoming software charges
• Contractor payments
• Taxes
• Equipment purchases
• Personal withdrawals where relevant to the cash-planning model

A freelancer may benefit from separating:

Confirmed payments
vs.
Potential new work

Potential future work should not be treated as guaranteed cash.

Cash Flow Forecasting for Agencies

Agencies may have significant timing differences between customer billing and contractor or media costs.

For example:

Client pays:               30 days
Contractor requires:       15 days
Advertising spend:          Immediate

The agency may therefore need to fund project costs before receiving customer cash.

A detailed forecast can highlight this working-capital gap.

Cash Flow Forecasting for Retail Businesses

Retailers may need to forecast:

• Customer sales
• Supplier payments
• Inventory purchases
• Rent
• Payroll
• Taxes
• Card-processing settlements
• Equipment purchases

Inventory is particularly important because purchasing inventory converts cash into stock before the goods are sold and collected.

A retailer with rapidly growing sales may therefore require more working capital rather than less.

Multi-Currency Cash Flow Forecasting

International businesses may hold and transact in multiple currencies.

Suppose:

Base currency: USD

EUR bank balance:      €10,000
GBP bank balance:       £4,000
USD bank balance:     $20,000

A consolidated forecast needs to handle the currencies consistently.

The business should distinguish:

• Original currency balances
• Expected foreign-currency inflows
• Expected foreign-currency outflows
• Exchange rates used for planning
• Base-currency equivalents

Forecasting exchange rates introduces additional uncertainty.

A planning model should therefore make assumptions visible rather than presenting converted amounts as certain.

Historical transaction exchange rates should also not be rewritten simply because current market rates change.

For more on multi-currency accounting, use a system that preserves transaction currency and historical rates consistently.

Common Cash Flow Forecasting Mistakes

Mistake 1: Treating invoices as cash

An invoice is not the same thing as a payment.

Mistake 2: Counting future sales as guaranteed

Sales that have not happened yet should be treated carefully.

Mistake 3: Ignoring payment timing

Two businesses can have the same annual revenue but very different cash positions depending on when customers pay.

Mistake 4: Forgetting annual or irregular expenses

Large one-time payments can materially change short-term liquidity.

Mistake 5: Ignoring accounts payable

Upcoming supplier payments are cash commitments.

Mistake 6: Using unrealistic collection assumptions

Assuming every customer pays exactly on the due date can create an overly optimistic forecast.

Mistake 7: Forecasting only for the next month

Some risks become visible only when the horizon is longer.

Mistake 8: Never comparing actual results with the forecast

A forecast cannot improve if its assumptions are never tested.

Mistake 9: Updating the forecast too rarely

New information can make an old forecast obsolete.

Mistake 10: Confusing profit with cash

Profitability and liquidity are related but not identical.

See Understanding Cash Flow: A Beginner's Guide.

How Accurate Should a Cash Flow Forecast Be?

A forecast should be as realistic as practical, but perfection is impossible.

The further into the future you forecast, the greater the uncertainty generally becomes.

For example:

Next 7 days:
Relatively high confidence

Next 30 days:
Moderate confidence

Next 6 months:
Greater uncertainty

Next 12 months:
Much greater uncertainty

This does not mean long-term forecasts are useless.

It means they should be treated as planning models rather than guarantees.

The best forecasts are updated as new information arrives.

Cash Flow Forecasting KPIs

A few metrics can help evaluate forecast quality.

Forecast variance

Compare forecast cash with actual cash.

Forecast ending cash:    $20,000
Actual ending cash:      $18,000

Variance:                -$2,000

Cash conversion timing

Track how quickly sales become collected cash.

Accounts receivable aging

Monitor overdue customer balances.

Accounts payable aging

Monitor upcoming and overdue supplier obligations.

Minimum cash balance

Track the lowest expected cash position over the forecast period.

Forecast coverage

Measure how far into the future the business has a current, usable forecast.

Operating cash burn

For businesses that regularly spend more cash than they generate, monitor the rate at which cash is being consumed.

These metrics are most useful when tracked consistently.

A Simple Cash Flow Forecasting Template

A simple forecast can be structured as follows:

BEGINNING CASH
                    $________

EXPECTED INFLOWS
Customer payments   $________
Cash sales          $________
Other receipts      $________

TOTAL INFLOWS       $________

EXPECTED OUTFLOWS
Suppliers           $________
Payroll             $________
Rent                $________
Taxes               $________
Software            $________
Debt payments       $________
Inventory           $________
Other expenses      $________

TOTAL OUTFLOWS      $________

NET CASH FLOW       $________

ENDING CASH         $________

Repeat the structure for each week or month in your forecast period.

Weekly Cash Flow Forecast Checklist

• Confirm beginning cash balance
• Review expected customer collections
• Review overdue invoices
• Update expected payment dates
• Add upcoming supplier payments
• Review payroll obligations
• Check tax deadlines
• Review loan and debt payments
• Add recurring subscriptions
• Add planned purchases
• Add unusual or one-time expenses
• Calculate projected ending cash
• Compare against minimum cash buffer
• Review best/base/worst scenarios
• Compare prior forecasts with actual results
• Update assumptions

How Accounting Software Can Help

Cash-flow forecasting becomes harder as transaction volume increases.

A useful accounting system can provide the underlying data needed for forecasting by keeping track of:

• Income
• Expenses
• Invoices
• Customer balances
• Payments
• Supplier obligations
• Bank transactions
• Recurring transactions
• Multiple currencies
• Historical financial reports

However, software does not automatically make a forecast accurate.

The forecast still depends on assumptions about:

• Collection timing
• Future sales
• Planned purchases
• Unexpected expenses
• Seasonality
• Payment behavior

FinFlowTrack helps small businesses organize invoices, expenses, payments, cash-flow information, and financial reporting in one system.

Explore FinFlowTrack

Frequently Asked Questions

What is cash flow forecasting?

Cash flow forecasting is the process of estimating future cash inflows, cash outflows, and ending cash balances over a selected period.

Why is cash flow forecasting important for small businesses?

It can help a business identify potential cash shortages early, plan upcoming payments, make better spending decisions, and understand future liquidity needs.

What is the difference between cash flow forecasting and budgeting?

Budgeting generally focuses on planned financial performance, while cash flow forecasting focuses specifically on the expected timing of cash entering and leaving the business.

How often should a small business update its cash flow forecast?

The appropriate frequency depends on the business. Businesses with volatile or tight cash flow may benefit from weekly updates. Businesses with more predictable cash flow may be able to update less frequently.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a weekly projection covering approximately one quarter. It is useful for monitoring near-term liquidity and identifying upcoming cash pressure.

Should accounts receivable be included in a cash flow forecast?

Yes, but the forecast should focus on the expected timing of customer payments rather than simply the total amount invoiced.

Should accounts payable be included?

Yes. Expected supplier and other business payments are important cash outflows and should be included according to their anticipated payment timing.

Can a profitable business still have negative cash flow?

Yes. A business can report profit while experiencing negative cash flow during a particular period because cash collection and payment timing may differ from when revenue and expenses are recognized.

How do you forecast customer payments?

Start with outstanding invoices and expected due dates, then adjust assumptions using customer payment history and other information that affects collection timing.

What is a minimum cash balance?

A minimum cash balance is an amount of liquidity management wants the business to maintain as a buffer against unexpected expenses, delayed customer payments, or other risks.

What should you do when a forecast shows a cash shortage?

Investigate the cause first, then consider actions such as accelerating legitimate collections, postponing non-essential spending, reviewing supplier terms, adjusting planned purchases, improving billing timing, or evaluating appropriate financing.

Can cash flow forecasting be done in multiple currencies?

Yes. A multi-currency forecast should track original currency amounts and apply clearly defined exchange-rate assumptions to produce consolidated amounts in the business's base currency.

Final Takeaway

Cash flow forecasting is not about predicting the future perfectly.

It is about improving visibility.

A strong forecast helps answer:

How much cash do we have now?

How much cash is likely to arrive?

When will it arrive?

What payments are coming?

When will they leave?

What will our cash balance look like next week,
next month, or next quarter?

The basic process is:

Starting cash
      ↓
Expected inflows
      ↓
Expected outflows
      ↓
Net cash flow
      ↓
Projected ending cash
      ↓
Compare with minimum cash buffer
      ↓
Update assumptions
      ↓
Compare forecast with actuals

Start with a simple weekly forecast.

Track the timing of customer collections, supplier payments, payroll, taxes, subscriptions, debt, inventory, and major purchases.

Then update the forecast as circumstances change.

For a small business, the value is not in having a complicated spreadsheet.

The value is in knowing before a problem happens that cash may become tight — and having enough information to do something about it.

For related guidance, read:

• Understanding Cash Flow: A Beginner's Guide
• Managing Business Cash Flow
• Accounts Receivable Management
• Accounts Payable Management for Small Business
• How to Create a Business Budget
• Profit and Loss Statement for Small Business
• Balance Sheet for Small Business

This article provides general educational information and is not accounting, tax, legal, or financial advice. Forecasting assumptions should be adapted to the specific circumstances of the business and reviewed regularly.