Skip to content

Prepper Inventory Spreadsheet: Count Supplies and Track the Next Action

A person points to a printed inventory grid beside a folder.
AI-generated editorial illustration

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.

Explore maintenance, testing and drills guides