Why Track-and-Trace and Financial Records Drift Apart
The two systems are maintained by different people for different purposes. Compliance staff record physical events; accounting staff record dollar events. Nobody owns the connection between the two by default.
Drift shows up from untracked samples and promotional product, waste that's recorded physically but never financially, repackaging that breaks unit-cost lineage, transfer records accepted at the wrong cost, returns processed in only one system, and manual adjustments made to clear a compliance flag with no corresponding journal entry.
- Sampling, R&D and employee product not costed out of inventory
- Waste and destruction events with no financial write-off
- Repackaging and conversion that breaks unit-cost lineage
- Transfer quantities that don't match receiving quantities
The Reconciliation Framework
We build a period-end rollforward starting with opening inventory by package or SKU, adding receipts from transfer records, subtracting sales per POS or invoices, subtracting documented waste and conversion, and arriving at a computed ending balance compared against both the physical count and the BioTrack balance.
Every difference gets a classification: timing, documentation, costing error, physical loss, or system error. Timing and documentation items get cleared. Physical losses are written off with support. Costing errors are corrected at the source so they don't recur.
Cost Layer Integrity Through Transformation
Manufacturers and distributors face a harder version of this problem. When flower converts to extract and extract into finished units, the state's unique identifiers change and cost has to follow the material through the transformation on a defensible allocation.
We set conversion costing rules up front — yield assumptions, joint and by-product allocation, processing labor and overhead absorption — and apply them consistently so finished goods carry a cost that can be explained line by line.
Compliance Value and Audit Defense
The CCD reviews the same track-and-trace data your accounting system is supposed to mirror. Unexplained inventory shrinkage invites diversion questions; unexplained inventory growth invites questions about unreported purchases. Either way, the operator is answering with data it did not prepare.
A monthly reconciliation with signed workpapers changes that posture entirely, and it directly supports the inventory figure on the tax return — usually the single most scrutinized number on a cannabis filing.
- Signed monthly reconciliation workpapers retained with the tax file
- Variance log with root cause and a remediation owner
- Physical count procedures with retained count sheets
- Support package ready for a regulator or IRS inventory inquiry
Systems and Integrations
We work with the point-of-sale, inventory and ERP platforms New Mexico operators actually run, and we're direct about where integrations break down. Automated syncs handle volume well but propagate costing errors at scale, so the control has to sit on top of the integration, not inside a trust assumption.
Where an integration can't be trusted, we build a structured import and reconciliation process instead — slower, but auditable.
What a Real Three-Way Reconciliation Looks Like
The reconciliation that matters compares three independent records of the same item: BioTrack package quantities, the point-of-sale or inventory subledger, and the general ledger inventory balance. Agreement across all three is the only credible statement that inventory is right. Two out of three is a coincidence.
We run it monthly at package and category level. Variances are classified rather than plugged: receiving errors where a transfer was accepted in one system and not the other, sales voids that reversed in the POS but not in BioTrack, unrecorded waste and destruction, sampling and testing pulls, and genuine shrinkage. Each classification points at a different operational fix, and the classification itself is the audit documentation.
For a multi-location retailer, we run the reconciliation by license and then consolidate, because a variance that nets to nothing across two or three stores is usually two problems hiding each other.
- Package-level quantity comparison across BioTrack, subledger and ledger
- Variance classification with operational root cause, not plug entries
- Documented waste, destruction, sampling and testing adjustments
- Escalation thresholds and a signed monthly reconciliation record
Compliance Consequences and the Audit Trail
Track-and-trace discrepancies are a licensing issue before they're an accounting issue. New Mexico's Cannabis Control Division can and does cite operators for inventory reconciliation failures, and unexplained variance is a common finding in a state inspection. The same records also carry the federal tax burden, because ending inventory determines COGS and COGS is the only relief 280E allows.
One multi-location retailer we've worked alongside had a persistent 2 percent variance that turned out to be transfer packages accepted at the dock but recorded a day later at a different weight after moisture loss. Once the receiving procedure captured weight at acceptance and the accounting policy documented normal moisture variance, both the compliance exception and the costing error disappeared.
Every reconciliation is retained with its supporting exports so that a state inspection or an IRS information document request is answered from an existing file rather than a scramble.
