Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHealth & FitnessClinic & Practice ManagementMedical Supplies Inventory

SpreadsheetClinic & Practice ManagementFree

Medical Supplies Inventory

Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.

Shown with sample data

Colour

Medical Supplies Inventory

Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.

Items to reorder
4
Expiring within 60 days
2
Expired
1
Remove from use
Stock value
$365.35
Stock value by category
  • PPE$131.50
  • Diagnostics$65.25
  • Cleaning$48
  • Wound care$47.10
  • Medication (non-controlled)$38.40
  • Injection & IV$35.10
Share of stock value by category
  • PPE$131.5036%
  • Diagnostics$65.2518%
  • Cleaning$4813%
  • Wound care$47.1013%
  • Medication (non-controlled)$38.4011%
  • Injection & IV$35.1010%

How to use it

  1. 1List every item with its unit, storage area, par level and unit cost.
  2. 2Count stock and type the quantity on hand and the earliest expiry date.
  3. 3Order the Reorder qty for anything marked Reorder.
  4. 4Use or return items marked Expiring soon, and remove anything Expired.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Never run out of gloves or find expired stock in the cupboard. List each item with its par level and the quantity on hand; the sheet flags what to reorder and how many, warns about items that expire within 60 days and totals the value of stock in each storage area.

Who it’s for

  • Clinic and treatment-room consumables
  • First-aid rooms and school health offices
  • Monthly stock checks

What’s included

  • Supplies sheet: Every stocked item with par level, quantity and expiry.
  • Summary by Category sheet: Stock value and Reorder qty and the number of entries for each category, calculated from the Supplies sheet.

How to use it

  1. 1List every item with its unit, storage area, par level and unit cost.
  2. 2Count stock and type the quantity on hand and the earliest expiry date.
  3. 3Order the Reorder qty for anything marked Reorder.
  4. 4Use or return items marked Expiring soon, and remove anything Expired.

Tips

  • Put new stock behind old stock so the earliest expiry is used first.
  • Set par levels to about two weeks of normal use plus your supplier’s lead time.

Questions

What is a par level?

The quantity you want on the shelf after restocking. Reorder qty is par minus on hand.

Related searchesmedical supplies inventoryclinic inventorypar levelsexpiry trackingconsumablesstock control

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetClinic & Practice ManagementFree

Medical Supplies Inventory

Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More clinic & practice management templates

View all
Patient Appointment Schedule2 sheets

Appointments

10

No-show rate

10%

Average wait (min)

11.5

ABCD
1DateTimeProviderVisit type
2Nov 1208:30Dr PatelAnnual check
3Nov 1208:30NP RiveraFollow-up
4Nov 1209:00Dr PatelNew patient
5Nov 1209:15Dr OkaforProcedure
Schedule
SpreadsheetClinic & Practice Management

Patient Appointment Schedule

A day sheet for the front desk: every appointment by provider and room, with arrival status, wait time and the day’s no-show rate.

10 min setupPreview

New Patient Intake Form

Please complete this form before your first visit. Your answers help us prepare for your appointment.

Full name *

Date of birth *

Phone *

Send my details
FormClinic & Practice Management

New Patient Intake Form

Registration details, emergency contact, insurance and a short health history, collected before the first visit.

10 min setupPreview
Nurse Shift Schedule

Shifts rostered

53

Hours rostered

636

16171819202122
Amara NwosuDDDOffOffOffD
Ben CarterOffOffOffOff
Chloe MartinOffOffOffDDDOff
Dev SharmaOffOffOffOff
SpreadsheetClinic & Practice Management

Nurse Shift Schedule

A two-week unit roster with day, evening and night shifts, hours per nurse and a staffing check for every shift.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