Free Excel templates

A free chiropractic practice break-even and visit planner in Excel

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.

Get the planner

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.

The book behind this planner

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

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
The week's scheduled visits on eight rows (Payer A, Payer B, Medicare, self-pay visit by visit, prepaid care plans, auto injury claims, reactivated patients, periodic care), the phase's cancellation and no-show rate, new patients, decompression sessions and the week's revenue; then one year of revenue, variable costs, kept visits, weeks, fixed office costs, the owner's pay and a rent change.
Planner
Kept visits row by row (plan visits count as kept), revenue per kept visit for the week, contribution per kept visit for the year, break-even kept visits a week with and without the owner's pay (149.3 without it in the case) and with the rent change (210.5), actual kept visits a week and the margin of safety.
Checks
Cancellation rate between 0 and 100 percent, contribution per visit above zero, kept visits not above scheduled visits, and an All checks cell.

Three things to try

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.

Questions

Why kept visits, not scheduled ones?

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.

Does it say what care a patient needs?

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.

Related reading