Clinic Finance Dashboard — Excel Tracker

The Complete Finance Tracker for Clinics & Medical Practices

Built specifically for private clinics, medical centres, and healthcare practices in Mauritius, this Excel dashboard gives doctors, clinic managers, and administrators a full financial and operational overview — from patient counts to pharmacy stock — all in one file in Mauritian Rupees (Rs).

Enter your figures in the yellow cells and every total, margin, and stock value updates automatically.

What's Inside — 6 Powerful Tabs

• 📊 Dashboard — Your command centre. See Total Revenue, Total Expenses, and Net Profit at a glance, plus a Full Summary showing Net Profit, Profit Margin %, Total Payroll, Total Patients (Yr), and Medicine Stock Value — all auto-calculated.
• 💰 Revenue — Monthly Revenue by Service (General Consultations, Specialist Consultations, Laboratory & Tests, Radiology & Scans, Minor Procedures, Pharmacy Sales, Vaccination Services, Health Check Packages) with annual totals, plus a Monthly Operating Costs breakdown (Staff Salaries & Wages, Rent & Utilities, Medical Supplies & Consumables, Pharmacy Stock Purchase, Equipment Maintenance, Lab & Test Reagents, Insurance & Licensing, Marketing, IT & Software, Miscellaneous).
• 👥 Patients — Monthly Patient Count by Department (General Practice, Paediatrics, Gynaecology, Cardiology, Dermatology, Orthopaedics, ENT) with annual totals, plus a Revenue per Patient Analysis showing Revenue This Month, Revenue per Patient, Target per Patient, and a Performance status per department.
• 💊 Pharmacy — Medicine & Stock Inventory Tracker with 18 pre-filled items (Paracetamol, Amoxicillin, Ibuprofen, Omeprazole, Metformin, Amlodipine, Salbutamol Inhaler, Oral Rehydration Salts, Vitamin D3, Folic Acid, Surgical Gloves, Syringes, Gauze & Bandages, Rapid Test Kits, Antiseptic Solution, Insulin & more). See Stock Value per item, Total Stock Value, and automatic REORDER NOW alerts.
• 👥 Payroll — Monthly Staff Payroll for up to 11 roles (Medical Director or Doctor, General Practitioner, Specialist Doctor, Head Nurse, Nurse x2, Lab Technician, Pharmacist, Receptionist, Admin Staff, Cleaner). Enter Basic Salary, Allowances, Overtime, and Deductions — Net Pay calculates automatically.
• 🗓️ Appointments — Daily Appointment Log. Record each appointment by Date, Patient Name, Doctor or Specialist, Department, Appointment Time, Consultation Fee, and Payment Status — keeping your daily operations fully organised.

Key Features

• ✅ Pre-built formulas — zero manual calculations
• ✅ Pharmacy stock tracker with reorder alerts
• ✅ Revenue per patient analysis by department
• ✅ Daily appointment log built in
• ✅ Currency set to Mauritian Rupees (Rs)
• ✅ Color-coded for fast, easy reading
• ✅ Works on Microsoft Excel (desktop & online)
• ✅ Instant download — ready to use today

Perfect for private clinics, medical centres, GP practices, specialist clinics, and healthcare businesses in Mauritius.

Format: .xlsx (Microsoft Excel) | Currency: MUR (Rs) | Instant Digital Download