Product Expiry Tracking
Product Expiry Tracking helps you monitor batch expiry dates, prevent the sale of expired products, and receive alerts before products expire.
It is ideal for businesses that sell food, beverages, pharmaceuticals, cosmetics, and other products with expiry dates.
Enabling Product Expiry Tracking
Go to Settings → Business Settings → Products.
Enable Product Expiry Tracking.
Enable Batch Numbers for complete batch-level tracking.
Save your changes.
Tip: Batch Numbers are recommended when using Product Expiry Tracking, as expiry dates are tracked for individual batches.
Expiry Behavior
Choose how IsleBooks POS should handle expired products.
Keep Selling
Expired products remain available for sale.
This option is useful if expiry dates are used only for monitoring purposes.
Stop Selling N Days Before Expiry
Automatically prevent products from being sold a specified number of days before their expiry date.
For example, if you enter 7 days, products become unavailable for sale seven days before their expiry date.
Stock Accounting Method
Select the inventory costing method used when selling stock.
FIFO (First In, First Out)
The oldest available stock is sold first.
Example:
Batch | Quantity |
Batch A | 20 |
Batch B | 20 |
If 22 units are sold:
20 units are deducted from Batch A
2 units are deducted from Batch B
The remaining stock is:
Batch A: 0
Batch B: 18
AVCO (Average Cost)
Products continue to be issued from the oldest available batches, while the Cost of Goods Sold (COGS) is calculated using the weighted average cost of all available inventory.
Important: Select your preferred stock accounting method before recording sales. Changing the accounting method after transactions have been processed may not affect existing inventory records.
Recording Expiry Dates
Once Product Expiry Tracking is enabled, you can enter the following information when receiving stock:
Batch Number
Manufacturing Date (if applicable)
Expiry Date
Expiry information can be recorded when adding:
Purchases
Opening Stock
Batch & Expiry Report
To view products by batch or expiry date:
Go to Reports → Product Reports → Batch / Expiry Report.
Apply any required filters.
Available filters include:
Batch Number
Expired Products
Products Expiring Within a Selected Number of Days
Business Location
This report helps identify products that require attention before they expire.
Removing Expired Stock
Expired inventory should be removed using a Stock Adjustment.
Go to Stock → Stock Adjustments.
Create a new stock adjustment.
Select the expired batch.
Record the quantity being written off.
This ensures inventory quantities remain accurate while preserving a complete audit trail.
Expiry Alerts
IsleBooks POS can notify you when products are approaching their expiry date or have already expired.
Alerts are available:
On the Dashboard
Through Telegram notifications
Through WhatsApp notifications (subject to template limitations)
Note: Telegram notifications include full expiry details. WhatsApp notifications may contain limited information due to message template restrictions.
Dashboard Alert Period
To configure how far in advance expiry alerts appear:
Go to Settings → Business Settings → Dashboard.
Set View Stock Expiry Alert For.
Enter the number of days before expiry that alerts should be displayed.
For example, entering 30 displays products that will expire within the next 30 days.