Cash flow forecasting: methods, templates and an example

Cash flow forecasting is projecting the company's bank balance forward: start from today's cash, add expected receipts and subtract expected payments on the dates money actually moves, so the owner can see the low points before they arrive. A company can be profitable and still run short of cash: customers pay late, an annual insurance bill lands, three hires start in the same month. A cash flow forecast turns those timing problems into dates and amounts that can be managed.

What is a cash flow forecast?

A cash flow forecast is a projection of the company's bank balance over a future period. It starts with the cash on hand today, adds expected receipts, subtracts expected payments, and shows the ending balance for each week or month.

Its job is narrow and practical: answer "will there be enough cash, and when is it tightest?" Everything in it is measured on the date money actually moves, not when revenue is earned or an expense is incurred.

How it differs from a budget, a P&L forecast and a cash flow statement

These four documents get confused often, and they answer different questions.

The budget and P&L forecast tell the owner whether the business makes money. The cash flow forecast tells them whether it can pay its bills while it does. Comparing results against the budget is covered in budget vs actual.

Forecast horizons: which cash flow forecast for which job

There is no single right horizon. Most growing companies benefit from two views running side by side.

The 13-week forecast is the short-term, weekly tool. It is detailed enough to show that a large customer payment due in week 6 is the difference between a comfortable month and a tight one. The full weekly method is in the guide to the 13-week cash flow forecast.

The 12 to 18 month monthly forecast is where runway lives. It answers how long current cash lasts under the hiring plan, and when the company needs new capital. The calculation itself is covered in burn rate and runway. Many companies run this as a rolling forecast, adding a month at the far end each time a month closes.

Longer-range models are planning tools, not cash management tools. They matter for fundraising and strategy, but nobody should manage payroll from a five-year model.

Direct vs indirect cash flow forecasting

There are two ways to build the numbers.

The direct method lists actual receipts and payments by category: collections from customers, payroll, rent, vendor payments, taxes, debt service. It is intuitive, it maps to the bank statement, and it is the standard for short-term forecasts. Its weakness is that it gets laborious beyond a few months.

The indirect method starts from forecast net income and adjusts for non-cash items (depreciation, stock compensation) and changes in working capital (receivables, payables, deferred revenue), then adds investing and financing flows. It mirrors the cash flow statement and links naturally to a three-statement model. Its weakness is that it is harder to explain to a non-finance reader and hides timing detail.

A sensible rule: use the direct method for the 13-week view and for owner-facing monthly forecasts; use the indirect method when the monthly forecast is part of an integrated operating model with a balance sheet. Whichever is used, the two should reconcile to the same ending cash.

The building blocks of a cash flow forecast model

Every cash flow forecast model, from a one-tab spreadsheet to a full integrated model, has the same parts.

• Opening cash. The actual bank balance on the start date, across all accounts. It should tie to the bank statement exactly.
• Receipts. Customer collections, forecast by customer or customer group and by when they actually pay, not by invoice date. Large customers deserve their own line. Add other inflows such as tax refunds or asset sales separately.
• Payroll. Salaries, payroll taxes, benefits and commissions, on actual pay dates. Include planned hires from their start dates; the headcount plan should drive this line.
• Vendors and rent. Software, contractors, professional fees and rent, based on payment terms. Annual and quarterly bills belong in the month they are paid.
• Taxes. Estimated income tax payments, sales tax remittances and other tax deadlines. The company's CPA should confirm the amounts and dates.
• Debt service. Interest and principal, including when an interest-only period ends.
• Capital expenditure. Equipment, buildouts, capitalized software.
• Financing. New equity or loan draws, shown separately and only when committed.
• Ending cash and minimum cash. Ending cash for each period, compared with the minimum the business must hold, including any lender covenant.

How to forecast cash flow, step by step

1. Pick the horizon and period. Weekly for 13 weeks, monthly for 12 to 18 months, or both.
2. Set opening cash from the bank, not from books that lag.
3. Forecast receipts from the receivables aging and the pipeline. Start with open invoices and when each customer historically pays. Then add new invoicing from the revenue plan, delayed by realistic collection terms.
4. Forecast payroll from the headcount plan, on pay dates.
5. Forecast vendor payments: open bills, then recurring spend, then one-off and annual payments.
6. Add taxes, debt service and capex, the lumpy items that cause surprises.
7. Add committed financing only: a signed loan, not a round in conversation.
8. Calculate ending cash and find the lowest point against the minimum.
9. Build a downside case. See the next section.
10. Update on a fixed rhythm and compare to actuals. Weekly for the 13-week view, monthly for the longer one. Note what was wrong and why, and fix the assumption, not just the number.

