# Complete clinic management sheet (free Excel template)

> Clinic sheet: patient file, priced visits log with discount and company share, doctor share, expenses, follow-ups, and daily and monthly income vs expenses.

Source: https://softwiro.com/templates/clinic-management
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Complete clinic management sheet

A free Excel sheet for managing a clinic. You keep your patients in one file, then log every visit with the service, doctor, discount, amount paid and contract-company share, and the sheet works out the net of the visit, the doctor's share, the clinic's share and what the patient and the company still owe. You log expenses too, so you see income against expenses by day and by month, along with a list of who is still entitled to a follow-up consultation within the period you set. The sheet holds no diagnoses or medical advice, and the notes column is free text.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-clinic-management.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-clinic-management-blank.xlsx)

Excel file (.xlsx) · 384 KB · 13 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

| التاريخ | كود المريض | الخدمة | الطبيب | النوع | الصافي | حصة الشركة | حصة المريض | حصة الطبيب |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 46296 | P003 | كشف جديد | د. أحمد سعيد | كشف | 400.00 | 0.00 | 400.00 | 200.00 |
| 46296 | P001 | استشارة متابعة | د. أحمد سعيد | استشارة | 200.00 | 0.00 | 200.00 | 100.00 |
| 46298 | P004 | كشف جديد | د. منى فؤاد | كشف | 400.00 | 320.00 | 80.00 | 160.00 |
| 46298 | P003 | تخطيط قلب | د. أحمد سعيد | إجراء | 250.00 | 0.00 | 250.00 | 125.00 |
| 46301 | P005 | كشف جديد | د. هشام رأفت | كشف | 400.00 | 0.00 | 400.00 | 240.00 |
| 46301 | P002 | استشارة متابعة | د. منى فؤاد | استشارة | 200.00 | 0.00 | 200.00 | 80.00 |
| 46303 | P006 | كشف جديد | د. أحمد سعيد | كشف | 400.00 | 400.00 | 0.00 | 200.00 |
| 46303 | P006 | سونار | د. أحمد سعيد | إجراء | 350.00 | 350.00 | 0.00 | 175.00 |
| 46305 | P004 | استشارة متابعة | د. منى فؤاد | استشارة | 200.00 | 160.00 | 40.00 | 80.00 |
| 46307 | P007 | كشف جديد | د. هشام رأفت | كشف | 400.00 | 0.00 | 400.00 | 240.00 |
| 46308 | P005 | تضميد جرح | د. هشام رأفت | إجراء | 120.00 | 0.00 | 120.00 | 72.00 |

Example from the “الزيارات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات: Today's date, any date inside the summary month, the first month of the monthly table, the number of follow-up days after a first examination, and the list of expense categories.
- الخدمات: The price list: service name, type (examination, consultation or procedure) and price. Holds 100 services.
- الأطباء: Each doctor's name, specialty and percentage of the net income of their visits (an adjustable setting), with the month's visits, net income, the doctor's share and the clinic's share. Holds 30 doctors.
- الشركات: Contract companies and the percentage each one covers, plus what you have collected from them so far, so you see the total of their shares and the balance they owe.
- المرضى: Patient code, name, mobile and date of first visit, with the number of visits, net billed, the patient's share, amount paid and balance, the last visit, the last examination and the follow-up status. Holds 300 patients.
- الزيارات: One row per visit: date, patient, service, doctor, company, discount, amount paid and free-text notes. The sheet calculates the price, the net, the company's share, the patient's share, the balance, the doctor's share and the clinic's share. Holds 2000 visits.
- المصروفات: The date, category, description and amount of each expense. Holds 1000 expenses.
- المتابعات: Patients whose last examination was less than the consultation period ago and who have not yet had a consultation, sorted by the nearest end date, with the days remaining and each patient's balance.
- اليومي: A table of the chosen month's days: visits, income, amount collected from patients, expenses and the net for each day.
- الشهري: Six consecutive months: visits, income, doctors' shares, expenses, net after expenses and the clinic's net after doctors' shares.
- الملخص: The chosen month's figures, outstanding balances and follow-ups, and income split by service type, with four charts: income against expenses, income by type, each doctor's share and daily income.

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

## What makes it different

