Home/Spreadsheets/Small Business Tools/Vaccine Inventory Log

Vaccine Inventory Log

Vaccine stock has a property ordinary inventory does not: the lot number matters as much as the count, and expiry is measured in weeks. Track it by lot or do not bother tracking it. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.

What you get

Vaccine item master with par levels and lots
Lot-level transactions: receive and administer
Reorder dashboard: on-hand vs par
Expiry Watch by lot and date
Categories: childhood, flu, COVID, travel and more
Opens in Excel and in Google Sheets

$19.00one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

Vaccine Inventory Log — the workbook open in Excel

What it does

Vaccine item master with par levels and lots
Lot-level transactions: receive and administer
Reorder dashboard: on-hand vs par
Expiry Watch by lot and date
Categories: childhood, flu, COVID, travel and more
Compliance-ready dose and lot tracking

What it looks like

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

Dashboard-Med
Item Master
Expiry Watch
Item Gallery
Transactions

Works in

Microsoft Excel 2016 or later, Windows and Mac
Google Sheets — upload to Drive and open
No macros, no add-ins, no subscription

Honest scope

This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.

Others in Small Business Tools

Vaccine Inventory Log$19.00Buy on Etsy