Skip to content
Medical Supplies Inventory cover: a sample sheet with lines stocked, stock value and lines to order and a column chart, beside the Dashboard and Supplies tabs

Medical Supplies Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Clinic managers, practice nurses and facility staff use this sheet to keep par-level records for dressings, gloves, syringes, IV fluids and disinfectant. The Supplies tab shows each line with its code, on-hand count, par level, unit cost, stock value, expiry date, an Order flag and a Date check flag that appears when an item expires within 60 days. The Dashboard adds totals, a value chart by category and units used by area.

Post each withdrawal on the Usage tab on the day it happens, then correct the On hand figure from a physical count instead of adding up the log, because counts catch breakage and miscounts. Review the Date check flags each week and move near-dated stock to the front of the shelf. Set each par level from how fast the line moves over a few weeks, and revisit it after a quarter.

Useful for

  • Setting par levels for a small clinic or treatment room
  • Spotting stock that expires within the next few months
  • Showing which ward or area uses the most supplies

What's included

  • 4 tabs: Dashboard, Supplies, Usage, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Supplies: a table
  • Usage: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Supplies tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I change how far ahead the expiry check looks?

The Date check column uses 60 days. Edit the formula in that column, swap 60 for your own number of days, and drag it down the rows. The count on the Dashboard updates on its own.

Should I log every use or count the shelf instead?

Use both. The Usage tab shows where supplies went, and a regular physical count corrects the On hand figure. Where the two disagree, trust the count and look for breakage, waste or a missed entry.

Can I keep records for more than one site?

Duplicate the file per site and name each one, so every location holds its own par levels and usage. Do not merge them, because the Dashboard totals only show what is in the file they belong to.

  • #inventory
  • #medical-supply-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…