Patients, visits and expenses in one place. You enter a visit once, and the doctor's share, the clinic's share, the company's share and the patient's balance all appear together, and the sheet compares income with expenses day by day and month by month.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY() so it updates itself), any date inside the month you want summarised, the first month of the monthly table, the number of consultation days after an examination, and the expense categories.
2. In the "الخدمات" (Services) sheet, enter each service with its type (examination, consultation or procedure) and price.
3. In "الأطباء" (Doctors), enter each doctor's name and their percentage of the net income of their visits, and in "الشركات" (Companies) enter your contract companies and the percentage each one covers.
4. In "المرضى" (Patients), give each patient a code, name, mobile and date of first visit. Do not enter any diagnosis here.
5. In "الزيارات" (Visits), log each visit: date, patient code, service and doctor, the company if the patient is under contract, the discount and the amount paid. The notes column is free text for things you want to remember, not for diagnoses.
6. In "المصروفات" (Expenses), log each expense with its date, category and amount.
7. Open "المتابعات" (Follow-ups) to see who is still entitled to a consultation and has not come yet, and "اليومي" (Daily), "الشهري" (Monthly) and "الملخص" (Summary) for income against expenses.

**Before you start:**

- The service price is taken from the "الخدمات" (Services) sheet. Net of the visit = price - discount, and it is the clinic's income before any split.
- Company share = net × the company's coverage percentage (from the "الشركات" sheet), and patient share = net - company share. Patient balance = patient share - what the patient paid.
- Doctor's share = net × the doctor's percentage, and clinic share = the remainder. The doctor's percentage is an adjustable setting you agree on, not a fixed rule.
- Balance owed by a company = total of its shares - the "المحصّل منها" (collected from it) amount that you enter in the "الشركات" sheet each time you receive a payment from it.
- Consultation period: for each patient, the sheet takes the last visit of type "كشف" (examination). If no "استشارة" (consultation) is logged between the examination date and the end of the period you set, the patient shows as "داخل المدة" (within period) in "المتابعات" (Follow-ups), and "انتهت المدة" (period ended) afterwards.
- Income in "اليومي" (Daily) and "الشهري" (Monthly) is the net after discount (including the companies' shares), and "المحصّل" (collected) is what patients actually paid that day.
- The sheet holds 100 services, 30 doctors, 30 companies, 300 patients, 2000 visits and 1000 expenses, and "المتابعات" (Follow-ups) shows the first 60 patients.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-clinic-management.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-clinic-management-blank.xlsx)

Excel file (.xlsx) · 384 KB · 13 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: clinic accounts (1/3)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-1.jpg)[![Cheat sheet: clinic accounts (2/3)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-2.jpg)[![Cheat sheet: clinic accounts (3/3)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/clinic-management/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet depends on someone checking the shelves and typing in the items by hand. Sehaty tracks the pharmacy's stock item by item, warns you before an item runs out rather than after, and records dispensing against the e-prescription itself.

| In this sheet | In 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](https://softwiro.com/systems/sehaty.html) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How do I calculate a doctor's share in a clinic with Excel?

Enter each doctor's percentage in the "الأطباء" (Doctors) sheet, then log the visit under the doctor's name. The sheet calculates the doctor's share = net of the visit × their percentage, and the clinic's share = the remainder. The percentage is a setting you agree on and can change whenever you like.

### How does the sheet handle contract companies and insurance?

Enter the company in the "الشركات" (Companies) sheet with the percentage it covers, then pick it on the visit. The company's share is calculated from the net, the rest stays with the patient, and in "الشركات" (Companies) you track what you have collected from it and what it still owes.

### Should I enter the diagnosis or test results in the sheet?

No. The sheet is for accounts and follow-up only and holds no diagnoses or medical advice. The notes column is free text for administrative things you want to remember, and it is best not to put sensitive medical data in it.

### How does the follow-up list work?

In "الإعدادات" (Settings), enter the number of consultation days after an examination. The sheet takes each patient's last visit of type "كشف" (examination), and if no "استشارة" (consultation) has been logged within that period, the patient shows as "داخل المدة" (within period) in "المتابعات" (Follow-ups) with the days remaining.

### 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](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](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)
- Dental clinic treatment plans tracker (Excel)
- Medical lab management sheet
- Pharmacy management sheet: sales, purchases, shortages and suppliers
- Small hospital management sheet: departments, beds, admissions and revenue
- Metal and turning workshop job sheet in Excel: job orders, materials and labor
- Glass and aluminium workshop sheet in Excel: orders by square metre, cutting and waste
- Carpentry workshop sheet: cutting list, boards, cost and delivery
- Garment printing shop sheet in Excel: DTF and screen print orders and cost
- Arabic grammar summary sheet: rules, i'rab and a self-test with examples
- English grammar rules sheet in Excel: tenses and structures with examples
- Taxi, Uber and ride-hailing driver income sheet (trips, fuel, commission, daily net)
- Personal car maintenance log (oil and filter dates by kilometre and months)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
