Pantry Inventory & Stock Rotation Tracker Spreadsheet – Expiry Status, Dashboard & Shopping List (Excel / Google Sheets)

Stop losing track of what you already own and stop buying duplicates.

This practical spreadsheet gives you a clear, living picture of your pantry, fridge and freezer. Enter what you have, add best-before dates, and the sheet automatically calculates days remaining and flags items as EXPIRED, URGENT, Soon or OK with colour coding.

What’s included:

• Instructions sheet – plain-language guidance on how to use the tracker
• Dashboard – at-a-glance counts of expired, urgent, soon and OK items, plus total items tracked
• Inventory sheet – main working area with columns for item name, category, location, quantity, unit, best-before date, days remaining, status, purchase date and notes. Sample data included so you can see how it works
• Shopping List – plan intentional restocks with priority levels
• Lists sheet – editable category list that feeds the dropdown menus

Works in Microsoft Excel, Google Sheets, LibreOffice Calc and Apple Numbers. Cream/yellow cells are for your input; formulas calculate automatically. No macros.

Ideal if you want to reduce waste, rotate stock properly (FIFO), and shop from what you already have.