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 (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
- Settings (الإعدادات): type today's date (or =TODAY() so lateness is measured against the real day) and any date inside the month to summarise.
- Tests (التحاليل): for each test a code, name, sample type, turnaround in days, price and reagent cost.
- 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.
- 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.
- Sample status: update it as work moves on: collected, in the lab, ready, delivered, and type the delivery date.
- Late and Stock (المتأخرة، المخزون): open Late to see what has passed its due date, and Stock to see what needs ordering.
- 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. For stock alone there is the general shop inventory sheet, and for clinics the complete clinic management sheet.
Try it now
Open the sheet and try it online, or download the Excel file. 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.





