# Pharmacy expiry and stock tracking sheet (free Excel)

> Batches with expiry dates and days left, expired and 30/60/90-day flags, reorder-level alerts, stock value at cost and at risk, and a needs-action list.

Source: https://softwiro.com/templates/pharmacy-expiry-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Pharmacy expiry and stock tracking sheet

A free Excel sheet for tracking pharmacy expiry dates and stock levels. You enter each batch with its batch number, expiry date, quantity, reorder level and cost price. The sheet counts the days left and flags each batch as expired or expiring within 30, 60 or 90 days. It alerts you to items at or below reorder level, shows stock value, and lists what needs action. The sheet tracks stock and dates only. It is not a medical reference.

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

Excel file (.xlsx) · 92 KB · 6 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

| الحالة | عدد التشغيلات | قيمتها بالتكلفة |
| --- | --- | --- |
| منتهي | 2 | 930.00 |
| خلال 30 يومًا | 3 | 2,202.00 |
| خلال 60 يومًا | 2 | 1,250.00 |
| خلال 90 يومًا | 2 | 3,550.00 |
| سليم | 6 | 3,179.00 |

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

## What is inside

- "الإعدادات" (Settings): Today's date, which the days-left count starts from. It updates automatically, or you can type a date of your own.
- "الأصناف" (Items): One batch per row: item, batch, expiry date, quantity, reorder level, cost and price. The sheet shows days left, expiry status, stock status, stock value and value at risk of expiring.
- "يحتاج إجراء" (Needs action): An automatic list of batches that are expired, close to expiring or below reorder level, sorted by nearest expiry first.
- "الملخص" (Summary): The number of batches and their value at cost for each expiry status, total stock value, value at risk of expiring, and the number of items below reorder level.

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

## What makes it different

A stock count by item alone does not show that part of it is about to expire. This sheet tracks every batch by its date, so you know what to display, return or pull from the shelf before it expires, and how much it is worth.

## How to use it

1. In the "الإعدادات" (Settings) sheet, today's date appears automatically. You can type a different date instead.
2. In the "الأصناف" (Items) sheet, enter each batch on its own row: item name, batch number, expiry date, quantity, reorder level, cost price and selling price.
3. Days left, expiry status, stock status and stock value appear automatically in the grey cells.
4. Open the "يحتاج إجراء" (Needs action) sheet to see what has expired, is close to expiring or is below reorder level, sorted by nearest expiry first.
5. Check the "الملخص" (Summary) sheet for the number of batches and their value in each status, and the value at risk of expiring.

**Before you start:**

- This sheet tracks stock and dates only. It is not a medical reference and contains no treatment information.
- The sheet holds up to 500 batches, and the "Needs action" list shows the first 60 rows.
- Statuses: "expired" if the expiry date has passed; "within 30 days" up to 30 days (including today); "within 60 days" from 31 to 60; "within 90 days" from 61 to 90; anything later is "safe".
- An item counts as "below reorder level" when its quantity is equal to or lower than the reorder level.
- Value at risk of expiring is the value, at cost price, of batches that are expired or expire within 90 days.

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

Excel file (.xlsx) · 92 KB · 6 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: pharmacy expiry and stock (1/3)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-1.jpg)[![Cheat sheet: pharmacy expiry and stock (2/3)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-2.jpg)[![Cheat sheet: pharmacy expiry and stock (3/3)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/pharmacy-expiry-tracker/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet depends on someone checking the shelves and typing in the items by hand. Sehaty tracks the pharmacy's stock item by item, warns you before an item runs out rather than after, and records dispensing against the e-prescription itself.

| In this sheet | In MyClinic (Sehaty) — Clinic, Pharmacy and Supplier Platform |
| --- | --- |
| You discover an item is short when a patient asks for it. | Sehaty tracks stock item by item and warns you before an item runs out, not after. |
| The prescription is a paper that can get lost or be hard to read, and no trace of dispensing remains. | The consultation produces an e-prescription in the patient's medical file, and the pharmacy records dispensing against that same prescription. |
| You learn what pharmacies need late, through reports and phone calls. | The supplier sees a digital catalog that reaches pharmacies and warehouses, and sees demand as it comes in. |
| The patient phones several clinics to book. | The patient searches for appointments by specialty and location and books without a phone call. |

[See MyClinic (Sehaty) — Clinic, Pharmacy and Supplier Platform](https://softwiro.com/systems/sehaty.html) · [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

### What is the difference between "within 30 days" and "within 60 days"?

Each status covers one range. "Within 30 days" runs from today up to 30 days, "within 60 days" covers days 31 to 60, and "within 90 days" covers days 61 to 90. A batch becomes "expired" once its expiry date has passed.

### How is the value at risk of expiring calculated?

It is the sum of quantity x cost price for batches that are expired or expire within 90 days. Batches that are still safe are not included.

### If an item has more than one batch, how do I record it?

Enter each batch on its own row with the same item, its own batch number, expiry date and quantity. Each batch then shows its own status.

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

- 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
- Small hospital management sheet: departments, beds, admissions and revenue
- Rent collection tracker for properties
- Business expenses and monthly budget sheet
- Lead and deal pipeline tracker
- Employee attendance sheet
- Employee payroll and attendance
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Monthly savings circle (gamaeya) tracker
- Recipe costing for restaurants and cafes (Excel)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
