Why Florida BioTrack Reconciliation Is a Four-Way Problem

In most cannabis markets, inventory reconciliation is a two-way comparison: the point-of-sale system against the state track-and-trace layer. Florida is different. A licensed Medical Marijuana Treatment Center is vertically integrated, so it cultivates, processes, transports, and dispenses, and the state's controls reach into all of it. That makes reconciliation a four-way check.

Those four surfaces, and how they relate, are the foundation every other Florida control sits on. If you treat it as a two-way problem, the gaps tend to open right where the regulatory risk is worst.

The four surfaces

An MMTC package exists, simultaneously, in four systems that can each be right or wrong independently:

• The internal STS / POS. The MMTC's own seed-to-sale or point-of-sale system, where staff actually do the work, receiving, converting, packing, selling.
• The BioTrack state layer. The Department's traceability system, which Florida law requires to trace product from seed to sale and provide regulators real-time, 24-hour access.
• The MMUR. The Medical Marijuana Use Registry, the patient-side ledger that records what was dispensed and tracks each patient's remaining allotment.
• Physical inventory. The actual product on hand in the cultivation rooms, processing area, vault, and retail floor.

The state tracking system is required to capture far more than sales. By statute it records when product is planted, harvested, destroyed, transported, sold, stolen, diverted, or lost. So adjustments, waste, and lost-product events are regulator-visible in Florida rather than internal bookkeeping, and a reconciliation that only looks at the dispensary counter is missing most of what the state sees.

The one key that ties them together

You can only reconcile four surfaces if they share a join key. Teams often reach for the SKU, but that is only a catalog mapping, and the MMUR route is a clinical and allotment key. The key that actually works is the state traceability identifier, the package or lot number.

Florida BioTrack integrations consistently describe a unique 16-digit identifier: a lot number in BioTrack, surfaced as a Package ID in the POS. It is the strongest join across all four surfaces because it survives the places where SKU and route break down.

Join on:   state package / lot ID  (the 16-digit identifier)
Not on:    SKU            (catalog mapping only)
Not on:    MMUR route     (clinical / allotment only)

The same product can live in several packages, and only the package-level key preserves traceability. A workbook that starts from SKU matching instead of package matching will miss the failures that matter most here.

Two kinds of event hide inside one transaction

In Florida a single retail action can be two regulated events at once. A dispensation is an inventory event, since it decrements a package, and it is also a patient-allotment event. Under OMMU's data requirements, a dispensation recorded in the internal STS is transmitted in real time, and when the Department system receives it, it updates the MMUR to reflect that dispensation against the patient's supply limit.

This is where corrections get subtle. Refunds and voids do not behave the same way:

Because of that split, staff have to classify every retail correction before making it: is this an inventory correction, a patient-allotment correction, or both? Picking refund when the situation called for a void, or the reverse, leaves one of the four surfaces wrong.

What this means in practice

A few practical consequences follow, and the rest of a Florida control program builds on them:

• Reconciliation has to cover cultivation, processing, internal transfers, retail, and delivery, not just the counter.
• The package or lot ID is the master join key for every comparison; SKU and route are secondary tests.
• Every correction is triaged as inventory, allotment, or both, with void and refund chosen deliberately.
• Adjustments, waste, and loss are treated as regulator-visible events with evidence retained, not quiet internal edits.

Summary

Florida inventory control is a four-way reconciliation problem: the internal STS, the BioTrack state layer, the MMUR, and the physical count, joined on the state package identifier and split by whether an event touches inventory, patient allotment, or both. The later controls, whether the discrepancy library, the workbook, or the SOPs, are all ways of keeping those four surfaces aligned.