Working Capital Forecasting: Why the P&L Can Be Right and Cash Still Be Wrong

The P&L can be almost exactly on forecast while cash quietly goes somewhere else.

Revenue lands. Margin holds. Operating expenses behave.

Then the CFO looks at the bank balance.

This is usually the moment working capital gets invited to the forecast.

Profit tells you what the business earned. Working capital tells you how much of it has actually turned into cash.

Start with the balance sheet lines that actually move cash

I would not begin by forecasting every balance sheet account with equal enthusiasm.

For most operating businesses, the useful starting point is accounts receivable, accounts payable and inventory where inventory matters.

Those balances have operating behavior behind them.

Customers take time to pay. Vendors have terms. Inventory is purchased before it is sold.

The forecast should connect those behaviors to the P&L rather than treating the balance sheet as a collection of plugs.

Accounts receivable is not just DSO

Days sales outstanding is useful. It is also an average.

If one large customer moves from 30-day payment behavior to 75 days, the average may take a while to tell the story.

I like looking at DSO alongside the aging and the actual customer mix.

For a simple forecast, a DSO assumption tied to revenue may be enough. For a concentrated customer base, I may want more detail around the largest receivables.

The right level depends on what can materially change cash.

That is the same principle behind a good 13-week cash forecast: detail should follow decision relevance.

Accounts payable contains management choices

AP is not merely the mathematical opposite of AR.

Payment timing can reflect vendor terms, purchasing patterns, cash management and sometimes stress.

A rising payable balance might mean the business negotiated better terms.

It might also mean invoices are piling up.

The financial effect looks similar for a while.

That is why I want the forecast assumption connected to what the company actually expects to pay and when, not just a historical DPO number copied forward forever.

Inventory can make a profitable growth plan expensive

Inventory businesses get the most obvious lesson.

Growth may require buying product weeks or months before the related revenue arrives.

A revenue forecast that increases 25% can therefore create a cash requirement well before the income statement celebrates the growth.

Forecasting inventory as a flat percentage of sales may be reasonable at a high level, but purchasing lead times, safety stock and seasonality can matter more than the annual ratio.

The operating plan should tell Finance when inventory needs to be funded.

Do not hide working capital inside the cash plug

A three-statement model will technically balance if cash is the plug.

That does not mean the cash forecast is useful.

If receivables, payables and inventory are poorly modeled, the plug simply absorbs the error.

I want to be able to explain why cash changed.

Collections slowed. Inventory was purchased ahead of peak season. Vendor terms improved. A large annual payment moved.

Those explanations are useful because management can do something with them.

Forecast the change, then test the story

Working capital forecasts are full of ratios that can look reasonable individually and produce a strange business collectively.

If revenue is accelerating, DSO is improving, inventory days are falling and DPO is extending all at once, the model may be forecasting an unusually generous universe.

Possible. But worth challenging.

I like a scenario around the assumptions that matter most.

What happens if customers pay ten days slower? What if inventory needs increase before a launch? What if a major vendor shortens terms?

Small changes in working-capital days can create large cash movements at scale.

The P&L forecast and cash forecast should talk to each other

This sounds obvious until you see a company maintain them in separate files with separate assumptions.

Revenue should feed receivables and collections. Expenses and purchasing should inform payables. Headcount and payroll timing should appear consistently. Capital spending should not materialize in one model and disappear from another.

Integrated does not necessarily mean one enormous workbook.

It means the assumptions reconcile.

Working capital is where operational discipline becomes financial

Finance can calculate DSO perfectly and still not collect an invoice.

The useful conversation happens with the people who own billing, collections, purchasing, inventory and vendor relationships.

That is where the forecast becomes more than a finance exercise.

A cash shortfall caused by slower collections is different from one caused by weaker margin. One may need a collections response. The other may need a pricing or cost response.

The bank account only shows the ending.

Working capital helps explain the route.