Skip to main content
Walflow

Cash Flow Forecast: Method, Template and Month-by-Month Management

A cash flow forecast projects, month by month, the money that will come into and go out of a company’s bank account. It shows the bank balance for the months ahead and reveals, several weeks in advance, when cash is likely to run short.

A profitable company can still run out of cash. A customer paying two months late, a forgotten VAT payment or a badly timed investment is enough. A cash flow forecast turns these nasty surprises into decisions taken in time.

Access the Platform

This guide explains what a cash flow forecast is, how to structure it and how to build it in six steps. It then covers the pitfalls that distort it, scenario-based management, the levers to pull when a cash dip looms, and the choice between an Excel template and dedicated software.

Cash Flow Forecast: Method, Template and Month-by-Month Management

The Cash Flow Forecast at a Glance

  • A dated view: every receipt and every payment placed in the month it will actually hit the account.
  • A projected balance: the cash position at the end of each month, over the next twelve months.
  • A dip spotted in advance: the month the balance falls below the safety threshold, known before it happens.
  • Informed decisions: investing, hiring and negotiating financing at the right time.
  • A living tool: compared with actuals every month, then rolled forward by one month.

What Is a Cash Flow Forecast?

Definition

A cash flow forecast, also called a cash budget, is a table listing expected cash inflows and outflows, period by period, usually monthly over twelve months. Each month starts from the opening bank balance, adds receipts, deducts disbursements and gives the closing balance. That closing balance becomes the opening balance of the following month.

It deals only in actual cash flows: what arrives in the account and what leaves it, on the date it happens. An invoice issued in March but paid in May counts in May. A purchase paid in three installments counts three times.

Cash Flow Forecast, Budget and Income Statement

The income statement measures profitability: it records the year’s sales and expenses, whether paid or not. The cash flow forecast measures liquidity: it looks only at payments. The two often diverge. A sale invoiced in December boosts the year’s profit but brings in no cash until the customer pays. An investment paid upfront drains cash in one go, while it weighs on profit only through depreciation, spread over several years.

The budget sets activity and spending targets. The cash flow forecast translates them into available cash, month by month. It tells you whether the budget can be funded.

Forecasting and Tracking Actuals

The forecast projects the months ahead. Tracking actuals records what really happened. The value of the exercise lies in comparing the two: every variance explains something, a late customer, an unexpected expense, a sale brought forward. A forecast never tested against actuals quickly loses all credibility.

Why Keep a Cash Flow Forecast

Anticipate a Cash Dip Rather Than Suffer It

An overdraft discovered on the day leaves few options: paying late, asking the bank for emergency help, postponing salaries. The same dip, flagged six weeks earlier by the forecast, leaves time to chase customers, defer an expense or negotiate financing on good terms.

Decide on Investments and Hires

A new hire or a new machine is not decided on profitability alone, but also on its effect on cash. The cash flow forecast shows whether the company can absorb the expense, in which month, and with what margin. It prevents signing off a profitable investment that would push the account into the red three months later.

Talk to Your Bank and Partners

A banker who receives a well-argued cash flow forecast is more willing to grant an overdraft or a short-term loan. The forecast shows the need, its duration and how it will be repaid. It also serves with shareholders, investors and the external accountant, who read in it how well the company is run.

Withstand Late Payments

In France, payment terms between businesses may not exceed 60 days from the date the invoice is issued, or 45 days end of month if the parties have agreed so. Reality often exceeds these caps. The forecast factors in the payment times actually observed, customer by customer, and quantifies the impact of a delay before it weighs on salaries or suppliers.

The Structure of a Cash Flow Forecast

Receipts

Receipts cover customer payments first, then other inflows: capital contributions, loan drawdowns, grants, VAT refunds, asset disposals. Each line goes in the month the money actually reaches the account, not the month of the invoice or the decision.

Disbursements

Disbursements include supplier payments, salaries and social security contributions, rent and fixed costs, VAT paid over, taxes, loan repayments and investments. Annual or quarterly expenses, such as insurance or a tax, go in the exact month they are paid, not spread over the year.

Opening and Closing Monthly Balances

