
Access Card Request Letter
Docs + Word2 pages
Free
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.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Supplies tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
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.
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.
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.
More Google Sheets templatesMore business operations templates

Docs + Word2 pages
Free
Docs + Word2 pages
Free
Docs + Word2 pages
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free