Cash flow forecasting is the process of estimating how much cash a business expects to receive and pay out over a future period. It helps management anticipate liquidity shortages, schedule payments, assess financing requirements, and make operating decisions before cash becomes critically low.
A business can generate strong sales and report accounting profits while struggling to pay its suppliers. This can happen when customers take longer to pay, the company purchases inventory ahead of demand, or several major expenses fall due before customer receipts arrive.
A cash flow forecast turns these timing differences into a forward-looking financial plan.
The basic calculation is:
[{Ending Cash}={Beginning Cash}+{Cash Inflows}-{Cash Outflows}]
For example, suppose a company starts a month with $40,000, expects to collect $90,000, and anticipates $105,000 in payments. Its projected ending cash balance is:
[$40{,}000+$90{,}000-$105{,}000=$25{,}000]
The company expects to finish the month with $25,000 in cash, assuming its forecast assumptions hold.
That information can influence purchasing decisions, hiring plans, supplier negotiations, debt repayment, and the timing of capital investments.
The U.S. Small Business Administration (SBA) identifies financial projections, including cash flow statements, as important components of business planning and financing requests.
The purpose of cash flow forecasting is not to predict the future perfectly. It is to identify likely financial pressure early enough to make informed decisions.
Cash Flow Forecast vs. Cash Flow Statement vs. Budget
These three financial tools are related, but they serve different purposes.
| Tool | Main purpose | Typical focus |
|---|---|---|
| Cash flow forecast | Estimate future cash availability | When cash will arrive and when payments will be due |
| Cash flow statement | Report historical cash movements | Operating, investing, and financing cash flows already recorded |
| Operating budget | Plan revenues and expenses | Expected business activity and financial performance |
A budget may show that a company expects to earn a profit during the month. A cash flow forecast may reveal that its customers will not pay until after payroll and supplier invoices are due.
That difference matters because accounting revenue and expenses do not necessarily occur at the same time as their associated cash receipts and payments.
For a deeper explanation, see Income Statement vs. Cash Flow Statement: Key Differences, Examples, and Why Profit Isn’t Cash.
Why a profitable business still needs a cash forecast
Suppose a wholesaler records $100,000 in qualifying credit sales during April. Its customers are expected to pay in May, but the wholesaler must pay $45,000 to suppliers and $20,000 in payroll and operating expenses during April.
The April income statement may recognize revenue from those sales, subject to applicable accounting requirements. However, the company cannot use the unpaid invoices to settle April’s bills.
A cash flow forecast makes the payment timing visible.
Choosing the Right Cash Flow Forecasting Method
Businesses commonly use a direct method for near-term cash planning and an indirect method for connecting financial projections to accounting results.
The appropriate method depends on the forecast’s purpose, the quality of available data, and the period being examined.
1. The direct cash flow forecasting method
The direct method estimates specific future cash receipts and cash payments.
Cash receipts may include customer collections, cash sales, loan proceeds, or owner contributions. Payments may include supplier invoices, payroll, rent, taxes, debt repayments, and equipment purchases.
A direct forecast is particularly useful when management needs to know whether the business can meet its obligations over the coming days or weeks.
Advantages:
- Makes expected payment dates visible.
- Highlights cash shortages before they occur.
- Supports payment scheduling and collection decisions.
- Can be updated using bank balances, accounts receivable, and accounts payable records.
Limitations:
- Requires dependable information about receipt and payment timing.
- Can become difficult to maintain without clear ownership.
- Must account for delayed customer payments and unplanned transactions.
For most businesses that need to anticipate an immediate cash shortfall, this is a practical starting point.
2. The indirect cash flow forecasting method
The indirect method begins with projected net income and adjusts it for noncash expenses, changes in working capital, and other relevant items to estimate operating cash flow.
For example, projected net income may be adjusted for depreciation, changes in accounts receivable, movements in inventory, and changes in accounts payable.
Projected investing and financing cash flows are then incorporated to determine the expected change in cash.
This method is useful when forecasts are integrated with a projected income statement and balance sheet.
However, an indirect forecast can conceal critical payment dates if it is built only from monthly accounting totals. A company might forecast sufficient cash at month-end but still run short in the middle of the month.
For that reason, some businesses use an integrated financial model for longer-term planning and a direct, short-term forecast for day-to-day liquidity management.
Weekly vs. Monthly Cash Flow Forecasting
The forecast interval should match the decisions management needs to make.
Weekly cash flow forecasting
A weekly forecast is useful when payment timing is tight, cash balances are volatile, or the business must coordinate large supplier payments with customer collections.
A rolling 13-week forecast is a common management tool because it provides roughly one quarter of forward visibility while allowing the forecast to be updated regularly. It is a practical convention, not a universal requirement for every business.
Weekly forecasting is especially useful for companies experiencing rapid growth, seasonal fluctuations, restructuring, or limited cash reserves.
Monthly cash flow forecasting
A monthly forecast is helpful for budgeting, annual planning, identifying seasonal patterns, assessing planned investments, and evaluating financing needs.
Many businesses build forecasts covering the next 12 months and update them as actual results become available.
For businesses seeking financing, the SBA advises preparing detailed financial projections, with monthly or quarterly detail during the first year where appropriate, as part of the wider business plan.
See the SBA’s business planning and funding guidance.
Which should a business use?
A business with comfortable cash reserves and predictable payment patterns may find a monthly forecast adequate for strategic planning, supplemented by routine bank-balance monitoring.
A business with tight liquidity should generally use a more frequent operational forecast. Monthly totals alone may not reveal a cash shortfall that occurs between the start and end of a month.
The appropriate approach is the one that gives management enough warning to act.
How to Create a Cash Flow Forecast Step by Step
A forecast does not need to begin with complicated software. A spreadsheet can provide a useful model if the inputs, assumptions, and calculations are reliable.
Step 1: Establish the beginning cash balance
Start with the cash actually available at the beginning of the forecast period.
Use current bank balances and reconcile material differences. Consider outstanding payments, uncleared transactions, cash restrictions, and balances that cannot be used for ordinary operating expenses.
Do not treat unused credit limits as cash already available in the bank. If a business expects to draw on an available credit facility, record the anticipated proceeds separately and verify that the facility is committed and the draw conditions can be met.
An incorrect starting balance can distort the entire forecast.
Step 2: Forecast cash receipts by expected collection date
Estimate when the business expects to receive money, not simply when it issues an invoice or records revenue.
Potential sources include:
- Cash and card sales, based on expected settlement dates.
- Customer payments against outstanding invoices.
- Deposits and milestone payments.
- Refunds from suppliers.
- Loan proceeds or owner contributions, when sufficiently certain.
- Other contractual receipts.
Use historical collection patterns, payment terms, accounts receivable aging, customer-specific information, and known disputes to estimate collection dates.
Avoid assuming every customer will pay on the contractual due date. If an important customer regularly pays late, the forecast should reflect a realistic collection assumption rather than the ideal contractual deadline.
Step 3: Forecast cash payments
List expected payments according to their likely payment dates.
Include relevant operating and non-operating items, such as:
- Supplier invoices and inventory purchases.
- Payroll, contractor payments, and employee-related obligations.
- Rent, utilities, insurance, software, and other overhead.
- Taxes and statutory payments.
- Loan principal and interest payments.
- Equipment purchases and other capital expenditures.
- Owner distributions, dividends, or other planned withdrawals.
- Seasonal or irregular expenses, including annual renewals.
Avoid double-counting. For instance, if a supplier invoice is already included in scheduled supplier payments, do not add the same purchase again merely because it also appears in a purchasing budget.
Record the actual expected cash payment, which may differ from the accounting expense for the period.
Step 4: Calculate net cash flow
For each forecast period, calculate:
[{Net Cash Flow}={Total Cash Inflows}-{Total Cash Outflows}]
A positive result means expected cash inflows exceed outflows during that period. A negative result means the business expects to use cash accumulated earlier or obtained from another source.
Neither result is inherently good or bad. A negative period may reflect planned investment, while positive cash flow may result from temporary factors that will reverse later.
Step 5: Calculate ending cash
The next calculation is:
[{Ending Cash}={Beginning Cash}+{Net Cash Flow}]
The ending cash balance for one period becomes the beginning cash balance for the next period.
Continue the schedule across every week or month in the forecast horizon.
Step 6: Set a minimum operating cash threshold
Decide how much cash the business needs to protect its normal operations.
The threshold should reflect payment obligations, cash flow volatility, payroll, supplier requirements, debt service, and the time needed to obtain additional funding or reduce spending.
There is no universal minimum cash balance that suits every company.
The threshold provides a practical warning point. If projected cash falls below it, management can investigate options before a payment is missed.
Step 7: Test alternative scenarios
Create at least a base case and a downside case. A business with material uncertainty may also benefit from an upside case.
For example:
- Base case: Expected customer receipts and planned payments.
- Downside case: A major customer pays late, sales weaken, or an unexpected expense occurs.
- Upside case: Collections improve or additional customer orders generate earlier cash receipts.
Keep the assumptions explicit. Scenario analysis should show how different conditions affect cash availability, rather than merely changing a final number without explaining why.
Step 8: Update the forecast using actual results
Compare forecast receipts and payments with actual transactions. Investigate important differences.
If customers consistently pay later than anticipated, revise the collection assumptions. If supplier costs or payroll repeatedly exceed projections, update the outflow model.
A rolling forecast is most useful when new information replaces outdated assumptions instead of allowing the original forecast to remain unchanged.
Worked Example: Forecasting a Cash Shortfall Before It Happens
Consider Northstar Components, a hypothetical distributor with an opening cash balance of $42,000.
Management wants to maintain at least $20,000 in cash to protect routine operating obligations. Its four-week forecast shows the following expected cash flows.
All amounts are illustrative and stated in U.S. dollars.
| Forecast period | Beginning cash | Expected inflows | Expected outflows | Net cash flow | Ending cash |
|---|---|---|---|---|---|
| Week 1 | $42,000 | $22,000 | $25,000 | −$3,000 | $39,000 |
| Week 2 | $39,000 | $18,000 | $27,000 | −$9,000 | $30,000 |
| Week 3 | $30,000 | $15,000 | $24,000 | −$9,000 | $21,000 |
| Week 4 | $21,000 | $17,000 | $29,000 | −$12,000 | $9,000 |
The ending cash calculation for Week 4 is:
[$21,000+$17,000-$29,000=$9,000]
The business finishes the fourth week with $9,000, which is $11,000 below its minimum cash threshold of $20,000.
The important discovery is not simply that cash will decline. The forecast identifies when the business is likely to fall below its required reserve.
Without the forecast, management might discover the problem only after several payments have already become due.
What actions could management consider?
Suppose the Week 4 outflows include a discretionary equipment deposit of $5,000 that can be postponed without disrupting operations. Management also learns that a customer may agree to pay an $8,000 invoice one week earlier than originally expected.
If both changes can be confirmed, the adjusted Week 4 estimate becomes:
| Item | Amount |
|---|---|
| Original projected ending cash | $9,000 |
| Equipment deposit deferred | +$5,000 |
| Customer receipt accelerated | +$8,000 |
| Adjusted projected ending cash | $22,000 |
The revised ending balance is:
[$9,000+$5,000+$8,000=$22,000]
The revised figure is $2,000 above the minimum cash threshold.
This does not mean the company has generated an additional $13,000 in profit. It has changed the timing of a payment and a customer receipt.
Management must also update subsequent weeks: the equipment payment has been postponed rather than eliminated, and the accelerated customer receipt must not be counted again in a later week.
This example illustrates the practical value of forecasting. It provides time to evaluate realistic actions before the cash shortage becomes urgent.
A Simple Cash Flow Forecast Template
A spreadsheet forecast should make the opening balance, cash movements, and ending balance easy to review.
The following structure can be adapted for a weekly or monthly forecast.
| Forecast line | How to populate it |
|---|---|
| Beginning cash | Available cash at the start of the period |
| Customer receipts | Expected cash collections by receipt date |
| Other operating receipts | Other cash received from normal operations |
| Financing inflows | Expected loan proceeds or owner contributions |
| Other cash inflows | Other material cash receipts not already listed |
| Total cash inflows | Sum of all inflow categories |
| Supplier payments | Expected supplier and inventory payments |
| Payroll and contractors | Scheduled wages and contractor payments |
| Operating expenses | Rent, insurance, utilities, software, and other costs |
| Taxes and statutory payments | Expected tax and other required payments |
| Debt service | Loan principal and interest payments |
| Capital expenditures | Expected cash paid for equipment or other assets |
| Owner distributions | Planned withdrawals or distributions |
| Other cash outflows | Additional payments not already included |
| Total cash outflows | Sum of all outflow categories |
| Net cash flow | Total inflows minus total outflows |
| Ending cash | Beginning cash plus net cash flow |
| Minimum cash target | The company’s designated operating reserve |
| Cash headroom / (shortfall) | Ending cash minus the minimum cash target |
The main formulas are:
[{Total Inflows}={Cash Inflow Categories}]
[{Total Outflows}={Cash Outflow Categories}]
[{Ending Cash}={Beginning Cash}+{Inflows}-{Outflows}]
[{Cash Headroom}={Ending Cash}-{Minimum Cash Target}]
A negative cash headroom figure means projected cash is below the designated operating threshold.
For a more detailed starting point, SCORE provides a cash flow projection model and a 24-month cash flow projection template. These are useful reference formats that businesses can adapt to their own assumptions and reporting needs.
How to Improve Forecast Accuracy
A forecast is only as useful as its inputs and the way management updates them.
Use realistic collection assumptions
Invoice due dates are a starting point, not proof that cash will arrive on time.
Review customer payment history, disputes, credit risk, and the aging of outstanding invoices. Give significant overdue balances individual attention rather than relying entirely on average collection periods.
Include irregular payments
Annual insurance premiums, tax installments, license renewals, bonuses, and major supplier commitments can create temporary cash pressure.
Include known payments in the period when they are expected to leave the business, even if they do not occur every month.
Reflect seasonality
A retailer may receive most of its annual sales during the holiday season. A manufacturer may purchase inventory well before seasonal demand, while a construction company might experience payment delays linked to project milestones.
Use historical patterns where available, but account for changes in customer demand, contracts, pricing, and the wider business environment.
Separate confirmed transactions from uncertain estimates
Record scheduled payments and highly reliable receipts separately from speculative transactions.
For example, an unsigned contract or an unapproved credit facility should not be treated like money already available. If a potential transaction could materially affect the forecast, model it as a clearly identified scenario.
Reconcile against bank balances
The forecast should start from a credible cash position. Reconcile material differences between accounting records, bank balances, and actual cash availability.
Investigate unexplained differences and ensure that restricted cash is not treated as freely available.
Analyze forecast variances
A useful approach is to calculate:
[{Forecast Variance}={Actual Cash Flow}-{Forecast Cash Flow}]
Compare actual and forecast values separately for receipts, payments, and ending cash.
A receipt variance may result from a customer paying early or late, a change in sales volume, or an inaccurate collection assumption. An outflow variance may result from unplanned costs or payments being scheduled incorrectly.
The purpose of variance analysis is to improve the model and the underlying decisions. A difference between forecast and actual cash is not automatically evidence of poor management; the cause and materiality matter.
Common Cash Flow Forecasting Mistakes
1. Forecasting sales instead of cash receipts
Projected sales are not necessarily the same as cash expected during the period.
A forecast must account for credit terms, settlement delays, customer deposits, refunds, and overdue invoices.
2. Omitting tax and debt payments
Taxes, principal repayments, interest, and other scheduled obligations can materially affect liquidity.
Include their expected payment dates even when the corresponding accounting expense has already been recognized or the principal repayment does not count as an expense.
3. Ignoring capital expenditures
Equipment purchases and other capital investments may require substantial cash even when the cost is recognized through depreciation over time.
Forecast the actual payment rather than relying only on the income statement.
4. Double-counting transactions
When information comes from several spreadsheets or accounting reports, the same payment can appear in multiple places.
Assign each cash transaction to one forecast line and reconcile totals against source records.
5. Treating an uncertain credit line as guaranteed liquidity
An unused credit limit does not necessarily mean money can be drawn immediately. Facility conditions, borrowing-base tests, covenants, or lender approvals can affect availability.
Confirm the facility’s terms before depending on a draw to cover a projected shortfall.
6. Updating the forecast too infrequently
An outdated forecast may continue to rely on customers paying on time even after a major invoice becomes overdue.
Update assumptions whenever material changes occur and follow a routine review schedule appropriate to the business’s risk.
7. Assuming a forecast is a guarantee
A forecast is an estimate built on assumptions. Unplanned expenses, economic changes, lost customers, delayed collections, and operational disruptions can change the outcome.
Use scenarios and a reasonable liquidity buffer rather than relying on a single precise-looking forecast.
FAQ’s
How far ahead should a business forecast cash flow?
The appropriate period depends on the decisions being made. A rolling 13-week forecast is a common tool for short-term liquidity management, while a 12-month monthly forecast supports annual planning and seasonality analysis. Businesses seeking financing may require longer financial projections as part of their business plans.
What is the difference between a cash flow forecast and a cash flow projection?
The terms are often used interchangeably. Both generally describe estimates of future cash inflows, outflows, and balances. Some businesses use “forecast” for their expected outcome and “projection” for a specified set of assumptions, but that distinction is not universal.
Can a small business create a cash flow forecast in Excel?
Yes. A spreadsheet can be sufficient if it records beginning cash, expected receipts, scheduled payments, net cash flow, ending cash, and the minimum cash target. More complex businesses may benefit from integrated accounting or treasury systems.
What should a business do when a cash shortfall is forecast?
First, verify the assumptions and timing of material receipts and payments. Then evaluate realistic actions, such as improving collections, negotiating appropriate supplier terms, delaying discretionary expenditure, reducing avoidable costs, or arranging suitable financing.
The right combination depends on contractual obligations, business priorities, and the time available. Do not assume a customer will pay early or a lender will provide funds until those arrangements are confirmed.
Does positive cash flow mean the business is profitable?
Not necessarily. Cash can increase because the business borrows money, receives owner contributions, sells assets, or collects previous receivables. Profitability should be assessed using the income statement alongside cash flow and balance sheet information.
What is the most important number in a cash flow forecast?
The ending cash balance is important, but it should be evaluated against expected obligations and the minimum operating cash requirement. A company may report a positive ending balance and still face a shortfall if payments are due before the forecasted receipts arrive.
How often should a cash flow forecast be updated?
The frequency depends on volatility and liquidity risk. A company with limited reserves or unpredictable collections may need weekly updates or more frequent reviews. A stable business may use a monthly forecast with additional updates when significant changes occur.
Final Takeaway
Cash flow forecasting helps a business move from reacting to cash shortages to anticipating them.
By estimating receipts and payments on realistic dates, calculating future balances, and monitoring the difference between projected cash and the minimum operating reserve, management can identify liquidity pressure early enough to make better decisions.
Start with a reliable opening cash balance and a practical direct forecast. Include customer collections, supplier payments, payroll, taxes, debt service, and planned investments. Then compare actual results with the forecast, revise assumptions, and test downside scenarios.
A forecast cannot eliminate financial uncertainty. It can, however, make that uncertainty more visible and give decision-makers time to respond.
For a broader view of how cash is tied up in day-to-day operations, continue with Working Capital Management: How Accounts Receivable, Inventory, and Accounts Payable Affect Cash Flow.
Related Articles
Explore more from the Corporate Finance & Markets section:
- Corporate Finance Fundamentals: Financial Statements, Cash Flow, and Capital Budgeting
- The Three Financial Statements Explained
- How to Read and Analyze Financial Statements: A Practical Guide
- Income Statement vs. Cash Flow Statement
- Working Capital Management: Formula, Examples, and Strategies
Last update: 20/09/2026
Disclaimer: This article provides general educational information and is not individualized accounting, tax, legal, or investment advice.
