Free tool

A pharmacy invoice: every item with its batch number and expiry date.

A pharmacy invoice is not like another shop's: the same item can come from two batches with different expiry dates, and when someone returns a box or asks about it you need to know which batch it left from. This template adds a batch number and an expiry date to the usual columns, with sample rows for common items under their generic names and the prices left blank for you to fill. Items that do not expire, like a thermometer, have both fields left blank on purpose.

Download

Plain files with no macros; they work in Excel, Google Sheets and LibreOffice.

Common questions

Why put a batch number and expiry on a pharmacy invoice?

Because the same item arrives in different deliveries. With the batch on the invoice you know which box left, so a return or a question can be traced to one batch. In Dashing every supplier delivery is recorded as a batch with its expiry date, and the cashier suggests the nearest expiry first.

Is this a prescription or an official tax invoice?

No. It is a plain sales invoice with no prescription fields. What an official invoice must contain is set by the tax authority in your country, so check it before using this template as one.

What do I enter for an item that does not expire?

Leave both blank. In the sample rows the thermometer has no batch and no date, on purpose: a blank field means the item does not expire, not that you forgot.

Dashing does this for every item, automatically, in your shop.