Cash Flow Forecasting,
line by line.

What is cash flow forecasting?

It is the discipline of estimating how much cash will move in and out of a business, and when, so that the people running it never get surprised by their own bank balance.

Why CFOs build this before almost anything else

Profitable companies run out of cash more often than unprofitable ones get caught off guard — because the profitable ones stop watching.

Cash flow forecasting matters for four overlapping reasons, and each one shows up in a different room of the business:

• Solvency. A forecast is an early warning system. It tells you three or six or thirteen weeks before a cash shortfall happens, while there's still time to act — delay a purchase, call a customer about an overdue invoice, draw on a credit line.
• Decision-making. Can the company afford to hire two more people in March? Take on a new lease? Pay a dividend? Buy the competitor's customer list? Every one of those is, underneath the strategy, a cash flow question with a yes/no answer that a forecast can give you in five minutes.
• Lender and investor confidence. Banks ask for cash flow forecasts before extending a line of credit. Investors ask for them before a funding round. A forecast that's been built carefully, and that has historically been accurate, is itself a credibility signal — it tells the other side of the table that management understands its own business.
• Working capital management. Forecasting surfaces the gap between when you pay suppliers and when customers pay you (the cash conversion cycle). Closing that gap by even a few days, across a large receivables book, can free up real cash without borrowing a cent.

Who actually uses a cash flow forecast, and for what

The same document gets read very differently depending on who's holding it, which is part of why forecasting discipline matters across an organization, not just inside the finance function.

• CFOs and finance directors use it to manage liquidity week to week, decide when to draw or repay a credit line, and time discretionary spending like bonuses or capital projects around periods of cash strength rather than cash stress.
• Accountants and controllers use it to reconcile expected versus actual cash movement, catch processing errors early (a missed invoice, a duplicate payment), and feed accurate numbers into board and lender reporting.
• Business owners, especially at smaller companies without a full finance team, use a simplified version of the same tool to answer the question that keeps them up at night: can I make payroll, and can I take the order that requires buying inventory upfront?
• Lenders and investors read a forecast to judge not just the numbers but the discipline behind them — a forecast with clear assumptions and a track record of small, well-explained variances reads very differently than one built the week before a loan application.
• Department heads in larger organizations increasingly get visibility into their own piece of the forecast — a sales leader sees how their pipeline assumptions translate into projected collections, which tends to make revenue forecasts more honest.

Direct method vs. indirect method

There are two accepted ways to build a cash flow forecast. They answer the same question but start from different places, and most finance teams end up using both, for different time horizons.

A worked indirect-method example

Say a company projects $500,000 in net income for the quarter. Depreciation and amortization for the same quarter is $40,000 — a real expense on the income statement, but not an actual cash payment, so it gets added back. Accounts receivable is projected to grow by $65,000 as sales increase, which means $65,000 of that "income" hasn't turned into cash yet, so it's subtracted. Inventory grows by $30,000 to support the higher sales, another use of cash, also subtracted. Accounts payable grows by $25,000 because the company is also taking longer to pay its own suppliers, which is a source of cash, so it's added back.

The company is profitable to the tune of $500,000, but the cash it actually generates is $470,000 — and if receivables and inventory had grown faster relative to payables, that gap could easily have flipped the sign entirely, producing negative cash flow from a profitable quarter. This is exactly the disconnect the indirect method is built to expose, and exactly why "we were profitable" is never, on its own, an answer to "did we generate cash."

In practice, most finance teams treat the two methods as complementary rather than competing: the indirect method, tied to the financial model, sets the long-range expectation for cash generation over the next several quarters or years; the direct method, rebuilt weekly from real invoices and real payment dates, tells you whether that expectation is on track right now, this month, this week.

A rule of thumb that holds up in most finance teams: the shorter the horizon, the more direct; the longer the horizon, the more indirect. A 13-week forecast is almost always built with the direct method. A 3-year strategic plan is almost always built with the indirect method off a financial model.

The 13-week cash flow forecast, explained

If there is one forecast every CFO eventually builds, it's this one. Thirteen weeks is one fiscal quarter — long enough to see trouble coming, short enough that the numbers are still grounded in things you actually know.

