Skip to content

Cash Flow Forecasting Methods: Direct, Indirect, and Driver-Based

By Newtown Analytics · · 8 min read

For finance, fp&a & accounting managers

Cash flow forecasting methods fall into three families: the direct method, which forecasts actual receipts and payments; the indirect method, which starts from projected profit and adjusts to cash; and driver-based forecasting, which builds cash from operational variables such as units sold and collection days. Each fits a different horizon and question, and most companies use more than one. This comparison helps you choose, as part of cash flow management.

The three methods at a glance

DirectIndirectDriver-based
Starts withExpected receipts and paymentsForecast net incomeOperating drivers
Best horizon1 to 13 weeks3 to 24 months3 months to several years
DetailInvoice and bill levelStatement line levelDriver level
EffortHigh per updateModerateHigh to build, low to update
StrengthAccuracy, actionabilityLinks to financial planScenario testing
WeaknessHard beyond a quarterHides timingNeeds good driver data

Direct method

The direct method lists the cash you expect to receive and pay in each period, usually weekly. Receipts come from the receivables aging and the sales pipeline, and payments from payroll, payables, tax and debt schedules.

Example (one week). Customer receipts of $52,000, supplier payments of $31,000, payroll of $24,500 and rent of $6,000 produce a net of -$9,500. Opening cash of $60,000 therefore ends the week at $50,500.

When it works best. Short-term liquidity management, covenant monitoring, payroll protection and any time you must know whether a specific payment can be made.

Limits. It requires clean invoice and bill data and regular updates. Beyond 13 weeks, the detail is unreliable and the effort is not worthwhile. The construction process is laid out in how to build a cash flow forecast and the 13-week cash flow forecast.

Indirect method

The indirect method begins with forecast net income from the budget or financial model and converts it to cash using projected balance sheet changes: add depreciation, subtract growth in receivables and inventory, add growth in payables, subtract capital spending and debt repayment.

Example (one quarter). Forecast net income is $90,000, depreciation $15,000, receivables are expected to grow $40,000, inventory $30,000, payables $20,000, capital spending is $25,000 and loan repayment is $10,000.

Net cash flow = 90,000 + 15,000 - 40,000 - 30,000 + 20,000 - 25,000 - 10,000 = 20,000

When it works best. Medium-term planning, annual budgets, financing requests and board reporting, where the cash forecast must tie to the profit forecast and balance sheet.

Limits. It works on monthly or quarterly totals, so it misses intra-month timing, such as a payroll week with low cash. It also depends on the quality of the working capital assumptions, which are often the weakest part of the model.

Driver-based method

Driver-based forecasting models cash from the operating variables that produce it. For a product company, those drivers include units sold, price, purchase lead time, days to collect and days to pay. The model derives revenue, receivables, inventory, payables and cash from the drivers, so changing a driver updates everything.

Example (one month). Assume the company sells 4,000 units at $50, collects in 45 days, buys inventory at $28 per unit with 30-day supplier terms, and holds 60 days of inventory.

DriverValueResult
Monthly revenue4,000 × $50$200,000
Monthly cost of goods4,000 × $28$112,000
Receivables at 45 days$200,000 × 45/30$300,000
Inventory at 60 days of cost$112,000 × 60/30$224,000
Payables at 30 days of cost$112,000 × 30/30$112,000
Net working capital300,000 + 224,000 - 112,000$412,000

If unit sales rise 10 percent to 4,400, every line scales: working capital grows to about $453,200, an increase of $41,200 that must be funded before the extra profit arrives. If collections slip five days, receivables rise by $33,333 on the original volume. The driver view shows which operating levers matter, and how much cash each requires.

When it works best. Scenario analysis, growth planning, financing decisions and any case where operations and finance must agree on assumptions. It is especially valuable for product businesses where inventory is a large cash driver.

Limits. It needs reliable driver data and discipline in keeping drivers current. A poorly specified model can be precise and wrong.

One company, three methods

To see how the methods differ, take a hypothetical company with $2.4 million of annual revenue and ask each method a different question.

