Softwiro
Free Excel template

Medical lab management sheet

A free Excel sheet for managing a medical laboratory. You enter the test list with each test's price, reagent cost and turnaround time, then record patient orders with one row per test. The sheet works out the price, discount, net revenue, the referring doctor's commission and the profit on each test. It tracks each sample's status (collected, in the lab, ready, delivered) and warns you about a result that has passed its turnaround time, and shows reagent stock and each day's revenue. The sheet covers prices, orders and samples only: it contains no results, no reference ranges and no interpretation of any result.

Excel file (.xlsx) · 272 KB · 11 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.
رقم الطلبالتاريخالمريضكود التحليلالتحليلالسعرالصافيموعد النتيجةتنبيه
100146315عبير سالمL01صورة دم كاملة CBC120.00120.0046316تم
100146315عبير سالمL02سكر صائم50.0050.0046315تم
100246319ماجد صلاحL03سكر تراكمي HbA1c250.00250.0046320تم
100246319ماجد صلاحL04كرياتينين70.0070.0046320تم
100346323نبيل عوضL01صورة دم كاملة CBC120.00102.0046324تم
100346323نبيل عوضL05إنزيم ALT70.0059.5046324تم
100346323نبيل عوضL06دهون ثلاثية80.0068.0046324تم
100446327سلمى رضاL08هرمون TSH200.00200.0046329تم
100446327سلمى رضاL09فيتامين د650.00600.0046330تم
100546329حسام الدينL10تحليل بول كامل60.0060.0046329تم
100546329حسام الدينL11تحليل براز كامل60.0060.0046329تم

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

What is inside

  • الإعدادات (Settings): Today's date (written as the example date, and you can enter =TODAY()) and any date within the summary month.
  • التحاليل (Tests): Code, name, sample type, turnaround time in days, price and reagent cost, then profit before commission, the month's count and revenue. It holds 200 tests.
  • الشركات (Companies): Contract companies with each one's discount percentage and what you have collected from it. The sheet shows its number of tests, the net it owes and the balance.
  • المحوِّلون (Referrers): Referring doctors with each doctor's commission percentage (an editable setting), and beside each the month's tests, their net revenue and the commission.
  • الطلبات (Orders): One row per test: order number, date, patient, mobile, test code, company, doctor, extra discount, amount paid, sample status and delivery date. The sheet works out the price, company discount, net, result due date, alert, commission, cost, profit and the balance owed by the patient. It holds 1,000 rows.
  • المتأخرة (Late): Tests whose result due date has passed and which are not yet ready, oldest due date first, with the patient's mobile and days late, plus the count of ready results not yet delivered.
  • المخزون (Stock): Reagent and supply items: minimum level, opening stock, received and used. The sheet shows the balance, status (in stock, order or out) and value. It holds 50 items.
  • اليومي (Daily): The days of the chosen month: orders, tests, revenue, amount collected, reagent cost, doctors' commissions and profit.
  • الملخص (Summary): The month's figures, amounts owed and alerts, sample status, and revenue of the top eight tests, with four charts: revenue per test, sample status, daily revenue and profit, and each doctor's commission.

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

What makes it different

The price list, patient orders and sample status are in one file. The lab enters a row once and the net, commission and profit appear, and the sheet warns you before a patient asks about a result that is late.

How to use it

  1. In the «الإعدادات» (Settings) tab, enter today's date (or =TODAY() to update itself) and any date within the month you want summarised.
  2. In «التحاليل» (Tests), enter each test with its code, name, sample type, turnaround time in days, price and reagent cost.
  3. In «الشركات» (Companies), enter the contract companies and each one's discount percentage, and in «المحوِّلون» (Referrers) enter the doctors and each doctor's commission percentage.
  4. In «الطلبات» (Orders), write one row for each test ordered. An order with several tests repeats its number and the patient's name on its rows. Pick the company and doctor if there are any, and enter the extra discount and the amount paid.
  5. Change the sample status as work progresses: collected, then in the lab, then ready, then delivered, and enter the delivery date when the result is handed over.
  6. Open «المتأخرة» (Late) to see the results that have passed their turnaround time and are not ready, and «المخزون» (Stock) to see which reagents need ordering.
  7. Review «اليومي» (Daily) for each day's revenue and «الملخص» (Summary) for the month's figures and charts.

Before you start:

  • A test's price, reagent cost and turnaround time are taken from the Tests tab by code. The sheet contains no reference values and no interpretation of any result.
  • Company discount = price x the company's discount percentage. Test net = price - company discount - extra discount. A contract company's tests are charged to the company, not the patient.
  • The balance owed by the patient appears on the first row of each order = the patient's share of the order's rows - the total they paid on its rows. The balance owed by a company = the total of its net - the "collected from it" figure you enter in the Companies tab.
  • Referring doctor's commission = test net x the doctor's percentage. This percentage is an editable setting based on your agreement, and check that this arrangement is permitted under local law.
  • Result due date = order date + test turnaround time. If it has passed and the status is not "ready" or "delivered", the test shows as "late" in Orders and in the Late tab.
  • Test profit = net - reagent cost - commission. Stock is simplified: you enter the opening quantity, received and used by hand, and the sheet works out the balance and status.
  • The sheet holds 200 tests, 30 doctors, 30 companies, 50 reagent items and 1,000 order rows, and Late shows the first 60 tests.

Excel file (.xlsx) · 272 KB · 11 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: lab management (1/3)Cheat sheet: lab management (2/3)Cheat sheet: lab management (3/3)
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 sheetIn 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 · Ask for a demo

Frequently asked questions

How do I know that a test result is late?

Enter each test's turnaround time in days in the «التحاليل» (Tests) tab. Result due date = order date + turnaround time, and if it has passed and the status is not "ready" or "delivered", the test shows as "late" in «الطلبات» (Orders) and «المتأخرة» (Late).

How is the referring doctor's commission calculated?

Commission on a test = its net x the doctor's percentage in the «المحوِّلون» (Referrers) tab. The percentage is a setting you agree and edit, and check that this arrangement is permitted under local law.

How does the sheet handle contract companies?

Enter the company and its discount percentage in «الشركات» (Companies) and pick it on the test row. The discount is taken off the price, the test's net is charged to the company rather than the patient, and you track what you have collected from it and what remains.

Does the sheet store test results or reference ranges?

No. The sheet is for prices, orders, samples and accounts, and contains no results, reference ranges or interpretation. Keep patients' results in your own lab system.

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