Softwiro
Free Excel template

Dental Practice Treatment Plan Tracker for Excel

A free Excel workbook for a small dental practice that wants its treatment plans, fees and balances in one place. You keep one treatment log: each row is a procedure for a patient, with the tooth or area typed as free text, the dentist and a status of Proposed, Accepted, In progress or Completed. The fee comes from your own fee schedule, you enter any discount, the sheet splits the net fee into an insurance portion and a patient portion, and you record what has been paid. From those rows it works out who owes what and for how long, which patients still have work waiting, and production and collections by dentist and by month. It holds records and arithmetic only, with no clinical or insurance rules, and it opens in Excel, LibreOffice and Google Sheets in any currency.

Excel file (.xlsx) · 155 KB · 11 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Last month shown46327Change the month, the "as of" date and the currency on Settings.
Production in the month (completed, net)2,370.00
Collections in the month (paid)1,310.00
Collection rate55.3%
Treatments completed in the month10
Discounts given on completed treatment0.00
Insurance portion of production946.00
Patient portion of production1,424.00
Total owed, all patients2,692.00
Patients who owe8
Owed for more than 60 days780.00
Credits held (paid ahead)200.00
Open plan value (not yet completed)6,300.00
Plan acceptance rate (share of value past Proposed)75.3%
MonthProductionCollections
461740.000.00
462040.000.00
462350.000.00
462660.000.00
462964,260.002,828.00
463272,370.001,310.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: The last month shown, set on Settings: production, collections, collection rate, treatments completed, discounts, insurance and patient portions, total owed, patients who owe, amounts more than 60 days old, credits held, open plan value and the plan acceptance rate. Four charts: production and collections by month, treatment value by plan status, amount owed by age, and production by dentist.
  • Treatment Log: The core table, one row per procedure: date, patient ID, tooth or area, procedure, dentist, status, optional fee, discount, optional insurance amount, amount paid and notes. It fills in the patient name, code, fee, net, insurance portion, patient portion, production, balance and age in days, and a Check column flags a missing date, an unknown ID or procedure, a discount larger than the fee and similar slips. Room for 400 lines.
  • Open Plans: Patients with Proposed, Accepted or In progress work, largest first, with phone number and the value in each status, so the front desk knows whom to call about the next step.
  • Balances: Patients who owe, largest first, with the amount split into 0-30, 31-60, 61-90 and over 90 days, and the total owed and the amount over 60 days at the top.
  • Production: Six months by dentist: production (completed treatment, net of discounts) and collections (amounts paid), with totals and the collection rate for each month.
  • Patients: One row per patient: ID, name, phone and the percentage their insurance is expected to cover. It adds up their plan value by status, paid, owed, credit, ageing and open plan value.
  • Fee Schedule: Your procedures, a code you choose and the fee. It feeds the fee on every log line.
  • Dentists: The names of your dentists and hygienists, used for the dropdown and for the production tables.
  • Settings: Practice name, currency symbol, the date balances are aged to and the last month shown.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free dental spreadsheets are a blank table or a printed estimate form. This one connects the plan to the money: the same line that says a crown is Accepted becomes production when you mark it Completed, splits itself into insurance and patient portions, and shows up in the right dentist's month and in the right ageing column if it is not paid. The sample is a three-dentist practice with 34 lines in October and November 2026, so you can see every sheet working before you replace it with your own.

What should a dental treatment plan tracker include?

Searching for a template turns up two kinds: a treatment estimate form to hand to the patient, and a practice dashboard with production and collections. A tracker needs both ends joined up: the proposed procedures with their fees, a status that moves as the patient decides and the work is done, and what has been paid. That is what the Treatment Log holds, one row per procedure, with the tooth or area typed in your own words.

In the sample, 4 lines worth $3,200 are still Proposed, 3 lines worth $1,370 are Accepted, 2 lines worth $1,730 are In progress and 25 lines worth $6,630 are Completed. Open Plans lists the patients behind the first three, so a follow-up call is a matter of reading down the page.

How do I track production and collections in Excel?

Production here means the net fee (fee minus discount) of lines marked Completed, counted in the month of the line date. Collections are the amounts you enter as paid on lines in that month. The Production sheet shows both by dentist for six months, and the collection rate is collections divided by production. Different practices define these terms differently, so decide on your definition and apply it the same way every month.

In the sample for November 2026, production is $2,370 and collections are $1,310, a collection rate of 55.3%. October shows $4,260 of production and $2,828 collected. The reason November looks low is simple: much of the work was done recently and has not been paid yet, which the ageing shows.

How do I keep a dental patient ledger and see who owes what?

