Expiry Date Inventory Tracker preview
Expiry Register sheet with columns for product, category, lot, warehouse, expiry date, on-hand quantity, unit cost, inventory value, days left, expiry band, and action owner. 1/5

About this expiry date inventory tracker spreadsheet template

This Expiry Date Inventory Tracker helps warehouse and inventory teams monitor product shelf life across multiple SKUs, lots, and locations. The five-sheet workbook includes an Expiry Register for master data entry, an Expiry Queue that prioritizes actions by urgency, high-risk Product Cards for at-a-glance review, a summary Dashboard with expiry-band breakdowns, and an International Setup sheet for currency and date localization.

Built with a clean dashboard layout, the template automatically calculates days left, expiry bands, sell-through rates, and days cover so you can act before stock expires. Every column, formula, and label is fully editable in WPS Office, Microsoft Excel, or Google Sheets.

5 structured sheets

Expiry Register, Action Queue, Product Cards, Dashboard, and International Setup in one workbook.

Automated expiry tracking

Calculates days left, expiry band, sell-through rate, and days cover from your entered dates and quantities.

Action-prioritized queue

Sorts products by expiry urgency with BLOCK, PROMOTE, and NORMAL action recommendations.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Expiry Date Inventory Tracker template is designed for warehouse managers, inventory controllers, and supply chain teams to monitor product expiry dates, prioritize stock actions, and reduce waste. Customize the sample data, columns, and other editable elements in WPS Office for your own inventory.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data structure and tracking logic in a Notion database; for branded visual reports, adapt the dashboard content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample product data, categories, warehouse names, dates, and currency labels with your own inventory information.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for warehouse stock monitoring, retail expiry management, food and beverage inventory control, pharmaceutical shelf-life tracking, and logistics reporting. It is available for personal and commercial projects, subject to the applicable template license.