# 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.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Finance, Write, Analyze, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/analyze-my-law-firm-s-utilization-realization-and-collections

## Prompt

```text
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.
```

## 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

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.