Pharma

Expiry risk and stockouts, before they become write-offs.

In pharma the clock matters as much as the count. Dashlytics surfaces capital at risk from expiry (FEFO), how fast lines are stocking out, and which customers you depend on most.

What your analyst looks at first

Expiry capital-at-risk (first-expiry-first-out)
Stockout velocity by product
Customer / distributor concentration
Batch and value at risk this month
$89K
Stock at expiry risk, flagged early
example, computed from your data

What a generic dashboard tool misses in pharma

In pharma the clock is a bigger risk than the count, and no general-purpose dashboard tool models it. Shopify has no expiry field at all; most BI tools will treat an expiry date as just another column to group by. What matters is the interaction between two things: how fast a line is selling and how long it has left. A product with six months of stock and three months of shelf life is a write-off already scheduled, and it looks perfectly healthy on a revenue chart.

The columns this needs from your file

You do not need all of these to start. The first three build a working dashboard; each one after that unlocks a specific analysis.

  • Sale or dispatch date
  • Product name or batch
  • Quantity sold
  • Unit price or line total
  • Expiry date (unlocks FEFO and capital-at-risk)
  • Stock on hand (unlocks stockout velocity)

Messy headers, several sheets in one workbook and mixed date formats are handled on upload, because real exports look like that. Every figure is computed from your rows and reconciles against the source file, and a Data Readiness score tells you how far to trust the result before you act on it.

Frequently asked questions

What is FEFO and why does it matter more than FIFO?

FIFO ships whatever arrived first. FEFO, first-expiry-first-out, ships whatever expires first, which is not the same thing when deliveries arrive out of order or shelf lives differ by batch. For anything dated, FEFO is the ordering that prevents write-offs, and it needs expiry data rather than receipt dates.

How is expiry capital-at-risk calculated?

For each product we compare current stock against how fast it is actually selling, project how much will remain unsold at its expiry date, and value that remainder at cost. The output is a single number: the money likely to be written off if nothing changes, with the specific lines driving it listed underneath.

What columns does a pharma dashboard need?

A date, product and quantity build the sales view. Expiry date is the column that unlocks everything specific to pharma, and stock on hand sharpens the stockout view. These usually already exist in a stock take or distributor export.

Add stock-on-hand and expiry-date columns to unlock FEFO and dead-stock analysis.

Try it on your data →See a live demo
← All industries