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.

Growth is where working capital surprises people

One of the stranger experiences in finance is watching a company celebrate growth while cash gets tighter.

There is nothing contradictory about it.

If customers pay after the company has already paid employees and vendors, faster growth can require more cash before it produces more cash.

Add inventory and the effect can become even more dramatic.

This is why I get nervous when a growth plan forecasts the P&L beautifully and assumes working capital will somehow maintain the same dollar balance.

Revenue growth changes the size of the operating machine.

The balance sheet usually notices.

DSO is a useful summary, not a collections strategy

I use DSO. I just do not want it doing work it cannot do.

An average can hide concentration.

If most customers pay in 30 days and one enormous customer has moved to 90, the cash risk may be much more important than the headline DSO suggests.

I like combining the ratio with aging, customer concentration and known collection issues.

For a diversified business, a simple DSO-based forecast may be enough.

For a business where three customers represent half of receivables, I want to know those three customers.

Materiality should decide the detail.

Billing timing belongs in the forecast too

Collections cannot happen before billing.

Obvious sentence. Surprisingly useful reminder.

A company can have reasonable payment behavior and still create cash delays because invoices go out late, milestones are disputed, paperwork is incomplete or billing waits for someone’s approval.

If Finance assumes “Net 30” from the revenue date while the invoice routinely goes out ten days later, the forecast has invented ten days of cash.

I want the collection curve to reflect the actual process, not just the contractual terms.

Payables can improve cash for good reasons and bad ones

Extending vendor terms can be smart working-capital management.

Simply paying everyone late is something else.

The balance sheet may look similar for a while.

The operational consequences do not.

I want to know whether DPO improved because Procurement negotiated terms, because the purchasing mix changed, or because cash is tight and invoices are aging.

If the forecast assumes longer payment timing, it should be an intentional assumption management understands.

Vendor relationships are part of the cost.

Inventory days need an operating explanation

Inventory ratios can create a wonderfully smooth model for a very lumpy reality.

Purchasing lead times, minimum order quantities, safety stock, seasonality and new product launches all matter.

A company may need to buy inventory months before a peak selling period.

That means the cash requirement arrives before the revenue forecast looks exciting.

I want Finance talking with the people who actually plan purchasing.

A historical inventory-days assumption is useful until the operating plan stops resembling history.

Deferred revenue and prepayments can reverse the usual story

Not every business funds customers before getting paid.

Subscription, membership or project businesses may collect cash before recognizing revenue.

That can make growth cash-generative in ways the P&L does not immediately show.

But the same principle applies: model the actual operating terms.

If renewal timing changes, annual prepayments shift to monthly, or customers negotiate different billing terms, cash can change even when revenue recognition remains similar.

Working capital is really about timing relationships.

The specific accounts depend on the business.

A ten-day change can be a very large number

This is where working-capital scenarios become useful.

Suppose a company produces $120 million of annual credit sales.

Very roughly, ten additional days of receivables can represent more than $3 million of cash tied up, depending on the business and timing.

That is why I do not dismiss a few days of DSO as accounting trivia.

At scale, days become dollars quickly.

The same logic applies to inventory and payables.

Small operational timing changes can create financial movements large enough to alter hiring, borrowing or investment decisions.

Working capital should have owners outside Finance

Finance can calculate the ratios.

Sales and billing may influence invoicing. Collections teams influence follow-up. Operations and Procurement influence inventory and purchasing. Business leaders influence contract terms.

If working capital deteriorates, I want the conversation with the process owner, not only the spreadsheet owner.

This is one reason cash forecasting can be such a useful management process.

It exposes operational behavior in financial terms.

“DSO worsened” is Finance language.

“Our largest customers are paying two weeks later because implementation sign-off is delayed” is something management can act on.

Actual versus forecast needs a cash bridge

If ending cash misses by $2 million, I do not want “working capital” as the entire explanation.

Break it down.

Collections were $1.1 million slower. Inventory purchases were $600,000 earlier. Vendor payments were $300,000 higher.

Now we can ask whether those are timing movements or changes in the underlying outlook.

The bridge also teaches Finance where the model is weak.

If collections miss every month, perhaps the collection assumption needs work.

If inventory is repeatedly early, perhaps purchasing data belongs in the process sooner.

Do not confuse a working-capital release with operating improvement

A company can create a strong quarter of cash by collecting old receivables, reducing inventory or stretching payables.

That can be excellent management.

It can also be temporary.

I want to distinguish sustainable operating cash generation from a one-time release of balance-sheet investment.

If inventory has been reduced to the minimum safe level, we cannot assume the same reduction next quarter.

If overdue receivables were collected, those dollars do not exist to collect again.

Cash flow deserves the same skepticism Finance applies to one-time P&L items.

The forecast should make the cash consequence of growth visible

This is ultimately what I want from working-capital forecasting.

If management wants 25% growth, what does that require before the cash arrives?

How much receivables investment? How much inventory? What vendor support? What happens if collections slow while growth accelerates?

A growth plan is incomplete if it answers only whether the company can sell the revenue.

I also want to know whether the company can finance the path to collecting it.

The P&L can be right.

The business can even be healthy.

And the bank account can still have a completely different opinion.

Working capital also belongs in scenario planning

Revenue downside scenarios often assume cash simply follows the lower P&L.

Sometimes it does not.

Customers may pay slower in a weak environment. Inventory may not fall as quickly as sales. Vendors may tighten terms. A business can therefore experience both weaker earnings and worse working-capital behavior at the same time.

I like stress-testing those relationships when liquidity matters.

What happens if revenue misses and DSO adds ten days? What if inventory takes a quarter longer to normalize? What if a major supplier requires faster payment?

Those combinations are where a comfortable cash plan can become uncomfortable quickly.

The balance sheet deserves a seat in the forecast meeting

Finance meetings naturally gravitate toward the P&L.

Revenue, margin and OpEx are intuitive. The balance sheet feels quieter.

Until cash is wrong.

I like bringing the few working-capital measures that actually matter into the regular forecast conversation.

Not twenty ratios.

The important ones.

If DSO is moving, talk about it. If inventory is building, understand why. If payables are stretching, know whether that is intentional.

The balance sheet should not become interesting only after the bank balance gets everyone’s attention.

By then it has usually been trying to tell us something for a while.