About this template
Whose refill is due this week? How many pills are actually left? Which pharmacy has it, and which doctor needs to renew it? For a family juggling several prescriptions — yours, your spouse's, a parent's — those answers live in five different pharmacy apps and nobody's head. The Medication & Refill Tracker Dashboard puts every medication for the whole family in one file. You type what the label and the pharmacy record say, once, in pale-yellow cells. The next refill date, the run-out date, the days of supply left and the status calculate themselves. The grey SAMPLE rows are a fictional couple, Alex and Sam, and four common medications. They are not real people. Delete the SAMPLE rows when you're ready and the whole file is yours. This tracker is an organizational and reminder tool, not medical advice. It never tells you how much of a medication to take — always follow your prescriber's and pharmacist's instructions, and confirm refill dates and supply with your pharmacy. LICENSE Personal use only — for your own household. Please do not share, resell or redistribute the file. © 2026 99toFive — US Life Dashboards. All rights reserved.
What's inside
- Start Here — the 3 steps, a download/open checklist for Etsy, Excel and Google Sheets, the color guide (pale yellow = type here; white/gold = automatic; grey = sample data), a walk-through of the filled example, and the license.
- Dashboard — the refill watch: active medications listed, refills OVERDUE today in bold, refills due within 7 days and within 30 days, the soonest next refill date, the soonest run-out date, and what refills have cost so far.
- Medications Register — one row per person per medication (there's a Family member column, so spouses, kids and parents each get their own rows): medication, dose/strength exactly as the label says, purpose, prescriber, pharmacy, refill cycle in days, date last filled, quantity per fill and how many are taken per day. From those, the sheet calculates the NEXT REFILL date, days to refill, the RUN-OUT date, days of supply left, and a plain status: OK, Refill soon, or OVERDUE.
- Refill Log — one line per pickup: date filled, family member, medication, pharmacy, quantity, cost and who picked it up — with the total refill cost added up for you.
- Pharmacies & Prescribers — the phone numbers you need when a refill stalls: pharmacies, prescribers and the insurance card line, with addresses, portals and notes, all in one place.
How it works — 3 steps
- List every regular medication on the Medications sheet, exactly as the label and pharmacy record say.
- Each time a refill is picked up, add one line to the Refill Log and update that medication's "Last filled" date — every countdown follows.
- Check the Dashboard once a week: overdue refills, what's due in 7 and 30 days, the soonest dates, and refill spending.
You never build or fix a formula. Type only in the pale-yellow cells — the formula cells are protected (no password) so the math can't be broken by accident. Fictional SAMPLE rows, clearly marked, show you the format; delete them and the file is yours.
What you need
Microsoft Excel, or Google Sheets (free with a Google account). One file works in both. A desktop or laptop is best for setup — a phone screen is too small. This is a spreadsheet. It will not work in GoodNotes, Notability or a PDF reader.
Instant download
This is a digital download — no physical item will be shipped. After purchase, go to Etsy → Purchases and reviews → Download files, save the file to your computer first, then open it in Excel (click “Enable Editing”) or upload it to Google Drive for Sheets (then File → Make a copy, and always work in your copy).
License
Personal use only — for your own household. Please do not share, resell or redistribute the file.
Questions
Does it work in Google Sheets as well as Excel?
Yes — the same .xlsx file works in both. Upload it to Google Drive, open it, then choose File → Make a copy and work in your copy.
I'm not good with spreadsheets. Is this for me?
Yes. You only ever type in the pale-yellow cells; the dates, countdowns and statuses calculate themselves. Instructions are printed at the top of every sheet, and a filled fictional example shows you exactly what goes where.
Can it track medications for more than one person?
Yes — there's a Family member column on every row, so you can track yourself, a spouse, children or a parent in the same file, each with their own prescribers and pharmacies.
How does it know when I'll run out?
From what you type: quantity per fill divided by how many are taken per day, counted from the date last filled. That gives the run-out date and the days of supply left — an estimate to plan refills by, so always confirm with the bottle and your pharmacy.
Does it tell me how much medication to take?
Never. This is a tracking and reminder tool only. Dose information is copied from your prescription label for reference — always follow your prescriber's and pharmacist's instructions.