Group Working Capital Analysis: What It Adds to Entity-Level Reporting

Executive summary

• Entity-level KPIs show how each business is performing; group working capital analysis shows which issues have the largest cash impact across the portfolio.
• Intragroup receivables and payables can distort standalone working-capital metrics, so the consolidated view should isolate exposure to external parties.
• A group working-capital bridge separates operating deterioration from growth, FX, acquisitions, disposals, and changes in business mix.
• Subsidiary comparisons only work when finance applies one definition for DSO, DPO, inventory days, provisions, and the underlying revenue or COGS base.
• Converting each KPI gap into currency lets management rank working-capital actions by cash-release potential rather than by the weakest headline ratio.

A CFO asked each subsidiary to identify its largest working-capital opportunity. One business stood out: its DSO was fifteen days above target, and management started discussing collection escalation and tighter credit control. Another subsidiary sat only three days above target and drew little attention.

The second subsidiary was five times larger.

When finance converted both gaps into cash, the ranking changed. Three days of DSO improvement in the larger entity released more cash than fifteen days in the weaker one. Group working capital analysis adds this second layer to entity reporting: it shows how much each issue matters to the group, where the movement comes from, and which action deserves management time first.

What group working capital analysis removes first

Standalone working capital includes balances between entities in the same group. Shared services may invoice operating companies, a distribution entity may owe manufacturing, and treasury or tax policies may determine the terms. Those balances affect entity-level receivables, payables, DSO, and DPO even though the obligation stays inside the group.

A subsidiary can therefore show a large receivable balance that creates no external cash exposure for the holding company. Another may appear well funded because it carries large intercompany payables while third-party customer collections deteriorate. The consolidated view removes those internal balances and leaves the receivables, payables, and inventory tied to parties outside the perimeter.

Finance needs that split before comparing entities. Group-level targets should focus on capital committed to customers, suppliers, and inventory, with internal funding and settlement structures analyzed separately.

How group working capital analysis separates operating movement from structural movement

A year-on-year increase in working capital does not automatically mean operating discipline weakened. Revenue growth raises receivables and inventory. Acquisitions add balances when they enter the perimeter. FX translation changes reported values in the presentation currency. Business mix can shift toward entities with longer customer terms or heavier inventory requirements.

Assume group working capital rises by AED 14 million. A newly acquired subsidiary adds AED 9 million, FX translation adds AED 3 million, and revenue growth at unchanged days adds AED 4 million. The remaining movement is an AED 2 million operational improvement.

A simple variance table shows an AED 14 million deterioration. A working-capital bridge shows that operating teams released AED 2 million despite the larger reported balance. Management can then discuss acquisition funding, currency effects, and operating execution separately.

Finance should build this bridge before using group working capital as an operating scorecard. The same logic applies to disposals, seasonality, perimeter changes, and material shifts in product or customer mix.

Five subsidiaries can report five different DSOs

Group comparisons fail when entities calculate the same KPI differently. One subsidiary may use gross revenue including VAT, another may exclude it. One may use a three-month average, another a countback method. Contract assets, provisions, or overdue intercompany balances may sit inside the calculation in one entity and outside it in another.

The group needs one calculation basis. Finance should define the numerator, denominator, period basis, treatment of VAT, provisions and contract assets, FX convention, and the revenue or COGS base used for each metric. It should then calculate the KPI from standardized entity data rather than rely on locally submitted ratios.

A ten-day DSO gap only has meaning when both entities reach their DSO through the same method.

Is the problem concentrated or group-wide?

Once the group position is clean, finance can rank each entity by its contribution to the movement in currency. This shows whether the issue sits in one business or reflects a broader operating pattern.

Suppose group receivables rise by AED 8 million. If one subsidiary explains AED 5.6 million, management has a targeted problem to investigate. Finance can review that entity’s customer mix, overdue balances, billing delays, disputes, and collection ownership.

The response changes when eleven of fifteen subsidiaries move in the same direction. Finance should then look for a common driver: a centrally approved payment-term change, a customer mix shift, supplier renegotiation, demand slowdown, or an inventory policy that affected the portfolio.

Local explanations can sound credible in isolation. Entity contributions against the consolidated movement show whether the causes are local or group-wide.

Convert working-capital days into cash before setting priorities

Days ignore scale. One day of DSO in an entity with AED 200 million of annual revenue represents roughly AED 550,000. One day in an AED 20 million entity represents about AED 55,000.

Return to the two subsidiaries from the opening. The smaller entity sits fifteen days above target and generates AED 20 million of annual revenue, making the gap worth roughly AED 825,000. The larger entity sits three days above target and generates AED 200 million, making its gap worth about AED 1.65 million.

Management should convert KPI gaps into currency before deciding where to intervene. For receivables, multiply the DSO opportunity by daily revenue. For inventory and payables, use the relevant daily COGS base. Then rank the opportunities by expected cash impact.

The ranking still needs judgment. A theoretical AED 5 million opportunity may require renegotiating strategic customer contracts, while an AED 2 million opportunity may come from fixing billing delays or collecting undisputed overdue balances. Finance should combine cash value with feasibility, timing, customer risk, and operating ownership.

Turning Working Capital Analysis Into Action

A useful group working-capital view should lead directly to a decision: where to intervene, how much cash is at stake, and which entity needs attention first

Group receivables increased by AED 8 million, and the CFO wants to know which entities caused it, how much came from FX or growth, which customers sit behind the increase, and where a three-day improvement would release the most cash. If finance has to rebuild the analysis, reconcile subsidiary files, or recalculate KPIs before answering those questions, the working-capital model is no longer keeping pace with the decisions it is meant to support.

Kudwa connects to the group’s accounting systems and consolidates the financial data into one model. Finance can then analyze working capital at holding and entity level, compare subsidiaries using the group’s own KPI methodology, identify the entities driving a movement, and drill into the accounts and balances behind it. The same calculation logic runs across the group, so finance does not need to recheck how each subsidiary arrived at its working-capital KPIs before comparing the results.

See how Kudwa supports multi-entity financial analysis.

‍