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
| كود المريض | الاسم | إجمالي أسعار الخطط | المدفوع | قيمة العمل المنجز | الرصيد المستحق الآن | الحالة |
|---|---|---|---|---|---|---|
| D001 | عصام نبيل | 4,000.00 | 2,000.00 | 2,250.00 | 250.00 | عليه رصيد |
| D002 | ريم صبحي | 850.00 | 850.00 | 850.00 | 0.00 | مسدد |
| D003 | تامر وجدي | 1,400.00 | 1,000.00 | 1,400.00 | 400.00 | عليه رصيد |
| D004 | آية مختار | 1,800.00 | 500.00 | 0.00 | -500.00 | دفع مقدمًا |
| D005 | وليد سمير | 350.00 | 0.00 | 0.00 | 0.00 | لم يبدأ العلاج |
| D006 | هالة رأفت | 0.00 | 0.00 | 0.00 | 0.00 | بدون خطة |
| D007 | مروان علي | 2,000.00 | 600.00 | 1,000.00 | 400.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
- In the "الإعدادات" (Settings) tab, enter today's date (or =TODAY() so it updates itself) and any date within the month you want summarized.
- In the "الإجراءات" (Procedures) tab, enter the names of the procedures the clinic offers (such as filling, extraction and crown).
- 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.
- In the "الخطط" (Plans) tab, enter each treatment plan: number, patient code, procedure, planned sessions, agreed price, start date and next session date.
- 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.
- 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.
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.
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 sheet | In 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. |
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
- Pharmacy expiry and stock tracking sheet
- Clinic appointments tracker (Excel)
- Complete clinic management sheet
- Medical lab management sheet
- Pharmacy management sheet: sales, purchases, shortages and suppliers
- Small hospital management sheet: departments, beds, admissions and revenue
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)
- Homework and behavior tracker for teachers (Excel)
- School bus subscriptions tracker (Excel)
- American diploma GPA calculator: unweighted, weighted and cumulative (Excel)
- IGCSE subject tracker with mock scores and target grades (Excel)
- IGCSE past papers log and error tracker (Excel)
- AP, SAT and ACT prep planner (Excel)





