1
Download the toolkit
It opens in Excel, Google Sheets, or Numbers — no special software required.
Why it exists
The tool I wish I'd had
Parents managing a child's care often say the same thing: the only place the full medication history lives is a looseleaf binder — or their own memory. Which medication was tried, at what dose, what it was supposed to help, what it actually did, and when and why it was stopped.
When several medications are adjusted across the day, each change based on how the last one went, keeping it all straight becomes a job of its own. Families describe being the only person who remembers which change caused which effect — and that history is exactly what a new prescriber, therapist, or care team needs.
Many parents also say the most useful questions they brought to an appointment came from other families further along in similar situations. This toolkit is meant to make that history easy to capture and easy to hand over, so nothing important depends on memory alone.
Nobody warns you about this part
What we didn't know to expect
Nobody sits you down and tells you what's actually coming. These medications are a hope-it-works — you and the prescriber try something, and you find out what it does by living through it, not by reading a pamphlet beforehand. Many families say they did not know to expect the range of effects they saw — some medications helped in the ways we needed, others didn't, and some came with side effects nobody had warned us about.
It's non-stop changes. Effects, side effects, ups and downs — all at once, and it's a lot. And underneath all of it, a kind of exhaustion nobody names: pill fatigue, and the fatigue of tracking it all, watching for it all, and still not knowing which version of your kid is going to walk in the door that day.
That's the piece this Toolkit can't fix, but it can at least hold — so you're not carrying every side effect, every change, every "wait, was it this one or that one" in your head on top of everything else.
Four tabs, one spreadsheet
Everything in one place, instead of scattered across a binder
Medication LogEvery medication, dose, and the reason it started or stopped, all in one running list instead of scattered discharge papers.
Side Effect TrackerWhat you noticed and when, kept separate from the medication list so patterns are easier to spot before your next appointment.
Visit LogEvery hospitalization, ER visit, or appointment, and what actually changed as a result.
Diagnosis HistoryHow the diagnosis picture shifted over time — a "rule out" today can become a confirmed diagnosis a year from now.
Not a one-time form
Add to it every time something changes
The Toolkit isn't something you fill out once and file away. Keep it open, add a row every time a medication changes or a side effect shows up, and bring it with you to appointments. A year of tracked entries can say more in five minutes than trying to reconstruct it all from memory in an exam room.
Quick tip
Make filling it in easier
Dictate it in the moment
You don't have to sit down at a computer to capture this. In the moment, use your phone's voice assistant (Siri, Google Assistant) to dictate a quick note or reminder — "note: seemed shaky after morning meds" — right when it happens, instead of trying to remember it later. If you want to take it a step further, a simple phone automation (an Apple Shortcut, a Google Assistant routine, or a free tool like Zapier or IFTTT) can drop that dictated note straight into a notes list or this spreadsheet for you. It sounds more complicated than it is — even just voice-texting yourself and copying it over once a week works. The point is capturing it in the moment, however that happens for you.
How it works
Download it. Start today. Fill in the past later.
2
Delete the example rows
Each tab has one lavender example row showing the kind of detail to fill in. Clear it and it's yours.
3
Start with today
Log what's happening right now. You can always go back and fill in history later — don't let the past hold up the present.
4
Bring it to appointments
Add a row whenever something changes, and bring the file (printed or on your phone) to every visit.
You're not doing this alone
Share it with your care team
Being a real team is the goal — and it's hard to pull off
It's easy to lose sight of this in the middle of it all: you, your child, the nurses, the doctors, the therapists, the case managers — everyone is holding a piece of this. Stress runs high for all of it, and there is rarely enough support to go around. Being a genuine team is one of the most important goals in any of this, and it can be genuinely hard to accomplish. Often, honestly, it just doesn't happen.
One less thing for everyone to worry about is being on the same page about medical history — bring this Toolkit to intake, to a new therapist, to a case manager stepping in, and hand over the whole picture at once.
It also helps to talk about communication up front, right at intake: how will updates happen? When will the nurse call you? When will your loved one be able to call you? These are worth asking before you leave that first meeting, not after you've spent days wondering.
I built a dedicated Intake & Placement Tracker for exactly this — care team contacts, the communication plan, meds going in, insurance, and a living log, right on your phone. Bring it and this Toolkit together and you'll have the whole picture in one hand.
Questions
Before you begin
Is this medical advice?
No. This is an organizational tool for keeping track of what your child's care team tells you — it is not medical, legal, or emergency advice. Always talk to your child's prescriber about medications, side effects, and any changes.
Do I need Excel to use it?
No. It's a standard .xlsx file, so it opens in Excel, the free Google Sheets, Apple Numbers, or most other spreadsheet apps.
Can I use this for more than one child, or for myself?
Yes. Make a copy of the file for each person you're tracking — there's nothing in the template tied to one child or diagnosis.
How should I share it?
This file can end up holding sensitive health information. Save and share copies only with people you trust, and use secure methods (encrypted storage, a provider portal, secure email) when you can.
Free to use
You shouldn't have to memorize any of this
Download the Toolkit, make a copy for your own use, and start with whatever's happening right now — you can always fill in the history later.
This spreadsheet may end up holding sensitive personal, behavioral, or medical information. Save and share completed copies only with people you trust and through secure methods when possible. This toolkit is an organizational tool; it is not medical, legal, or emergency advice.