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)