Download the toolkit
It opens in Excel, Google Sheets, or Numbers — no special software required.
A spreadsheet for tracking every medication, every side effect, every hospitalization, and every diagnosis change, so none of it has to live only in your head or a looseleaf binder.
For years, the only place I kept track of every medication, dose change, side effect, and hospitalization was a looseleaf binder — and honestly, a lot of it just lived in my head. I had to memorize it. Which medication we tried, what dose, what it was supposed to help, what it actually did instead, and when we stopped it and why.
At one point we were managing multiple medications across morning, noon, afternoon, and bedtime, each one added or adjusted based on what the last one did or didn't do. We used an automatic pill dispenser just to keep it straight. Even with that, I was the one who had to remember which medication caused which effect, which ones didn't work, and which one — after years of trial and error — finally helped in the way we needed it to.
One of the medications that ended up making the biggest difference is one doctors are often slow to reach for — it's older, it takes more monitoring, and it's usually tried only after other options haven't worked. The only reason I knew to even ask about it was another parent I found online, further along in a similar situation, navigating the same kind of system and the same kind of exhaustion I was. Their experience is part of why I knew what to bring up at the next appointment.
When I went looking for anyone else who understood what we were living through, real firsthand accounts were hard to find. That's part of why I do this now — so the next parent searching at 2am finds more than just a couple of stories.
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. We didn't know to expect the range of effects we 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.
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.
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 — "remind me he seemed shaky after his 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.
It opens in Excel, Google Sheets, or Numbers — no special software required.
Each tab has one lavender example row showing the kind of detail to fill in. Clear it and it's yours.
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.
Add a row whenever something changes, and bring the file (printed or on your phone) to every visit.
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.
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.
No. It's a standard .xlsx file, so it opens in Excel, the free Google Sheets, Apple Numbers, or most other spreadsheet apps.
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.
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.
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.