# The Counseling Practice Owner: companion files

Julian R. Sterling

## What is here

- CPO_1_Schedule_and_Sessions.xlsx (Chapters 3, 5 and 6; Schedule and Sessions workbook of Appendix A): sheets Inputs, Slots, Ramp, Booking, then Checks. Weekly slots turned into slots offered each month, the ramp of a new clinician, slots booked (92.0 percent then 92.9 percent of slots offered), no-shows and late cancellations, sessions held (7,078 then 9,733) and the booked share month by month.
- CPO_2_Payers_and_Rates.xlsx (Chapters 4 and 7; Payers and Rates workbook): sheets Inputs, Charges, Net per session, then Checks. Sessions and charges by payer ($914,965 then $1,256,415), the payer mix, and net revenue per session after write-offs (Ostermere Mutual $94.76 against a rate of $98 in FY2026).
- CPO_3_Claims_and_Collections.xlsx (Chapters 6, 7 and 8; Claims and Collections workbook): sheets Inputs, Claims, Client share, Receivables, Missed fees, then Checks. Denials, resubmissions and write-offs, the client's share collected at the session by year and by half, receivables and days to collect (22.4 then 22.3), and the missed-session fee charged and collected.
- CPO_4_Clinician_Pay.xlsx (Chapters 9, 10 and 11; Clinician Pay workbook): sheets Inputs, Pay models, Fee split, Supervision, Departure, then Checks. A salary, a per-session pay and a fee split side by side ($69.52, $55.20 and $78.43 a session in FY2026), the split counted month by month ($66,034), supervision hours, the second associate's first six months, and the cost of a departure ($21,115).
- CPO_5_Cash_and_Decisions.xlsx (Chapters 14 and 15; Cash and Decisions workbook): sheets Inputs, Cash, Decisions, then Checks. Month-end cash, the line of credit month by month and the rule for distributions, then the two decisions of year two, both projections: outsourcing the billing ($5,015 a year more) and leaving the lowest-paying panel ($30,693 a year, -$3,202 if half the freed slots refill).
- CPO_6_Profit_and_Value.xlsx (Chapters 13 and 16; Profit and Value workbook): sheets Inputs, Income statement, SDE, Planning range, then Checks. Both income statements ($28,958 then $92,788 of net income) and the bridge between them, seller's discretionary earnings ($144,208 then $218,144) and the founder's planning range ($436,288 to $610,803).
- CPO_Counseling_Practice_Owner_Checklists.docx: the 8 check-lists of Appendix B, editable (Hiring and onboarding a clinician; Joining a payer's panel; The first appointment and the good faith estimate; The monthly billing close; The weekly schedule review; A clinician's departure; The founder's monthly review; Preparing a sale).

## 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 CPO_1_Schedule_and_Sessions.xlsx, on Inputs, type your own weekly slots and the weeks a year your clinicians see clients: the slots a month move at once.
2. In CPO_2_Payers_and_Rates.xlsx, on Inputs, type your own contracted rate and write-offs for one payer: the net a session shows what that payer really pays.

To use a workbook on your own practice, fill the yellow column from your scheduling system, your payer contracts and remittances, your claims and denial reports, your payroll and contractor agreements, the bank statements and the accounting system, in the order Appendix A gives, and keep a copy with the case column for comparison. Keep the fiscal year aligned: the case runs from 1 July to 30 June. Set your conventions with your outside CPA first: when a session becomes revenue, and when a denial or a client balance is written off. The workbooks are separate files with no link between them.

## A word of caution

Ferrowmont Counseling Group, PLLC, the town of Wendlecross, its founder, clinicians and staff, the health plans, the EAP, the billing company and the landlord are fictional. Rates, fees, shares, salaries, per-session pay, splits, rents and multiples are teaching assumptions, not market norms or recommendations. A session in these files is a slot, a payer, a rate and a date: nothing describes a client or a clinical matter. Licensing, supervision, payer terms, missed-session fees, worker classification, privacy and telehealth rules are questions for counsel, the licensing board, the payer, your outside CPA and your insurance broker. No real practice, health plan, EAP, platform or software is described or recommended. Nothing here is legal, tax, insurance, accounting or clinical advice.