The 13-week cash flow forecast (sometimes called a "13-week cash flow" or "13WCF") is a rolling, weekly forecast using the direct method. Each week is a column; each cash inflow or outflow category is a row; the bottom line is the projected ending cash balance for that week. It's the model lenders ask turnaround and restructuring teams to produce first, because it's hard to hide a real problem inside thirteen weekly columns.

Why thirteen weeks, specifically?

• It matches a fiscal quarter — a natural reporting and planning unit most finance teams already think in.
• It's short enough to be accurate. Weekly granularity over a year would mean 52 columns of guesswork past week 6 or 8. Thirteen weeks keeps almost every line grounded in known invoices, signed payroll runs, and contracted payment terms.
• It's long enough to act. If week 9 shows a cash shortfall, you find out in week 1 — giving 8 weeks to fix it: collect faster, cut a cost, draw a credit line, delay a payment.
• It rolls. Every week, you drop the week that just ended and add a new week 13 weeks ahead, so the forecast is a living document, not a static report that goes stale.

Building a cash flow forecast, step by step

This is the same sequence whether you're building a 13-week direct forecast in a spreadsheet or a 3-year indirect forecast inside a financial model.

What a real template looks like, line by line

Below is a simplified but realistic 4-week excerpt of a 13-week direct-method cash flow forecast template for a small services business, with real category structure you can rebuild in a spreadsheet.

Notice three things this template makes visible that a monthly P&L never would: week 2 dips to $58,300 because a quarterly tax payment and a payroll run land in the same week — invisible if you only look at monthly totals. The business stays above its $50,000 minimum every week, but the margin in week 2 (just $8,300) is thin enough to be worth watching if any collection slips. And the swing between week 2's net outflow of −$12,650 and week 3's net inflow of $22,150 shows exactly why weekly timing — not just monthly totals — is what actually protects a business.

Five numbers every forecast should be able to produce

A good cash flow forecast isn't just a grid of numbers — it should let you answer these five questions in under a minute.

These five numbers turn a forecast from a spreadsheet exercise into a management tool. A CFO walking into a board meeting with DSO, DPO, CCC, recent variance, and minimum headroom for the next 13 weeks has, in five lines, told the board more about the company's real financial health than a page of commentary on revenue growth ever could.

Two situations where forecasting changed the outcome

Common mistakes that quietly wreck a forecast

A cash flow forecast doesn't fail loudly. It fails by being slightly wrong every week until the gap between forecast and reality is too large to act on.

• Confusing invoice date with payment date. Modeling collections on the date you invoice rather than the date customers historically actually pay overstates near-term cash and hides the real receivables gap.
• Treating monthly totals as good enough. A month can net to a healthy positive number while containing one specific week that goes deeply negative — payroll and a tax payment landing the same week is the classic case. Weekly or even daily granularity catches this; monthly totals hide it.
• Building only a base case. A forecast with no worst-case scenario tells you what you hope will happen, not what you can survive if it doesn't.
• Never comparing forecast to actuals. Without a regular variance review, you have no way to know whether your assumptions are getting better or worse over time — and no early signal when a customer's payment behavior has changed.
• Ignoring one-time and irregular items. Annual insurance renewals, quarterly tax payments, equipment leases up for renewal, bonus payouts — these get forgotten because they don't recur monthly, and they're often exactly the items large enough to cause a real shortfall.
• Letting the forecast go stale. A 13-week forecast built once and never updated is a snapshot of a quarter that's already changed. The "rolling" part isn't optional — it's the mechanism that keeps the tool honest.
• Forecasting revenue but not its cash timing. A sales forecast and a cash flow forecast are different documents. Revenue recognized this month might not become cash for 30, 60, or 90 days — modeling them as the same thing erases the exact gap the forecast exists to expose.

Most of these mistakes share a root cause: treating the forecast as a one-time report rather than a recurring habit. The businesses that get real value from cash flow forecasting are rarely the ones with the most sophisticated spreadsheet — they're the ones that update it on the same day every week, review variance honestly even when it's embarrassing, and treat a forecasted shortfall as useful information rather than bad news to quietly ignore. The forecast is only as good as the discipline behind it.

Quiz — 10 questions on cash flow forecasting

Click any question to reveal the answer and a short explanation. No signup, no scoring pressure — just a quick gut check on the concepts above.