Softwiro
Free Excel template

Dental clinic treatment plans tracker (Excel)

A free Excel sheet for dental treatment plans. You enter your patients and a treatment plan for each, with its number of sessions and agreed price, and you record sessions and payments. The sheet calculates how much of each plan is done and the value of the work completed, works out each patient's balance after what they paid, warns you about plans that need a new appointment, and gives you a list of patients with a balance and a monthly summary. It stores no diagnoses or medical data, only what is needed to schedule sessions and settle accounts.

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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 “المرضى” tab (Arabic), with the numbers and formulas that are in the file.
كود المريضالاسمإجمالي أسعار الخططالمدفوعقيمة العمل المنجزالرصيد المستحق الآنالحالة
D001عصام نبيل4,000.002,000.002,250.00250.00عليه رصيد
D002ريم صبحي850.00850.00850.000.00مسدد
D003تامر وجدي1,400.001,000.001,400.00400.00عليه رصيد
D004آية مختار1,800.00500.000.00-500.00دفع مقدمًا
D005وليد سمير350.000.000.000.00لم يبدأ العلاج
D006هالة رأفت0.000.000.000.00بدون خطة
D007مروان علي2,000.00600.001,000.00400.00عليه رصيد

Example from the “المرضى” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الإعدادات (Settings): Today's date and any date within the month you want summarized (October 2026 in the example).
  • الإجراءات (Procedures): The names of the procedures the clinic offers (seven in the example), then the number of plans, their total agreed prices and the sessions completed for each procedure. The table holds 50 procedures.
  • المرضى (Patients): Patient code, name, phone and first visit date. The sheet then calculates the number of plans, their total price, amount paid, balance remaining on plans, value of work done, balance due now, last session and patient status (owes a balance, settled, paid in advance, treatment not started, or no plan). It holds 300 patients.
  • الخطط (Plans): For each plan: number, patient code, procedure, planned sessions, agreed price, start date and next session date. The sheet then calculates sessions completed and remaining, percent complete, value of work done, status (not started, in progress or completed) and a "needs appointment" alert. It holds 500 plans.
  • الجلسات (Sessions): Log each session with its date, plan number, status (attended, no-show or cancelled) and a note. The patient code and name appear automatically. It holds 2000 sessions.
  • المدفوعات (Payments): Each payment with its date, patient code, amount, payment method (cash, card or bank transfer) and a note. The patient name appears automatically. It holds 1000 payments.
  • للمتابعة (Follow-up): An automatic list of patients who owe a balance, largest balance first, with their phone, last session and the balance remaining on their plans.
  • الملخص (Summary): The number of patients, those who owe a balance, those who paid in advance and those with no plan; plans by status and those needing an appointment; total prices, value of work done, amount paid, balance due now and balance remaining on plans; and the month's sessions, attendance rate and amount collected.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

You open the "للمتابعة" (Follow-up) tab and see who owes a balance for work actually done, and you open "الخطط" (Plans) and find the plan that stalled with no next appointment, without comparing the session book with the accounts book by hand for each patient.

How to use it

  1. In the "الإعدادات" (Settings) tab, enter today's date (or =TODAY() so it updates itself) and any date within the month you want summarized.
  2. In the "الإجراءات" (Procedures) tab, enter the names of the procedures the clinic offers (such as filling, extraction and crown).
  3. In the "المرضى" (Patients) tab, enter a code, name, phone and first visit date for each patient. Do not enter a diagnosis or any medical data here.
  4. In the "الخطط" (Plans) tab, enter each treatment plan: number, patient code, procedure, planned sessions, agreed price, start date and next session date.
  5. In the "الجلسات" (Sessions) tab, record each session: date, plan number and status (attended, no-show or cancelled). In "المدفوعات" (Payments), record each payment: date, patient code and amount.
  6. The sheet calculates sessions completed, value of work done, each patient's balance and each plan's status. Open "للمتابعة" (Follow-up) to find patients who owe a balance, and review the "الملخص" (Summary) tab.

Before you start:

  • Value of work done on a plan = agreed price × (sessions with status "attended" ÷ planned sessions), and never exceeds the full price. A "no-show" or "cancelled" session does not count as done.
  • Balance due now = value of work done − amount paid. A negative number means the patient paid in advance, and the status shows "paid in advance".
  • Balance remaining on plans = total plan prices − amount paid. This is what the patient still owes even after finishing the whole plan.
  • Plan status: "not started" if no "attended" session has been recorded for it, "completed" if the sessions completed reach the planned sessions, and otherwise "in progress".
  • An incomplete plan with no next appointment, or whose next appointment is before today's date, shows the alert "needs appointment".
  • The sheet holds 300 patients, 500 plans, 2000 sessions and 1000 payments, and the Follow-up tab shows the first 30 patients. The sheet stores no diagnoses, so write only booking and billing details in the notes.

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: dental treatment plans (1/3)Cheat sheet: dental treatment plans (2/3)Cheat sheet: dental treatment plans (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

How is a patient's balance calculated?

Value of work done minus what the patient paid. For each plan, value of work done = agreed price × (sessions with status "attended" ÷ planned sessions), and never exceeds the full price. A "no-show" or "cancelled" session does not count as done. A negative number means the patient paid in advance.

What is the difference between "balance due now" and "balance remaining on plans"?

Balance due now compares what the patient paid with the work actually done. Balance remaining on plans compares what they paid with the prices of all their plans, including sessions not yet held.

Does the sheet store diagnoses or medical records?

No. It has only the patient code, name, phone and first visit date, a plan with its procedure, sessions and price, the status of each session and the patient's payments. Do not write a diagnosis or medical data in the notes column; write only what concerns booking and billing.

Can one plan cover more than one procedure?

Each plan has one procedure. If a patient needs more than one procedure, create a plan for each, with its own price and sessions, and the sheet adds all of that patient's plans together on the patient's row.

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