The closing balance is the opening balance plus receipts minus disbursements. That is the line that matters. A negative balance signals a financing need. A balance below the company’s safety threshold signals a risk.

Three-Month Cash Flow Forecast Example

Line Month 1 Month 2 Month 3
Opening balance €90M €75M -€3M
Customer receipts €150M €120M €180M
Total receipts €150M €120M €180M
Suppliers €84M €90M €87M
Salaries and social security contributions €51M €51M €51M
VAT paid over €15M €12M €9M
Rent and fixed costs €9M €9M €9M
Loan repayment €6M €6M €6M
Investment €0M €30M €0M
Total disbursements €165M €198M €162M
Closing balance €75M -€3M €15M

In this example, the company sells well and its business is healthy. Yet in the second month, a customer pays late just as a €30M investment falls due. The balance drops to -€3M. The cash flow forecast shows this three months ahead: pushing the investment back one month, or securing a deposit from a customer, is enough to stay positive.

Build Your Cash Flow Forecast in Six Steps

1. Start From the Actual Bank Balance

The starting point is the actual balance of all the company’s bank accounts on a specific date. A cash flow forecast built on an estimated balance is wrong from the first line.

2. List Expected Receipts

List the invoices already issued and still unpaid, with their due dates. Add forecast sales, applying to each the payment time actually observed with that customer, not the contractual one. A customer who always pays at 75 days must appear at 75 days, even if the invoice says 45 days end of month.

3. List Known Disbursements

Start with what is known and dated: salaries, social security contributions, rent, loan repayments, subscriptions, taxes and VAT. These lines often account for the bulk of outflows and can be forecast precisely. Remember one-off expenses: bonuses, paid leave, annual insurance, scheduled maintenance.

4. Estimate Variable Disbursements

Activity-related purchases track sales volume. Estimate them from your usual ratios, then apply the payment terms negotiated with your suppliers. A rise in sales increases purchases first, before customer cash comes in: this is the working capital requirement, often underestimated in periods of growth.

5. Calculate the Balance Month by Month

Each month’s closing balance becomes the next month’s opening balance. Spot the months when the balance falls below your safety threshold, and those when it turns negative. These are the months that call for a decision.

6. Compare Each Month With Actuals

At the end of each month, replace the forecasts with actual figures, analyze the variances and adjust the following months. Roll the forecast forward by one month to keep twelve months of visibility at all times. A cash plan kept up this way becomes more and more accurate.

The Pitfalls That Distort a Cash Flow Forecast

Confusing Revenue With Cash Received

The month’s revenue is not the month’s cash. Recording sales in the month they are invoiced rather than paid gives an overly optimistic cash position, especially for companies with long payment terms.

Forgetting VAT

Customers pay including VAT, suppliers are paid including VAT, and the VAT difference is paid over to the tax authorities on fixed dates. A cash budget built excluding VAT misses these flows, which can weigh heavily in a given month. The forecast works in amounts actually paid, so including VAT, with a dedicated line for VAT paid over.

Taking Contractual Terms at Face Value

General terms of sale set a payment term. Customers apply another one. Only each customer’s payment history tells the truth. Ignoring it artificially brings receipts forward.

Ignoring Seasonality

Many businesses have slow months and peak months: summer shutdown, year-end peak, sales season. A cash plan that spreads sales evenly over twelve months hides the strain of the weak months, which are precisely the ones to watch.

Building the Forecast Once, Then Forgetting It

A forecast drawn up to obtain a loan, then filed away, is useless three months later. Its value comes from regular updates and comparison with actuals.

One-Off Forecast Versus Managed Forecast: What Changes

Criterion One-off forecast Managed forecast
Frequency Drawn up once, for a specific need Updated every month, or even every week
Horizon Frozen at the creation date Always twelve months ahead
Receipts Based on contractual terms Based on payment times actually observed
Comparison with actuals None Systematic, with variance analysis
Scenarios Just one, often optimistic A base case and a cautious case
Safety threshold Not defined Set, with an alert when it is crossed
Use Financing application Day-to-day management of the company

Managing Cash Flow With Scenarios

The Base Case Scenario

