The Pharmacy Stock Expiry Calendar in Google Sheets is a ready-to-copy scheduling workbook with six tabs, three linked calendar views and 100 sample stock-control jobs loaded across 2026, covering 18 recurring activity types in 22 named storage areas. Buy it once at $4.99, open the PDF in your download, click the copy link, and the calendar lands in your own Google Drive in about two minutes. No subscription and no per-branch licence. Built and tested by NextGenTemplates, reaching 300K+ subscribers across our YouTube channels. If the file does not open or copy correctly, contact us for a replacement or a refund.
Key Features of Pharmacy Stock Expiry Calendar in Google Sheets
- Six tabs, five visible – Home, Annual View, Monthly View, Daily View and Events, plus one hidden List tab that feeds the dropdowns.
- Four navigation buttons on Home jump to each view, and every view carries a “Back” link home.
- Annual View driven by one cell – type a year and all twelve month grids rebuild, with job days shaded, so a whole year of expiry checks reads at a glance.
- Monthly View with Month and Year dropdowns – pick September and 2026 and the Sun-to-Sat grid fills with that month’s jobs by date.
- Daily View date range – set a Start Date and End Date and a
FILTERformula returns every job between them across all seven columns. - 100 sample jobs on the Events tab, numbered 1 to 100 and dated 01-Jan-2026 to 30-Dec-2026, spread eight or nine to a month, with room for roughly 900 more rows.
- 18 recurring activity types – Batch Expiry Audit, Near-Expiry Shelf Sweep, FEFO Rotation Check, Expiry Sticker Re-Tagging, Quarantine Segregation, Expired Stock Destruction, Short-Dated Stock Transfer, Distributor Return Pickup, Supplier Credit Reconciliation, Recall Notice Screening, Physical Stock Count, Cold Chain Temperature Log, Fridge Defrost and Clean, Vaccine Batch Verification, Syrup and Ointment Check, Narcotics Register Audit, Schedule H Cabinet Review and Drug Inspector Readiness.
- 22 named storage areas covering the whole pharmacy floor – Bulk Store Rack A and B, Fast Mover Rack, Front Retail Shelf, OTC Display Aisle, Syrup Aisle, Antibiotic Shelf, Dispensing Counter, Backroom Store, Goods Inward Bay, Returns Staging Area, Quarantine Shelf, Expired Stock Cage, Disposal Yard, Cold Chain Refrigerator, Insulin Chiller, Vaccine Fridge 2, Narcotics Safe, Schedule H Cabinet, Schedule X Cabinet, Billing Desk and Pharmacy Office.
- Cold chain and controlled stock sit on the same calendar – fridge temperature logs, defrost days, vaccine batch checks, narcotics register audits and Schedule H / Schedule X cabinet reviews run alongside the ordinary shelf sweeps.
- 14 working time slots from 8:00 AM to 7:00 PM, so opening-hour jobs and closing-hour jobs are visibly separated.
- No patient data by design – the seven columns are ID, Date, Day, Event Name, Time, Location and Description. There is no patient, prescriber or prescription column anywhere in the workbook.
- Rolling year list – the hidden List tab carries a 36-year range, 2021 to 2056, so the year dropdown does not expire.
- Nothing to install – native Sheets formulas only. No Apps Script, no macros, no add-on permissions.
What’s Inside the Pharmacy Stock Expiry Calendar in Google Sheets
Home is a title banner over four stacked buttons – Annual View, Monthly View, Daily View, Events. It is the menu, not a dashboard: no counters, no charts.
Annual View lays out twelve month grids, three across and four down, each Sun to Sat. One Year cell drives them all, and days carrying a job are shaded, so you can see at a glance that January holds eight checks and April holds nine.
Monthly View puts Month and Year dropdowns above a Sun-to-Sat grid. Each day cell shows the date and the job booked that day – Short-Dated Stock Transfer on Thursday the 3rd, Drug Inspector Readiness on Tuesday the 8th. Where a day holds more than one, the first name appears with a “1 more…” note; the grid is a summary, and the full list lives in Daily View and Events.
Daily View takes Start Date and End Date over a seven-column table. Set 01-Sep-26 to 30-Sep-26 and it returns the eight September jobs – IDs 68 to 75 – with day, time, storage area and a one-line description such as “Scan every batch number on the rack and match it to the expiry register.”
Events is the single source table behind all three views: ID, Date, Day, Event Name, Time, Location, Description. Add a row here and every view updates without touching a formula. List (hidden) holds the month names and the 2021-2056 year range behind the dropdowns.
Pharmacy Stock Expiry Calendar in Google Sheets vs. Microsoft Excel Calendar vs. Paid Pharmacy Inventory SaaS – Where This Fits
| This Google Sheets calendar | Excel calendar file | Pharmacy inventory or ERP SaaS | |
|---|---|---|---|
| Cost | $4.99 once | One-off file price | Recurring subscription |
| Platform | Google Sheets in a browser | Desktop Excel | Vendor’s web app |
| Setup time | Copy link, about 2 minutes | Download and open | Onboarding, stock import, training |
| Real-time team editing | Yes, native to Sheets | Only via OneDrive co-authoring | Yes |
| Mobile access | Google Sheets app | Excel mobile app | Vendor app |
| Customisable activities and storage areas | Yes, it is your sheet | Yes | Usually fixed catalogues |
| Share with a link | Yes | File send or cloud link | Seat invitations |
| Year-1 cost, 5 staff | $4.99 total – seats are free in Sheets | One file price | Scales with users and branches |
| Reads batch numbers or expiry dates from your stock file | No – you schedule the check, you do not import stock | No | Usually yes |
| Automatic near-expiry alerts by SKU | No – nothing is calculated from batch data | No | Usually yes |
| Barcode or 2D-code scanning | No | No | Usually yes |
| Statutory registers, witnessed destruction records, e-signatures | No – it schedules the job, it is not the register | No | Sometimes |
| Reminders or notifications to staff | No – it sends nothing | No | Usually yes |
Read the bottom five rows before you buy. This is a scheduling spreadsheet: it shows which stock-control job is due when and in which storage area. It does not read your batch numbers, calculate near-expiry lists, scan anything, hold your statutory registers, or message your team.
Who This Template Is For – and Who It’s Not For
A good fit if you run a retail pharmacy, a hospital pharmacy store or a clinic dispensary and the expiry routine currently lives on a wall planner or in someone’s head; if you want a twelve-month view of audit and destruction load before an inspection; or if two or three staff need to edit the same stock-control diary from a browser.
Not a good fit if you need batch-level expiry alerts generated from your own stock file, barcode scanning, automatic FEFO picking lists, purchase-order or returns automation, statutory register keeping, or an audit trail of who changed what. Those are pharmacy inventory and ERP jobs, and this template does none of them.
Please note. This is a scheduling and record-keeping spreadsheet, not medical software and not pharmacy-compliance software. It is not a regulated system of record, it is not a licensed dispensing or inventory system, and it makes no HIPAA, GDPR, Drugs and Cosmetics Act, GDP or other compliance or certification claim. It holds only what you type into a file in your own Google account, with no access control, encryption or audit trail beyond the sharing settings Google itself provides. The 100 sample rows deliberately carry activity, time and storage area only – there is no patient, prescriber, prescription, batch-number or quantity column anywhere in the workbook, and we recommend you keep it that way. Where a jurisdiction requires a specific register or a witnessed record for destruction or controlled drugs, keep that register as your legal record and use this calendar only to schedule the work.
How to Use the Pharmacy Stock Expiry Calendar in Google Sheets
- Open the PDF in your download and click the “Make a copy” link. The calendar is created in your own Google Drive.
- Open the Events tab. The sample data runs from ID 1 to ID 100.
- Rename the storage areas first in the Location column – it is the field your team will scan most. Swap “Bulk Store Rack A” and “Vaccine Fridge 2” for your own rack and fridge labels.
- Replace the samples with your own jobs, keeping the column order and using real dates so the views can read them. Keep it to the activity, the time and the storage area – not batch numbers or patient details.
- Check Monthly View – pick your month and year from the dropdowns and the grid fills from Events automatically.
- Use Daily View for the week ahead by setting Start Date and End Date to the range you want, then print it for the dispensary noticeboard.
- Use Annual View for planning – change the Year cell to see the whole year’s job days at once and move a destruction day off the week that already carries a stock count.
- Share it with Google’s own Share button. Anyone with the link sees whatever the sheet contains, so set the sharing scope deliberately.
Real-World Use Cases
Anita, superintendent pharmacist at a two-branch retail chain. She keeps Bulk Store Rack A, Fast Mover Rack and the Expired Stock Cage in the Location column, then uses Annual View each quarter to check that a Batch Expiry Audit falls in every month and that the five Expired Stock Destruction days are not bunched into one week.
Daniel, hospital pharmacy storekeeper. Every Friday he sets Daily View to the coming week and prints the filtered list for the store, so the team can see which slots are Cold Chain Temperature Logs in the Insulin Chiller and which are Quarantine Segregation runs to the Expired Stock Cage.
Farah, clinic dispensary in-charge preparing for an inspection. She uses the eight Drug Inspector Readiness rows as her dry-run schedule, cross-checks the Narcotics Register Audit and Schedule H Cabinet Review dates against her paper registers, and shares view-only access with the clinic manager.
Frequently Asked Questions
Is this pharmacy-compliance or medical software?
No. It is a scheduling and record-keeping calendar in Google Sheets. It is not a regulated system of record, not a dispensing or inventory system, and it carries no HIPAA, GDPR, Drugs and Cosmetics Act or GDP certification. Keep your statutory registers where they legally belong and use this to schedule the work around them.
Does it track individual batch numbers and expiry dates?
No, and that is deliberate. There is no batch, SKU, quantity or expiry-date column. Each row records the job – a Batch Expiry Audit on Bulk Store Rack A, for example – along with the date, time and storage area. Your batch-level data stays in your stock system.
Will it warn me when something is about to expire?
No. Nothing is calculated from stock data, so there are no near-expiry alerts. What it gives you is the recurring rhythm – the Near-Expiry Shelf Sweep and the FEFO Rotation Check land on the calendar so the sweep actually happens.
Does it store any patient or prescription details?
No. There is no patient, prescriber or prescription column anywhere in the workbook. The single mention of prescription-only stock in the sample data describes a shelf category, not a person.
Does it send reminders to my staff?
No. Nothing here sends an SMS, an email or a notification, and it does not connect to a POS or inventory system. It is a spreadsheet you and your team read.
Can I use it for cold-chain and controlled drugs alongside ordinary shelf stock?
Yes. The sample data already mixes them – Cold Chain Temperature Log and Fridge Defrost and Clean in the Insulin Chiller and Cold Chain Refrigerator, Vaccine Batch Verification in Vaccine Fridge 2, Narcotics Register Audit in the Narcotics Safe, and Schedule H and Schedule X cabinet reviews, all on the same calendar as the Front Retail Shelf sweeps.
What exactly is in the download?
A PDF carrying the “Make a copy” link for the Google Sheet. There is no Excel or ZIP file – the PDF is how you get the sheet into your own Drive.
Can I change the activities and storage areas?
Yes. All 18 activity names and 22 locations sit in ordinary cells on the Events tab. Overwrite them and all three views follow.
Do I need Apps Script, macros or an add-on?
No. The views use native formulas – FILTER, VLOOKUP and DATE. Nothing asks for permissions and nothing runs in the background.
The sample data is 2026 – does it expire?
No. The Year cell accepts any year and the hidden List tab carries a 2021 to 2056 range, so the dropdown keeps working for decades.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
Prefer a desktop file to a browser tab? The same calendar is available as the Pharmacy Stock Expiry Calendar in Excel, with the identical Annual, Monthly and Daily views in a macro-enabled workbook.
For general stock rather than medicines, the Product Expiration Date Calendar in Google Sheets uses the same six-tab layout, and the Warranty Expiration Calendar in Google Sheets applies it to warranty end dates. To keep the shelf itself topped up, add the Office Supplies Restock Calendar in Google Sheets.
To record what is actually on the shelf rather than only when it is checked, the Medicine Stock Data Entry System in Excel is the stock-register companion. For the numbers behind the counter there is the Pharmacy KPI Dashboard in Google Sheets and the Pharmacy Sales & Operations Dashboard in Google Sheets. When a spreadsheet is no longer enough, the Pharmacy Inventory and Billing Management System Web App is the multi-user step up.
Browse the whole Google Sheets Calendar category or the wider Google Sheets template library.
Get the Pharmacy Stock Expiry Calendar in Google Sheets for $4.99 – one payment, no subscription, yours to copy and edit in your own Google Drive. A full walkthrough of every tab is on the blog: Pharmacy Stock Expiry Calendar in Google Sheets.
Watch the step-by-step video Demo:
Last updated: 27 August 2026.
