Companion files · The Private Markets Career Guides
How to Run a Profitable Small Law Firm: Fee Agreements, Billable Hours and Collections, Flat and Contingent Fees, Trust Accounting, Partner Pay, Cash and Selling a Practice.
These are the companion files of the book. Six workbooks follow Hollisvane Law, the fictional small law firm of the case, across two fiscal years: intake and marketing, hours and rates, people and partner pay, the contingency docket, trust and cash, and margins and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 4
Marketing per personal injury lead and per matter signed, the family retention rate and the estate engagement rate, for both years. Sheets: Inputs, Lead cost, Retention. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 113 KBChapters 5 and 6
Family law hours to billing and collections, what one recorded hour brought in by timekeeper, and the flat fee per planned hour. Sheets: Inputs, Hour to dollar, Per hour, Flat fee. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 215 KBChapters 7 and 8
Utilization and leverage, the full cost of a paralegal and an associate, and partner pay under an equal split and under the formula. Sheets: Inputs, Utilization, Staff cost, Partner pay. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 315 KBChapters 10 and 11
A settlement statement with its referral share, and the docket of open matters with the expenses it carries. Sheets: Inputs, Settlement, Docket. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 413 KBChapters 12 and 14
Client money in trust at each year end, a block for your own three-way reconciliation, draws and the true-up. Sheets: Inputs, Trust, True-up. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 513 KBChapters 13 and 15
Both income statements, the fees needed, what each practice area left, and the indication for the estate planning practice. Sheets: Inputs, Income statement, Fees needed, Areas, Indication. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
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.
Download the toolkit40 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| An associate hour | $225 x 93 percent x 94 percent = $196.70 collected in FY2026 |
| Partner pay | $270,625 and $199,899 under the formula, against $235,262 each if equal |
| The trust account | $382,000 of client money at 30 September 2026, none of it revenue |
The files are provided as they are, without warranty of any kind. The model is illustrative: Hollisvane Law, Hollisvane, the referring lawyer, the buyer firm and every party are fictional, and the rates, salaries, hours, fees, settlements and multiples are the book’s assumptions, not market terms or the practice of any real firm. Each state adopts its own rules of professional conduct: check your state’s version, counsel on legal ethics and your outside CPA.