Month-End CS Reconciliation in Veterinary Practices: Step-by-Step Guide

Every practice manager and lead tech has a version of this story: it's the last Sunday of the month, the hospital is closed, and you're alone in the treatment room with three binders, a calculator, and a sinking feeling. Three hours later, you find a one-unit discrepancy in fentanyl that you can't explain. You go home without resolving it and try not to think about it until Tuesday.

This guide exists to make that experience shorter, less anxiety-inducing, and — more importantly — less likely to produce the undocumented discrepancies that cause DEA problems.

Why Reconciliation Takes 3–5 Hours

The core of the problem is that paper logs and EMR modules do not maintain a continuous, verified running balance. This means reconciliation requires you to reconstruct what the balance should be by manually tallying every event in the log, then comparing that against a physical count. At a practice with high CS volume — 20–30 events per day — this is not a quick calculation.

The specific bottlenecks are:

• Handwriting decipherment. Paper logs with illegible entries force you to track down the original author or make a judgment call.
• Missing entries.When a tech forgets to log a draw during a crash, you discover it only when the balance doesn't reconcile — at which point you must reconstruct the event from memory, patient records, and billing.
• Wrong vial/lot. Entries logged against the wrong vial (a common locum error) create false discrepancies that take hours to untangle.
• No running balance.Without a running balance maintained between entries, you can't spot a growing discrepancy until month-end — when the cause is far in the past.
• Multi-schedule complexity. Separate logs for CII, CIII, CIV, and CV, with different vials and lot numbers for each drug, multiply the work.

What the DEA Requires for Monthly Reconciliation

The DEA does not technically require a monthly reconciliation — it requires a continuous running balance maintained per vial (21 CFR §1304.04(d)), and it requires that records be available for inspection at any time. In practice, monthly reconciliation is the industry standard interval because:

• Discrepancies discovered after more than 30 days are exponentially harder to investigate
• Many state veterinary boards explicitly require monthly reconciliation by regulation
• DEA inspectors expect to see evidence of regular, documented reconciliation activity

A proper DEA-defensible monthly reconciliation must produce a written record that shows:

• Calculated balance: Starting balance + receipts − draws − wastes ± adjustments
• Physical count: Actual physical count performed by two people (one blind, one verifying), with both signatures
• Comparison: Calculated vs. physical, with variance noted
• Discrepancy documentation: Any variance explained and investigated
• Sign-off: Dated signature of the DEA registrant (DVM or owner)

Pre-Reconciliation Setup

Before you pull the first binder, these tasks should be complete. Skipping them is the most common reason a reconciliation takes six hours instead of two:

