Description
The Medication Tracker Spreadsheet is a ready-to-use 25-tab Google Sheets and Excel template for daily medication log, adherence tracker, refill alerts and inventory. It is an instant digital download with pre-built formulas, an automated dashboard and step-by-step instructions, so you can start using it in minutes.
Key features
- Daily Medication Log
- Adherence Tracker
- Refill Alerts
- Inventory
- Side Effects Log
- Prescription Tracker
- Doctor Report
About this template
- Instant access after purchase, no waiting
- Works on Google Sheets & Excel, no software needed
- Mobile friendly, use it on your phone too
- Stuck? Message me, I reply personally within a few hours
- Free updates: if I improve this template, you get the new version free
Managing multiple medications is harder than it should be.
Which pill was this morning. Whether you already took the afternoon dose. When the refill is due. Whether the prescription expires before the next appointment. What side effects started after which medication changed.
Most people manage all of this from memory — and memory is not a reliable medication management system.
This Medication Tracker Spreadsheet gives you one complete Google Sheets and Excel system to log every dose, track your adherence rate, monitor refills before you run out, log side effects, track prescription expiry dates, manage your supplement schedule, and generate a printable medication list you can bring to any doctor appointment or emergency room visit.
25 fully built tabs. Adherence percentage calculated automatically. Days remaining and reorder date per medication. Prescription expiry alerts. Printable doctor report. All live formulas. All connected.
Important medical and privacy disclaimer
This spreadsheet is a personal medication organization, recordkeeping, and appointment preparation tool only. It is not medical advice, diagnosis, treatment, dosing guidance, or a substitute for professional healthcare. Never use this tracker to change, adjust, skip, or make decisions about your medication without consulting your doctor, pharmacist, or healthcare provider. Always follow your prescriber's instructions for all medications. If you experience a medical emergency, call emergency services immediately.
This tracker stores sensitive personal health information. Store your file securely in your private Google Drive and Excel File. Do not share it publicly. Follow all applicable privacy rules and guidelines for your region.
This is for you if
- You take multiple medications and want one organized tracking system
- You want to know your real medication adherence rate — taken versus scheduled
- You need refill reminders before you run out — not after
- You track side effects and want to know which medication they are connected to
- You want a printable current medication list for doctor appointments or the emergency room
- You manage supplements and vitamins alongside prescription medications
- You take as-needed medications and need to track frequency against safe limits
- You want one place for prescriber contacts, pharmacy details, and insurance costs
What's included — 25 tabs
- Foundation
- Start Here — welcome page, full navigation links, color key, how-to guide, privacy notice, and medical disclaimer prominently displayed
- Setup — your name, year, units, time zone, and goals — dropdown lists for medications, doses, and frequencies — all feeding every tracker tab automatically
- Medication Dashboard — the command center — adherence percentage, doses due today, refills coming up, expiring prescriptions, low inventory alerts — all live formulas — no hardcoded values
- Your Medications — Core Tabs
- Medication List — name, dose, form, frequency, purpose, prescriber, start date, status — the canonical source every other tab reads from — add a medication once and it appears everywhere
- Daily Medication Log — the engine of the entire system — date, medication, scheduled time, taken checkbox, actual time taken, notes — every dashboard and report reads from this tab — adherence, missed doses, and inventory all calculated from your daily log entries
- Weekly Medication Schedule — at-a-glance grid of every medication and when it is taken across the week — morning, noon, evening, and bedtime columns — see your full week in one view
- Monthly Medication Calendar — month view with per-day dose counts — today highlighted automatically — see your consistency across the whole month visually
- Dose Schedule — time-of-day plan per medication — morning, noon, evening, bedtime — with food or without food noted — feeds Weekly Schedule automatically
- Standout Feature Tabs
- Adherence Tracker — taken divided by scheduled — adherence percentage calculated automatically per medication and overall — weekly and monthly rates shown separately — your single most important medication metric tracked clearly
- Missed Dose Log — every missed dose recorded — medication, scheduled time, date missed, reason — pattern analysis — most missed medication identified — most common reason identified — no shame-based labels anywhere
- Refill Tracker — days remaining calculated automatically per medication — reorder by date calculated from days remaining and lead time — refill alert status — Order Now, Order Soon, On Track — never run out because you forgot to refill
- Medication Inventory — quantity on hand, daily use rate, running balance — run-out date calculated automatically — low inventory highlighted immediately — inventory value calculated per medication
- Prescription Expiration Tracker — prescription expiry date, refills remaining, expiry alert status — Expired highlighted red, Expiring Soon highlighted amber, Valid highlighted green — never attend an appointment with an expired prescription
- Supplements, Symptoms and Effects
- Pharmacy and Prescription Details — Rx numbers, pharmacy name and contact, prescriber, fill history — everything in one reference tab for appointments and insurance calls
- Supplement and Vitamin Tracker — separate log for non-prescription items — name, dose, frequency, purpose, brand, start date — keeps supplements organized without mixing into your prescription log
- As-Needed PRN Log — log every as-needed medication taken — date, time, medication, dose, reason, relief rating — frequency cap tracking — alerts when approaching safe frequency limits — important for pain medications and rescue medications
- Side Effects Tracker — symptom, severity, onset date, which medication suspected, action taken — severity levels — Mild, Moderate, Severe — pattern shown — most reported side effect identified — most affected medication identified — side effects disclaimer — always report concerning side effects to your healthcare provider immediately
- Symptom Tracker — log how you are feeling over time — daily symptom rating, energy level, mood, pain level, notes — compare symptoms alongside medication changes to prepare for healthcare conversations
- Effectiveness Log — self-rated effectiveness per medication — weekly rating, notes, trend direction — most effective medication identified — all labeled as self-reported personal observations for provider discussion only
- Care Team and Records
- Doctor and Appointment Tracker — appointment date, provider, type, main concerns, follow-up date — upcoming appointments highlighted — countdown to next appointment calculated
- Medical Contacts and Emergency Info — prescribers, pharmacy, emergency contacts, insurance provider, blood type, allergies, emergency medication notes — formatted for quick reference in any medical situation
- Cost and Insurance Log — copay per fill, monthly medication total, annual total, insurance notes — total medication cost calculated — monthly cost trend shown — useful for benefits review and financial planning
- Printable Reports
- Printable Doctor Report — clean current medication list — medication name, dose, frequency, prescriber, start date, purpose — plus current supplements, known allergies, and recent side effects noted — formatted for bringing to any appointment or emergency room visit — medical disclaimer footer on every page
- Printable Monthly Report — adherence rate, missed doses, side effects summary, refills due, prescriptions expiring — formatted for monthly self-review or sharing with your care team — disclaimer footer included
- Both formatted for A4 and Letter paper sizes — PDF export ready
- Formula Guide
- Every calculation explained in plain language — adherence percentage, days remaining, run-out date, refill reorder date, inventory balance, expiration alert logic, missed dose count, and more
- Written for non-spreadsheet users — no technical knowledge assumed
What you receive
- Google Sheets version — one-click copy to your Drive via PDF link
- Excel File instant download Microsoft 365 Recommended
- Sample data version — all tabs populated so you see everything working
- Blank version — delete sample rows and start with your own medications
- 25 fully built tabs — every feature above included and connected
- Lifetime access — no subscription, no expiry, no renewal fee
- Full personal support — real replies within 24 hours
How to get started
Purchase — PDF with Google Sheets link arrives instantly
Click the link — make a copy to your Google Drive in one tap
Excel file instant download
Open Setup — enter your name, year, and medication dropdown lists
Open Medication List — add every current medication with dose and frequency
Open Daily Log — log your first day of doses
Open Medication Dashboard — adherence, refills, and inventory update automatically
Open Refill Tracker — see your reorder dates appear automatically
Print Doctor Report — before your next appointment export as PDF
Works on every device
- Phone — daily dose logging on the go in seconds
- Tablet — full dashboard and weekly schedule view
- Laptop and Desktop — complete medication management experience
- Google Sheets syncs automatically across all devices
- Free Google account required
Quick answers
Does it calculate my adherence rate automatically?
Yes. The Adherence Tracker divides doses taken by doses scheduled per medication and overall. Weekly and monthly rates are shown separately. This is the single most useful metric for understanding your medication consistency — and it updates automatically every time you log a dose.
Will it tell me when to refill before I run out?
Yes. The Refill Tracker calculates days remaining from your current inventory and daily use rate. A reorder by date shows when to contact your pharmacy. Order Now, Order Soon, and On Track status labels update automatically. You will never run out because you forgot to refill.
Can I track side effects and connect them to specific medications?
Yes. The Side Effects Tracker logs every symptom with the suspected medication, severity, onset date, and action taken. Most reported side effect and most affected medication are identified automatically. Always report concerning side effects to your healthcare provider.
Does it track supplements separately from prescriptions?
Yes. The Supplement and Vitamin Tracker is a completely separate tab so your non-prescription items are organized without mixing into your prescription medication log.
Is the Doctor Report printable?
Yes. The Printable Doctor Report generates a clean current medication list formatted for any appointment or emergency room visit — medication name, dose, frequency, prescriber, purpose, supplements, allergies, and recent side effects. Export as PDF in one click.
Is this a one-time purchase?
Yes — pay once, manage your medications indefinitely. No subscription ever.
Perfect for
- People managing multiple daily medications who need one organized system
- Older adults or caregivers managing complex medication schedules
- Chronic illness patients tracking medications alongside symptoms
- Anyone preparing a current medication list for a doctor or emergency room
- People tracking medication effectiveness and side effects for provider discussions
- Caregivers managing medications for a family member or loved one
- Anyone who has run out of a medication because they forgot to refill in time
Why this beats a pill reminder app
Pill reminder apps tell you when to take your medication. They do not calculate your adherence rate over three months. They do not show your run-out date or reorder deadline. They do not log side effects against specific medications. They do not generate a printable doctor report. And they do not store your prescriber contacts, Rx numbers, insurance details, and emergency information in one secure place you own.
→ Adherence rate calculated automatically — taken divided by scheduled per medication
→ Refill alerts before you run out — reorder by date calculated from inventory
→ Prescription expiry alerts — never attend an appointment with an expired script
→ Side effects connected to medications — not just a symptom list
→ Printable doctor report — current med list for any appointment or emergency
→ Your data — stored in your private Google Drive not shared with any app
→ One-time purchase — pay once, manage medications forever
Important notes
- Google Sheets only — not compatible with Microsoft Excel
- Free Google account required
- Personal medication organization tool only — not medical advice of any kind
- Never use to change or adjust medication without consulting your healthcare provider
- Store your file securely — health data is sensitive and private
- As-needed PRN frequency tracking is for personal awareness only — always follow prescriber instructions for safe use limits
- Personal use only — no reselling or redistribution
- Digital download — no physical item shipped
Access after purchase
Refund policy
Digital downloads cannot be refunded once accessed. Message the shop immediately with any issue — every problem resolved personally and promptly.
Every dose logged. Every refill tracked.
Every appointment prepared.
What you receive
- Microsoft Excel workbook (.xlsx)
- Google Sheets copy link
- Built-in How to Use instructions
This is a digital download. No physical item will be shipped.














Reviews
There are no reviews yet.