Demonstration · Illustrative data · BI Consulting Services
Professional & financial services × BI Consulting Services
Industry sample board · Partner ledger
Single-page Power BI concept · no client data

The partner ledger: where the hours go, where the cash gets stuck, and who carries the client.

Prepared for Managing partners and CFOs | September 2026 | Utilisation · realisation · lock-up · pipeline · ageing · concentration

Billable hours vs plan, last 24 months

Hours
Billable hours, selected periodBillable hours, outside periodPlan

What this board answers

Three questions

Lock-up river: work in progress → debtors → cash

Days · width = billings per day
Work in progress (unbilled)Debtors (billed, uncollected)Selection average lock-upWrite-down at the billing weir

Utilisation & realisation by practice

vs plan
UtilisationPlanned utilisation
Util.Real.

Partner × client allocation grid

Billable hours in period

Revenue & margin by client

Fees · margin
Client · sectorFeesMargin

Pipeline by stage

Opened in period

Invoice ageing

Period end

Client concentration

Share of fees

Ask the data

AI layer · answers grounded in this board
YouWhich practice's lock-up got worse this period, and how much cash would bringing it back to the firm average release?

Other questions partners ask this board

Which clients are below 15% margin? Who bills the most hours to a single client? How many months of revenue does the pipeline cover? Where did write-downs increase this quarter? Which office is furthest under plan?
1 Benchmark: SPI Research, 2026 Professional Services Maturity Benchmark (19th annual), reports average billable utilisation of 66.4% across surveyed professional-services organisations for 2025 — the lowest in the survey's history and below the 75% target (spiresearch.com; figures as summarised by Deltek). This board's utilisation KPI is compared against that published figure. Every other number on this page is illustrative sample data generated for demonstration, internally consistent (subtotals reconcile, percentages match the values shown) and does not describe any real firm or client. Practice cost rates include fee-earner salary and on-costs only; margin is before overhead and partner distributions.
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min