● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Meal Health & Habits›Pantry Tracker
Pantry Tracker main view of the food inventory workbook
MEAL HEALTH & HABITS

Pantry Tracker

Every kitchen has the same quiet leak: food bought twice because the first lot was hiding at the back. This pantry tracker logs what you own once, then counts down the dates, flags what needs eating and writes half your grocery list.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Plan meals from your shelves, not from memory

Most food waste is not carelessness, it is invisibility. The second jar gets bought because the first was hiding, and the good food at the back gets thrown away because its date crept past unnoticed. This tracker fixes both ends. You log what is on the shelves once, with quantities and dates, and from there the workbook watches the countdown so you do not have to remember what is where.

The Pantry Inventory covers the dry shelves and Fridge & Freezer covers the cold food, each item with a low-water mark you choose. The Expiry Tracker gathers every dated item from both lists onto one countdown: Use First inside ten days, Use Soon inside thirty, and Expired once the date has passed. When stock drops to its low mark, the item lands on the Running Low list by itself.

Cooking from that picture is the satisfying part. The Meal Planner holds breakfast, lunch and dinner for seven days, built around what needs using up first, and the Recipe Index stores the meals your house actually cooks with their times, servings and staples. The Grocery List tab combines your own list with tick-off boxes and the automatic running low list, so the next shop starts from your shelves.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own Google Drive
  • BLANK Excel workbook, your fresh start with all formulas ready
  • EXAMPLE Excel workbook filled with a realistic family kitchen of 26 items
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Google Sheets with a free Google account
  • Also runs in Excel 2021 or Microsoft 365
  • Works on computer, tablet and phone
  • No prices to convert, so it works the same in every country
  • Pantry and fridge lists hold 26 items each, grocery list 24 lines

Questions about this template

The things buyers ask us most.

How do the expiry flags work?

When you stock an item, type the expiry date printed on the packet. Every time you open the workbook, the sheet counts the days left: Use First inside ten days, Use Soon inside thirty, and Expired once the date has passed. The Expiry Tracker gathers every dated item from both inventories onto one page, so nothing hides at the back.

How does the grocery list write itself?

Every inventory item has a low quantity mark that you choose. When what is left drops to that mark, the item appears on the Running Low list on the Grocery List tab, with a buy-up-to quantity. Your own hand-written list sits on the same tab with tick-off boxes, so one list covers the shop.

Is this just another meal planner?

No, and the difference is the point. A meal planner decides what you will eat. This tracker starts earlier, with the food you already own, and then helps you plan the week around it. Planning from your shelves instead of from the shop is what stops the duplicate buying and the quiet waste at the back of the fridge.

Can I add my own items and categories?

Yes. The pantry and fridge lists hold 26 items each and the grocery list holds 24 lines, and the categories and units are dropdowns you can type over with your own words. Rename an item anywhere and the rest of the workbook follows the name you typed, so the tracker adapts to your kitchen rather than the other way round.

More in Meal Health & Habits

All templates in this category →

Three more workbooks from the same shelf.

Calorie Tracker

One quick line per meal, with days, weeks and targets totalled for you.

$7.50 $3.00
View on Etsy
Calorie Tracker Spreadsheet with Meal Planner

Food log, meal plan and weight progress together in one workbook.

$7.50 $3.00
View on Etsy
Food Diary Excel Spreadsheet

A daily food diary with hunger and mood notes, plus a weekly review of your patterns.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00