SheetSmart Template Co.
Pantry Inventory Spreadsheet

Pantry Inventory Spreadsheet, Excel and Google Sheets, Fridge Freezer Tracker, Grocery List, Meal Planner, Food Waste Log

$7.49 USD
Buy on Etsy

Instant digital download for Microsoft Excel and Google Sheets. Checkout and delivery are handled securely by Etsy.

Pantry Inventory Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Know exactly what's in your pantry, fridge and freezers, use food before it goes bad, cook from what you already have and let the shopping list build itself. Perfect for families who want to stop buying what they already have. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 14 tabs with a clickable Start Here page and a step-by-step How To Use guide • Dashboard: 16 KPI tiles, a "use these first" list, "cook tonight" meal matches, totals by location, a shopping list preview and 4 charts • Inventory (500 rows): item, category, location (pantry, fridge, freezer, deep freezer and more), shelf or bin, quantity, use-by date, price and store, with days left and a Fresh / Use soon / Use first / Expired status • Use First: everything sorted by use-by date with a meal idea that uses each item, plus a count by location • Staples & Par Levels (150 rows): set the least you want on hand; anything below it goes onto the Shopping List • Shopping List: builds itself from your par levels, grouped by store, with tick boxes, 20 extra lines, totals by store and a weekly budget check • Meal Ideas (60 meals, up to 6 ingredients each): shows what you can make now, what's missing and which meals use food that's expiring • Freezer Meals (80 rows): date frozen, portions left, eat-by date and status • Stockpile (60 rows): cost per unit, savings vs the regular price and months of supply, plus a bulk buy calculator (which size is cheaper?) • Food Waste log (300 rows): what got tossed, why and what it cost, with totals by reason and location • Restock Checklist: 16 starter weekly tasks (room for 22) across 8 weeks, with progress bars • Insights: the last 6 months of groceries logged vs food wasted, plus value on hand by category, with 2 charts ★ PERFECT FOR ★ ✓ Families who want to stop buying what they already have ✓ Freezer cooks and bulk shoppers ✓ Cutting food waste and the grocery bill ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download the files right after purchase. 2. On Setup, set your locations, categories, units, stores and use-first window. 3. Add what's on each shelf, then list your staples and favorite meals. 4. Check Use First and Meal Ideas before you plan, and shop from the Shopping List. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★ • This is a digital download. Nothing will be shipped. • Use-by dates are a guide. Follow package and food safety advice where you live. • Because it's a digital file, returns aren't accepted, but if yo
Free Monthly Budget Starter Kit

5 printable pages: a monthly budget sheet, a 12-month bill checklist and 3 savings-goal trackers. Free when you join the email list.

Get the free kit