Professional Services Reporting: Utilisation, WIP, Realisation

Why does your firm feel flat out every week, yet the month-end numbers never seem to match the effort? If you run an accounting, legal, engineering or consulting practice in Bendigo, you've probably asked that question more than once. The answer usually sits in three numbers most firms track badly: utilisation, work in progress and realisation. Good professional services reporting puts those three side by side, so you can see where the hours go and where the money leaks out.

Three Numbers That Tell You If the Firm Is Healthy

Utilisation is the share of available hours your people spend on billable work. Simple on paper. In practice, the definition of "available" is where firms trip up. Do you count annual leave? Training days? Business development time for partners? If two managers calculate it differently, your dashboard will start arguments rather than settle them.

WIP is time and cost recorded but not yet billed. A growing WIP balance isn't automatically bad. But WIP that ages past 60 or 90 days often signals scope creep, a client dispute or a manager who quietly hates sending invoices. Realisation then tells you how much of the standard value of that work you actually collect. Record $10,000 of time at standard rates, write off $1,500, and your realisation sits at 85%.

Each number on its own is half a story. High utilisation with poor realisation means your team is busy doing work you can't charge for. Strong realisation with low utilisation means you're pricing well but carrying too much capacity. You need all three in one view to know which problem you've actually got.

Why Bendigo Practices Often Fly Blind on WIP

Most regional firms we speak with run practice management software that already holds the right data. Then they export it to Excel for the monthly partner meeting. Someone spends two days building pivot tables, and by the time partners see the figures, they're three weeks old. Sound familiar?

Bendigo adds a few wrinkles of its own. Plenty of local firms have grown by merging with smaller practices in Castlemaine, Echuca or Kyneton, and the systems never quite got consolidated. Others serve clients across agriculture, healthcare and manufacturing, each with very different billing patterns. A farming client billed once after harvest looks nothing like a health provider billed monthly, and both distort your WIP if you don't account for them.

There's also the governance angle. Firms here, especially those advising financial services clients or working alongside Bendigo Health, tend to want clear definitions and an audit trail behind every figure. That's a good instinct. It just doesn't survive a spreadsheet passed between five people with five versions saved on five desktops.

• Utilisation targets set annually, but only checked when someone's performance review comes around
• WIP aged in buckets nobody agrees on, so stale work hides inside "current"
• Write-offs recorded at billing with no reason code, so you can't separate pricing problems from delivery problems
• Office or team comparisons done by hand, which means they rarely happen at all

What a Partner-Ready Practice Dashboard Shows

So what does this look like in practice? Picture a mid-sized accounting firm with offices in Bendigo and one other regional town, roughly 40 fee earners. Their partner dashboard opens on a single page. Firm utilisation against target, WIP by age band and rolling 12-month realisation, each sliceable by office, service line and manager.

From there, a partner can click into any client with WIP older than 90 days. They see who's responsible, what's been written off before and when the last invoice went out. Managers get their own view showing team utilisation week by week rather than month by month. That shorter feedback loop changes behaviour fast, because people can fix a slow week before it turns into a slow quarter.

• Utilisation by person and team, with "available hours" defined once and documented
• WIP ageing in fixed bands (0 to 30, 31 to 60, 61 to 90 and 90+ days)
• Realisation split into billing realisation and collection realisation
• Lock-up days, combining WIP and debtors, so you see the full cash cycle
• Write-off reasons captured at the source, not reconstructed later

That last point matters more than most firms expect. Once you know whether write-offs come from fixed fee overruns, junior staff learning on the job or clients pushing back on rates, you can tackle each one differently. We've written more about how we structure these models on our dashboards for professional services firms page.

From Friday Spreadsheets to Numbers Partners Trust

You don't need to replace your practice management system. In most cases the data is already sitting there. The real work is connecting it, cleaning it and modelling it so every number calculates the same way each time. Professional services reporting built in Power BI refreshes automatically, so nobody spends month end rebuilding the same tables.

Start small. Pick one metric, usually WIP ageing because it ties straight to cash, and get it right first. Bring in utilisation and realisation once partners trust that initial view. If your firm also needs tighter finance reporting across the general ledger and cash flow, plan both together so they draw on the same source and never disagree.

Because Bendigo is a smaller market, our engagements there tend to run deeper. We usually work closely with a firm's practice manager over several months rather than dropping in a template and disappearing. That suits professional firms well, since every practice has its own quirks in how it records time and bills clients.

If your professional services reporting still depends on someone's Friday afternoon spreadsheet, it's worth a conversation. Roar Data works with firms across regional Victoria from our Brisbane base, and distance hasn't been a barrier for any of them. Book a short call and we'll review your current reports, agree on clear definitions for utilisation, WIP and realisation, and map out a first dashboard your partners will actually open.

For the wider picture of how this work is run, our Power BI consulting approach across Australia sets out the stages and what each one is meant to settle.