VFC Vaccine Inventory and Borrowing Log
Track VFC vaccine inventory, dose use, waste, and any public/private stock borrowing in one audit-ready log. Use it to reconcile counts, document PII disclosures, and keep replacement timing visible.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Pediatrics · Community Health Clinics · Family Medicine · Public Health Immunization Programs
Overview
The VFC Vaccine Inventory and Borrowing Log is a workplace form for tracking vaccine stock by product, lot, expiration date, and manufacturer, while also recording doses administered, wasted doses, quantity adjustments, and final ending quantity. It is built for clinics that need a clear record of public and private stock movement and a place to document when borrowing occurred, why it happened, and when replacement is due.
Use this template when your site manages Vaccines for Children inventory, needs to reconcile physical counts against administered doses, or must document borrowing between stock types. It is especially useful for pediatric practices, community clinics, and public health sites that handle multiple vaccine products and need an audit trail for each entry. The form also includes fields for patient identifiers collected and PII disclosure acknowledgment, which helps teams document consent and data handling when identifiers are needed for reconciliation or follow-up.
Do not use this template as a general immunization registry or a patient intake form. It is not meant to collect broad clinical history, and it should not be filled with unnecessary PII. If your site does not borrow between public and private stock, the borrowing section should stay blank through conditional logic rather than being forced into every entry. The form works best when counts are verified at the time of entry and any mismatch is resolved before the log is closed.
Standards & compliance context
- This template supports VFC inventory accountability by separating stock types, documenting borrowing, and preserving an audit trail for review.
- The patient_identifiers_collected and pii_disclosure_acknowledged fields help document data minimization and disclosure practices when PII is needed.
- If your workflow includes patient identifiers, collect only the minimum necessary information and apply access controls consistent with privacy policy.
- Use the form in a way that supports accurate reconciliation and traceability, since incomplete counts or undocumented borrowing can create compliance risk.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Log Entry Details
This section identifies when the entry was made, where it applies, and who completed it so the record can be traced later.
-
Entry Date
Date this log entry is completed.
-
Clinic / Site Location
Location where the inventory event occurred.
-
Completed By
Name or role of the staff member completing the log entry.
-
Entry Type
Choose the primary reason for this entry.
Vaccine Product and Inventory
This section ties each count to a specific vaccine product, lot, expiration date, and manufacturer for accurate traceability.
-
Vaccine Name
Product name or abbreviation used by your program.
-
Stock Type
Indicate whether the inventory is public VFC stock or private stock.
-
Lot Number
Lot number for the vaccine product.
-
Expiration Date
Expiration date for the lot.
-
Manufacturer
Manufacturer name, if needed for reconciliation.
Inventory Movement and Dose Counts
This section captures the math behind the inventory change so administered doses, waste, and adjustments reconcile to the ending quantity.
-
Starting Quantity On Hand
Count at the beginning of the reporting period or before the event.
-
Doses Administered
Number of doses given from this stock or lot.
-
Doses Wasted / Spoiled
Number of doses discarded due to waste, spoilage, or breakage.
-
Quantity Adjustment
Positive or negative adjustment to reconcile inventory counts.
-
Ending Quantity On Hand
Count remaining after administration, waste, and adjustments.
Borrowing Between Public and Private Stock
This section documents any stock borrowing and keeps the reason and replacement timing visible for follow-up.
-
Did borrowing occur?
Select yes if doses were temporarily moved between public and private stock.
-
Borrowing Direction
Choose the direction of the borrowing event.
-
Borrowed Quantity
Number of doses borrowed.
-
Reason for Borrowing
Brief explanation of why borrowing was needed.
-
Replacement Due Date
Date by which borrowed doses should be replaced, if applicable.
Reconciliation, Consent, and Audit Trail
This section records the review notes, PII disclosure acknowledgment, and audit trail reference needed to close the loop on the entry.
-
Reconciliation Notes
Explain discrepancies, corrections, or follow-up actions needed.
-
Were any patient identifiers collected in this entry?
Use only if your workflow requires linking doses to specific patients.
-
PII Disclosure Acknowledged
Confirm that only minimum necessary PII is collected and used for the stated purpose.
-
Audit Trail Reference
Optional internal reference number, batch ID, or reconciliation ticket.
How to use this template
- Create one log entry for each vaccine product and site location, and make entry_date, stock_type, and completed_by required fields.
- Record the lot_number, expiration_date, and manufacturer exactly as printed on the vial or carton so the inventory line can be traced later.
- Enter the starting_quantity, doses_administered, doses_wasted, and any quantity_adjustment, then confirm the ending_quantity matches the physical count.
- If borrowing occurred, select the borrow_direction, enter the borrowed_quantity and borrow_reason, and set a replacement_due_date before closing the entry.
- Add reconciliation_notes, note whether patient_identifiers_collected was needed, acknowledge the pii_disclosure, and save the audit_trail_reference for review.
Best practices
- Use conditional logic so borrowing fields appear only when borrowing_occurred is marked yes.
- Keep stock_type explicit for every entry so public and private inventory are never mixed in the same count.
- Use a date picker for expiration_date and replacement_due_date, and numeric inputs for all quantity fields.
- Record the lot number and manufacturer at the time of entry, not from memory later in the day.
- Document only the patient identifiers you actually need, and avoid collecting extra PII that does not support reconciliation.
- Reconcile the ending_quantity against the shelf count before submitting the log, and resolve discrepancies immediately.
- Keep reconciliation_notes factual and time-stamped so the audit trail explains any adjustment or exception.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this template used for?
This template records Vaccines for Children inventory movements, dose administration, waste, and any borrowing between public and private stock. It is designed to support daily or per-shift reconciliation and to leave a clear audit trail. Use it when your site needs a single log for stock counts and borrowing documentation.
How often should the log be completed?
Complete an entry whenever inventory changes, doses are administered, waste is recorded, or borrowing occurs. Many sites use it daily and reconcile at the end of each clinic session or business day. If your workflow is high volume, assign one entry per vaccine product per location to avoid missed adjustments.
Who should fill this out?
A designated vaccine coordinator, nurse lead, medical assistant, or inventory owner should complete the log. The person entering data should have access to lot numbers, expiration dates, and count changes, and should be able to confirm any borrowing with the responsible site. A second reviewer can be added for reconciliation if your process requires it.
Does this template support compliance needs?
Yes, it is structured to support inventory accountability, borrowing documentation, and audit readiness. It also includes fields for PII disclosure acknowledgment and audit trail reference, which help document how patient identifiers are handled. You should still align the completed log with your local VFC program rules and internal policies.
What are the most common mistakes when using it?
Common issues include mixing public and private stock without marking the stock type, forgetting to record borrowed quantities, and leaving the replacement due date blank. Another frequent problem is using free-text notes instead of structured counts, which makes reconciliation harder. Always confirm that ending quantity matches the calculated movement before closing the entry.
Can this be customized for different clinics or sites?
Yes, you can add site-specific fields such as clinic session, freezer location, or reviewer name. If your organization tracks multiple locations, keep the site_location field required and use separate logs or filtered views by site. You can also add conditional logic so borrowing fields appear only when borrowing_occurred is marked yes.
How does this compare with ad-hoc spreadsheet tracking?
A structured template reduces missed fields, inconsistent naming, and unclear borrowing records that often happen in ad-hoc spreadsheets. It also makes validation easier because dates, counts, and yes/no fields can be standardized. That improves reconciliation and makes it easier to review entries during audits or internal checks.
What should happen after I submit an entry?
After submission, the entry should be reviewed against physical stock and any borrowing agreement or replacement plan. If the ending quantity does not match the shelf count, the discrepancy should be investigated and corrected in the audit trail. If patient identifiers were collected, confirm that disclosure and retention rules were followed before closing the record.
Related templates
Go deeper on the topic
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
Job hazard analysis (JHA) — also called job safety analysis (JSA) — is the structured exercise of breaking a work task into sequential steps, identifying the...
-
A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
-
AI governance is the framework a company uses to decide what AI tools are allowed to do, who's accountable for their outputs, what data they're allowed to...
-
See how MangoApps Forms helps teams collect, track, and analyze employee data in real time — with mobile access, file uploads, and enterprise-grade security.
-
MangoApps AI agents now take action across 21 apps—approving leave, advancing candidates, managing schedules—not just surfacing recommendations.
-
Learn how nonprofit tracking of KPIs, donations, and operational workflows reduces turnover and improves decision-making with the right knowledge management...
-
Spring '26 adds real-time Google & Outlook calendar sync, Google Workspace file creation in Files, upgraded Messenger, and expanded mobile parity.
Ready to use this template?
Get started with MangoApps and use VFC Vaccine Inventory and Borrowing Log with your team — pricing built for small business.
