# Small hospital management sheet

> Hospital records and billing in Excel: departments and beds, admissions with stay length and payer, bills, monthly bed occupancy, clinics and expenses.

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

---

Free Excel template

# Small hospital management sheet: departments, beds, admissions and revenue

A free Excel sheet for running a small hospital on the records-and-money side. You enter your departments, their number of beds and the daily bed rate, then log each admission with admission and discharge dates and the payer, and record services and procedures against the admission number, along with payments. The sheet calculates length of stay, each admission's bill and the balance, each department's occupancy rate for every month, and revenue from beds, services and outpatient clinics. It compares revenue with expenses by category and shows the outstanding balance for each payer: cash, insurance or contract. The sheet contains no diagnoses or treatment data, and it is best to enter a patient code rather than a name.

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

Excel file (.xlsx) · 210 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

| رقم الدخول | القسم | تاريخ الدخول | تاريخ الخروج | جهة الدفع | ليالي الإقامة | إجمالي الفاتورة | المدفوع | المتبقي |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ADM-1001 | باطنة | 46296 | 46298 | نقدي | 2 | 4,580.00 | 4,580.00 | 0.00 |
| ADM-1002 | رعاية مركزة | 46296 | 46302 | تعاقد | 6 | 21,800.00 | 0.00 | 21,800.00 |
| ADM-1003 | باطنة | 46297 | 46299 | نقدي | 2 | 2,100.00 | 1,900.00 | 200.00 |
| ADM-1004 | جراحة | 46297 | 46299 | تعاقد | 2 | 6,730.00 | 0.00 | 6,730.00 |
| ADM-1005 | جراحة | 46297 | 46303 | تعاقد | 6 | 8,100.00 | 0.00 | 8,100.00 |
| ADM-1006 | رعاية مركزة | 46297 | 46300 | نقدي | 3 | 11,950.00 | 11,950.00 | 0.00 |
| ADM-1007 | عظام | 46297 | 46299 | نقدي | 2 | 3,400.00 | 3,050.00 | 350.00 |
| ADM-1008 | نساء وتوليد | 46297 | 46299 | نقدي | 2 | 13,400.00 | 13,400.00 | 0.00 |
| ADM-1009 | باطنة | 46298 | 46299 | تعاقد | 1 | 3,400.00 | 2,700.00 | 700.00 |
| ADM-1010 | عظام | 46298 | 46304 | نقدي | 6 | 7,800.00 | 7,800.00 | 0.00 |

Example from the “الدخول” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات (Settings): Any date within the summary month, the first month of the monthly table, today's date, the alert threshold for a nearly full department and the expense categories (up to 8).
- الأقسام (Departments): Department, number of beds and bed rate per day. Beside each: current inpatients, admissions this month, days of stay, monthly occupancy, bed revenue, service revenue and an over-capacity alert. It holds 12 departments.
- قائمة الخدمات (Service list): The services and procedures you charge for, with type and price. You pick from this list in the Services Provided tab. It holds 40 services.
- الدخول (Admissions): One row per admission: admission number, patient code, department, admission and discharge dates, payer and discount. It shows status, nights of stay, bed charges, services, the bill, amount paid, balance and data alerts. It holds 300 admissions.
- الخدمات المقدمة (Services provided): Each service or procedure on an admission number with its date, quantity and an optional custom price. The sheet works out the department, unit price and amount. It holds 800 rows.
- المدفوعات (Payments): Each amount received against an admission number, with date and payment method. The payer appears automatically, with an alert if the number is not registered. It holds 400 payments.
- العيادات (Clinics): Outpatient clinics and the price of a visit in each, with the selected month's visits and revenue beside each. It holds 12 clinics.
- زيارات العيادات (Clinic visits): The number of visits to each clinic per day. The sheet works out the visit price and revenue. It holds 500 rows.
- المصروفات (Expenses): Date, category, description and amount of each expense. It holds 400 expenses.
- الإشغال الشهري (Monthly occupancy): For each department over six consecutive months: occupancy rate, days of stay and bed revenue, with a hospital total. The current month is calculated up to today's date.
- الملخص (Summary): The month's revenue from beds, services and clinics, expenses, net result and collections, bed and admission figures, the balance for each payer, expenses by category and a six-month table, with four charts.

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

