Pharmacy Inventory & Compliance Tracker Google Sheets Template

Track pharmacy inventory, expiration dates, supplier invoices, and compliance documents in Google Sheets. Free pharmacy management template.

What's in this template

• Drug Name — Medication name including strength and form (e.g., Amoxicillin 500mg Capsules)
• NDC — National Drug Code identifier for the product
• Qty on Hand — Current stock quantity in dispensing units
• Unit Cost — Wholesale acquisition cost per unit
• Expiration Date — Earliest expiration date of current stock
• Supplier — Primary wholesale distributor for this product
• Supplier Invoice — Most recent supplier invoice or purchase order PDF for this product
• MSDS - Safety Sheet — Material Safety Data Sheet or product monograph PDF for compliance records
• Reorder Needed — Check if stock is below reorder point and needs replenishment

This free Google Sheets template is built to work with FileFox, the drag-and-drop file management add-on for Google Sheets. Attach contracts, photos, invoices, and any other files directly to rows — every file stays in your own Google Drive. Download the template free and install FileFox from the Google Workspace Marketplace to add file-upload columns.