1. Confirm the reconciliation period. Define the exact start and end dates. Most practices use calendar months. The DEA uses calendar year for biennial inventory but does not specify a monthly window — pick one and keep it consistent.
2. Pull all receiving records for the period. Every CS purchase order, DEA Form 222, or CSOS record for drugs received during the period. These are your "in" column.
3. Confirm the opening balance.The closing balance from last month's reconciliation is your opening balance. If last month's reconciliation wasn't documented, you need a physical count as of the first day of the period.
4. Stage the vials. Pull all active vials into a single, organized staging area. You cannot count vials that are scattered across treatment rooms.
5. Arrange for a second person.DEA regulations do not require two people for monthly reconciliation (that's the witness requirement for waste events), but state regulations in many states do, and it's best practice regardless.

The Complete Reconciliation Workflow

Follow these steps in order. Do not skip steps to save time — every shortcut creates a risk you discover at the worst possible moment.

1. Tally all receipts for the period. For each drug and lot number, sum all units received. This is your gross addition to the opening balance.
2. Tally all dispenses (draws) from the log. Per drug and per vial/lot, sum all draw volumes. Include patient name and date for each.
3. Tally all wastes from the log. Per drug and per vial/lot, sum all waste volumes. Verify that every waste entry has a documented second witness.
4. Tally all adjustments from the log. Any adjustments (spillage, breakage, expiry disposal) documented during the period.
5. Calculate the expected balance per vial:
   Expected Balance = Opening Balance + Receipts − Draws − Wastes ± Adjustments
6. Perform the blind physical count. One person counts the physical vials without seeing the expected balance. The second person records the count and then compares to the expected balance.
7. Document the result. Record the expected balance, physical count, and variance for each drug and lot number on your reconciliation form.
8. Investigate any variance (see below).
9. Have the DEA registrant sign the completed reconciliation. Dated signature. This is the legal record.

Investigating and Documenting Discrepancies

A discrepancy is any variance between the expected balance and the physical count that cannot be explained by an authorized event in the log. The DEA expects you to investigate discrepancies promptly and document the investigation — not just note that the variance exists.

Threshold for DEA Form 106

Under 21 CFR §1301.74(c), you must file DEA Form 106 for theft or significant loss of controlled substances. The DEA does not define a precise threshold for "significant" — it evaluates based on the drug, the quantity, and the pattern. In practice:

• Any unexplained loss of a Schedule II controlled substance (morphine, fentanyl, oxymorphone) should be considered a reportable event until proven otherwise.
• A recurring single-unit variance in any drug at the same time of month is a pattern, not a rounding error.
• If in doubt, consult your DEA compliance attorney before concluding a loss is insignificant.

Investigation Steps

1. Confirm the physical count is correct. Recount independently before assuming a discrepancy is real.
2. Verify the opening balance.An error in last month's closing balance carries forward and appears as a new discrepancy every month until found.
3. Cross-reference with billing/EMR. Patient billing records can confirm administered drug quantities. A draw with no corresponding billing is a red flag.
4. Review near-misses and crash events. Emergency cases often have log gaps because logging during a crash is difficult. Interview the attending tech and DVM.
5. Check witness signatures. A waste with no witness — or the same person signing as both administering and witnessing — is a compliance gap that may mask a larger issue.
6. Document everything. Even if you resolve the discrepancy, document the investigation process and conclusion. A documented investigation is evidence of a functional compliance program; an undocumented discrepancy is evidence of negligence.

Sign-Off and Record Retention

Every monthly reconciliation record must be retained for at least two years per 21 CFR §1304.04(a). This means:

• The completed reconciliation form (or digital equivalent)
• The underlying event log for the period
• Any discrepancy investigation documentation
• The DEA registrant's signed and dated attestation

If you're retaining digital records, ensure they satisfy 21 CFR Part 11 electronic record requirements — specifically that records cannot be modified after submission and that electronic signatures are attributable to a specific individual.

The 7 Most Common Reconciliation Mistakes

1. Reconciling per drug, not per vial/lot. The DEA requires running balance per vial — not per drug class. A single drug with three open vials requires three separate balances.
2. Using the previous balance without verifying it.If last month's reconciliation had an undocumented discrepancy, using its closing balance as your opening balance perpetuates the error.
3. Counting expired or condemned vials.Vials pending destruction or already destroyed should not be counted in the active balance. If they're still in the cabinet and the destruction hasn't been logged, your balance will be off.
4. Not reconciling vials opened but not finished. A partially used vial has a remaining volume that must be estimated or measured. This is a common source of "found" discrepancies.
5. Missing a vial entirely.Vials stored in secondary locations (crash kits, procedure rooms) that aren't staged for the count create false deficits.
6. Documenting without signing. A reconciliation form not signed by the DEA registrant is not a compliant record. The signature is the legal attestation.
7. Carrying forward an unexplained discrepancy. Writing "variance: -1 unit, cause unknown" and not investigating is not a defensible compliance record. It is an admission that you have an unsolved problem.

How to Cut the Process to Under 30 Minutes

With purpose-built CS software that maintains a live running balance per vial, the reconciliation calculation step disappears entirely. The system continuously computes the expected balance from every logged event. At month-end, you:

1. Perform the physical blind count (still required)
2. Enter the physical count into the system
3. The system flags any variance immediately — no manual math
4. Investigate and document any variances
5. Generate the one-click PDF reconciliation report
6. DEA registrant e-signs the report

At a practice that averaged 4.5 hours for monthly reconciliation, this workflow typically reduces the process to under 30 minutes — and catches discrepancies during the month (when they're still investigable) rather than at month-end.

Free Monthly Reconciliation Checklist Template

Every veterinary practice, regardless of the tools they use, should have a documented reconciliation procedure. The checklist below covers the minimum elements required for a DEA-defensible monthly reconciliation record:

1. Reconciliation period defined (start date, end date)
2. Opening balance verified against prior month's closing balance
3. All receipts tallied per drug and lot
4. All draws tallied per drug and vial
5. All wastes tallied per drug and vial — witness verified for each
6. All adjustments tallied per drug and vial
7. Expected balance calculated per vial
8. Physical blind count performed — two staff members
9. Variance calculated (expected minus physical)
10. Any variance investigated and documented
11. DEA Form 106 determination made (reportable or not, documented)
12. DEA registrant signature and date
13. Record retained per 2-year DEA requirement

Download the printable version from our resources page — it includes a calculation worksheet and a variance investigation log.