## What makes it different

You enter admissions, services and payments once, and the sheet knows each patient's bill and balance, what each payer owes, each department's occupancy month by month, and how revenue compares with expenses, without you adding up numbers from departmental books.

## How to use it

1. In the «الإعدادات» (Settings) tab, enter today's date (or =TODAY() to update itself), any date within the month you want summarised, the first month of the monthly table and the expense categories.
2. In «الأقسام» (Departments), enter each department, its number of beds and the bed rate per day. In «قائمة الخدمات» (Service list), enter the services and procedures you charge for and their prices.
3. In «الدخول» (Admissions), log each admission on one row: admission number, patient code, department, admission date, discharge date (leave it empty while the patient is still in the hospital), payer and discount. Do not enter any diagnosis here.
4. In «الخدمات المقدمة» (Services provided), record each service against the admission number with its date and quantity. You can enter a custom price if it differs from the list.
5. In «المدفوعات» (Payments), record each amount you received against an admission number, and the amount paid and balance appear in the Admissions tab.
6. In «العيادات» (Clinics), enter the outpatient clinics and the visit price; in «زيارات العيادات» (Clinic visits), enter each clinic's visits per day; in «المصروفات» (Expenses), record expenses by category.
7. Open «الإشغال الشهري» (Monthly occupancy) for each department's occupancy over six months, and «الملخص» (Summary) for revenue against expenses and the balance by payer.

**Before you start:**

- This sheet is for records and accounts only. It contains no diagnoses or treatment data, and it is best to enter a patient code rather than the full name. Follow whatever requirements the competent authority sets for keeping patient data.
- Length of stay in nights = discharge date - admission date, with a minimum of one night. For a current inpatient (no discharge date), it is counted up to "today's date" in Settings.
- Admission bill = length of stay x the department's bed rate + total services for the admission number - discount. Balance = bill - amount paid against the same admission number.
- Department occupancy in a month = (days of stay within the month) / (number of beds x days elapsed in the month up to today's date). The current month is calculated up to today's date, and a month that has not started appears empty.
- Bed revenue in a month = days of stay within it x bed rate. Service revenue is counted by the date the service was recorded, and clinic revenue by visit date. Revenue here is on a billed (accrual) basis, not collected, and collections have a separate line in the Summary.
- Payers: cash, insurance or contract. The Summary shows each payer's number of admissions, bills, amount paid and balance, so you know what you need to collect from companies.
- The sheet holds 12 departments, 300 admissions, 40 services in the list, 800 service rows, 400 payments, 12 clinics, 500 visit rows and 400 expenses.

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

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

0 downloads · 3 pages

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

[See Custom Software from Softwiro](https://softwiro.com/contact) · [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 bed occupancy for each department in Excel?

Enter each department's number of beds in «الأقسام» (Departments) and log admissions with admission and discharge dates. The sheet counts days of stay within each month, and occupancy = days of stay / (number of beds x days elapsed in the month). The current month is calculated up to the date entered in Settings.

### How are the patient bill and length of stay calculated?

Length of stay in nights = discharge date - admission date, with a minimum of one night; for a current inpatient it is counted up to today's date. Bill = nights x the department's bed rate + the admission's services - discount, and balance = bill - amount paid.

### How do I track what insurance and contract companies owe?

Choose "insurance" or "contract" as the payer on the admission row, and record what you receive from the payer in «المدفوعات» (Payments) against the admission number. The Summary shows each payer's number of admissions, bills, amount paid and balance.

### Should I write the diagnosis or medical procedure in the sheet?

No. The sheet is for records and money only and contains no diagnoses or treatment data. Enter the patient code, not the full name, and follow whatever requirements the competent authority sets for keeping patient data.

### 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)
- Complete clinic management sheet
- Medical lab management sheet
- Pharmacy management sheet: sales, purchases, shortages and suppliers
- 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)
