# The Law Firm Owner: companion files

Julian R. Sterling

## What is here

- LFO_1_Intake_and_Marketing.xlsx (Chapter 4; Intake and Marketing workbook of Appendix A): sheets Inputs, Lead cost, Retention, then Checks. Marketing per personal injury lead ($150.00 in both years) and per matter signed ($1,950.00 then $1,846.15), the family retention rate (40.0 percent then 43.9 percent) and the estate engagement rate.
- LFO_2_Hours_and_Rates.xlsx (Chapters 5 and 6; Hours and Rates workbook): sheets Inputs, Hour to dollar, Per hour, Flat fee, then Checks. Family law recorded value, billing and collections ($533,610 then $645,597 collected on each year's billing), what one recorded hour brought in by timekeeper, and the flat fee per planned hour ($240.00 then $311.11), with Mr. Tullingham's plan.
- LFO_3_People_and_Partner_Pay.xlsx (Chapters 7 and 8; People and Partner Pay workbook): sheets Inputs, Utilization, Staff cost, Partner pay, then Checks. Associate utilization and leverage, the full cost of a paralegal and an associate against what each collected, and partner pay: the FY2025 equal split and the FY2026 formula ($270,625 and $199,899, against $235,262 each if equal).
- LFO_4_Contingency_Docket.xlsx (Chapters 10 and 11; Contingency Docket workbook): sheets Inputs, Settlement, Docket, then Checks. Ms. Brantimore's settlement statement (fee $114,000, to the client $156,400) with the referral share, and the docket rolled forward (55 then 71 open matters) with the expenses it carries.
- LFO_5_Trust_and_Cash.xlsx (Chapters 12 and 14; Trust and Cash workbook): sheets Inputs, Trust, True-up, then Checks. Client money in trust at each year end ($212,000 then $382,000), a block for your own three-way reconciliation, draws and the true-up ($60,386 then $146,524).
- LFO_6_Margins_and_Value.xlsx (Chapters 13 and 15; Margins and Value workbook): sheets Inputs, Income statement, Fees needed, Areas, Indication, then Checks. Both income statements on a cash basis ($348,386 then $470,524 before partner pay), the fees needed, what each practice area left before shared costs, and the indication for the estate planning practice ($290,520 to $387,360).
- LFO_Law_Firm_Checklists.docx: the 7 checklists of Appendix B, editable (New matter intake and conflict check; Engagement letter and fee agreement (hourly, flat, contingent); Monthly three-way trust reconciliation; Monthly billing run; Settlement statement and disbursement; Closing a matter; Annual review: rates, flat fees, partner pay, the docket).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In LFO_2_Hours_and_Rates.xlsx, on Inputs, type your own collection rate for FY2026: the Hour to dollar and Per hour sheets show at once what each recorded hour now brings in.
2. In LFO_3_People_and_Partner_Pay.xlsx, on Inputs, type other pool percentages for the partner pay formula: the Partner pay sheet shows how each partner's line moves.

To use a workbook on your own firm, fill the yellow column from your billing and practice management reports, intake records, payroll, the trust journal and client ledgers, and the income statement, in the order Appendix A gives, and keep a copy with the case column for comparison. Reconcile the trust workbook first. The workbooks are separate files with no link between them.

## A word of caution

Hollisvane Law Group, PLLC, the town of Hollisvane, its partners, staff and clients, the referring lawyer and the regional firm that gave an indication are fictional. Rates, salaries, hours, fees, settlements, expenses, counts, shares and multiples are teaching assumptions, not market norms or recommendations. The ABA Model Rules are a model: each state adopts its own version, so read your state's rules and ethics opinions, with counsel on legal ethics and your outside CPA. No real firm, software, lead service or vendor is described or recommended. Nothing here is legal, ethics, tax or accounting advice.
