Pantry Inventory — Google Sheets & Excel (Microsoft 365) Template
A grocery-spend control system: pantry/freezer inventory with expiry flags, master shopping list generator, and a price book that reveals which store is cheapest per staple.Food inflation + forgotten pantry items = duplicate purchases and waste; nobody remembers which store had cheaper eggs. This template fixes that: the Pantry/Freezer/Fridge inventory with expiry flags does the heavy lifting - you type into the highlighted cells, and every number, chart and status updates itself. No formulas to write, no setup headaches.WHAT'S INSIDE▸ Pantry/Freezer/Fridge inventory with expiry flags — Inventory with expiry flags so food gets eaten, not tossed▸ Master Shopping List builder — Step-through builder: answer the inputs, get the output automatically▸ Price Book by store & item — Know a real deal when you see one▸ Grocery Budget vs actual — Planned vs actual comparison with live variance and over/under colors▸ Waste log — Food waste log with monthly dollar total▸ Staples reorder list — Low-stock flags with reorder-point logic▸ Start Here tab — Step-by-step setup guide (most buyers are running in ~10 minutes)WORKS WITH• Google Sheets (free Google account) - full experience• Microsoft Excel version included - requires Microsoft 365 (uses modern formulas)• Not compatible with Excel 2016/2019 - please check your version before buyingHOW IT WORKS1. Checkout - you instantly receive ONE small PDF: your personal access guide.2. Inside are your links - click the Excel link for a direct .xlsx download, or the Google Sheets link and hit ""Make a copy"". Your choice, both included.3. Follow the Start Here tab - most buyers are set up in about 10 minutes.4. Fill in your home's details once - then it runs on autopilot.GOOD TO KNOW• The PDF also includes a view-only link to a fully filled-in sample - see every tab working before you buy... and after.• Free lifetime updates - your links always open the latest version.• All formulas come pre-built and protected; input cells are clearly highlighted.• Colors and categories are fully editable. Personal use only.Questions? Reply to your receipt email any time - I answer within 24 hours, and if something isn't working I'll fix it or refund you.
Get it → formulaandco.gumroad.com