Pantry Inventory, Free to Print

A shelf list you can keep current in pen. This pantry inventory printable is two pages: page 1 logs 12 items with quantity, the day you opened each one, the date the label prints, and a yes/no circle for whether the next shopping trip replaces it. Page 2 holds the two shelves the main log never fits (six freezer rows, six spice rows) and 8 shopping lines that start from the circles you marked. Every date on the sheet is transcribed from a label you own; the sheet invents none.

How to use this page: print both pages at 100% scale (the site chrome drops out on paper). Fill page 1 one row at a time, when you notice the item, not from memory in one sitting. Write what you have, when you opened it, and the use-by date exactly as printed on the label, then fill the circle next to yes or no in the reorder column. Page 2 covers the freezer and the spice shelf, then the shopping lines copy from the circles on shopping day. Reprint page 1 when 12 rows run out.

Matchbook Labs · printable · page 1 of 2

Pantry log

Shelf / cupboard:

Use-by column: copy the date exactly as the label prints it. This sheet sets, extends, or interprets no dates.

#ItemQtyOpened dateUse-by (from label)Reorder? fill one
1◯ yes   ◯ no
2◯ yes   ◯ no
3◯ yes   ◯ no
4◯ yes   ◯ no
5◯ yes   ◯ no
6◯ yes   ◯ no
7◯ yes   ◯ no
8◯ yes   ◯ no
9◯ yes   ◯ no
10◯ yes   ◯ no
11◯ yes   ◯ no
12◯ yes   ◯ no

One row per item, written when you notice it. "Reorder" means the next shopping trip replaces it. The use-by column repeats what your own label says, nothing more.

Matchbook Labs · printable · page 2 of 2

Freezer, spice shelf, shopping lines

The two shelves page 1 does not reach, then the list those pages already wrote.

Freezer — 6 rows

ItemQtyDate inUse-by (from label)

Same one-row-per-item habit. The freezer hides its stock behind frost and stacked bags, so these rows are the count you cannot see from the door.

Spice shelf — 6 rows

ItemOpened dateNotes

Notes takes the job, not the judgment: "for rice", "backup jar", "nearly empty".

Shopping — 8 lines

1.
2.
3.
4.
5.
6.
7.
8.

Copy from the reorder circles you filled on page 1, plus whatever the freezer and spice rows showed you. This page drafts the list; the workbook's Grocery List sheet below sorts the full version by store section.

This sheet tracks what you own and what is gone. It holds no temperatures, no storage rules, and no advice on what to keep or discard; the use-by column repeats your own labels.

Fits A4 and US Letter at 100%. Grayscale prints fine.

Four opinions on running a pantry inventory

  1. (Opinion.) Put the newest stock behind the oldest. The hand reaches the front row first, so the front row should hold the item that needs using first, and the new purchase goes behind it. A shelf ordered any other way hides its own history.
  2. (Opinion.) Write the opened date the day you open it. The purchase date lives on a receipt you will throw away; the opened date lives nowhere else. It is also the row detail nobody remembers a week later, which is exactly why it earns its column.
  3. (Opinion.) Pick one date format and keep it for every row. A column written in mixed formats cannot be scanned, and a column you cannot scan at a glance is a column you stop reading. One format, all rows, and the whole sheet stays readable from arm's length.
  4. (Opinion.) Let the reorder circles draft the shopping list. Fill the circle in the moment you notice the stock is low, because that notice is free and the memory of it is not. On shopping day the 8 lines on page 2 copy from the circles instead of from a guess in the aisle.

What this page is

A shelf list, and nothing past that. It records what you own, how much, since when, and what the labels say. No temperature appears anywhere on it, no storage rule, and no guidance on what anyone should eat or discard; those are decisions the sheet never touches. The use-by column transcribes your own labels, so if a label says nothing, the column stays blank and the row still works. What the sheet does do is turn "do we already have one of these" into a glance instead of a search, and it makes the shopping list start from evidence you wrote down instead of memory in the store.

Where the spreadsheet fits

Paper answers what is on the shelf today. The Meal Planner workbook answers the next question: once you know what you already own, its Grocery List sheet flags which items this week's plan actually needs, sorts them by store section, and totals the lines you typed prices against. Verbatim from the product README:

A one-workbook meal planning system for Excel and Google Sheets: plan 21 meals a week from a 32-recipe bank using dropdowns, keep a grocery list that flags what your plan actually needs and totals itself, and track what you pay per store over time.

What's inside

FileWhat it does
meal.xlsxThe workbook. 4 sheets: Weekly Plan (7 days x 3 meals with recipe dropdowns and plan stats), Recipe Bank (32 recipes: meal type, time, servings, ingredients), Grocery List (store categories, on-plan auto flag, qty x price line totals, weekly total), Price Tracker (unit prices per store, best/average price watchlist)
instructions.md5-minute setup, every formula explained in plain language, how to extend the dropdown ranges, troubleshooting
README.mdThis file

Personal and commercial use allowed - plan your own meals, use it for clients, as many copies as you like. No resale or redistribution of the pack itself, as-is or with minor edits.

Quoted verbatim from the Meal Planner + Grocery List Spreadsheet product README.

Get the Meal Planner + Grocery List Spreadsheet — →

One workbook for Excel and Google Sheets: Weekly Plan (7 days × 3 meals with recipe dropdowns and plan stats), Recipe Bank (32 recipes), Grocery List (store categories, on-plan auto flag, qty × price line totals), Price Tracker (unit prices per store). Sample week included. Personal and commercial use allowed.

Related