Three open bags of rice. Two jars of the same spice. A can at the back that expired last spring. Most pantries do not have a storage problem — they have a memory problem: nobody actually knows what is in there. This inventory template fixes that with one honest list.
Every item gets a quantity, an expiry date, and the exact shelf it lives on, plus a low-stock flag for the moment a staple runs short. Twelve typical items are filled in as examples — replace them with your own stock, shelf by shelf. The list saves on your device as you type, so it is always current. Print it for the inside of the pantry door, or keep it on a tablet and shop from it.
The short version: the table above is a working template, pre-filled with 12 realistic example rows. Edit the examples into your own, add rows as you need them, and print or copy the finished table. Your entries save on this device automatically. The example table is also written out below, so the page works printed or saved.
The Filled-In Example
| Item | Qty | Unit | Expiry date | Location | Low stock |
|---|---|---|---|---|---|
| Rolled oats | 2 | bags | 2027-02-14 | Shelf 2 | — |
| Penne pasta | 4 | packs | 2027-01-25 | Shelf 2 | — |
| Chopped tomatoes | 6 | cans | 2027-09-15 | Shelf 3 | — |
| Chickpeas | 3 | cans | 2027-04-02 | Shelf 3 | — |
| Olive oil | 2 | bottles | 2027-05-10 | Door rack | — |
| Long-grain rice | 1 | bags | 2027-06-30 | Bottom shelf | — |
| Plain flour | 1 | bags | 2026-12-20 | Bottom shelf | ✓ |
| Peanut butter | 1 | jars | 2026-11-28 | Shelf 2 | ✓ |
| Baked beans | 5 | cans | 2027-08-19 | Shelf 3 | — |
| Honey | 1 | jars | 2028-01-31 | Top shelf | — |
| Tuna in spring water | 4 | cans | 2027-10-05 | Shelf 3 | — |
| Granulated sugar | 1 | bags | 2028-03-01 | Bottom shelf | — |
Set Up the Inventory: Shelf by Shelf
- Empty one shelf at a time — Work shelf by shelf, never the whole pantry at once. Everything on the shelf comes out, gets wiped down, and only goes back once its row exists on the list.
- Count what is really there — Count open and unopened packs separately in the quantity column, and weigh part-used bags honestly instead of guessing — a half bag written as one will betray you mid-recipe.
- Copy expiry dates exactly as printed — Write the date from the packet, not a rounded month. The exact day is what lets you sort use-first items later without opening the pantry at all.
- Name locations the way you say them — Use the location words your household actually uses — top shelf, door rack, the deep cupboard. A location nobody recognizes is the same as no location.
- Group rows by location, not by food type — Keep the list in shelf order. When you stand in front of the pantry with the list, your eyes and the rows should travel in the same direction.
- Decide your low-stock line per staple — Low stock means different numbers for different foods: one bag of flour is low, one can of tomatoes is fine. Flag a staple when it drops to your last one.
Keep It Current: The Two-Minute Update Habit
- Cross out the moment you finish something — The list only works if finishing an item takes five seconds: delete the row or drop the quantity before the empty packet hits the bin, not at the weekend.
- Add new shopping the day it is unpacked — New items get a row while the bags are still on the counter, with the expiry date copied before the packet goes to the back of the shelf.
- New stock goes behind old stock — First in, first out: the fresh can joins the back of the row and the older can moves forward. The inventory stays honest if the shelf obeys the same order.
- Do a five-minute front-row check monthly — Once a month, scan only the earliest expiry dates on the list. Anything inside 30 days moves to the front and into this week's meal plans.
- Delete rows for things you no longer buy — A list padded with abandoned products stops being trusted. When a food leaves your life, its row leaves the inventory the same day.
- Keep one copy where the food is — Printed inside the door or saved on the kitchen tablet — an inventory stored on a laptop upstairs will quietly die. Proximity is the whole system.
Shop and Cook From the List
- Write the grocery list from the low-stock flags — Before any shop, filter the list by the low-stock column. Those flags are your list's first draft — everything else is a recipe want, not a stock need.
- Check the inventory before adding a "staple" to the list — Duplicates are born at the store, from memory. A ten-second quantity check on rice, pasta and tins kills most of them before they reach the cart.
- Plan one use-first meal a week — Pick the ingredient with the nearest expiry date and build a meal around it. One deliberate meal a week keeps the front of the shelf rotating all year.
- Let quantities set your pack sizes — If the list shows chickpeas sitting at five cans for two months, the four-pack offer is not a bargain. Buy sizes your real usage justifies.
- Share the list before anyone else shops — Two people shopping from memory buy two of everything. One shared, current inventory means whoever passes a store buys only what is flagged.
- Audit the whole list twice a year — Spring and autumn, walk the list against the shelves row by row. Ten minutes of honesty resets any drift and catches the expiry dates quietly approaching.
Pro Tips
- Date-opened beats date-bought for jars and sauces: write the day you opened it on the lid with a marker, and let the inventory expiry column hold the printed date.
- If an item has no printed date — decanted flour, bulk-bin grains — give it the date you filled the container plus its typical life, and treat that as its expiry.
- Keep the inventory in the same order as the shelves, top to bottom. A list that mirrors the room takes seconds to check; an alphabetical one does not.
- Photograph each shelf after the first full inventory. The photo settles "didn't we have…?" arguments at the store better than memory ever will.
- The low-stock flag is the only automation a paper list needs. Guard it: a flag left on bought items trains everyone to ignore real ones.
Frequently Asked Questions
How long does the first pantry inventory take?
About 20 to 40 minutes for a typical pantry, working shelf by shelf. A single cupboard takes ten. After that, updates are seconds per item — the first pass is the only real job.
Should I inventory spices and small items too?
Yes, but simply: one row per spice with quantity as jars, and the date you opened it if there is no printed date. Spices are where duplicate buying is worst, so they earn their rows.
Paper or digital — which works better?
Whichever lives nearest the food. This template saves your rows on the device you open it on, and prints cleanly for the pantry door. Many households keep the digital master and a printed copy for quick checks.
What do I do with items that have no expiry date?
Give them an honest working date: the day you bought or decanted them, plus the usual shelf life for that food. An estimated date you review beats a blank that nobody ever questions.
More Templates, Lists and Guides
- All Home Checklists, Calendars & Idea Lists — every list and template in one place
- Fridge & Freezer Inventory Template — What is in the fridge and freezer, when it went in and when it must be used — no more mystery containers.
- Grocery List Template — A shopping list sorted by store section with tick-off boxes, so one pass through the shop gets everything.
- Pantry Organization Checklist — the one-session reset that sets up the zones this inventory tracks
- Pantry Storage Ideas — bins, risers and turntables that keep every inventoried item visible
Embed this tool on your website — free
Copy the code below to add this working tool to your own page. A small credit link stays with it — that’s all we ask.