Portfolio working-capital analytics: balances, drivers, and cash evidence

Agree the management measure before comparing companies

For this guide, operating working capital means eligible receivables plus eligible inventory less eligible operating payables. Cash, debt, and all other balances are outside this demonstration definition. Finance must specify the eligible accounts, treatment of reserves, intercompany amounts, currency, and period-end cutoff for a live implementation. This is a management analytics convention, not a definition of a transaction's working-capital target.

Use closing balances for the chosen date. A March balance plus a June balance is not the June working-capital position. When companies close on different calendars, record the actual as-of dates and whether a comparison is permitted. Missing inventory data should produce a coverage exception rather than an assumed zero; otherwise the company with the weakest submission can appear to use the least working capital.

Calculate a synthetic portfolio snapshot

Company A has $4.0 million of eligible receivables, $3.0 million of inventory, and $2.0 million of operating payables. Its working capital is $5.0 million. Company B has $1.0 million, $0.5 million, and $0.8 million respectively, producing $0.7 million. Both use the same date, currency, and agreed definition, with no intercompany balances. The portfolio closing position is $5.7 million.

Retain the company rows and source references beneath the total. A reviewer should be able to confirm whether the $0.8 million payables balance uses the same cutoff as the receivables and inventory. A dashboard refresh timestamp alone does not establish source freshness: the file can load today while describing an older period.

Explain the movement before calling it a cash release

Suppose the approved opening position was $6.8 million. Acquired balances add $0.4 million; currency translation reduces the balance by $0.1 million; a receivables write-off reduces it by $0.2 million; and independently traced eligible operating cash movements reduce it by $1.2 million. The bridge is $6.8m + $0.4m − $0.1m − $0.2m − $1.2m = $5.7m.

The balance fell by $1.1 million, but that is not the same as the $1.2 million cash-related component. Acquisition, translation, and the write-off changed the reported balance for other reasons. In a live review, require supporting records for the cash classification rather than using it as a plug. The simplified bridge excludes other working-capital categories and does not replace a complete cash-flow statement.

Add ratios only when their bases remain meaningful

A simple receivables-days approximation can be defined as closing eligible receivables divided by eligible credit sales for the selected period, multiplied by the number of days in that period. State that it uses a closing balance, not an average, and that it is a screening measure rather than an invoice-level collection history. Seasonal sales, acquisitions, and incomplete credit-sales classifications can limit the interpretation.

In a separate 90-day example, A has $4 million of receivables and $12 million of eligible credit sales: 30 days. B has $1 million and $1.5 million: 60 days. The combined measure is $5m ÷ $13.5m × 90, approximately 33.33 days, not the 45-day average of the two company ratios. A zero or missing eligible sales denominator makes the measure unavailable. Microsoft's DIVIDE function supports explicit zero-denominator handling in Power BI; the chosen business definition still needs review.

Turn a variance into a company-level action record

A receivables increase should lead to eligible invoices, aging, payment history, disputes, or source timing before someone assigns an action. Define non-overlapping aging buckets and one as-of date. Inventory review needs a similarly explicit item and location scope; payable changes need their own due-date and payment context. Keep sensitive detail limited to the people who require it for the approved review.

Record the owner, action, expected timing, source evidence, and next review date. Separate a proposed collection improvement from an observed cash movement. Compare the same population over time and explain any reclassification before crediting an initiative with a reduction. This gives the operating partner a usable follow-up path without turning a balance change into an unsupported benefit claim.

• Approve eligible balance accounts, reserves, currency, and cutoffs.
• Show one closing snapshot; never sum balances across displayed periods.
• Retain missing-source and stale-period exceptions beside the total.
• Bridge acquisition, currency, adjustments, and supported cash movements separately.
• Calculate portfolio ratios from compatible aggregate inputs.
• Use non-overlapping aging buckets and trace actions to source records.
• Confirm realized cash evidence with finance before reporting an initiative benefit.

Primary sources

• Microsoft: DAX DIVIDE and zero-denominator behavior

Related services and experience

• Portfolio performance analytics (Implementation service)
• Private equity analytics toolkit (Ungated methods and synthetic evidence)
• Portfolio operations dashboard (Synthetic evidence first published 2026-09-09)
• Private equity portfolio analytics (Industry practice)