Why track lots and expiry
Expiry tracking cuts waste: if you know which stock expires next month, you can discount it, move it to a busier store or use it in-house while it still has value. Lot tracking protects you in a recall: when a supplier recalls lot 26-0412, you can see in minutes how much you received, how much is on the shelf and, where customers are recorded, who bought it.
For some businesses it is not optional. Pharmacies, food producers and anyone selling regulated products may be required to trace lots. For everyone else it is a cheap insurance policy.
Record at the receiving door
The only reliable time to record a lot is when the stock arrives. Each case or carton usually shows a lot or batch number and a best-before or expiry date. Enter them on the purchase as you check the delivery against the invoice. If one delivery contains two lots of the same product, enter them as two lines. Waiting until later means guessing, and a guessed lot number is worse than none.
For opening stock, count by lot and expiry where you can. If the old stock has no lot information, enter one line per product with the earliest expiry date you can find.
Rotate and review
Shelving new stock behind old (first expired, first out) is the simplest habit that cuts waste. Then set a weekly time to review short-dated stock. Decide your rule in advance: for example, anything with less than 30 days gets a markdown, less than 7 days moves to staff use or donation, and expired stock is written off. Some systems can also stop selling a product a set number of days before it expires.
Write off expired stock as a stock adjustment with a reason. That keeps the count right and shows the cost of waste on your reports.
Handling a recall
When a recall notice arrives, look up the lot. Check how much you received, how much is left and where it is stored. Pull it from the shelf and quarantine it. If the product is one where customers are attached to sales, check which customers bought it. Return or destroy the stock as the supplier instructs, and record it as an adjustment or a purchase return.
Doing it in SeroPOS
Lot and expiry tracking is set up in the SeroPOS web back office and recorded on purchases and opening stock.
- Business Settings, then Product: Enable Product Expiry (enter an expiry date, or a manufacturing date plus an expiry period), and choose On product expiry: Keep selling, or Stop selling a set number of days before.
- Business Settings, then Purchases: Enable Lot Number.
- Purchases, then Add Purchase: each line takes a lot number and MFG and EXP dates. Opening stock can also be entered with lot and expiry.
- Business Settings, then Dashboard sets the stock expiry alert window; the Dashboard shows a Stock Expiry Alert table.
- Reports, then Stock Expiry Report: stock left per lot with its dates, so you know which lots to write off with a stock adjustment.
- Reports, then Lot Report: current stock, units sold, units adjusted and expiry per lot.
- Products, then Print Labels can print the lot number, expiry date and packing date on shelf or product labels.