BioTrack · Part 5 of 8 · 2 min read

Building a Florida BioTrack Reconciliation Workbook

On this page
  1. Keep raw records intact
  2. Use the right identifiers
  3. Build the exception queue
  4. Check route and quantity separately
  5. Retain the audit trail
  6. Sources

Build the workbook around the specific inventory record, then check the product type, the location, the movements (sales, transfers, adjustments), and the patient's limit on the order, in separate columns. Do not use the product ID as if it identified one package: Florida's rules define it for a product type.

Keep raw records intact

Store the original exports from your internal seed-to-sale system (STS), the Department's STS (the state's seed-to-sale system), POS, manifest, and physical-count exports separately, with the date and time you pulled each one. Add cleaned-up copies of the fields in a working sheet; do not change the source values to make the records match up.

Use the right identifiers

  • Department inventory ID: use it to find one specific package or inventory record in the Department's records.
  • Unique product ID: use it to match each SKU to its product type. Rule 64-4.221 allows a unique SKU to serve as this ID.
  • Patient/order and route: keep these on the dispensation record, not on the package record.
  • Manifest/event IDs: connect transfers and transaction history to the inventory record.

Build the exception queue

Include the compared values, source IDs, facility/room, unit, event time, discrepancy type, owner, and what was done about it. Flag missing or duplicate identifiers and unit mismatches. A match in the workbook is only a reason to look. It does not mean you change the record in the state system or in the patient file.

Check route and quantity separately

For each dispensation, check the recorded route (how the patient takes the product) and THC amount against the current order, and against what the patient already got in the applicable rolling window (the period over which the rule totals a patient's supply). For usable whole flower recorded in ounces, Rule 64-4.222 specifies that the Department STS converts to grams using 1 g = 0.0353 oz; use that rule-specific factor when matching the Department's converted value.

Retain the audit trail

Rule 64-4.222 requires an MMTC to retain data recorded in its internal STS for three years and provide the Department the native data in CSV within 48 hours of a request. Keep each workbook row tied to the source record it came from, including the internal STS record, and keep a note on every exception you reviewed.

Sources

Let’s work together

Untangling a Florida reconciliation?

STS, the state layer, the MMUR, and the vault, reconciled as one routine.