Prepper Inventory Spreadsheet: Count Supplies and Track the Next Action

A prepper inventory spreadsheet shows what is on hand, where it is and which action is due next. Use one row per item, unit and location. Keep the quantity you actually counted separate from your target. Record the printed expiry separately from your own inspection date so you can tell a label from a reminder. Ready.gov advises replacing expired items as needed and reviewing your kit as household needs change. Ready.gov disaster kit checklist
Copy the header into your spreadsheet
Paste this header into your spreadsheet or save it as the first line of a CSV file. If the software places it in one cell, use its comma-separated import option.
Category,Item,Unit,On hand,Target,Location,Printed expiry,Last check,Gap,Next action,Owner,Action due
Put like quantities in the same unit on each row. Count bottles in bottles and gallons in gallons. If one batch has a different expiry date, split it into its own row. If the same item is in a home cupboard and a travel bag, split those locations too. Assign only the stock you can find. A product shared between two locations needs a single physical count and a note about which plan uses it.
Keep observations and reminders separate
| Field | What to record |
|---|---|
| Category and item | A functional group and exact item description |
| Unit, on hand and target | Matching units, actual count and the household’s chosen target |
| Location | A cupboard, bag, shelf or other place someone can find |
| Printed expiry | Date from the package when applicable |
| Last check | Date someone actually counted or inspected it |
| Gap | Target minus on-hand amount, with no gap shown until both numbers are available |
| Next action, owner and due date | One specific follow-up, who will do it and when |
For the columns above, enter =IF(COUNT(D2:E2)=2,MAX(0,E2-D2),"") in I2 to calculate the shortfall for the first row. Copy it down if useful. With two on hand and a target of three, it returns 1. With three on hand and a target of two, it returns 0. A blank input leaves the result blank so a missing count cannot look like a finished check. Check the cells and units if you rearrange the columns. The quantity formula does not flag an expired item, so keep the next action column even when the gap is zero.
Start with a small, checked inventory
For example, two adults count one home cupboard and one travel bag. They record two working torches against a household target of two and one matching spare battery set against a target of two. Their quantity gap is one battery set. They notice a second torch is hard to retrieve because they cannot find it in the location entered. They give that row a specific location action even though the count met the target.
| Example item | On hand / target | What the observation changes |
|---|---|---|
| Torches | 2 / 2 | Correct the location and verify that both can be reached |
| Matching spare battery sets | 1 / 2 | Add a set of the right type |
| Manual can opener | 1 / 1 | Check that it works with the food you store |
| Household contact plan copy | 1 / 1 | Confirm the meeting and pickup details are still current |
These counts illustrate the spreadsheet. Choose targets after checking your household’s needs and where you would use the items. Ready.gov gives basic category examples such as water, food, light and sanitation, with locations suited to home, work or travel. Use current official directions during an emergency. Ready.gov disaster kit checklist
Keep personal information in the right place
For a contact sheet, record that an accessible copy exists and when to review it. Keep the actual numbers, meeting and pickup details in the household’s agreed private record. Ready.gov’s family communication form can help identify what those details are. Record equipment and care reminders without copying sensitive health information into a shared inventory. Ready.gov family emergency plan form
Prepper inventory spreadsheet questions
Should I include a row for an item I have not bought yet?
Yes, if it is a real gap in your plan. Enter zero only after checking that none is on hand. Add a target, owner and action. Leave an unknown count blank until someone checks it.
How often should I check the spreadsheet?
Ready.gov recommends reassessing kit needs each year. Set reminders for products with dates and review the row after any change in location, household needs or the items you use. Ready.gov disaster kit checklist
How do I show whether an item was tested?
Put the date and observation in the record. For example, say which torch was switched on or which cable fit. Leave the check open when you have only counted the item.
Should I keep separate files for different kits?
One file works if every row has a clear location and you can filter by it. Keep personal contact records separately and point the inventory to the approved location. Ready.gov family emergency plan form
Count one location
Copy the header, count what is in a single bag or cupboard and assign the first missing item or check to someone. Record when they will follow up.