Matters, billable hours, realization, and collections for a law firm
Industry
Mid-size law firm
Timekeepers
120 attorneys and paralegals
Clients
400; Matters: 1,800
Practice groups
8
Annual billed fees
about $50M
Realization
about 83%
Dataset scope
9 Standard-tier tables
Marrowford Legal is a fictional mid-size law firm created for synthetic BI demos and training; the firm, its attorneys, clients, and matters represent no real firm or person. The firm sells time across eight practice groups, billing fees at about 83% realization and collecting on a median cycle near 50 days. BI builders move from monthly billable hours and value into realization, billing, collections, receivables, work-in-progress, and practice-group performance. Realization reflects write-downs against standard value, so the money story stays honest from hours through cash.
These are the operating questions this kit is optimized to answer first.
track billable hours and billable value worked over time and by group.
compare standard value, billed fees, and realization across practice groups, client types, and arrangements.
trace billed fees through collections to outstanding receivable balances.
rank timekeepers and matters by billable value and hours, and compare actual hours against the matter budget.
rank clients by tier, matter count, and billed fees, and follow each open cohort of matters to conclusion.
analyze matter expenses by category and practice group, split by what is recoverable from the client.