I found an unopened water filter in a closet the same week I ordered another one. The packing slip was still in the box. I “remembered” I needed a filter because I couldn’t see the one I already owned.
That’s the supplies problem. Food is the pile people inventory first. You cook it. You see the empty shelf. Gear, tools, medical, lighting, radios, batteries, and filters don’t work that way. They live in bins, bags, vehicles, and closets. You buy them once, shove them somewhere safe, and then you remember the purchase, not the location.
A junk drawer isn’t an inventory. Neither is a notebook from last spring, or a mental list of stuff you know you have. A blank spreadsheet you have to babysit fails for the same reason: the work never ends, so you stop, and the rows go stale.
The inventory that works still looks like a spreadsheet. A grid you already know how to use is the point. Rows, columns, a number you can change. What you want is a sheet that already does the extra work, so you aren’t babysitting every cell.
Supplies scatter even when the food is tracked
If you have a decent food record, you probably feel organized. Makes sense. Food has a rhythm. You rotate it. You can see the cans.
Then the power goes out and you need a light. The lantern is in the garage. The batteries are in a kitchen drawer. The extra bulbs are in a tote you haven’t opened since you moved. Or you need the water filter and you remember buying cartridges. You just can’t say which closet they went into, or whether you already used them.
Imagine unzipping a vehicle kit looking for a tourniquet that was in a backpack in the hall closet. Imagine digging for a headlamp that was in a bin labeled camping, which isn’t where your brain goes at 1 a.m. when the house is dark. None of that’s a food problem. The food was fine.
Supplies get lost for boring reasons. There’s no weekly dinner cue. Medical lives in the bathroom, the car, the bug-out bag, and a kit you packed once and never opened again. Filters and batteries look the same in every package, so you stack more instead of checking what you already own.
Split locations make it worse. Lighting is a lantern in the garage, a headlamp in a coat, a light in the car, and cells in an office drawer. If the record only says “we have lights,” you will still be walking the house.
Memory fails as soon as you have more than one stash. Notebooks fail when you stop rewriting them. A hand-maintained list fails when you skip updates and stop trusting the numbers. The stuff is still in the house. You just can’t put your hand on it when it matters.
What a usable supplies inventory actually records
A usable supplies inventory isn’t a dump of every item you’ve ever bought. It’s enough information to grab the right thing in the dark.
Start with the item, named like a human would ask for it. “Flashlight” isn’t enough. “Streamlight, black, takes two CR123” is. “Filter” isn’t enough. “Sawyer Squeeze, extra cartridges in the same bin” is. If two people in the house would describe it two different ways, write it so either of them can find it.
Then quantity. How many you have, not how many you meant to buy. If the same item lives in two places, record both. One row that says “batteries: lots” is how you own four packs of AA and zero for the lantern that takes D cells.
Location is the part people skip. Room is a start. Bin, bag, shelf, vehicle, or pack is better. If you can’t walk to it from the record, you don’t have an inventory. You have a house to search. I keep gear in more than one spot on purpose — home, vehicle, a bag by the door. That only works if the sheet knows which one.
Condition and expiration belong on the rows where they actually matter. Medicine expires. So do some filters, batteries, adhesives, and test strips. A lantern doesn’t have a best-by date. The batteries in it do. Note if something is unopened, partly used, or missing pieces. A first-aid kit with no gloves isn’t a first-aid kit. It’s a box.
Add enough detail to use the thing, not catalog it. Size. What it takes for power. What it pairs with. Which bag it belongs to. “Nitrile gloves, large, hall closet medical tote” is useful. “Gloves” isn’t. Same idea for a radio and the cable that actually fits it.
Kits need their own honesty. Someone takes ibuprofen out of the trauma kit. The kit still looks full from the outside. The inventory shouldn’t pretend it’s complete.
You don’t need a serial number on every screwdriver. You do need to know you have a screwdriver, where it is, and that the headlamp next to it still has batteries that fit.
Duplicates, holes, and gear you can’t find
The ugly part of a real supplies inventory is what it shows you.
Duplicates. You bought the same radio twice because you couldn’t see the first one. Three multi-tools. Four first-aid kits that are all missing the same thing. Two water filters and zero extra cartridges. That isn’t being thorough. That’s shopping blind.
Critical holes. You own the lantern. You don’t own the batteries it takes. You own the filter. The cartridges sat in a hot garage and you never logged a date. You own a radio and a power bank that hasn’t been charged since last summer. A list of purchases won’t show that. A usable inventory will, because it ties the item to the consumable it needs.
Batteries are the poster child. You can own two hundred cells and still have a dead lantern if they’re the wrong size. AA, AAA, CR123, and D cells aren’t interchangeable. If the inventory doesn’t connect the light to the cell it takes, you will keep buying bulk AA because they were on sale.
Expired medical. This one is quiet until it isn’t. Pain reliever past its date. Test strips. Chest seals. A kit you packed once and never checked. Food at least gets cooked. Medical sits until someone is hurt. You won’t rotate what you never recorded.
Gear you can’t find is the same as gear you don’t have. If the outage is at 1 a.m. and the only working headlamp is under Christmas decorations, you don’t have a headlamp. You have a storage problem.
Those four problems hide in the same places: bins, bags, vehicles, and closets with no record attached. A junk drawer feels like you’re prepared because you can see stuff in it. You can’t see what’s missing.
A dashboard beats a junk list
A supplies list can look impressive and still be useless. Tools. Medical. Lighting. Comms. Two hundred rows. Maybe you even keep it current.
Then the questions that actually matter. Do you have spare batteries for every light you own, in the sizes those lights take? Where is the trauma kit, and has anything in it expired? How many water filters, and how many cartridges? Can you put a hand on the radio without walking the house? Are you stacked in flashlights and empty in first aid?
A junk list doesn’t answer that at a glance. You have to hunt and hope you logged the last hardware-store run. You can look well stocked on paper and still have a hole in the one category that would matter tonight.
A dashboard should show the overview without that hunt. Supplies by category, against the goal you set. Lighting versus medical versus water versus comms. On hand versus what you said you needed. The holes next to the piles. Enough location context that you walk to the right bin instead of opening all of them.
That overview is how you stop shopping by vibe. Without it, you buy another flashlight because flashlights are easy, and skip the boring refill — gloves, cartridges, the right cells. See the hole, then fill the hole. The point isn’t a catalog. It’s one look at whether you’re actually equipped or just well-stocked in the category you like shopping for.
Log it when you put the tote away
Supplies don’t get handled every night the way dinner does. If adding a new radio means hunting columns and hoping you don’t break a formula, you won’t add the radio. You get home from the hardware store, tired, and the tote gets closed with nothing written down. A month later you don’t trust a single row.
A simple form is how you add a row without breaking anything. Item, quantity, location, condition or expiration if it matters. Barcode scan on a phone helps where the package has a code worth scanning — batteries, meds, filters, packaged tools. Not every wrench has a barcode. You still need a fast way to enter it.
Add it when it comes in. Move the location when you move the bag. Subtract it when you use it or toss it. Don’t wait until you “organize the garage.” The garage doesn’t organize itself.
Food inventory is a different job. Calories, days on hand, and rotation are their own problem. Supplies are about finding the thing, knowing it still works, and seeing the hole before you need it.
That’s why I built a supplies inventory next to the food inventory in the Ultimate Prep System. Same familiar Smartsheet grid. Food and supplies in one place, a dashboard that updates when the sheets update, barcode scan on the online versions, a form when there’s no code, optional best-by email reminders for meds, filters, and anything else with a date, and a shopping list pulled from the gaps so the next store run is based on what you’re short.
The grid is the feature. The extra work is already in it.
If you can’t find it, you don’t have it. If you can’t see the hole, you won’t fill it. Write the supplies down like you mean to use them.