Each log line has a balance: production minus paid. Lines with a balance owed are aged from the line date to the as-of date on Settings, and the Balances sheet adds them up per patient in 0-30, 31-60, 61-90 and over 90 day columns. A balance below zero is shown as a credit, for example a deposit paid on a procedure that is not completed yet.

In the sample, 8 patients owe a total of $2,692, of which $780 is more than 60 days old, and $200 is held as a credit. The sheet works out insurance and patient portions from a percentage you set per patient, or from an amount you type on the line, but it does not know what any insurer will actually pay. Check your local rules and the insurer's own statements for that.

How to use it

  1. On Settings type your practice name, currency symbol, the "as of" date for balances and any date in the last month you want to see.
  2. On Fee Schedule list each procedure with a code you choose and its fee. On Dentists list your dentists and hygienists.
  3. On Patients give each patient an ID (P001, P002...), a name, a phone number and, if they have insurance, the percentage you expect it to cover.
  4. On Treatment Log add one row per procedure: date, patient ID, tooth or area (free text), procedure, dentist and status. Move a row from Proposed to Accepted, In progress and Completed as the plan moves.
  5. Enter any discount, and the amount paid. Leave the fee blank to use the schedule fee. Type an insurance amount only if it differs from the patient's percentage.
  6. Open Open Plans for patients with work still to do, Balances for who owes what and for how long, Production for dentist and month totals, and Dashboard for the charts.

Before you start:

  • Capacity: 400 treatment lines, 150 patients, 60 procedures, 10 dentists. Production shows the first 8 dentists.
  • Production counts a line only when its status is Completed. Net = fee - discount. Insurance portion = net x the patient's percentage, rounded to cents, unless you type an amount on the line. Patient portion = net - insurance portion.
  • Balance on a line = production - paid. Paid is the total received on that line, from the patient and from insurance together. A negative balance is a credit, for example a deposit on a line that is not completed yet.
  • Ageing counts days from the line date to the "as of" date on Settings, for lines that still have a balance owed: 0-30, 31-60, 61-90 and over 90 days.
  • Collections in a month are the amounts paid on lines dated in that month. The tracker has no separate payment dates.
  • The plan acceptance rate on the Dashboard is the share of all line value that is no longer Proposed.
  • This file holds records and arithmetic only. It gives no clinical, insurance or legal guidance: check your local rules. Patient data must be handled under your local privacy rules, so keep the file in a protected place. The patient names in the sample are fictional.
  • "As of" date is typed on Settings so the file gives the same answer whenever you open it. Type =TODAY() there to follow the calendar.

Excel file (.xlsx) · 155 KB · 11 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This tracker relies on someone typing every treatment line, payment and plan status by hand. It cannot let patients book, remind them, or keep a digital patient file. Sehaty does that on one platform.

In this sheetIn MyClinic (Sehaty) — Clinic, Pharmacy and Supplier Platform
You discover an item is short when a patient asks for it.Sehaty tracks stock item by item and warns you before an item runs out, not after.
The prescription is a paper that can get lost or be hard to read, and no trace of dispensing remains.The consultation produces an e-prescription in the patient's medical file, and the pharmacy records dispensing against that same prescription.
You learn what pharmacies need late, through reports and phone calls.The supplier sees a digital catalog that reaches pharmacies and warehouses, and sees demand as it comes in.
The patient phones several clinics to book.The patient searches for appointments by specialty and location and books without a phone call.

See MyClinic (Sehaty) — Clinic, Pharmacy and Supplier Platform · Ask for a demo

Frequently asked questions

Is this dental treatment plan tracker really free?

Yes. Download it, use it in your practice and change anything you like. There is nothing to sign up for to open the file.

Does it give clinical or insurance advice?

No. It stores dates, tooth or area as free text, procedures, fees, discounts and payments and does arithmetic on them. It has no treatment rules, diagnosis fields or insurance and legal rules. Check your local rules for those.

How does it split insurance and patient portions?

Set the percentage the patient's insurance is expected to cover on the Patients sheet. The insurance portion of a line is the net fee times that percentage, rounded to cents, and the patient portion is the rest. If a particular line differs, type the insurance amount on that line and it overrides the percentage.

Can I keep patient data in a spreadsheet?

Patient data must be handled under your local privacy rules. Keep the file in a protected location, do not type clinical details into the notes, and only share it with people who are allowed to see it. The names in the sample are fictional.

How many patients and treatment lines can it hold?

150 patients, 400 treatment lines, 60 procedures and 10 dentists, with the Production sheet showing the first 8. When the log is full, save a copy and start a fresh file with your patients, fee schedule and dentists.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Pharmacies and clinics

More free templates

All templates · Free tools