Expiry Date Report
The Expiry Date report lists items whose expiry dates fall inside the selected period, together with the quantity held against each date.
How to Access
Navigate to: Sidebar > Reports > Expiry Date Report
Route: /warehouse/reports/expiry-dates
Quick actions:
Overview
The report helps you find batches that are about to expire early enough to sell, discount, or write them off. It opens on a default period of "today through the next 30 days" — the batches that usually need attention first.
The data comes from the expiry dates recorded on the item card. Items with no expiry dates recorded will not appear.
Filters
| Filter | Description | Required |
|---|---|---|
| Expiry date from | Start of the expiry-date range to search | Yes |
| Expiry date to | End of the expiry-date range to search | Yes |
| Item or item group | Limit the report to one item or group | No |
The period is required — the report is always built for a date range. Selecting a group also includes the items within that group.
Report Columns
| Column | Description |
|---|---|
| Item ID | Item identifier in the catalog |
| Item | Item name |
| Expiry dates | Every expiry date that falls inside the period |
| Qty | Quantity for each date, in the same order |
| Unit | Unit of measurement |
When an item has several batches with different dates, they appear on a single row with each date and quantity stacked underneath one another.
Step-by-Step Guide
- Go to Reports > Expiry Date Report.
- Set the period in Expiry date from and Expiry date to.
- Optionally pick an item or item group.
- Click Build Report.
- Export the result if needed using the export button (Excel, PDF, or print).
Tips
- To find stock that has already expired, set a period ending yesterday.
- To plan the week ahead, leave the start at today and set the end seven days out.
FAQ
Why is the report empty?
Either no expiry dates fall inside the selected period, or the items have no expiry dates recorded. Expiry dates are set on the item card.
How do I add an expiry date to an item?
Open the item in the items catalog — it has an expiry-dates section where you can add a date and a quantity.
Can I export the report?
Yes. Once the report is built, the export button offers Excel, PDF, and print.