Pantry Inventory Spreadsheet | Recipe Cost Calculator (Digital Download)

Run your kitchen with two of the most useful spreadsheets a family can have, in one warm and simple file. The Lizara Pantry Inventory + Recipe Cost Calculator gives you a clear view of what's on hand — and what dinner actually costs — so you can plan, shop, and cook with a lot less guessing.

On one tab you track every staple in your pantry, freezer, and fridge with par levels and expiration dates; on another, you turn your favorite recipes into honest cost-per-serving numbers using a one-time-setup ingredient price book. No more wasted groceries hiding in the back of the cupboard, and no more wondering whether tonight's dinner was a $4 or a $20 night. It works in both Microsoft Excel and Google Sheets.

★ WHY FAMILIES LOVE IT
• Pantry, freezer, and fridge inventory in one easy view — pre-filled with 36+ common household staples
• Par levels you set per item — anything below par auto-flags as 'running low'
• Optional expiration dates with a Days Left countdown so nothing gets forgotten
• Ingredient price book pre-filled with 36 staple ingredients — set pack size and price once, unit cost is automatic
• 6 pre-filled recipe calculators (one-pot, sheet-pan, slow-cooker, vegetarian, kid-friendly) with auto totals and true cost per serving
• Cost Dashboard ranks every recipe cheapest-first so you instantly see what saves the most money
• Grocery and Restock List auto-pulls every running-low item, with a manual section for the rest
• Drop-downs, auto-counts, and gentle highlights keep everything tidy

★ WHAT'S INCLUDED
• Pantry Inventory — 36+ pre-filled items across pantry, freezer, and fridge with category, current quantity, unit, par level, running-low auto-flag, notes, expiration date, and a Days Left countdown
• Ingredient Price Book — 36 staple ingredients with pack size, pack price, auto unit cost, vendor, and last-updated date
• Recipe Cost Calculator — 8 recipe blocks (6 pre-filled, 2 blank), each with up to 8 ingredient rows, auto unit-cost lookup, row totals, recipe total, and a real cost per serving
• Cost Dashboard — every recipe ranked cheapest-first, with average cost per serving and a recipes-priced count
• Grocery and Restock List — running-low items pulled automatically, plus a 20-row manual-add area with a 'got it' check column
• A 'Start Here' guide built right into the file

★ HOW IT WORKS
1. List your pantry on the Pantry Inventory tab and set a par level for each item
2. Set pack size and pack price for your common ingredients on the Ingredient Price Book
3. Build out your favorite recipes on the Recipe Cost Calculator — totals are automatic
4. Glance at the Cost Dashboard to see the cheapest dinners on rotation
5. Restock from the auto-pulled Grocery and Restock List

★ INSTANT DIGITAL DOWNLOAD
This is a digital product — nothing will be shipped. Right after purchase you can instantly download the spreadsheet file (.xlsx).

★ WORKS IN EXCEL AND GOOGLE SHEETS
Use it in Microsoft Excel (desktop, 2016 or newer recommended), or use it free in Google Sheets — just upload the file to Google Drive and open it with Google Sheets. It is not designed for the Excel mobile app or Apple Numbers.

★ A NOTE ON DIGITAL ITEMS
Because this is an instant download, all sales are final and no refunds are offered. But if anything ever looks off with your file, just message us — we'll happily make it right.

For personal use only. Please don't resell, share, or redistribute the file or its design.

Thank you for supporting our small family business. — The Lizara family