Free AuditEnterprise AIShelfSense
All free tools
Free template

The pharmacy stock register that tracks batches, not just quantities

One row per batch with expiry date, days-left countdown, FEFO pick order and a return-window status column — because 'Amoxicillin, qty 400' is really three batches with three different expiry dates. Print-ready Excel, 500 rows, formulas included.

Drop your email, get the file. Not locked — the form just tells us it was useful.

Instant download. No spam, unsubscribe in one click.

What's inside

The register

  • Batch-level rows: medicine, generic, schedule, batch, supplier, invoice, MRP and cost
  • Days-to-expiry countdown and FEFO pick order computed for you
  • Status ladder tuned for pharmacy: EXPIRED / RETURN WINDOW (≤90 days) / WATCH / OK
  • Summary tiles: stock value, value in the return window, expired value

The discipline sheet

  • Why batch-wise beats item-wise for anything with a date
  • The supplier return-window logic — the deadline that is NOT printed on the strip
  • How the Schedule column links to your statutory H1/X registers
  • Where a spreadsheet stops and software starts (honestly)

Operational template — it complements, never replaces, the statutory H1 and Schedule X registers (both available free on this site).

The file solves the format. The discipline is the hard part.

ShelfLifePro enforces FEFO at the point of sale, fills the H1/X registers automatically, and alerts you while the supplier return window is still open.

See ShelfLifePro for pharmacies