Controlled Substance Perpetual Inventory and Monthly Reconciliation
Use this template to reconcile Schedule II controlled substances against a perpetual inventory, document variances, and close the loop with corrective action and sign-off.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Healthcare · Pharmacy · Ambulatory Surgery · Dental · Veterinary
Overview
This template is for reconciling a perpetual inventory of Schedule II controlled substances against a physical count and the source records that created the balance. It gives you a structured way to confirm the inspection period, identify the items in scope, verify the beginning balance, review receipts and dispensing entries, document adjustments or wastage, and record any variance found during the count.
Use it when you need a repeatable monthly reconciliation, a diversion-control review, or a controlled-substance audit trail that shows who reviewed the records and what happened when the count did not match. It is especially useful in pharmacies, clinics, hospital units, surgery centers, and any location that stores controlled substances in a secure cabinet or vault. The storage-security section helps confirm access restrictions and segregation of inventory, while the discrepancy section ensures issues are escalated and tracked to closure.
Do not use this template as a substitute for your required dispensing, administration, receipt, or destruction records. It is also not the right tool for non-controlled inventory or for one-time physical counts that do not require reconciliation against a perpetual log. If your operation handles Schedule II substances under a specific state board, DEA program, or facility policy, customize the fields to match your workflow and retention rules. The goal is to make the monthly review observable, defensible, and easy to repeat.
Standards & compliance context
- This template supports controlled-substance accountability expectations commonly associated with DEA and state controlled-substance rules, especially where perpetual inventory and reconciliation are required.
- The storage-security section aligns with controlled-access expectations found in healthcare and pharmacy compliance programs, including restricted access, segregation, and documented exceptions.
- The discrepancy and corrective-action sections support diversion-prevention controls and internal audit practices used in regulated healthcare environments.
- If your organization follows a formal quality system, the record review and corrective-action workflow also fits ISO 9001-style non-conformance handling and closure.
- Customize retention, reviewer roles, and escalation steps to match your facility policy, board requirements, and any applicable federal or state controlled-substance program.
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
Inspection Scope and Inventory Period
This section defines exactly what was reviewed and over what time window, which prevents scope drift and makes the reconciliation defensible.
-
Inspection period is defined and covers the required reconciliation interval
Record the inventory period start and end dates being reviewed.
-
Schedule II controlled substances included in scope are identified
Select all Schedule II items included in this reconciliation.
-
Perpetual inventory log is available for review
The current perpetual inventory record is present and accessible for inspection.
-
Inspector verified the reconciliation date and responsible reviewer
Enter the name or role of the person who performed the reconciliation and the date completed.
-
Source records available for comparison
Confirm the records used to support the reconciliation.
Perpetual Inventory Record Accuracy
This section checks whether the log itself is trustworthy before you rely on it for the physical count comparison.
-
Beginning balance matches prior reconciled ending balance
Record the beginning balance and confirm it matches the prior period ending balance.
-
All receipts were entered into the perpetual inventory on the date received
Verify that incoming Schedule II receipts were recorded without delay or omission.
-
All dispensing or administration events were recorded accurately
Verify that each decrement in inventory is supported by a corresponding record.
-
Adjustments, returns, and wastage are documented with reason codes
Confirm that any inventory adjustment includes a documented explanation and authorization where required.
-
No unexplained gaps or duplicate entries were found in the log
Review the perpetual inventory for missing transactions, duplicate postings, or sequence breaks.
Physical Count Reconciliation
This section proves whether the recorded balance matches what is actually on hand and captures any variance in a usable format.
-
Physical count completed for each Schedule II item in scope
A direct physical count was performed for each controlled substance included in the reconciliation.
-
Counted quantity matches perpetual inventory balance
Confirm the physical count agrees with the perpetual inventory record.
-
Variance amount recorded when counts do not match
Enter the quantity variance for the item being reviewed.
-
Variance explanation documented and reviewed
Describe the reason for any discrepancy and the review performed.
-
Second-person verification completed for the count
Confirm a witness or second verifier independently confirmed the count where required by policy.
Storage Security and Access Control
This section verifies that controlled substances are stored and accessed only under the restrictions your policy requires.
-
Controlled substances stored in a secure, access-restricted location
Storage is locked or otherwise secured against unauthorized access.
-
Access list is current and limited to authorized personnel
Verify that only authorized staff have access to the storage area and inventory records.
-
Storage area is orderly and inventory is clearly segregated
Controlled substances are organized to support accurate counting and reduce mix-ups.
-
Any access exceptions or security deficiencies documented
Record any unauthorized access event, missing key control, or other security deficiency.
Discrepancy Review and Corrective Action
This section turns a mismatch into a tracked issue with ownership, follow-up, and closure instead of leaving it as an unresolved note.
-
Discrepancy escalated according to policy
Confirm the variance was escalated to the appropriate supervisor, pharmacist-in-charge, or compliance lead.
-
Corrective action plan documented
Describe the corrective action, owner, and target completion date.
-
Follow-up review scheduled or completed
Enter the follow-up date/time for recheck or closure review.
Closeout, Sign-Off, and Record Retention
This section confirms management review, final approval, and retention of the completed record for audit readiness.
-
Inspection findings reviewed with responsible manager
Confirm the results were communicated to the responsible manager or compliance owner.
-
Records retained according to policy and regulatory requirements
Confirm the reconciliation, count sheets, and supporting records will be retained per policy.
-
Inspector signature
Inspector signs to confirm the inspection was completed accurately.
How to use this template
- 1. Define the inspection period, list every Schedule II item in scope, and attach or reference the source records that will be compared against the perpetual inventory.
- 2. Verify that the beginning balance matches the prior reconciled ending balance, then review receipts, dispensing or administration events, returns, wastage, and adjustments for date and quantity accuracy.
- 3. Perform and record a physical count for each item in scope, using second-person verification where required, and compare the counted quantity to the perpetual inventory balance.
- 4. Document any variance with the exact amount, a clear explanation, and the reviewer’s assessment, then escalate unresolved discrepancies according to policy.
- 5. Check that storage remains secure, access is limited to authorized personnel, and any access exceptions or security deficiencies are recorded with corrective action.
- 6. Close out the review with manager sign-off, assign follow-up actions and due dates, and retain the completed record according to policy and regulatory requirements.
Best practices
- Reconcile the inventory on the same day each month so the period boundary is consistent and the beginning balance is easy to validate.
- Use source documents, not memory, to verify receipts, administrations, returns, wastage, and transfers before you approve the ending balance.
- Photograph or otherwise preserve evidence of any count discrepancy at the time it is found, especially when the variance involves a high-risk item.
- Require a second-person count for Schedule II stock whenever your policy allows it, and record the verifier by name or role.
- Flag any unexplained gap, duplicate entry, or late transaction as a non-conformance until the record is corrected and reviewed.
- Keep the access list current and remove former staff promptly so the storage-security section reflects real authorization, not outdated permissions.
- Document the reason for every adjustment in plain language, because vague notes like 'inventory correction' do not support a defensible audit trail.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this template cover?
This template covers a perpetual inventory review for Schedule II controlled substances, a physical count reconciliation, storage security checks, discrepancy handling, and final sign-off. It is designed to show whether the recorded balance matches on-hand stock and whether any variance was investigated. It also captures access control and record-retention checks so the audit does not stop at the count. Use it as a monthly reconciliation record or as a controlled-substance audit worksheet.
How often should this reconciliation be performed?
Use it on the cadence required by your policy, diversion-control program, or pharmacy/clinic workflow, with monthly reconciliation being the common use case implied by this template. If your operation handles high-risk items, high volume, or frequent adjustments, you may choose a shorter interval. The key is to keep the reconciliation period consistent so beginning balance, receipts, dispensing, and ending balance can be compared cleanly. If your policy or regulator requires a different cadence, customize the inspection period field accordingly.
Who should complete the count and review?
A designated responsible reviewer should complete or oversee the reconciliation, and the physical count should include second-person verification where your policy requires it. In practice, that often means a pharmacist, controlled-substance manager, inventory lead, or other authorized employee with access to source records. The person performing the count should not be the only person reviewing discrepancies. Separation of duties helps reduce errors and makes the audit trail stronger.
Does this template replace DEA, state, or facility-specific controlled substance logs?
No. It is a reconciliation template that sits alongside your required controlled-substance records, not a replacement for them. You should still maintain the underlying dispensing, administration, receipt, wastage, return, and adjustment records required by your governing rules and internal policy. This template helps compare those source records to the perpetual inventory and document the result. Customize it to match your state board, DEA program, hospital policy, or clinic workflow.
What are the most common mistakes this audit catches?
Common issues include receipts entered late, missing wastage or return entries, duplicate transactions, unexplained balance gaps, and counts that were not independently verified. It also often surfaces access-control problems such as outdated authorized-user lists or unsecured storage. Another frequent problem is a variance explanation that is too vague to support follow-up. This template forces each discrepancy to be documented, reviewed, and assigned an action.
Can this be used for pharmacies, clinics, or hospital units?
Yes, as long as the scope is limited to Schedule II controlled substances and the workflow matches your local process. Pharmacies may use it for stock bottles and unit-dose inventory, while clinics or hospital units may use it for cabinet stock or procedure-room supply. The section structure works well wherever a perpetual inventory must be tied back to physical counts and source records. You can rename fields to match your location, department, or medication class.
How should discrepancies be handled when the count does not match?
Record the variance amount, document a specific explanation, and escalate it according to policy rather than correcting the log without review. The template includes a corrective-action section so the issue can be assigned, tracked, and closed out. If the discrepancy cannot be explained immediately, preserve the source records and recheck the count, transaction history, and access log. Unresolved variances should be treated as a compliance and diversion-risk issue until cleared.
Can this template be integrated with inventory software or EHR systems?
Yes. Use it as the audit layer over your inventory system, EHR, dispensing platform, or controlled-substance cabinet logs. The source-records section is meant to capture what was compared, even if the underlying data came from software rather than paper. If your system exports transaction history, attach or reference it in the reconciliation record. That makes the monthly review easier to repeat and easier to defend during an internal or external audit.
Related templates
Go deeper on the topic
-
Predictive scheduling laws — also called fair workweek laws or secure scheduling — require employers in covered industries to publish employee schedules...
-
Overtime calculation is the process of applying federal, state, local, and contractual rules to hours worked to determine the correct pay — including...
-
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...
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
See how customers use MangoApps Projects Module to collaborate, track progress, and share knowledge across teams.
-
MangoApps in Okta Integration Network automates user provisioning, SSO, and access management for stronger security and less admin work.
Ready to use this template?
Get started with MangoApps and use Controlled Substance Perpetual Inventory and Monthly Reconciliation with your team — pricing built for small business.
