GeminiPOS
Expiry Date & Batch Lot Tracking (FIFO)
Reduce expired-stock risk in grocery stores or pharmacies with batch tracking and automatic First-In, First-Out depletion.
Expiry Date & Batch Lot Tracking (FIFO)
This system tracks stock by batch number and expiry date. Every time stock comes in, a new batch is created with its expiry details. When stock is sold, batches are depleted automatically using the FIFO or FEFO method. Suitable for pharmacies, grocery stores and bakeries.
Before You Start
- Requires the Growth plan or higher, with the Smart stock module enabled.
- Turn on Track expiry under Settings → Inventory (web; on the Android POS the switch is labelled Enable Expiry Date Tracking) — without this, the batch/expiry date fields won't appear during Stock In.
1. Batch Creation
Batches are created automatically when stock comes in (Stock In). Each batch contains: batch number, product, quantity received, expiry date and received date.
2. Automatic Depletion (FIFO / FEFO)
When stock is sold, the system automatically depletes batches using the configured method: Tip: FEFO is recommended for pharmacies because medicines must be sold before they expire. This depletion runs behind the scenes — the cashier doesn't need to, and can't, choose which batch is sold.
- FIFO (First In First Out) — The batch that came in earliest is sold first — Grocery, general retail
- FEFO (First Expired First Out) — The batch closest to its expiry date is sold first — Pharmacy, Bakery
Using It in the Web Dashboard
- Sign in to the Web Dashboard.
- Go to the Products & Stock menu → Expiry & Batch tab.
- View the summary: All, Expiring Soon, Expired, Active, Depleted — each one shows the latest count.
- Use the search box to search by batch number or product name.
- Each batch shows: product, batch number, quantity, expiry date, received date, cost and supplier (if any).
Batches Are Created During Stock In
Tip: The supplier's batch number is usually printed on the product box — type that number into the Batch number field.
- Open Stock In → choose/scan a product.
- If expiry tracking is turned on, the Expiry Tracking section appears:
- Batch number — a field prefixed with LOT-; leave it empty to auto-generate a number.
- Expiry date — pick from the date picker (must be a future date).
- Tap Save — the new batch is created automatically.
Automatic Depletion During Sales
When the cashier checks out, the system automatically depletes batches by FIFO or FEFO behind the scenes — the cashier doesn't see it and doesn't need to choose any batch.
Stock Depletion Method Setting
Tip: This setting is synced between the POS and the Web Dashboard. In the Web Dashboard you can set it for all stores or for a specific store only.
- In the Web Dashboard: Settings → Inventory, or on Android: Settings → Inventory.
- Find Stock Depletion (on Android: Stock Depletion Method).
- Choose FIFO or FEFO.
Usage Tips
- Run an expiry check every week — review "Expiring Soon" batches and arrange for them to be sold first.
- Use FEFO for pharmacies — reduces waste from medicines that are close to expiry.
- Let the system auto-generate batch numbers if the supplier doesn't provide its own batch number.
- Audit batches regularly — compare system records with the physical stock on the shelves.
Frequently Asked Questions
Batch/expiry date fields don't appear during Stock In
Turn on Track expiry under Settings → Inventory
Batch isn't created during Stock In
Make sure the batch number and expiry date are filled in (or leave the batch number empty to auto-generate)
Batch depletion doesn't happen as expected
Check that Settings → Inventory → Stock Depletion is set correctly
Dashboard shows 0 batches
Make sure stock has been received with batch details
Expiry date can't be selected
The date picker only allows future dates (tomorrow onwards)