Why the Two Systems Drift Apart
Different people maintain these systems for different reasons. Compliance staff log physical events; accounting staff log financial ones. By default, nobody owns the connection between them.
Drift shows up as untracked samples and promotional product, waste that's logged physically but never financially, repackaging that breaks the unit-cost trail, transfer manifests received at the wrong cost, returns entered in only one system, and manual fixes made to clear a compliance flag with no matching journal entry.
- Sampling, R&D and staff product not backed out of inventory
- Waste and destruction with no offsetting financial write-off
- Repackaging or conversion that severs unit-cost history
- Manifest quantities that don't match what was actually received
How We Structure the Reconciliation
We build a period-end rollforward: opening inventory by package or SKU, plus receipts from transfer manifests, minus sales from POS or invoices, minus documented waste and conversion, landing on a computed ending balance we check against both a physical count and the BioTrack figure.
Every gap gets classified rather than papered over: timing, documentation, a costing error, physical loss, or a system error. Timing and documentation items clear on their own. Physical losses are written off with support. Costing errors get fixed at the source so they don't repeat.
Keeping Cost Intact Through Product Transformation
Infusers and craft growers moving flower into extraction face a tougher version of this problem. Once flower becomes extract and extract becomes a finished unit, the tracking tags change, and cost has to follow the material through that change on a defensible basis.
We set the conversion costing rules up front — yield assumptions, joint and by-product allocation, labor and overhead absorption — and apply them the same way every time, so finished goods carry a cost that can be traced line by line.
What This Buys You on Compliance and Audit
IDFPR, IDOA and IDOR all pull from track-and-trace data in some form. Inventory that disappears without explanation invites diversion questions; inventory that appears without explanation invites questions about unreported purchases. Either way, you're stuck responding with data you didn't prepare.
A signed monthly reconciliation changes that entirely, and it directly backs the inventory figure on the return — the single most examined line item on a cannabis filing.
- Signed monthly reconciliation workpapers kept with the tax file
- Variance log with root cause and an owner assigned to fix it
- Physical count procedures with count sheets retained
- A ready-made support package for a regulator or IRS inventory request
Systems We Work Inside
We work with the BioTrack, POS and ERP setups Illinois operators are actually running, and we're upfront about where the integrations break down. Automated syncs handle volume, but they also propagate a costing error at scale, so the control needs to sit on top of the integration, not inside it.
Where an integration can't be trusted, we build a manual import-and-check 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: state track-and-trace quantities in BioTrack, the point-of-sale or inventory subledger, and the general ledger inventory balance. Agreement across all three is the only credible sign that inventory is right. Two out of three is a coincidence.
We run it monthly at package and category level. Variances get classified rather than plugged: receiving errors where a transfer was accepted in one system and not the other, sales voids reversed in POS but not BioTrack, unrecorded waste and destruction, sampling and testing pulls, and genuine shrinkage. Each classification points to a different operational fix, and the classification itself becomes the audit documentation.
For a multi-location dispensary group, we run the reconciliation by license and then consolidate, because a variance that nets to zero across three stores is usually two problems canceling each other out.
- 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 Building the Audit Trail
Track-and-trace discrepancies are a licensing problem before they're an accounting problem. IDFPR and IDOA cite operators for inventory reconciliation failures regularly, and unexplained variance is a common inspection finding. The same records also carry the federal tax burden, since ending inventory determines COGS and COGS is the only relief 280E allows.
A Metro East craft grower we work with had a persistent 2 percent variance traced back to transporting organization pickups accepted at the dock but logged 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 flag and the costing error disappeared.
Every reconciliation is kept with its supporting exports, so a state inspection or an IRS information request gets answered from an existing file instead of a scramble.