QuestionMethodHow it answers
Can we pay the supplier invoice of $45,000 due on the 28th?DirectLists receipts and payments by week, showing a projected balance of $58,000 on the 27th
Will we stay within our loan covenant at year-end?IndirectStarts from budgeted net income, adjusts for working capital, and shows year-end cash of $310,000 against a $250,000 covenant
What happens to cash if we add a new retail account that grows sales 20 percent?Driver-basedRaises units sold, receivables and inventory, and shows the account needs about $95,000 of extra working capital before it generates cash

The numbers are illustrative, but the pattern is real. No single method answers all three questions well. Direct is too detailed for the covenant question, indirect is too coarse for the supplier question, and neither explains the growth question as clearly as the driver model.

Choosing between methods when data is poor

Data quality often decides the method more than theory does. If your receivables ledger is incomplete or bills are entered late, a direct forecast will be wrong in every week. In that case, fix the data first, or use the indirect method as a temporary view while you clean the sub-ledgers. If you cannot define the drivers, such as true days to collect by customer, start with a simpler method and gather the data for the driver model over a few months.

A practical test is to check how well last month's forecast matched actuals under each method. A method that cannot beat a simple "same as last month" rule is not ready to use for decisions.

Seasonality and the choice of method

Seasonal businesses stress every method. Direct forecasts must capture the timing of pre-season inventory buys. Indirect forecasts need monthly rather than quarterly working capital assumptions. Driver models need seasonal indexes for sales and inventory. The details are in cash flow forecasting for seasonal businesses.

Combining the methods

The strongest forecasting setups layer the three.

LayerHorizonMethodUsed for
Weeks 1 to 13QuarterDirectLiquidity, payroll, covenant compliance
Months 4 to 12YearIndirect, informed by driversBudget, financing, board
Years 2 to 3StrategyDriver-basedGrowth plans, capital needs

Reconcile the layers. The first 13 weeks of the direct forecast should roughly match the first three months of the indirect forecast. Differences point to timing assumptions that need attention. Also, run scenarios in the driver model and feed the resulting cash needs into the planning process, a method developed in cash flow scenario planning.

How to choose

Ask three questions.

  1. What decision will this forecast support? Paying bills next week requires direct detail. Negotiating a credit facility requires a 12-month view that ties to the budget. Testing a growth plan requires drivers.
  2. How much data and time do you have? If you have clean invoice and bill data, direct is feasible. If you have a strong financial model, indirect is a short step. If your operations are data-rich, drivers are powerful.
  3. How volatile is the business? The more uncertain the environment, the more you need frequent, short-horizon updates and scenario thinking.

For a small business, start with direct. Add an indirect view once you have a budget. Add drivers when inventory or growth makes working capital the central issue.

Common mistakes

  • Using the indirect method for short-term decisions. Monthly totals mask payroll-week shortfalls.
  • Using the direct method for annual planning. The detail cannot be maintained and adds false precision.
  • Driver models with stale drivers. Update collection days, lead times and sales assumptions regularly. Check them against actuals.
  • Not reconciling methods. If layers disagree, find out why before relying on either.
  • Ignoring the link to operations. For companies that buy and sell goods, the demand forecast determines purchases, which determine cash. The relationship between planning and cash is explained in demand planning and inventory optimization.

Practical next steps

If you have no forecast, build a direct 13-week view first using the template. If you have a budget, derive an indirect cash projection from it. If working capital is your main challenge, build a simple driver model with the five drivers in the table above and use it to size the cash cost of growth. Measure all three against actuals, and improve the one that matters most for your decisions.

FAQs

Which cash flow forecasting method is most accurate?

The direct method is usually the most accurate for the near term because it uses specific invoices and bills. Accuracy declines with distance for all methods. Match the method to the horizon.

Can I use more than one method?

Yes, and most companies should. Use direct for the next 13 weeks and indirect or driver-based for longer horizons, and reconcile them.

Is the indirect method suitable for small businesses?

It can be, if you already prepare a budget or projected income statement. For liquidity management, a small business should add a short-term direct forecast.

What is driver-based forecasting?

It models cash and working capital from operational drivers such as units sold, price, collection days, inventory days and payment terms. Changing a driver updates the forecast.

How do I know which method to start with?

Start with the decision you must make. If you need to know whether you can cover next month's obligations, start with direct. If you need a financing plan, start with indirect. If you want to test growth scenarios, start with drivers.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.