A week's schedule by payer turned into kept visits, and a year of revenue and costs turned into the kept visits a week an office needs, with and without the owner's pay. One sheet of inputs, live formulas and three checks.
The file opens on the book's fictional first office. In one week of April 2026, 292 scheduled visits at a cancellation and no-show rate of 8 percent became 271 kept visits and $16,637 of revenue, $61.39 a kept visit. Over FY2026 each kept visit left $59.04 after supplies, card fees and the billing service, so the office broke even at 208.5 kept visits a week once the owner's pay was counted, against an actual 233.2: a margin of safety of 24.7 visits a week.
One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.
Chiropractic_Practice_Break_Even_and_Visit_Planner.xlsx (11 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is drawn from workbooks 1 and 5 of The Chiropractic Practice Owner, which follows one fictional practice with two offices through two fiscal years: new patients and kept visits, one fee schedule, care plans and good faith estimates, commercial payers, auto injury claims and Medicare, staff and two associates, rent and the break-even, a second office built on a bank loan, and a letter of intent from a group.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.
Lower the cancellation rate by two points. Type 6 percent instead of 8 and watch the kept visits move row by row. A visit that is kept brings in revenue; an empty slot saves almost nothing, because the chiropractor, the staff and the rent are paid either way.
Type the landlord's renewal. In the case the first office's rent would rise from $6,386 to $6,900 a month, $6,168 a year, and the break-even moves from 208.5 to 210.5 kept visits a week. Try your own lease.
Leave the owner's pay out. Without it the case's office breaks even at 149.3 kept visits a week. That is the figure that flatters an office where the owner also treats; the planner shows both.
A practice is paid for visits that happen. Cancellations and no-shows take visits out of the week while almost every cost stays, so the break-even is counted in kept visits a week.
No. The visit counts are the book's teaching assumptions, not clinical guidance. The planner counts and prices visits; it says nothing about which visits a patient should have.