The base case uses the most likely assumptions: expected sales, usual payment times, planned expenses. It is the benchmark for managing cash, the one compared with actuals every month.

The Cautious Scenario

The cautious scenario answers one question: what happens if things go worse than expected? Sales fall, major customers pay a month later, an unexpected expense arises. If cash holds up in this scenario, the company is well prepared. If not, the forecast shows the amount to secure and the month by which it must be in place.

The Safety Threshold

A cash budget gains from setting a threshold below which the balance must not fall. Many companies choose the equivalent of one month of fixed costs: salaries, rent, loan repayments. When a month in the forecast crosses this threshold, action is decided immediately, without waiting for the account to go overdrawn.

The Levers When the Cash Flow Forecast Signals a Dip

Speed Up Receipts

Invoice earlier, on delivery or in stages on long projects. Ask for a deposit with the order. Chase before the due date rather than after. Offer direct debit to recurring customers. These simple steps often bring receipts forward by several weeks.

Negotiate Disbursements

A supplier warned in advance is more willing to accept a payment schedule than one paid late without explanation. An investment can often be pushed back a month, or financed by a loan rather than from equity. The forecast provides the figures to back the negotiation.

Finance the Need

When the dip is structural or lasting, it needs financing. An authorized overdraft covers short, one-off needs. Selling receivables, such as factoring, turns customer invoices into cash before they fall due. A short-term loan finances an identified, repayable need. Each solution has a cost: the cash flow forecast lets you choose the cheapest one for the actual need.

Enforce Payment Terms

In France, late payment between businesses triggers late-payment penalties and a fixed €40 indemnity for recovery costs, both of which must appear on invoices. Recalling these rules, tactfully, is often enough to get a customer paying on time again.

Cash Flow Forecast: Excel Template or Software?

What an Excel Template Can Do

An Excel template is enough to get started: one column per month, one row per receipt and disbursement category, a balance calculated automatically. It suits companies with simple flows that update it rigorously. Its limits show as volume grows: manual entry of bank statements, fragile formulas, multiple versions, no alerts.

When to Switch to Software

Cash management software connects to bank accounts, retrieves and categorizes transactions, matches receipts to invoices and updates actuals without manual entry. It lets you build several scenarios and sends an alert when a threshold is crossed. The switch is justified when accounts multiply, when several people work on the forecast, or when updating it takes more than half a day a month.

The Lines Not to Forget

  • VAT paid over, in the month it falls due.
  • Social security contributions and taxes, on their payment dates.
  • Loan repayments, principal and interest.
  • Bonuses, the thirteenth-month salary and paid leave.
  • Annual insurance, taxes and subscriptions.
  • Investments and any deposits paid on them.
  • Repayments of debts and shareholder current accounts.
  • Dividends, if paid.

Frequently Asked Questions

What Is the Difference Between a Cash Flow Forecast and a Financial Forecast?

A financial forecast projects a company’s activity, profitability and financing over several years, often for a start-up or a fundraising round. The cash flow forecast is its monthly breakdown, focused on the cash coming in and going out over the next twelve months.

Over What Period Should a Cash Flow Forecast Run?

Most often over a rolling twelve months, detailed month by month. A company under pressure adds weekly tracking over the next four to eight weeks.

How Often Should It Be Updated?

At least every month, when the previous month is closed. Every week in periods of strain or rapid growth.

Should It Be Prepared Excluding or Including VAT?

Including VAT, since these are the amounts actually received and paid, with a dedicated line for VAT paid over.

Is a Cash Flow Forecast Mandatory?

It is not required for most companies, but banks and investors almost always ask for one. In France, however, commercial companies with at least 300 employees or at least €18 million in revenue excluding VAT must prepare forward-looking management documents, including a forecast financing plan.

A Cash Flow Forecast, a Decision-Making Tool

A cash flow forecast is not an accounting exercise, it is a decision-making tool. Updated every month, compared with actuals and broken down into scenarios, it gives the business leader several weeks’ head start on every cash squeeze. Cash then stops being a source of worry and becomes a variable under control.

Joseph Mersus
Article written by
Joseph Mersus
Procurement Digitalisation Consultant
Share

Also Worth Reading

See all Publications