Skip to content
FibonacciAestheticsLog inTry it free

Running the practice

The practice stockroom without Excel: inventory, expiry dates and batches

Stock management in a medical practice: what to record on receipt, how to keep stock levels, minimum stock and expiry dates, and how to trace a batch.

The Fibonacci editorial teamUpdated on 8 min read

Cardboard boxes on a metal shelf
In this article
  1. What the stockroom holds
  2. Intake: what you write when the goods arrive
  3. Drawdown: the session takes from the shelf
  4. Minimum stock and reordering
  5. Expiry dates
  6. When the figures do not add up
  7. The batch, traced
  8. A routine so you do not lose the thread

A well-run practice stockroom answers four questions without anyone having to count: what is there, what is running out, what is expiring and who received that batch. With a spreadsheet the first three depend on who remembers to update it, and the fourth on how well the records have been written. The most solid route is to let the stock on hand arise from what you already record: the goods intake and the treatment.

Below: what you write when the goods arrive, how you draw them down, how you set the minimum stock level, how you order and what to do when the figures do not add up. The functions are those of the Fibonacci stockroom.

What the stockroom holds

For the program the stockroom is the set of packs you have loaded: each with product, batch, expiry date, quantity, price and supplier. From there you read four tabs: Scorte (what is there and what is missing), Lotti (the individual packs), Ordini (what you have asked suppliers for) and Chi l'ha ricevuto (the search by batch). How broad to make it is your decision. A product you put in the stockroom has to be kept up to date: an account nobody tends ends up giving wrong numbers, and worse than no numbers at all.

Intake: what you write when the goods arrive

Intake is the moment that decides the quality of everything else. For each pack you record:

DataHow you write it
ProductFrom the list, always the same name
Batch numberAs printed on the box, without spaces or convenient hyphens
ExpiryMonth and year
Quantity and unitVials, packs, or however you count them
Price per unitVAT included
SupplierThe one it comes from
What it containsOnly if in the treatment you record units and not vials

Price is the piece of data most willingly skipped and the one that costs the most. Without it, the batch stays out of the stockroom value and out of the cost of treatments. We discuss this in the article on how much margin a treatment leaves.

To avoid copying by hand, the intake window has Leggi dalla confezione: with a USB reader that types like a keyboard, or with the camera on your phone or tablet, the 2D code on the box fills in batch and expiry. The product is recognised on its own for toxins and, for fillers and devices, from the second box loaded onwards; the first time you choose it yourself. If the printed date has already passed the program writes «Confezione scaduta». Check and press Usa questi dati. The image does not leave the device.

Drawdown: the session takes from the shelf

Stock on hand is not a number that someone adjusts. The program recalculates it every time: quantity loaded, minus what sessions with the same product and the same batch have declared, minus manual drawdowns. If a session is corrected or withdrawn, the figure adjusts itself.

Two practical consequences, both intended by the program:

  • The batch written in the session must be identical to the one written at intake. A1234-B and A1234 B are two different batches, and the stock of the first never goes down.
  • Units are not converted. If the pack is loaded in vials and the session declares units, that session is not subtracted; it is flagged in the batch history. You write the ratio yourself, copying it from the box, in the field «What it contains».

A vial that breaks or a pack to be thrown away leaves the shelf without going through a session. From the batch row, Scarica asks for quantity and reason (broken, expired, disposed of, lost, other). You cannot draw down more than there is. The reasons are useful afterwards too: manual drawdowns become the waste you see in the statistics.

The history of a batch shows intakes, drawdowns and sessions, without the patient's name: the stockroom is a shelf page. For names there is the Chi l'ha ricevuto tab. An intake written by mistake is not deleted: it is withdrawn and the stock is recalculated.

Minimum stock and reordering

For each product you can say below which quantity you want to be alerted, how much you usually order and from whom. The threshold is your decision: the program does not suggest how much to keep, because it depends on how many treatments you do, how long the supplier takes and how much being without it weighs on you.

When stock falls below the threshold, the product moves to Da ordinare (or Esaurito, if none is left) and a reminder appears. There are four states: Esaurito, Da ordinare, Ordinato (an order has been sent and not yet arrived that brings the product back above the threshold), A posto.

The order starts from an already written row, with the usual quantity and supplier, or from scratch. It is saved as a draft or as sent. One thing to know: Fibonacci does not send the order. Apri la posta opens your email program with the message ready, or Copia il testo if the supplier has no email. You send it. When the goods arrive, for each product you write quantity, batch, expiry and price, and Metti in magazzino creates the intakes. If the supplier has sent less and the rest will not arrive, Chiudi l'ordine stops waiting for it.

Expiry dates

Packs are filtered by In carico, In scadenza entro 60 giorni, Scadute and Tutte. At the top of the Scorte tab are three numbers: the products to order, the packs expiring (with how many have already expired) and the stockroom value. That value sums only batches with a price, and batches without a price are counted separately: so the total does not look more complete than it is.

For expiring packs a reminder arrives in the reminders list. It talks about the pack, never about people.

When the figures do not add up

Before suspecting a counting error, look for the cause, almost always one of these:

  • the batch has been written in two different ways;
  • the session is in units and the intake in vials, without the «What it contains» field;
  • a pack has been used without going through a session, and nobody has done the manual drawdown;
  • an intake has been withdrawn and not redone.

The batch history flags sessions in units that have not been subtracted, and it is the first place to look. A check with the box in hand at the end of the month, on two or three products, tells you almost immediately which of the four is yours.

The batch, traced

The last question, who received that batch, is the one the stockroom really counts for. Write the batch number in the Chi l'ha ricevuto tab and you get the sessions: patient, date, quantity, expiry. The list exports to CSV and the program prepares a text to copy for contacting patients; it sends nothing on its own, and does not state the reason for the contact, because an SMS can be read by anyone holding the phone. The reason is given verbally. Whether a batch should be recalled is stated by the manufacturer or the Ministry, not by the program. A notice reminds you of sessions with a product but without a batch: the search does not see them.

On why the batch is written, on what the texts on devices say and on how to prepare a recall, see the article on batch traceability. The European regulation, at Article 27, paragraph 9 (opens in a new tab), obliges health institutions to record and keep the identifiers of class III implantable devices. For other devices it says that Member States encourage health institutions, and may oblige them, to do the same. What applies to your practice is established by the Italian implementing rule, and it is worth asking your adviser: in the meantime, writing the batch at every session is the practice those texts push towards.

A routine so you do not lose the thread

  • On delivery: intake straight away, with price and expiry, before putting the box on the shelf
  • The batch is always written as printed
  • Every breakage or discard goes through Scarica, with the reason
  • At the end of the month: a spot check with the box in hand
  • At the end of the month: scroll through In scadenza entro 60 giorni and decide what to use first
  • You send the orders: when the goods arrive, close the order

What Fibonacci does for this

This is how it looks in Fibonacci, with sample data:

Sessions with product and batch in Fibonacci, with sample data

Sources

  1. Regulation (EU) 2017/745 (MDR), Articles 25 and 27 (EUR-Lex) (opens in a new tab)

These articles explain what regulations and guidelines require and what is documented in the medical record. They are not legal or tax advice on your situation and do not say how to treat a patient.

Try Fibonacci in your practice for 15 days, no credit card needed

Within one working day we call you: together we set up your practice and import your data.

Try it free

Read next

All articles