Scenarios: base case and downside

One set of numbers hides how wide the range of outcomes really is. Build at least a base case, reflecting the current operating plan, and a downside case. Three things are worth stressing first:

• Collections timing. Push receipts out by 15 or 30 days, or lower the collection rate. In practice, collections timing is the input that most often makes a cash flow forecast wrong.
• A large customer. Model the largest customer paying 60 days late, or not renewing. If one customer is a large share of receipts, this scenario matters more than any other.
• Hiring. Show the cash effect of the hiring plan as approved, and of pausing it. Hires are the easiest commitment to make and the hardest to reverse.

Run the business against the downside numbers. If that case breaches the minimum cash level, act now, while there are still options.

A cash flow forecast example

A fictional recurring-revenue business with a $500K minimum cash covenant on its bank loan. Six months, direct method, figures in $K; for a fuller version with every line explained, see the monthly cash flow forecast example.

Illustrative figures, not client data.

Two hires start in month 3, which also carries a one-off equipment purchase. The base case never comes close to the $500K covenant; the low point is $1,030K in month 4.

Now the downside: collections come in $80K a month lower from month 2 onward, perhaps because a large customer moves to slower payment.

Illustrative figures, not client data.

In the downside, the business is still above its covenant at month 6, but headroom has fallen from $730K to $140K and is still shrinking. That is the signal to act early: tighten collections on the slow customer, delay the next hire, or arrange a credit line while the numbers still look healthy.

What to look for in a cash flow forecast template

A good cash flow forecast template saves time, but only if it is built around how cash actually moves. Whether it is a free download or a paid tool, check that it has:

• Separate opening cash, receipts, disbursements and ending cash, with ending cash rolling into next period's opening cash automatically.
• Receipts by customer or group, not one revenue line.
• Room for lumpy items: taxes, annual bills, debt service, capex.
• A minimum cash line so the low point is visible at a glance.
• Actual vs forecast columns so accuracy can be tracked.
• Clear inputs and formulas, with assumptions in one place.

Excel vs software

A cash flow forecast template in Excel or Google Sheets is flexible, transparent and free, and it is how most growing companies should start. Its weaknesses are manual updates and formula errors as it grows. Forecasting software connects to the accounting system and bank feeds and saves update time, but it can hide assumptions and does not replace judgment about when customers will pay; the trade-offs are covered in FP&A software. A spreadsheet the owner understands beats software nobody checks.

Decipher's free template covers the short-term weekly view: a 13-week direct-method forecast with receipts, disbursements, minimum cash and actual vs forecast tracking, built step by step in the 13-week cash flow forecast guide. It is not a 12 to 18 month model. See what the 13-week template includes, or get the free 13-week cash flow forecast template.

Common mistakes

• Forecasting revenue instead of collections. Invoices are not cash until customers pay.
• Missing lumpy payments such as annual renewals, insurance, estimated taxes and bonus payouts.
• Counting financing before it closes. A term sheet is not cash.
• Ignoring restricted cash and covenants. Cash the company cannot use is not runway.

How an investor or lender reads your cash flow forecast

Decipher sets up a company's finance the way an investor, lender or acquirer will read it. On a cash flow forecast, they tend to check the same things.

• Does opening cash tie to the bank? It is the first number checked, and a mismatch undermines everything after it.
• What is the lowest point, against what minimum? Lenders focus on the low point relative to any minimum cash covenant, and on whether all debt service is included.
• How accurate have past forecasts been? A record of small, explained misses builds more trust than a polished new forecast.
• Does it match the P&L and the plan? Hiring, revenue growth and capex should agree with the operating plan and board materials.

For the weekly version of this checklist, see how a reader checks a 13-week forecast. For help building forecasts that hold up in front of a board, a lender or a buyer, see Decipher's FP&A services.