How do I calculate days of supply?

Divide pills on hand by (doses per day × pills per dose). The sheet does it for you and turns amber at 7 days.

Can several family members use it?

Yes — save it to Google Drive and share it. Use the 'Logged by' column so everyone knows who gave each dose.

No. It is a record. Many families use both.

Free template · Excel & Google Sheets

Built for families sharing care of a parent: a medication list that warns before pills run out, and a dose log everyone can read.

No sign-up, no email. Opens in Excel, Google Sheets, Apple Numbers and LibreOffice.

Yellow cells are the ones you type in. Everything else calculates.

Medication	Doses/day	Pills on hand	Days left	Runs out	Status
Vitamin D	1	22	22	3 Dec	OK
Metformin	2	9	4	16 Nov	Refill this week

List each medicine, vitamin and supplement on Medication List with doses per day and pills on hand.
Each time a dose is due, add a row to the Dose Log and pick the status.
When you refill, update 'Pills on hand'. The run-out date recalculates.
Print the Summary before appointments so the doctor sees the real pattern.

Upload the file to Google Drive, then open it with Google Sheets. Formulas, drop-downs and colour rules carry over.

A record-keeping tool. It does not give medical advice. Always follow the label and your prescriber or pharmacist.

DoseBeacon adds large-text reminders for the person taking the medicine and a shared, read-only record for approved family members.

How do I calculate days of supply?: Divide pills on hand by (doses per day × pills per dose). The sheet does it for you and turns amber at 7 days.
Can several family members use it?: Yes — save it to Google Drive and share it. Use the 'Logged by' column so everyone knows who gave each dose.
Is this a substitute for a pill organiser?: No. It is a record. Many families use both.

This template is free to use, share and adapt under CC BY 4.0. If you post it on your site, please link back to this page.