A procurement capital forecast estimates when planned inventory buying may require cash. It is useful for owners, purchasing leads and finance teams when supplier commitments, seasonal purchases and customer collections occur at different times.
Keep three dates distinct: the purchase commitment, physical receipt and cash payment. Separately, finance determines when inventory cost becomes an expense. A purchase forecast is one input to a cash plan; it is not the bank balance or a complete financial statement.
Begin with the commitments already made
List open orders and invoices before estimating future replenishment. For each, record the supplier, amount, currency, delivery expectation, deposits, unpaid balance and agreed payment-date basis. Mark estimates and unresolved changes clearly.
Avoid counting an open PO again when its invoice enters the model. Likewise, do not add the same planned buy through both an item simulation and a historical-spend estimate. Compare the two views or explicitly choose how they are combined.
Payment terms need a starting event
“Net 30” is incomplete without the agreed starting event. The terms may run from invoice date, receipt or another contractual event; payment on order and deposits behave differently.
For an illustrative $6,000 order placed October 1:
| Event | Example timing | Cash effect |
|---|---|---|
| PO approved | October 1 | Commitment recorded; no payment assumed |
| Goods and invoice received | October 15 | Invoice enters the payable schedule |
| Payment due under 30 days from invoice | November 14 | $6,000 expected outflow |
| Goods sold | November and December | Cost recognition follows the applicable accounting policy |
This is a timing example, not a rule for every supplier. If a 50% deposit is due on October 1, model $3,000 then and only the remaining $3,000 on the final due date.
Under IAS 2, for example, inventory costs and the recognition of the carrying amount as expense when goods are sold are distinct from the cash-payment date. Finance should apply the accounting framework and policy relevant to the business. IFRS IAS 2.
Estimate future purchases with explicit assumptions
An item-level plan needs usable stock, expected consumption, timely incoming orders, supplier lead time, order cadence, pack sizes, minimums and cost. Perishables also need actual lot-life and waste information; modeled decay does not establish safety or permission to use an item.
A historical-spend view can provide a comparison using prior purchases, known changes and seasonal patterns. Distinguish order-date spend from actual cash payments. Short history, stockouts, promotions, a new location or a changed product mix can make a historical average misleading.
If an item simulation suggests $18,000 of October buying and the historical view suggests $11,000, investigate the $7,000 difference. It is not evidence that either method is automatically better.
For a simple monthly baseline, a seasonality multiplier can be that month's comparable historical value divided by average monthly value. Do not substitute month-over-month growth ratios or an annual share without the appropriate normalization. With limited history, label assumptions as assumptions and test a range.
Build a cash bridge
A useful manual table starts with reconciled opening cash and separates customer collections from recognized revenue:
Closing cash = Opening cash + Cash collections + Financing inflows
− Supplier payments − Payroll − Taxes − Other cash outflows
Include debt service, capital spending, owner distributions and other material flows where relevant. A buying-only model that excludes those items cannot establish overall runway.
Compare a base case with plausible changes: sales collections arrive later, a supplier requires prepayment, input cost rises, or an order must be expedited. Record the action owner if cash falls below the business's chosen minimum.
Use purchasing records in your finance forecast
LineNow's Capital dashboard has been retired. Use purchasing records, supplier confirmations and receiving evidence to reconcile open commitments in the cash forecast maintained by your finance team.
Review one open PO, one deposit, one invoice with a known due date and one future reorder. Keep planned buying, invoice due dates and actual payments separate, and confirm which system owns each record.
Treat inventory cash and recurring savings differently
Inventory value is not always cash already paid: some stock may still be financed by supplier payables. Nor is every unit immediately convertible to its recorded value.
If usable inventory falls from $40,000 to $35,000 while service remains acceptable, the $5,000 reduction may release working capital once purchases and payments adjust. It is a one-time change in the investment, not $5,000 of recurring annual profit. At an illustrative 8% annual financing cost, sustaining that reduction could avoid $400 a year of financing cost, subject to actual borrowing and timing.
Do not reduce critical safety stock simply to make a forecast positive. Evaluate availability, alternatives, expiry and supplier reliability alongside cash. The procurement ROI worksheet and KPI guide keep those decisions and measures separate.