Near-expiry report
Audience: Inventory manager, center admin, compliance manager
The Near Expiry report helps you identify batch-tracked products approaching their expiry dates. Use this report to reduce wastage, optimize product usage, and ensure compliance — especially for high-value consumables like injectables, skincare products, or medications.
Data refresh: Real-time on grid load and on filter change (V2 grid).
On this page
- Before you begin
- Steps
- Filter reference
- Column reference
- Take action from the report
- Tips
- Troubleshooting
- Related articles
Before you begin
- Batch tracking must be enabled for products you want to monitor. Refer to Configure batch and expiry management for more information.
- You must have access to the Reports section at the organization or center level.
- This report is available only for businesses with the Batch Management and Expiry feature enabled. Contact your Zenoti representative if you need confirmation of feature availability for your org.
Permission: Near Expiry Report (under the Inventory report permissions group) — Required to access the Near-expiry report.
Steps
- Click the Reports icon at the organization or center level.
- On the Reports page, search for and select Near Expiry.
- The Near Expiry report screen appears.
- Apply filters from the Filter reference.
- Use the action controls to drive workflows from the report — see Take action from the report.
To export the report, click the Excel or CSV icon.
Filter reference
Use the filters at the top of the report to narrow down results.
| Filter | Description |
|---|---|
| Centers | Select one or more centers to view near-expiry and expired products. |
| Category / Sub-Category | Filter by product classification. |
| Brand | View products from a specific brand. |
| Product Type | Choose Retail, Consumable, or Both. |
| Batches | Select a specific batch number after choosing a product. |
| Expiry Bucket | Choose products expiring in 30, 60, 90 days, 6 months, 1 year, or already expired. |
| Search | Enter product name, code, or barcode. |
Column reference
The natural sort order is First Expiry First Out (FEFO) — soonest-expiring batches surface first. You can re-sort by clicking any column header.
| Column Name | Description |
|---|---|
| Center Name | The center where the expiring product is currently stocked. |
| Center Code | The unique code representing the center where the product batch is located. |
| Product Name | The name of the product from the batch approaching expiry. |
| Product Code | The unique code assigned to the product for tracking purposes. |
| Product Type | Indicates whether the product is sold to guests (retail) or used during services (consumable). |
| Batch # | The unique batch number linked to the expiring product. |
| On-Hand Quantity | The number of product units available in the selected batch (combined store + floor for unified-stock orgs; store-only otherwise). |
| Brand | The brand associated with the expiring product batch. |
| Expiry Date | The last valid usage date for the product batch. Expiry is evaluated in the center's local time zone. |
| Days Until Expiry | The number of days remaining until the product batch reaches expiry. Expired batches show as Expired (or a negative number depending on render mode). |
Take action from the report
Use the Raise PO (purchase order) or Raise TO (transfer order) options directly from the report to reorder or redistribute stock.
- Raise PO — for low-stock items where reorder is appropriate before the next service window.
- Raise TO — to redistribute soon-to-expire stock to a busier center where it will be used before expiry.
- Write off — if a batch has already expired or cannot be used or transferred in time, write it off via Track damaged and expired products.
After Raise TO/PO is clicked, the underlying record is created in the orders module. The report row updates to reflect the new outstanding order; on-hand quantity at the source center is reduced when the TO is dispatched, not at the moment of click.
Tips
- Use Save View to save frequently used filter combinations so you can access them quickly later. Save View persists Center / Product Type / Expiry Bucket filter combos so weekly review takes one click.
- Run weekly with the 30-day Expiry Bucket to catch high-priority expirations; escalate to 60-day at month-end for medium-term planning.
- For example, if a batch of injectables nears expiry in 25 days, transfer the stock to a busier center using Raise TO to ensure timely usage. For a low-stock item, create a purchase order using Raise PO to avoid service disruption.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report shows no rows | Org has no batch-tracked products OR Batch Management feature is not enabled. | Verify batch tracking is configured per Configure batch and expiry management. |
| Expired batches missing | The Expiry Bucket filter is set to a future window only (e.g., 30 days). | Set the Expiry Bucket to Already expired or clear the filter. |
| Days Until Expiry shows blank | The batch lacks a configured expiry date. | Edit the batch via the inventory batch UI to add an expiry date. |
| Raise TO action disabled | The product is not configured for transfer at the source center, OR the user lacks the RAISE_ORDER permission under Inventory. | Verify product configuration and user permissions. |
| Permission denied | The user role lacks Near Expiry Report under the Inventory report permissions group. | Confirm the role permission. |