Analyze my law firm's utilization, realization, and collections
A law firm financial health review using standard metrics, with the leaks between hours worked and cash collected traced to causes and fixes.
The prompt
Analyze my law firm's financial performance and show me where money is leaking.
Period: [e.g. "last 12 months by quarter"]
Data by timekeeper or practice group: [PASTE - hours worked, billable hours, standard rate value, billed value, collected value, write-downs, write-offs]
Billable hour targets: [e.g. "1,800 associates / 1,500 partners"]
Accounts receivable aging: [PASTE - current, 31-60, 61-90, 91-120, over 120 days]
Unbilled WIP aging: [PASTE]
Headcount by level: [PARTNERS, ASSOCIATES, PARALEGALS]
Calculate and explain:
1. Utilization (billable hours / available or target hours) by timekeeper level.
2. Billing realization (billed / standard value) and collection realization (collected / billed); overall realization (collected / standard).
3. Lockup: WIP days plus debtor days, and the oldest buckets.
4. Leverage (non-partner timekeepers per partner) and revenue per lawyer.
5. Where the gap sits: unrecorded time, pre-bill write-downs, client discounts, or uncollected invoices.
Return:
- A metrics table with formulas shown.
- The three biggest leaks with likely causes (e.g. fixed-fee overruns, slow time entry, one client's aging).
- Five specific actions ranked by expected cash impact, such as time-entry deadlines, earlier pre-bill review, retainer requirements, or rate renegotiation.
- Questions the data cannot answer yet.
Use only the numbers I provide; mark missing data as [NEED DATA] rather than estimating.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- e.g. "last 12 months by quarter"
- e.g. "1,800 associates / 1,500 partners"
- PASTE - current, 31-60, 61-90, 91-120, over 120 days
- PASTE
- PARTNERS, ASSOCIATES, PARALEGALS
- NEED DATA
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Diagnose my digital subscription funnel and reader churnAn analysis of paywall, registration, conversion, and churn data that pinpoints the weakest stage and tests to run next.
- Run a fair lending review of loan pricing and approval dataA structured fair lending analysis plan and readout that tests for disparities in approvals, pricing, and exceptions.
- Analyze my clinic's claim denials and revenue cycle KPIsTurns denial and A/R data into root causes, benchmark gaps, and a prioritized fix list for the front end, coding, and billing teams.
- Engineer my menu using item sales and contribution marginSorts every menu item into stars, plowhorses, puzzles, and dogs, with specific actions for each and the next menu.