Fostering More Than One Animal? You’ve Got A Data Problem

My colleague Ari does trap-neuter-return (TNR) work, which means they’re almost always fostering — taking cats in, getting them healthy, and keeping them until they’re adopted out, or until they decide to keep them. The roster changes as cats arrive and leave; right now it’s five. Each one comes with a different medication schedule, a different vet history, and in a couple of cases an insurance claim working its way through some company’s review queue. If you’ve ever cared for a single pet, picture the paperwork, multiply it by five, and stagger every renewal and refill date so that no two ever line up. That’s roughly what their kitchen counter looked like before we built them a spreadsheet.

Here’s the thing nobody tells you: this is a data problem. It just doesn’t show up wearing a name tag that says “data problem.” It shows up as a sticky note that says Olive — pill, 2x? and a vet portal login you can’t remember and a text thread with the rescue coordinator that you have to scroll three weeks back to find. When it’s one animal, you hold all of it in your head and you’re fine. At five, you can’t, and the cost of forgetting isn’t a late report. It’s skipped medication or a missed appointment.

So we sat down and figured out what Ari actually needed to know, and when, and built around that. The result is one Excel file with six tabs. I want to walk through it, not because you need this exact spreadsheet, but because the way it’s organized is the part worth stealing.

The foundation is Cat Profiles — the who. One row per cat: name, sex, intake date, microchip number, the basic vitals. Nothing clever. It’s the reference sheet everything else points back to, and having it in one place means you’re never again digging through email to find when Winnie came in.

Then Care Log, which is the diary — dated entries of what happened and when. Vet visit, weight check, the morning Lenny decided he was done with a particular food. It reads chronologically, like a journal, because that’s how you actually remember events: “wait, when did that start?”

Medications is the tab that earns its keep every single day. What drug, what dose, how often, which cat. This is the one standing between a foster home and a genuine mistake, and it’s the first tab I’d build for anyone caring for more than one animal with medical needs. Everything else can wait. This one can’t.

Insurance Claims is the money pipeline, and it’s the tab most people don’t think to build until they’re already underwater. Every claim gets a row and a status — submitted, under review, approved, partially approved, paid, denied — so at any moment Ari can see what they’ve laid out, what’s been reimbursed, and what’s still owed to them. When Olive needed real veterinary work, that tab was the difference between “I think I’m owed something?” and a clear number they could actually follow up on.

The fifth tab, Summary Dashboard, is the one that makes the whole thing feel less like a list and more like a tool. It doesn’t hold any original information — you never type into it. It reads from the other tabs and answers the questions you actually ask out loud: How much have I spent on each cat? What’s the status of every open claim? How many active medications am I juggling right now? Enter a fact once, anywhere in the file, and it shows up here automatically. That’s the single principle that separates a spreadsheet that helps from a spreadsheet that becomes one more thing to maintain: enter once, see everywhere.

One small touch that does more than it should: every cat has a color, and that color stays consistent across all six tabs. Olive’s rows are always the same blue. Your eye finds her information before you’ve consciously read a word. It costs about five minutes to set up and it pays that back every time you open the file in a hurry.

And then there’s the sixth tab. It’s called Remembrance, and it’s for the ones who’ve come through Ari’s care and moved on — the adoptions, and the ones who didn’t make it. Fostering means both. That’s the unglamorous, true part, and I think it belongs in the file rather than tucked away somewhere, because a record of an animal’s care should include the whole of it. It’s the one tab nobody designs first and the one that ends up mattering most.

If you’re caring for more than one animal and your system is currently your memory plus a shoebox of receipts, you don’t need to build all of this tonight. Build the one tab that’s costing you sleep — almost always Medications — and a small summary that reads from it. Add Care Log when you find yourself asking “when did that start?” Add Insurance Claims the first time a reimbursement goes missing. The structure earns its way in one gap at a time, which is the only way anyone actually keeps a spreadsheet alive.

If you’d rather not start from a blank page, we’ve made a companion version you can copy and make your own — the same six tabs, the dashboard, and the per-animal color system, with none of the data filled in. Download the foster tracker template here. Take it, rename the cats (or the dogs, or the chickens), and delete the tabs you don’t need.

The numbers were never the hard part of loving five cats. They were just the part that didn’t fit in your head. That’s exactly the kind of thing a spreadsheet is for.

With thanks to friend and colleague Ari Holmes, who lives this and told me what it actually needed.