Free tool

Excel Templates for Dental Clinics

13 workbooks for the patients and numbers you track every week

Each one is built in your browser with your clinic's name and currency, in English or right-to-left Arabic, starting from a sample clinic or a blank sheet. The formulas are already in and protected, so the only thing left is your data.

  • No sign-up, no email
  • Your clinic name and currency
  • English or Arabic (RTL)
  • Excel, Google Sheets, LibreOffice
  • Nothing stored on our servers

Also free: Prescription generatorTreatment plan generator

Make them yours

Applies to every download on this page and is remembered on this device.

Filled with a fictional clinic so you see the results first. Select the rows and press Delete when you start.
ExcelChairside and lab

Dental lab case tracker

Every case sent out with its due date, late returns, remakes and why. A Labs sheet gives each lab's turnaround, remake rate and cost.

  • Overdue and due-soon flags
  • Remakes with their reason
  • Per-lab turnaround and cost

Sheets: Cases · Labs

Automatic in PDental
ExcelChairside and lab

Materials, expiry & implant lots

Stock by item, size and lot with expiry and reorder level, and an implant log that answers “who received this lot?” with one filter.

  • Expired and expiring-in-60-days flags
  • Reorder alerts and stock value
  • Implant lot to patient log

Sheets: Stock · Implant log · Summary

Automatic in PDental
ExcelChairside and lab

Patient register & medical alerts

One row per patient with allergies, blood thinners, diabetes, heart conditions and pregnancy. Any of them raises a red alert with a one-line summary.

  • Medical alert with details
  • Age worked out from date of birth
  • Birthdays this month, not seen for a year

Sheets: Patients · Summary

Automatic in PDental
ExcelChairside and lab

Post-op follow-up calls

A day-1 call and a day-7 check for every extraction, implant, graft or root canal, with what is due today, what was missed and any complication reported.

  • Call dates worked out for you
  • Due today and overdue flags
  • Complications counted by type

Sheets: Follow-ups · Summary

Automatic in PDental
ExcelChairside and lab

Ortho patient tracker

Braces and aligner patients with their next visit, who missed theirs, months in treatment against the estimate and the balance on each case.

  • Next visit from interval in weeks
  • Overdue and past-estimate flags
  • Balance per case

Sheets: Ortho patients · Summary

Automatic in PDental
ExcelPatients and money

Recall & reactivation list

Patients due back from their last visit and recall interval, a WhatsApp link per patient, and every call logged.

  • Next due worked out for you
  • One-click WhatsApp per patient
  • Booking rate from your calls

Sheets: Recall list · Summary

Automatic in PDental
ExcelPatients and money

Appointments & no-show tracker

Appointments with reminder and outcome. Repeat no-shows are flagged, tomorrow's unreminded patients listed, and no-show rates shown per doctor and weekday.

  • “Repeat no-show” flag
  • No-show rate with vs without a reminder
  • Per doctor and per weekday

Sheets: Appointments · Doctors · Summary

Automatic in PDental
ExcelPatients and money

Unscheduled treatment follow-up

Treatment you diagnosed and priced but the patient has not booked. Follow-up dates, who to call today, and why patients hesitate.

  • Value still on the table
  • “Follow up today” list
  • Hesitation reasons counted

Sheets: Plans · Summary

Automatic in PDental
ExcelPatients and money

Patient balances & instalments

Treatment paid in monthly instalments: what should have been paid by today, what was, the next instalment and a WhatsApp reminder for anyone late.

  • Due-by-today worked out per plan
  • Days overdue and 1–30 / 31–60 / 60+ split
  • Payments log with method

Sheets: Plans · Payments · Summary

Automatic in PDental
ExcelPatients and money

New patient sources

Every enquiry from first message to first visit, with its source and referrer. See which channels bring patients, the treatment they accept and the cost per new patient.

  • “Call today” for new enquiries
  • Conversion per channel
  • Cost per new patient

Sheets: Enquiries · Sources · Summary

Automatic in PDental
ExcelPatients and money

Patient feedback & NPS

One 0–10 question after each visit. Promoters, passives and detractors, who to call back, who to ask for a Google review, and NPS per doctor.

  • NPS for the clinic and each doctor
  • Call-back and review lists
  • Complaints counted by topic

Sheets: Responses · Doctors · Summary

Automatic in PDental
ExcelPatients and money

Doctor production & commission

Visits with fee, discount, paid and lab cost. Commission is worked out on what was collected, at each doctor's own rate, for any month you pick.

  • Rate per doctor
  • Lab cost deducted or not, per doctor
  • Month totals for each doctor

Sheets: Visits · Doctors

Automatic in PDental
ExcelPatients and money

Insurance claims tracker

Claims from submission to payment: claimed, approved and paid, rejections and reasons, aging buckets and how fast each insurer pays.

  • 0–30 / 31–60 / 61–90 / 90+ aging
  • Rejection rate per insurer
  • Average days to pay

Sheets: Claims · Insurers

Automatic in PDental

How they are built

Spreadsheets that do not break on day two

  • Built for your clinic, not a download folder

    The file is generated when you click, with your clinic's name on every sheet and your currency on every amount. Nothing is uploaded: it is made in your browser.

  • Formulas protected, without a password

    Yellow cells are yours, grey cells calculate. Grey cells are locked so nobody types over a formula by accident. There is no password, so you can still unprotect a sheet and change a formula.

  • Arabic that reads right to left

    The Arabic file is not a translated English one: sheets run right to left, with Arabic sheet names, statuses and dropdowns, and the formulas are written for them.

  • Works where your team works

    No macros and no functions only the newest Excel has, so the files work in Excel 2010 and later, Google Sheets and LibreOffice. WhatsApp links open the chat from a phone.

Questions

Before you download

Are the templates really free?
Yes. No form, no account, no email and no watermark. Download as many as you want, as often as you want.
Where does my data go?
Nowhere. The workbook is built in your browser, and what you type into it stays on your computer or in your own Google Drive. Your clinic name and currency are remembered on this device only.
Do they work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The formulas, dropdowns and colours carry over. Google Sheets does not keep Excel's sheet protection, so the grey cells can be typed over there.
How do I remove the sample clinic?
Select the filled rows on each sheet and press Delete. Only the yellow cells clear, and the formulas stay. Or download the blank version: switch “Start with” to Blank sheets.
Which tooth numbering do they use?
Tooth columns are free text, so FDI (16, 21–23), Palmer or Universal all work. The samples use FDI.
What if I outgrow a spreadsheet?
That is what PDental is for. Each card shows the module that keeps the same numbers up to date by itself, from appointments, lab orders and invoices the clinic already enters, across every branch and every user.

See PDental Running Your Clinic — in 30 Minutes

Bring your real problems to the call: the report you can't get, the no-shows you can't explain, the insurance claims sitting unpaid. We'll show you exactly how PDental handles them with your own workflow on screen — not a generic slide deck.

  • A walkthrough of your real workflow, not a slide deck
  • Straight answers on migration, pricing and timelines
  • No obligation to buy at the end of it

No credit card. No installation. No obligation — just a straight answer on whether PDental fits your clinic.

Book your demo

We'll reply within one business day.

We use your details only to arrange the demo.