# Medical lab management Excel sheet (free) + online

> Free Excel sheet for a medical lab: price list, orders, discounts, referring doctors' commission, sample status, late-result alerts, reagent stock and revenue.

Source: https://softwiro.com/blog/medical-lab-management-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Medical lab management in Excel (free): prices, samples, results due and referrals

One workbook for the tests price list, patient orders, sample status with late alerts, referring doctors' commission and reagent stock.

15 November 2026 6 min read

## In short

- One row per test; the sheet works out the company discount, net, due date, commission and profit.
- Sample status (collected, in the lab, ready, delivered) with a late alert against each test's turnaround days.
- Referring doctors' commission is an editable percentage, and contract companies have a discount and a balance.
- A simple reagent stock shows balance and whether to order, with daily revenue and four charts.
- Records and prices only: no results, no reference ranges, no interpretation.

You run a medical lab and want quick answers: how many tests were ordered this month and what they earned net, what the reagents cost, what the referring doctors' commission comes to, which result is late before the patient calls you, and which reagent is about to run out. The free [medical lab management sheet](https://softwiro.com/templates/medical-lab-management) (the page is in Arabic) keeps the price list, patient orders, sample status, doctors' commission, reagent stock and daily revenue in one file. It is a record of prices, orders and samples only: it holds no results, no reference ranges and no interpretation of any result.

## The problem it solves

In many labs orders go in a book, sample status on a slip of paper, the doctor's commission is worked out from memory at month end, and reagents are checked when they run out. A patient asks "is my result ready?" and you go looking; you want the month's profit and you add it up by hand. Here each test is typed once on a row and the rest is calculated.

## Step by step, from opening the file to the report

1. Settings (الإعدادات): type today's date (or =TODAY() so lateness is measured against the real day) and any date inside the month to summarise.
2. Tests (التحاليل): for each test a code, name, sample type, turnaround in days, price and reagent cost.
3. Companies and referring doctors (الشركات، المحوِّلون): contract companies with a discount each, and doctors with a commission percentage. The commission is a setting you agree and can edit; make sure the arrangement is allowed under local law.
4. Orders (الطلبات): one row per test. An order with several tests repeats its number and patient name on each row. Pick the company and doctor if any, and type the extra discount and the amount paid.
5. Sample status: update it as work moves on: collected, in the lab, ready, delivered, and type the delivery date.
6. Late and Stock (المتأخرة، المخزون): open Late to see what has passed its due date, and Stock to see what needs ordering.
7. Open Daily (اليومي) and Summary (الملخص); both calculate themselves.

## What each sheet does

- Orders: pulls the price, sample type and reagent cost from Tests, and works out the company discount, net, due date, alert (late, on time or done), commission and profit.
- Late: late tests, oldest due date first, with the patient's phone and the days late.
- Stock: balance = opening + received − used, with status: available, order (below the minimum) or out.
- Daily and Summary: revenue, collected, cost, commission and profit, sample status, and four charts.

## Walk-through on the sample numbers

The names and figures below are sample data in the workbook, not real people. The sample has 14 orders and 31 tests between 20 October and 15 November 2026; the chosen month is November and "today" is 15 November.

- A test with a company discount: an HbA1c priced at 250 for Louay Nasser from the Oasis Sports Club (10% discount) nets 225, reagents cost 90, so profit is 135.
- A test with discount and commission: vitamin D priced at 650 with a 50 extra discount for Salma Reda nets 600. Her referring doctor, Dr Hala Gaber, earns 8%, which is 48, and the reagent costs 300, so profit is 252.
- November 2026: 11 orders and 24 tests, list prices 3,880, company discounts 105 and extra discounts 50, so net revenue is 3,725. Reagents cost 1,414 and doctors' commission is 219.6, leaving profit of 2,091.4, a 56.1% margin. Patients paid 2,840.
- November commissions: Dr Yasser Mansour 22, Dr Hala Gaber 116, Dr Adel Fahmy 81.6.
- Late results: four tests: a urine culture for Doaa Fouad (due 8 November, 7 days late), an HbA1c for Louay Nasser (6 days), a urine analysis for Amr El-Shenawy (4 days) and a creatinine for Ayman Kandil (1 day). Five ready tests have not been delivered yet, and three are due today.
- What is owed: patients owe 200 (30 and 170). Companies owe 814.5 after what they paid: 265.5, 405 and 144.
- Reagents: four items need ordering: three below their minimum (blood-count reagent, creatinine reagent and EDTA tubes) and one out (serum tubes).
- Sample status in November: 8 collected, 4 in the lab, 5 ready and 7 delivered.

## Common mistakes

- Forgetting to change the status to "ready": the test stays "late" on the list although it is done. Update the status when the result is out.
- Typing the wrong turnaround: every alert is built on it, so check it when your workflow changes.
- Typing the company or doctor by hand: pick them from the list; one different letter drops the discount or commission.
- Not updating "collected so far" on the Companies sheet, so a company looks as if it never paid.
- Recording or interpreting patient results in the sheet: that is outside its job; keep results in your lab system.

## When to move to a system

If reception, the lab bench and the accountant need to work at the same time, the order volume outgrows a sheet, or you want screens and reports built around your lab's workflow, Softwiro can [build you a custom program](https://softwiro.com/contact). For stock alone there is the [general shop inventory sheet](https://softwiro.com/templates/general-inventory), and for clinics the [complete clinic management sheet](https://softwiro.com/templates/clinic-management).

## Try it now

[Open the sheet and try it online, or download the Excel file](https://softwiro.com/templates/medical-lab-management). Clear the sample figures, type your tests and prices first, then record today's orders. It holds 200 tests, 1000 order rows and 50 reagent items. For something tailored to your lab, [request it here](https://softwiro.com/request-sheet).

## 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: lab management (1/3)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-1.jpg)[![Cheat sheet: lab management (2/3)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-2.jpg)[![Cheat sheet: lab management (3/3)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/medical-lab-management/en-3.jpg)

0 downloads · 3 pages

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

## Questions this raises

### How do I know a test result is late?

Type each test's turnaround in days in the Tests sheet. Due date = order date + turnaround; if it has passed and the status is not ready or delivered, the test shows as late in Orders and in the Late sheet.

### How is a referring doctor's commission calculated?

Commission = the test's net × the doctor's percentage in the Referring doctors sheet. The percentage is a setting you agree on and can edit; make sure the arrangement is allowed under local law.

### How does the sheet handle contract companies?

Enter the company and its discount in the Companies sheet and pick it on the test row. The discount comes off the price, the test's net is billed to the company rather than the patient, and you track what it has paid and what remains.

### Does the sheet store test results or reference ranges?

No. It is for prices, orders, samples and accounts, with no results, reference ranges or interpretation. Keep patient results in your own lab system.

### How many rows does it hold?

200 tests, 1000 order rows, 30 doctors, 30 companies and 50 reagent items. When you outgrow that, consider a custom program.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
