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
| Direct | Indirect | Driver-based | |
|---|---|---|---|
| Starts with | Expected receipts and payments | Forecast net income | Operating drivers |
| Best horizon | 1 to 13 weeks | 3 to 24 months | 3 months to several years |
| Detail | Invoice and bill level | Statement line level | Driver level |
| Effort | High per update | Moderate | High to build, low to update |
| Strength | Accuracy, actionability | Links to financial plan | Scenario testing |
| Weakness | Hard beyond a quarter | Hides timing | Needs 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.
| Driver | Value | Result |
|---|---|---|
| Monthly revenue | 4,000 × $50 | $200,000 |
| Monthly cost of goods | 4,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 capital | 300,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.
| Question | Method | How it answers |
|---|---|---|
| Can we pay the supplier invoice of $45,000 due on the 28th? | Direct | Lists 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? | Indirect | Starts 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-based | Raises 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.
| Layer | Horizon | Method | Used for |
|---|---|---|---|
| Weeks 1 to 13 | Quarter | Direct | Liquidity, payroll, covenant compliance |
| Months 4 to 12 | Year | Indirect, informed by drivers | Budget, financing, board |
| Years 2 to 3 | Strategy | Driver-based | Growth 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.
- 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.
- 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.
- 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.
Keep reading
- Complete guide: Cash Flow Management: The Complete Guide for Growing Businesses
- Cash Flow Forecasting for Seasonal Businesses
- Cash Flow Scenario Planning: Base, Downside, and Upside Cases
- How to Build a Cash Flow Forecast You'll Actually Use
- Related topic: Demand Planning and Inventory Optimization: The Complete Guide
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.