WIP, Billings and Debtors: The Working Capital Triangle Explained

Ask most firms how healthy their working capital is, and you'll typically get three separate answers, from three separate reports, built by three different people, at three different times, using three different snapshots of the underlying data. WIP comes from one export. Billings comes from another. Debtors comes from a third. Nobody's necessarily doing anything wrong, it's just how most firms have always produced this information, and the disconnect between the three has simply become invisible through familiarity.

The trouble is that WIP, billings and debtors aren't really three separate things. They're three stages of the same underlying story.

The working capital triangle

Time gets worked and captured as WIP. That WIP needs to convert into an invoice through the billing process, and along the way, some of it may be written off rather than billed. Once invoiced, the amount becomes a debtor, and it needs to convert into actual cash in the bank. Cash, in turn, funds the payroll that lets new work begin, capturing new time as WIP, and the cycle continues.

When any one stage of this cycle breaks down, the symptom usually shows up somewhere else. WIP that never gets billed becomes a debtors problem you'll never see, because it never became an invoice in the first place. Invoices that don't get collected show up as a cash flow problem, even though the underlying issue might actually trace back to how the fee was originally scoped or billed. If the three numbers live in separate spreadsheets, built at different times, nobody sees the whole chain, only the individual, disconnected links.

Why this makes diagnosing problems so much harder than it should be

This is the practical cost of treating WIP, billings and debtors as three unrelated reports. A partner who notices cash flow is tight has no easy way to trace that back to its actual source, is it a WIP problem (work not being billed promptly), a billing problem (too much being written off), or a genuine debtors problem (invoices sent but not collected)? Without a connected view, answering that question requires pulling three separate reports and manually reconciling them against each other, which is exactly the kind of exercise most firms don't have time to do properly, especially under the pressure of an actual cash flow concern.

What a connected view changes

Bringing WIP, billings and debtors into a single view, drillable down to the individual client and staff level, and consistent across all three, turns a vague, firm-wide concern like "cash flow feels tight lately" into a specific, actionable diagnosis: which stage of the cycle is actually the bottleneck, for which clients, and what needs to happen to fix it.

It also changes how partners think about the numbers day to day. Instead of three separate KPIs to check in three separate places, there's one coherent picture of the practice's financial engine room, where healthy WIP, strong recoverability, and timely collections aren't three unrelated goals, but three connected outcomes of the same well-managed cycle.

A healthier firm starts with seeing the whole chain

Firms that manage this well don't necessarily have fewer problems in any single stage. They just catch problems faster, because they can see exactly where in the chain something has gone wrong, rather than discovering the downstream symptom weeks or months after the actual cause.

Frequently asked questions

How are WIP, billings and debtors connected? Time becomes WIP, WIP converts into an invoice through billing, and the invoice converts into cash through collection, so a problem at any stage shows up as a symptom later in the cycle.

Why is it hard to diagnose cash flow problems without a connected view? Because if WIP, billings and debtors live in separate reports, there's no easy way to trace a cash flow issue back to which stage of the cycle is actually the bottleneck.

Previous
Previous

Off-the-shelf versus accounting-specific Power BI templates: which is right for your firm?

Next
Next

Why WIP Is the Most Under-Managed Number in Your Firm