Controlled Substance Perpetual Inventory and Monthly Reconciliation
This controlled substance perpetual inventory and monthly reconciliation template tracks Schedule II stock from receipt to dispensing, then compares the book balance to the physical count. Use it to catch variances early, document investigations, and support DEA-ready accountability.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Healthcare · Pharmacy · Ambulatory Surgery Centers · Long Term Care · Veterinary Clinics
Overview
This template is for documenting a perpetual inventory and monthly reconciliation of Schedule II controlled substances. It gives you a structured way to confirm the inventory period, review every posted transaction, count selected items, compare book balance to physical stock, and record any discrepancy review or escalation. The workflow is built for controlled substance accountability, so it emphasizes traceable receipts, dispensing reductions, wastage adjustments, secure storage, and sign-off by responsible personnel.
Use it when you need a repeatable control for pharmacy stock, clinic cabinets, automated dispensing locations, or any other secured controlled substance storage area. It is especially useful after a variance, during routine monthly reconciliation, or when you need to show that inventory records are current and that access is restricted. The template also helps when multiple people touch the stock, because it records who counted, who witnessed, and who reviewed the findings.
Do not use this as a substitute for your dispensing system, controlled substance log, or required regulatory records. It is not meant for non-controlled medications, general supply counts, or informal spot checks without a reconciliation trail. If your site has unresolved losses, suspected diversion, or repeated posting gaps, the template should be used as a control document alongside your incident response and compliance process, not as a standalone fix.
Standards & compliance context
- This template supports controlled substance accountability expectations under DEA and related controlled substance recordkeeping and security rules by tying each transaction to a running balance and a physical count.
- The storage and access-control section aligns with controlled substance security practices expected in healthcare and pharmacy environments, including restricted access and tamper awareness.
- If your organization operates under state pharmacy rules, hospital policy, or a diversion prevention program, this template can be adapted to match those internal controls without changing the reconciliation logic.
- When a discrepancy suggests loss, theft, or diversion, the escalation section should be used to document management review and any required reporting under applicable regulatory frameworks.
- The template is compatible with broader quality and compliance systems, including ISO-style document control and audit trail expectations, because it preserves who reviewed, counted, and signed off.
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 what was reviewed, when it was reviewed, and who is accountable for the reconciliation.
-
Inspection date and reconciliation period documented
Record the date/time of the inspection and the inventory period covered by this reconciliation.
-
Controlled substance inventory set identified
Select the Schedule II controlled substances included in this perpetual inventory review.
-
Reference to perpetual inventory log available
Confirm the current perpetual inventory record is available for review and matches the reconciliation period.
-
Inspector and witness names recorded
Enter the inspector name and any required witness or second verifier name.
Perpetual Inventory Record Review
This section checks whether the transaction log is complete enough to trust the running balance before the physical count.
-
All Schedule II transactions posted without unexplained gaps
Verify receipts, dispensing, returns, wastage, transfers, and adjustments are posted in sequence with no unexplained gaps in the record.
-
Receipts documented with date, quantity, and source
Confirm incoming Schedule II receipts are documented with date received, quantity received, and supplier or transfer source.
-
Dispensing and administration reductions documented
Verify reductions to inventory are documented with the transaction date, quantity removed, and supporting record.
-
Adjustments and wastage entries authorized and traceable
Confirm any inventory adjustments, wastage, or reversals include authorization and a traceable explanation.
-
Running balance updated after each transaction
Verify the perpetual inventory running balance is updated after each transaction and remains mathematically consistent.
Physical Count Reconciliation
This section compares the book record to actual stock and captures the variance in a way that can be investigated.
-
Physical count performed for each selected item
Confirm a physical count was completed for each selected Schedule II item in the reconciliation set.
-
Book-to-physical variance recorded
Enter the variance quantity between the perpetual inventory balance and the physical count.
-
Variance is within acceptable tolerance
Confirm the variance is zero or within the organization’s approved tolerance threshold.
-
Count performed by authorized personnel
Verify the physical count was completed by authorized personnel and, where required, independently verified.
-
Count location secured during reconciliation
Confirm the storage area remained secured during the count and access was limited to authorized staff.
Storage Security and Access Control
This section confirms the stock is protected from unauthorized access and that the access list matches current reality.
-
Controlled substances stored in locked, access-restricted area
Verify Schedule II stock is stored in a locked area with access restricted to authorized personnel only.
-
Access list current and reviewed
Confirm the access list for controlled substance storage is current and reviewed for authorized users.
-
Security incidents or tampering signs absent
Check for signs of tampering, unauthorized entry, missing seals, or other security incidents.
Discrepancy Review and Escalation
This section turns a variance into an action item by documenting root cause, reporting, and corrective follow-up.
-
Discrepancies investigated and root cause documented
Confirm any variance was investigated and a root cause or probable cause was documented.
-
DEA or regulatory reporting initiated when required
Verify discrepancies meeting reporting thresholds were escalated to the DEA or applicable regulator per SOP.
-
Corrective action assigned with due date
Document the corrective action owner, action steps, and target completion date.
Closeout and Sign-Off
This section records management review and formal approval so the reconciliation is complete and auditable.
-
Inspection findings reviewed with responsible manager
Confirm findings, variances, and corrective actions were reviewed with the responsible manager or pharmacist-in-charge.
-
Inspector signature captured
Capture the inspector signature to complete the reconciliation record.
How to use this template
- 1. Enter the inspection date, reconciliation period, controlled substance inventory set, and the reference to the perpetual inventory log before the count begins.
- 2. Assign an authorized inspector and witness, then confirm the count location is secured and access is limited during the reconciliation.
- 3. Review each Schedule II transaction for the period, checking that receipts, dispensing, administration, wastage, and adjustments are posted with complete source details and running balances.
- 4. Perform a physical count for each selected item, record the book-to-physical variance, and note whether the difference falls within your approved tolerance.
- 5. Investigate any discrepancy, document the root cause and corrective action, and initiate regulatory reporting or management escalation when required.
- 6. Review the findings with the responsible manager, capture signatures, and close the record only after all open actions have an owner and due date.
Best practices
- Count from the secured storage location without moving stock between locations during the reconciliation.
- Photograph or otherwise document any damaged seals, tamper signs, or unexplained discrepancies at the time they are found.
- Verify that every receipt has a date, quantity, and source before you accept the running balance as reliable.
- Flag any manual adjustment or wastage entry that lacks authorization or a clear supporting record.
- Use the same tolerance rule every month so small variances are not treated inconsistently.
- Separate the person who maintains the perpetual log from the person who performs the physical count whenever your policy allows it.
- Review access lists against current staffing so terminated or transferred users are removed promptly.
- Escalate repeated minor variances as a pattern, not just as isolated bookkeeping errors.
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 exactly?
This template covers a perpetual inventory review for Schedule II controlled substances, a physical count reconciliation, storage security checks, discrepancy escalation, and closeout sign-off. It is designed to document the chain from receipt through dispensing, wastage, and adjustments so the running balance can be compared to actual on-hand stock. It is not a dispensing log by itself, but it can reference one as the source record. Use it as a monthly control or more often if your risk profile requires it.
How often should this reconciliation be performed?
Most organizations use it monthly because the template is built around periodic reconciliation against a perpetual inventory. Higher-risk settings, frequent high-volume handling, or prior variance history may justify more frequent checks. The right cadence should match your internal controlled substance policy and any applicable regulatory expectations. If you change the cadence, keep it consistent and documented.
Who should complete the inspection and count?
The template is intended for an authorized inspector or compliance lead, with the physical count performed by authorized personnel and a witness recorded where required by policy. The person reconciling the inventory should not be the only person handling the stock if your internal controls call for segregation of duties. In practice, pharmacy, nursing, clinic, or compliance staff may participate depending on the site. The key is that the roles are defined and traceable.
Does this template replace DEA recordkeeping requirements?
No. It supports controlled substance accountability, but it does not replace the recordkeeping, security, and reporting obligations that apply under DEA and related controlled substance rules. It helps you document the perpetual inventory, identify unexplained variances, and show that discrepancies were reviewed and escalated. You should align the template with your controlled substance policy, state requirements, and any DEA reporting triggers that apply to your operation. If a discrepancy meets your reporting threshold, the template should capture that escalation.
What are the most common mistakes this template helps prevent?
Common mistakes include missing transaction entries, delayed posting of receipts or administrations, unexplained balance changes, and counts performed without a secure location or proper authorization. Another frequent issue is treating small variances as harmless instead of investigating them and documenting a root cause. The template also helps prevent weak access control documentation, which can make a reconciliation look incomplete even when the count was accurate. Using the same structure every month reduces those gaps.
How do I customize it for a pharmacy, clinic, or hospital unit?
Start by defining the controlled substance inventory set, the count location, and the people authorized to count, review, and sign off. Then adjust the transaction fields to match your workflow, such as receiving, dispensing, administration, wastage, returns, and transfers. You can also add item identifiers, lot numbers, NDCs, or cabinet locations if your process needs more traceability. Keep the core reconciliation steps intact so the audit trail stays consistent.
Can this be integrated with an eMAR, pharmacy system, or cabinet log?
Yes, the template works well as a reconciliation layer over eMAR, pharmacy dispensing systems, automated dispensing cabinet logs, or manual perpetual logs. The important part is that the source records match the running balance and that any differences are explained. If you import data, keep the original source and the reconciliation date visible so reviewers can trace the numbers. Integration should improve traceability, not hide the underlying transactions.
When should a discrepancy be escalated?
Escalate when the variance is unexplained, exceeds your internal tolerance, suggests diversion or tampering, or triggers a regulatory reporting requirement. The template includes a place to document root cause analysis, corrective action, and due dates so the issue does not stop at detection. If the discrepancy involves possible theft, tampering, or repeated unexplained loss, it should move quickly to management and compliance review. Your policy should define who is notified and when.
How is this different from an ad hoc count sheet?
An ad hoc count sheet only captures what was on hand at one moment, while this template ties the physical count back to the perpetual inventory and the transaction history. That makes it easier to spot missing postings, unauthorized adjustments, and access-control issues. It also creates a repeatable monthly record with sign-off and escalation fields, which is what auditors and regulators expect to see. In short, it documents control, not just a count.
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...
-
Mango Training is a healthcare LMS that streamlines onboarding, compliance, and recertification for busy frontline teams.
-
Only 13% of employees use their intranet daily. Learn 9 proven moves to drive frontline adoption above 90% with mobile-first design and governance.
-
Why frontline training fails without rehearsal, and how AI roleplay, live voice practice, and coaching close the gap between learning and doing.
-
Discover why an employee text alert system is essential for frontline safety, faster emergency response, and two-way communication across your entire workforce.
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.
