When a DEA Diversion Investigator walks into your practice, two documents come off the shelf before anything else: the controlled-substance receiving log, and the stack of Patterson Vet, Covetrus, and Henry Schein Animal Health invoices behind it. Those two records are supposed to reconcile, line for line, for every Schedule II–V drug that has crossed your threshold since the last inspection. When they do not, the citation is written that day. According to Cubex, the controlled-substance management vendor that compiled the figure from DEA enforcement data, roughly 96% of US veterinary practices fail at least one recordkeeping requirement on their first DEA inspection, and the most common failure is precisely that receiving-log-to-invoice mismatch.
A DEA-compliant veterinary controlled-substance receiving log captures, for every Schedule II–V order received: the date received, the name and address of the supplier, the kind, finished form, and strength of the drug, the quantity, the NDC, and the signature of the person who took receipt. Under 21 CFR 1304.04, Schedule I and II records must be kept separately from all other records of the registrant; Schedule III, IV, and V records may be kept separately or in a form readily retrievable from ordinary business records. All inventories and records are retained for at least two years and made available to DEA on inspection.
This article walks the practical workflow for building a veterinary controlled substance log from invoice data — specifically the PDF invoices the three remaining US veterinary wholesalers send. Patterson Vet, Covetrus (which absorbed MWI Animal Health from Cencora in the $1.25 billion transaction that closed in late 2024), and Henry Schein Animal Health together handle the overwhelming share of US veterinary controlled-substance distribution. Their invoice surfaces differ in layout and convention but converge on the same regulated row set on the receiving side.
The lens throughout is operational: the receiving log a working veterinary practice maintains in Excel or in a purpose-built system, populated from the wholesaler PDFs, structured to survive inspection, and tied forward to the daily-use log your technicians keep at the cabinet. This is not legal advice. Case-specific questions belong with your state veterinary medical association, your state veterinary medical board, or your DEA Diversion Control field office. What the article delivers is the workflow that a defensible practice runs in between those consultations.
The 21 CFR 1304.04 Column Set, Field by Field
The federal receipt-record requirement is short and specific. Treated as a spreadsheet design rather than as a paragraph of regulation, it produces a row set that maps cleanly onto an Excel header. Each field below corresponds to one column; populate them in this order and you have a controlled drug receiving log veterinary inspectors recognize at a glance.
Date received. The date your practice took physical possession of the drug. This is not the wholesaler's ship date and not the invoice date; both of those appear on the wholesaler PDF but neither is the field the regulation asks for. The date received is what your receiving signer wrote on the packing slip when the box was opened and the contents counted.
Name and address of the person or firm from whom the substance was received. The wholesaler's legal entity name and registered address, taken verbatim from the invoice header. For a Patterson order, this is Patterson Veterinary Supply, Inc., at its Greeley or Devens address depending on the shipping warehouse. For a Covetrus order, this is the Covetrus legal entity printed on the invoice you actually received, which during the post-2024 transition may still read MWI Animal Health. For Henry Schein, this is Henry Schein Animal Health. Capture what the invoice says; do not retroactively normalize.
Kind, finished form, and strength of the drug. The active ingredient, the dosage form, and the concentration. Buprenex 0.3 mg/mL 1 mL injectable, butorphanol 10 mg/mL injectable, ketamine 100 mg/mL injectable, diazepam 5 mg/mL injectable, phenobarbital 30 mg tablet — each of these is a distinct kind-form-strength entry, even where two share the same active ingredient at different concentrations.
Quantity received. The count in the wholesaler's unit of sale: one case, six vials, one hundred tablets. Where the unit of sale is a case or multipack, carry a parallel per-unit-of-issue count in an adjacent column so the daily-use log has something to decrement. The case-to-per-vial expansion gets its own treatment in the multi-pack section below.
NDC. The National Drug Code printed on the invoice line, copied verbatim. NDC appears in two normalized forms in the wild — the 10-digit form the manufacturer assigns and the 11-digit form CMS uses for billing. Pick one and use it consistently across the log; mixing the two breaks reconciliation downstream.
Lot number and expiration date. Lot and expiration are not strictly required at the receipt-record line under the federal rule, but treat them as mandatory in practice. Every state inspector expects them, every drug-recall response needs them, and every per-vial entry on the daily-use log decrements against a specific lot. If a Patterson controlled-substance line shows lot and expiration on the packing list rather than on the invoice itself, pull from both documents to populate the row.
Signature of the person receiving. The licensed individual or the authorized designee who took possession. In a spreadsheet workflow, this is typically a printed-name column with the wet signature retained on the printed packing slip the row references. The packing slip lives in the binder; the row tells the inspector which binder tab to open.
CSOS order number or DEA Form 222 serial number (Schedule II only). For Schedule II receipts, the corresponding electronic CSOS order number or, for any remaining paper-222 orders, the 222 serial number. The CSOS workflow and the three-record set this column ties together get their own walk-through later in the article.
The rule text that pins these fields down is the 21 CFR § 1304.04 record-maintenance rule, which states that inventories and records of Schedule I and II controlled substances must be maintained separately from all other records of the registrant, while Schedule III, IV, and V records may be maintained either separately or in a form that is readily retrievable from the registrant's ordinary business records. Cite once, link once, move on; over-citing the regulation in the body of the log adds clutter without authority.
Two practical formatting choices make the difference between a spreadsheet that survives inspection and one that creates more problems than it solves. First, one row per distinct invoice line, no exceptions. Where the same NDC appears twice on the same invoice with two lot numbers, that is two rows. Where one invoice line carries multiple lots in a single shipment, that is one row per lot. Collapsing multiple lots into a single row breaks the daily-use log's lot-level decrementing and breaks the recall traceability the next outbreak will demand. Second, a static, dated reference to the source PDF in each row — filename plus invoice number plus page. An inspector pulling the log and asking for source should receive the PDF in under a minute.
What this row set deliberately does not yet carry: running balance, dispensation, on-hand quantity. Those are functions of the daily-use log at the cabinet, fed by this receiving log but maintained separately. And the row set does not yet reflect the structural decision that comes next — Schedule II on its own sheet, Schedule III–V on a parallel sheet, because the federal rule treats them differently and the workbook layout has to follow.
Schedule II Separately Maintained, as a Structural Decision
The federal rule splits the workbook before you write the first row. Under 1304.04(f)(1), records of Schedule I and II controlled substances must be maintained separately from all other records of the registrant. Under 1304.04(f)(2), records of Schedule III, IV, and V controlled substances must be maintained either separately or in such form that the information is readily retrievable from the registrant's ordinary business records. That is the federal floor, and it shapes the layout of your workbook, not just a flag inside it.
"Readily retrievable" sounds permissive on paper, but in the room with an inspector it is rarely the easier path. The inspector asks for every Schedule IV ketamine receipt since the last biennial inventory. A separate Schedule III–V tab returns the answer with a filter on NDC. A combined operational system returns the answer only if someone has built and tested the PIMS query in advance, and even then the inspector is now waiting for a tech to run a report rather than reading the log. For solo and small-group practices, the keep-them-separate approach is the lower-risk default. Practices with a PIMS that genuinely surfaces Schedule III–V receipts on demand can rely on 1304.04(f)(2); most do not.
The structural choice that follows is a single Excel workbook with the following tabs:
- Schedule II receipts, with the CSOS order number column populated for every row.
- Schedule III–V receipts, with the CSOS column absent or unused.
- Biennial inventory snapshots, one row per inventory event.
- DEA Form 41 destruction records, one row per destruction event.
- DEA Form 106 theft and loss reports, one row per filing.
The two receiving tabs share the column set from the previous section; the only field that differs is the Schedule II tab's CSOS / 222 reference column. The inventory, Form 41, and Form 106 tabs are walked further down, in the section that pulls the receiving log into its supporting-record reconciliation.
A common misread, and one worth naming because compliance officers run into it: combining Schedule II and Schedule III–V on a single sheet with a "Schedule" filter column does not satisfy the separately maintained requirement for Schedule II under DEA's interpretation. The records must be physically separable on demand, not just filterable. A filter is a view; the rule asks for a record set. Two tabs in one workbook satisfies the rule because the Schedule II tab is a record set that exists independently of the III–V tab; one combined sheet with a filter does not, because pulling the filter off rejoins the records.
A note on the boundary with the daily-use log, before the next sections take it further. The receiving log is one of two records DEA expects you to maintain. The daily-use log, or dispensing log, lives at the cabinet, gets manual entries from techs at every removal, and decrements per administration. The receiving log feeds the running balance the daily-use log opens with, lot by lot. The two logs are separate records that reference each other; they are not the same document with different views.
Pulling Controlled-Drug Lines Off Patterson Vet, Covetrus, and Henry Schein Invoices
The PDFs carry the data; the log row is its regulated representation. Each wholesaler's invoice has its own layout conventions, and a practice that buys from all three quickly learns which fields sit where on which form. The extraction step is the same job each time: pull the controlled-drug lines off the PDF and write them into the receiving log with the column set from section 2 intact. Whether you do that by hand, with a spreadsheet helper, or with AI-powered veterinary invoice data extraction that lifts NDC, lot, expiration, quantity, supplier, and CSOS reference off the PDF into a structured row, the destination row set does not change — the wholesaler PDF is the source of record, the spreadsheet log is the regulated representation, and every row carries a reference back to the source page so the inspector can pull the original on demand.
Patterson Veterinary. Orders flow through Patterson Connect; PDF invoices arrive both as email attachments and inside the portal. Controlled-substance lines on a Patterson invoice are flagged with a schedule indicator in the description column, and the NDC sits adjacent to the product description on the same line. Lot number and expiration are sometimes on the invoice line itself and sometimes only on the packing list that ships with the order, depending on the product category — for some injectables you will need to pull from both documents to populate a single Patterson Vet controlled substance invoice row in the log. The CSOS order number, when the order was placed electronically, appears in the invoice header alongside the Patterson invoice number, and copies into the Schedule II tab's CSOS column.
Covetrus, post-MWI consolidation. Covetrus closed its $1.25 billion acquisition of MWI Animal Health from Cencora in late 2024, and MWI now operates inside Covetrus. The practical reality for the Covetrus controlled drug invoice receiving log is that shipments and invoices during the transition continue to carry MWI Animal Health branding in some markets and full Covetrus branding in others; some invoices read "Covetrus North America, Inc. (formerly MWI Animal Health)" in the header during the conversion period. The "name and address of person or firm from whom received" column captures the legal entity printed on the invoice you actually received, not the parent brand you would prefer to standardize on. Do not retroactively re-label MWI receipts as Covetrus in your historical log; the inspector compares the row to the source PDF, and a mismatch creates a question you do not need. Orders flow through covetrus.com; CSOS is supported for Schedule II; invoice layout puts NDC, lot, and expiration on the same line as the product description for most controlled-drug entries.
Henry Schein Animal Health. Orders flow through the Henry Schein Animal Health Pro portal; CSOS is supported for Schedule II. The invoice layout is the most predictable of the three for the Henry Schein Animal Health controlled substance log workflow: controlled-substance lines are grouped together at the top of the invoice under a controlled-drug header, the NDC sits on its own under the product description, and lot and expiration sit in a dedicated columnar zone to the right. The header zone also carries the CSOS order number for the Schedule II portion of the order.
The per-row discipline from section 2 applies across all three wholesalers: one log row per distinct invoice line, even when the same NDC repeats with different lot numbers or different ship dates on the same invoice. A consolidated Patterson Vet invoice that ships across two days with two lot numbers for the same butorphanol NDC is two rows, not one. A Covetrus invoice with one ketamine line at lot A and a second ketamine line at lot B is two rows, not one merged row with a comma-separated lot field. The lot-level discipline keeps the recall response fast and the daily-use log's per-lot ledger aligned.
One bookkeeper-bridge note worth making once. The same Patterson, Covetrus, and Henry Schein invoices that populate the controlled-substance receiving log also feed your practice's accounts-payable workflow, where the line items get categorized against the AAHA/VMG Chart of Accounts categorisation for the same wholesaler invoices under Pharmacy COGS for the GL. The bookkeeping side is a parallel record, not a substitute for the regulated log. Your bookkeeper categorizes; your receiving signer logs; the two workflows touch the same PDF but produce different downstream artifacts.
CSOS, the Electronic 222, and Linking Three Records
The Controlled Substance Ordering System is the DEA-administered electronic ordering channel for Schedule I and II controlled substances, in production since 2008 as an alternative to the paper triplicate DEA Form 222. All three major US veterinary wholesalers — Patterson Vet, Covetrus, and Henry Schein Animal Health — support CSOS ordering, and for new registrants the practical default is electronic. The paper 222 has not disappeared, and if your practice still has archived triplicates from the pre-2008 era they remain part of the historical record, but new Schedule II orders are placed against a CSOS digital certificate.
A CSOS Schedule II receipt produces three records that an inspector reads as a set. The CSOS schedule II receipt log veterinary practices maintain has to point at all three.
- The CSOS order PDF. Generated when the registrant places the order and signs it with their CSOS digital certificate. The signed order PDF is archived by the practice — typically in a CSOS folder organized by year. The CSOS order number is the primary key.
- The wholesaler invoice. Generated when the order ships. The invoice header carries the CSOS order number, which links back to the order PDF and forward to the log row.
- The receiving-log entry. Populated when the shipment arrives and the receiving signer counts the contents. The row carries the CSOS order number in the Schedule II tab's dedicated CSOS column, plus the wholesaler invoice number and a reference to the source PDF.
The cross-reference is what an inspector follows. The log row points back to the wholesaler invoice (filename, invoice number, line) and forward to the CSOS order PDF (order number). An inspector spot-checking a Schedule II receipt pulls the log row, then the invoice, then the CSOS order in succession. The trio reconciles or the registrant has an exposed gap to explain.
For practices that still hold paper Form 222 triplicates in their archived records, the same column position in the Schedule II tab takes the 222 serial number rather than the CSOS order number. The two-year federal retention rule applies (some states require longer); the paper 222 lives in the binder, the row references the binder tab, and the chain of records reads the same way. Mixing the two within a single tab is fine — older rows reference 222 serials, newer rows reference CSOS order numbers — as long as the column is populated for every Schedule II row.
One detail catches new registrants and registrant transitions, worth naming explicitly. The CSOS digital certificate is tied to the individual DEA registrant, not to the practice. When the registrant of record changes — a new DVM-owner takes over a practice, a previous registrant retires — the new registrant has to obtain their own CSOS certificate from DEA before any Schedule II ordering can resume. There is no automatic transfer. Practices in transition that miss this step end up with a Schedule II ordering blackout that lasts until the new certificate clears, and the daily-use log decrementing against existing stock with no way to reorder is a problem worth avoiding by starting the new-registrant CSOS application well before the handover date.
Multi-Pack Receipts, Per-Vial Accounting, and the Daily-Use Log Handoff
The mismatch most practices stumble on is between the invoice line and the daily-use log. The invoice line is the unit of sale — a case of 25 vials, a box of 100 tablets. The daily-use log is the unit of issue — one vial drawn from, one tablet dispensed. The receiving log sits between them and has to carry both.
The operational principle is straightforward. The receiving log captures what the wholesaler shipped at the unit of sale, with a per-unit-of-issue quantity in a parallel column for the daily-use log to decrement against. One invoice line becomes one receiving-log row; the per-unit-of-issue column handles the bookkeeping. You write the case down once; the daily-use log knows there are 25 vials to draw from.
A worked example. A Patterson invoice line reads "Buprenorphine 0.3 mg/mL injectable, 1 mL vial, case of 25, lot ABC123, exp 2027-09." The receiving log row reads:
- Quantity received: 1 case (25 × 1 mL vials)
- NDC: as printed on the invoice
- Lot: ABC123
- Expiration: 2027-09
- Per-vial running-add to the daily-use log for that NDC and lot: +25
The +25 is the opening contribution to the daily-use log's running balance for lot ABC123. When a tech draws a vial from the cabinet, the daily-use log decrements that lot by one. The receiving log does not get touched again; the receipt is final the moment the row was written.
The variant worth flagging because it actually happens: a case-with-multiple-lots. A high-velocity controlled substance occasionally ships in a case that combines vials from two different lots — the wholesaler's warehouse pulled from two open totes to fill the order. Treat each lot as its own receiving-log row, because the daily-use log decrements against a specific lot, not against the case. One row for the ten vials at lot ABC123, one row for the fifteen vials at lot ABC124. Two opening contributions to the daily-use log, both visible to the next recall response that asks which lot went to which patient.
The bridge to the daily-use log stops here in this article. The dispensing log at the cabinet is the second of the two records DEA expects from your practice: receipts on the receiving log this article walks, dispensations on the daily-use log your techs maintain. The receiving log's per-vial opening flows into each lot's dispensing-log ledger, and the dispensing log decrements per administration. The mechanics of the cabinet log — who signs at each draw, how partial doses get accounted for, how the lot-level running balance gets reconciled to the physical count at end of shift — belong to a separate workflow that this piece does not cover.
The technical reality of the multi-pack vial controlled drug log veterinary extraction is that the case-to-per-vial expansion is the kind of derivation hand-extraction misses regularly. The multipack quantity, the vials-per-case, the per-vial unit volume, and the per-lot split if the case combines lots all have to come out of the PDF together to produce a defensible row set. Readers curious about the underlying mechanics of pulling tabular line data out of supplier PDFs can look at Python PDF table extraction libraries for invoice line items for the technical background; the structured-extraction tooling end of the workflow — a prompt that says "extract NDC, lot, expiration, case quantity, vials per case, and per-vial volume; one row per lot received" applied consistently across a month of Patterson and Covetrus invoices — produces the same row structure each time.
Receipt Discrepancies: Short-Shipped, Broken, Mis-Pick, Refused
The receiving log captures what physically arrived in your practice's possession, not what the wholesaler invoice claims was shipped. Every discrepancy between the invoice line and the physical receipt becomes its own documented entry, referenced to the wholesaler's adjustment record. This is the controlled drug invoice reconciliation veterinary workflow inspectors look at most closely, because the physical and paper trails are momentarily out of sync and one of them tends to get neglected. The typical DEA inspection veterinary recordkeeping sequence — receiving log first, then the wholesaler invoices the log claims to reconcile against, then the daily-use log, then the most recent biennial inventory snapshot, then the Form 41 destructions and any Form 106 filings — runs straight through this seam. Discrepancies are where the cross-document reconciliation gets stress-tested, and the 96% inspection-failure pattern this article opened with lives in this section more than any other.
The four common discrepancy types and the log-side treatment for each:
Short-shipped. The quantity received is less than the invoiced quantity. The log row records the actual quantity received, plus a discrepancy note in the row's notes column referencing the wholesaler's credit memo — for example, "short 5 vials, Patterson credit memo PT-12345 dated 2026-03-12." Do not record the invoiced quantity in the receiving log and "fix it later"; the log captures the receipt as it happened, with the discrepancy noted, and the wholesaler-side credit memo closes the financial side separately.
Broken in transit. A vial arrived broken or compromised. The log row records the quantity actually receivable — the intact vials — plus a discrepancy note with the wholesaler claim reference. The broken vial itself is destroyed per the practice's documented destruction protocol, with the destruction recorded separately on a DEA Form 41 destruction record (walked in the next section). The broken vial never enters the daily-use log running balance, because it never enters the cabinet. Note in the receiving-log row that a DEA Form 41 entry was created on the same date for the destruction event, so the cross-reference is visible without an inspector having to pull the Form 41 tab to discover it.
Mis-pick. The wholesaler shipped the wrong NDC or the wrong strength. The log row treats the actual product received as a separate receipt — its own NDC, lot number, expiration, and quantity — with a discrepancy note explaining that the line was a substitution for the originally-ordered product. The originally-ordered product remains an open order item against the wholesaler. The mis-picked stock either stays in the cabinet (if the practice can use it) or returns to the wholesaler through their reverse-logistics process; if it returns, retain the return manifest with the receiving log's supporting documentation, and add a closing notation on the row when the credit memo arrives.
Refused at receipt. The package was refused at the door — damaged outer carton, suspected tamper, courier mishandling, missing chain-of-custody paperwork. No receiving-log entry is generated for refused shipments, because the practice never took possession. The refusal is recorded separately in the practice's refused-shipment record with the courier waybill, the reason for refusal, and the wholesaler's acknowledgement of the refusal. Some practices keep this as a dedicated tab in the same workbook; some keep it in the AP file. Either works, as long as a refused shipment can be reconciled against a wholesaler invoice that was generated for an order the practice never accepted.
The defensible position under inspection is a discrepancy entry written the same day the discrepancy is discovered, a credit memo or claim reference attached within the wholesaler's standard turnaround (typically a week or two), and a closed audit trail before the next biennial inventory event. Discrepancies that sit open across a biennial inventory boundary turn into unreconciled inventory variances, which is the conversation with an inspector that no practice wants to have.
Biennial Inventory, and the Supporting Records: Forms 41 and 106
The receiving log is one of four records that together form the practice's controlled-substance file under DEA inspection. The biennial inventory pulls the receiving log into its reconciliation arithmetic. The DEA Form 41 destruction record explains every controlled-substance unit taken out of inventory that was not dispensed to a patient. The DEA Form 106 theft and loss report covers diversion and significant loss. The receiving log feeds all three.
Biennial inventory. Every DEA registrant must conduct a complete inventory of all controlled substances on hand at least every two years — the federal floor, with some states requiring annual. The inventory is a dated snapshot recorded as its own document. The reconciliation arithmetic is the same in every direction:
Opening inventory + sum of receiving-log entries since the last inventory − sum of daily-use-log dispensations − destructions − losses = on-hand count on the inventory date.
The receiving log is the additions-side source. An inventory that does not reconcile points the practice at one of three things: a missing receiving-log entry that was never written down, a missing dispensation entry the daily-use log never captured, or an undocumented loss that has to be investigated and (depending on what is found) reported. The biennial inventory controlled substances veterinary practices conduct is the moment all four records have to agree.
The inventory snapshot belongs on its own tab in the workbook, with one row per inventory event, capturing the date, the licensed person who conducted it, the totals on hand by NDC and lot, and a notation of any variances. Variances should be reconciled or explained before the snapshot is closed; an open variance carried across two inventory cycles is the kind of finding that compounds.
DEA Form 41 destruction record. Form 41 is the record DEA requires for destruction of controlled substances by a registrant. The DEA Form 41 destruction record veterinary practices keep covers expired stock pulled from the cabinet, vials broken in transit (as noted in the previous section), partial doses drawn for a patient but not administered, and client-returned medications taken back into the practice's possession. The form captures the substance, the form and strength, the quantity, the method of destruction, and the witnesses. Method of destruction is typically either transfer to a reverse distributor — a DEA-registered destruction agent who handles bulk destruction and provides documentation back to the practice — or witnessed in-house destruction per state rule. Form 41 records are retained for two years under the federal rule. Every Form 41 entry pairs with a corresponding decrement on the receiving log's running balance for the destroyed NDC and lot, so the next biennial inventory reconciles cleanly.
DEA Form 106 theft or loss report. Form 106 is filed with DEA upon discovery of a theft or significant loss of controlled substances. The DEA Form 106 theft loss veterinary registrants file covers events like a break-in or armed robbery, employee diversion (the most common cause cited in DEA enforcement actions against veterinary practices), and transit losses that fall outside the standard wholesaler discrepancy reconciliation. The form is filed within one business day of discovery — the regulation language is "immediately upon discovery" with formal filing via the online portal at the next opportunity — and a copy is retained in the practice's records. The loss is reflected in both the receiving-log records (as a running-balance decrement with a Form 106 reference in the notes) and the next biennial inventory.
The four records sit together for a reason. Each one references the others, and an inspector reading any one of them can follow the cross-references into the rest. The receiving log this article walks is the additions side of that system; the other three are how the additions get reconciled, decremented, accounted for, and explained.
State-Board Overlays: California, Texas, Florida, New York, Pennsylvania
Federal 21 CFR 1304.04 is the floor. State veterinary medical boards layer their own requirements on top in their jurisdictions, and some of those additions materially change the log shape. This is not a 50-state primer, and it does not substitute for advice from your state VMA, your state board, or a veterinary compliance attorney on case-specific questions. What it does is name the commonly-encountered overlays in five high-population states and point you at the state-board pages for the substance.
California. The California Veterinary Medical Board (CVMB) maintains its own published controlled-substance log format and expects the receiving-log column structure to align with it. Controlled-substance recordkeeping is reviewed during routine CVMB inspections, not only on cause. California also schedules some substances differently from the federal schedule — gabapentin shifted to state-controlled status in several jurisdictions over recent years, with California among the states that have moved on it — so a California practice's log structure has to accommodate state-schedule entries that the federal CFR does not list. Confirm the current CVMB log format against the board's published guidance before committing to a workbook layout.
Texas. The Texas State Board of Veterinary Medical Examiners (TBVME) carries its own controlled-substance log expectations, layered on the federal floor under the Texas Veterinary Licensing Act and TBVME's DEA-coordinated inspection authority. Bound-book recordkeeping has historically been the TBVME preference, and many Texas practices still maintain a serial-numbered bound book for the daily-use log even where the receiving log lives in a spreadsheet. Spreadsheet records that mirror the federal column set are accepted where the practice can produce them on demand; the operative phrase is "readily retrievable on inspection," which a well-organized workbook with a printed packing-slip binder satisfies.
Florida. The Florida Board of Veterinary Medicine (FBVM) operates joint-inspection authority with state law enforcement under Florida Statutes Chapter 893, the Florida Comprehensive Drug Abuse Prevention and Control Act. In a Florida inspection, the receiving log is reviewed alongside the daily-use log, and the inspector is as likely to be a state law enforcement officer working from FBVM authority as a DEA Diversion Investigator. The federal column set is the floor; Florida adds documentation expectations around chain of custody and dispensing records that should be confirmed against the current FBVM and Florida Department of Health guidance.
New York. The New York State Office of the Professions oversees veterinary practice. New York maintains its own controlled-substance schedule, which includes substances not on the federal schedule and lists some federally-scheduled substances at different schedules. The practical implication for the receiving log is that the workbook has to accommodate state-schedule entries alongside the federal Schedule II–V tabs — either by listing state-only controlled substances on the III–V tab with a state-schedule notation, or by adding a dedicated state-controlled tab. Check the current New York Public Health Law Article 33 listings to see what your practice's drug formulary intersects with.
Pennsylvania. The Pennsylvania State Board of Veterinary Medicine (PSBVM) layers additional column requirements on the federal receiving-log set under certain conditions, and Pennsylvania prescription monitoring program requirements connect to the dispensing log on the daily-use side. Confirm current PSBVM expectations against the board's published guidance, particularly for practices that prescribe extended-release Schedule II analgesics or that dispense controlled substances to clients for take-home administration.
Outside the US entirely, the parallel workflow for human community pharmacy in the UK is structured differently again — Schedule 2 and 3 wholesaler invoice lines reconcile to the statutory CD register rather than to a DEA-style receiving log, with running balances kept per preparation and inspection evidence assembled accordingly; see reconciling Schedule 2 and 3 wholesaler invoice lines to the UK pharmacy CD register for the UK-side mechanics. Multi-location veterinary groups — Mars Veterinary Health, NVA, VetCor, Pathway Vet Alliance, and others — handle the state-overlay problem by standardizing on a single receiving-log shape that satisfies the strictest of their footprint's states, rather than maintaining a per-state shape that varies hospital by hospital. The standardized shape is typically richer than any single state requires, which is the cost of group standardization, but it produces one training program, one audit pattern, and one inspection-readiness posture across the group. Groups working through this kind of cross-state standardization often pair it with parallel work on multi-location AP standardisation for groups consolidating compliance records, since the same wholesaler invoices feed both the compliance log and the AP system, and standardizing the source-document handling once pays back across both workflows.
Spreadsheet Template Versus Purpose-Built Systems
The right answer depends on volume, not vendor preference. A controlled substance log Excel template veterinary practices build to the column set this article walks works well for the solo practice, the mobile veterinarian, the equine ambulatory practice, the low-controlled-substance-volume small-animal hospital, and any practice operating in tight-budget mode. Excel handles the receiving-log row set comfortably, the daily-use log can run on a parallel sheet or in a serial-numbered bound book at the cabinet, and the reconciliation work at biennial inventory is manageable when the controlled-drug velocity is modest.
As volume rises, the spreadsheet model strains. Multi-doctor hospitals running heavy surgical schedules, emergency and specialty hospitals on a 24-hour cabinet rotation, and large mixed-animal practices with multiple controlled-drug cabinets across the building hit a point where the manual reconciliation burden between receiving log, daily-use log, biennial inventory, and Form 41 destructions becomes the failure point itself. The reconciliation is doable, but a single missed entry across hundreds of monthly cabinet draws compounds into the kind of variance that surfaces at biennial inventory and never gets cleanly resolved. At that volume, a purpose-built controlled-substance management system that integrates the receiving side with automated daily-use tracking earns its subscription cost — Cubex's automated dispensing cabinet model, VetSnap's cloud logging, ScriptSure, Bayshore SafeScript Pro, and others in the category exist precisely because the spreadsheet model has a ceiling.
The operational threshold worth naming, without pretending there is a single hard rule: practices receiving more than a handful of controlled-substance shipments per month, running multiple controlled-drug cabinets across the building, or operating with three or more veterinarians actively prescribing controlled substances tend to find that the reconciliation overhead exceeds the cost of a purpose-built system. Practices below that profile tend to find the spreadsheet workflow cleaner, more transparent, and more defensible than a system they would not fully use. The choice is not a referendum on the vendors; it is a read on the practice's own controlled-substance velocity and the time the compliance lead has to spend on reconciliation.
The receiving log sits inside a broader US veterinary practice document workflow: the bookkeeper-side categorization of the same wholesaler invoices, the parallel IDEXX and Antech monthly lab statement reconciliation for vet practices the practice manager runs each month, and the multi-location standardization patterns that emerge as groups grow. The wholesaler PDFs are the source for several downstream artifacts; the practice that handles them well handles all of them well.
Extract invoice data to Excel with natural language prompts
Upload your invoices, describe what you need in plain language, and download clean, structured spreadsheets. No templates, no complex configuration.
Related Articles
Explore adjacent guides and reference articles on this topic.
Vet Wholesaler Invoices: AAHA Chart of Accounts to QuickBooks
Walk Patterson and Covetrus invoices across the AAHA/VMG Chart of Accounts and post a clean category-split bill to QuickBooks Online or Desktop.
Extract IDEXX and Antech Lab Statements to Excel
Extract IDEXX and Antech lab statements to Excel for veterinary missed-charge review, PIMS matching, and clean month-end AP posting.
Extract ADT & Securitas Invoices to Excel for Multi-Site AP
Extract ADT, Securitas, and Allied Universal multi-site security invoices to Excel — per-site monitoring, false-alarm fees, and guard hours for GL coding.