Softwiro
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.

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

Example from the “الزيارات” tab (Arabic), with the numbers and formulas that are in the file.
التاريخكود المريضالخدمةالطبيبالنوعالصافيحصة الشركةحصة المريضحصة الطبيب
46296P003كشف جديدد. أحمد سعيدكشف400.000.00400.00200.00
46296P001استشارة متابعةد. أحمد سعيداستشارة200.000.00200.00100.00
46298P004كشف جديدد. منى فؤادكشف400.00320.0080.00160.00
46298P003تخطيط قلبد. أحمد سعيدإجراء250.000.00250.00125.00
46301P005كشف جديدد. هشام رأفتكشف400.000.00400.00240.00
46301P002استشارة متابعةد. منى فؤاداستشارة200.000.00200.0080.00
46303P006كشف جديدد. أحمد سعيدكشف400.00400.000.00200.00
46303P006سونارد. أحمد سعيدإجراء350.00350.000.00175.00
46305P004استشارة متابعةد. منى فؤاداستشارة200.00160.0040.0080.00
46307P007كشف جديدد. هشام رأفتكشف400.000.00400.00240.00
46308P005تضميد جرحد. هشام رأفتإجراء120.000.00120.0072.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.

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)Cheat sheet: clinic accounts (2/3)Cheat sheet: clinic accounts (3/3)
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 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

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, 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