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:
| Data | How you write it |
|---|---|
| Product | From the list, always the same name |
| Batch number | As printed on the box, without spaces or convenient hyphens |
| Expiry | Month and year |
| Quantity and unit | Vials, packs, or however you count them |
| Price per unit | VAT included |
| Supplier | The one it comes from |
| What it contains | Only 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-BandA1234 Bare 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 giorniand decide what to use first - You send the orders: when the goods arrive, close the order




