BioTrack Reconciliation for Illinois Cannabis Businesses

BioTrack reconciliation is an accounting engagement, not a compliance filing service. Our job is to take the inventory data your operation already produces and turn it into financial records that can be relied on: an inventory balance that ties to something, a cost of goods sold figure supported by movement rather than by a plug, and a variance file that explains the difference between what a system says and what is actually on the shelf.

Most operators do not have a single inventory problem. They have several systems that were each built for a different reader. The regulated tracking system exists to record regulated activity. The point-of-sale exists to sell product and manage the sales floor. The purchasing records exist to pay vendors. The general ledger exists to produce financial statements and support the tax return. None of them was designed to agree with the others automatically, and nobody inside a busy license owns the space between them.

The goal of the engagement is not to force every system to display the same number. That framing is what produces bad accounting — someone changes a quantity or posts an adjustment simply to make two reports match, and the underlying cause survives into the next period. The goal is to understand and document why differences exist, then determine which of them require an operational correction, which require an accounting entry, and which are simply timing that will clear on its own.

We work on a recurring basis for operators who want inventory reconciled as part of every close, and on a project basis for operators who need historical differences investigated before a tax filing, a financing event, a system change or an ownership transaction.

Every operator we have worked with produces differences. That by itself is not evidence of a problem; it is evidence that several systems record overlapping events at different moments, at different levels of detail, for different purposes. What matters is whether the differences can be explained and whether the explanations are documented.

Timing accounts for a large share of what looks alarming at first glance. A transfer recorded in one system on the last day of the period and received into another on the first day of the next will show as a gap until the cutoff is understood. A count taken mid-morning while the sales floor is trading will never match a report pulled at midnight. Nothing is wrong in either case, but somebody has to write down why.

Data quality accounts for another large share. Product received into the operational system under a different unit of measure than it was purchased in, a receipt entered twice on a busy day, a vendor credit never recorded against the original invoice, a conversion or repackaging event captured in one place but not another, a return processed at the register but never reversed in inventory — each of these creates a difference that no amount of adjusting entries can legitimately close until the source record is corrected.

The remainder is genuine: physical loss, damage, unrecorded waste, or errors in a prior period that were never resolved and are now embedded in the opening balance. Those are real accounting events and they deserve real entries with real support.

What we will not do is tell you to make the accounting system match the tracking system. Adjusting a ledger to agree with an unverified report is not reconciliation; it moves the error rather than resolving it, and it destroys the trail a future examiner, buyer or lender will ask you to walk.

A dispensary generates inventory events faster than any other license type, in small units, across many SKUs, with staff turnover at the exact points where accuracy matters. Product arrives and is received. It is entered into the operational system and made available. It sells, sometimes with discounts, loyalty redemptions, returns or voids attached. It is occasionally transferred, destroyed, damaged or written down. Every one of those events has both a quantity consequence and a dollar consequence, and they are frequently recorded by different people in different systems on different days.

We rebuild that flow: PURCHASE → RECEIVING → INVENTORY → SALE OR ADJUSTMENT → ENDING INVENTORY → COST OF GOODS SOLD. Receiving is compared to vendor invoices and purchase records. Sales are compared between the register and the inventory relief. Adjustments and waste are pulled and reviewed for support. The expected ending position is compared to the count and to the operational report, and the remaining difference is investigated by category and by product rather than in total.

One of the most common financial errors we correct in retail is an inventory balance derived from what was paid to vendors. Payments and inventory are not the same thing. Vendor terms, unpaid invoices, credits, returns, deposits and consignment-style arrangements all break the link between cash out the door and product on the shelf. Inventory belongs on the balance sheet based on what was received and what remains, with accounts payable carrying the obligation separately.

We also look at discounting and loyalty from an accounting angle, because heavy promotional activity changes reported margin without changing unit movement, and it will distort any variance analysis performed on dollars alone.

The basic shape is RAW OR INPUT INVENTORY → PROCESSING → OUTPUT AND FINISHED PRODUCT. Flower or biomass enters, extraction or infusion happens, and what emerges is measured differently, packaged differently and valued differently. Some material is consumed, some is lost to the process, some becomes byproduct with its own value, and some remains as input for the next run. None of that is shrink, but it will look like shrink to anyone comparing an opening number to a closing number.

We reconcile at the batch or run level wherever the records allow it, because yield only means something in context. Inputs consumed, outputs produced, byproduct captured, waste recorded and packaging applied are compared for the run, and yield is reviewed against the operator's own history for similar material rather than against an outside benchmark we cannot support.

Testing holds, quarantine and release create timing effects worth calling out. Product physically present but not yet released is still inventory; product released late crosses a period boundary. Both routinely explain differences that would otherwise be written off.

On the cost side, conversion is where cost accounting is either done deliberately or done accidentally. Input cost, conversion labor, applicable overhead, packaging and hardware all have to attach to output on a consistent, documented basis, including how joint products and byproducts are treated. Finished goods should carry a cost you can trace back through the run.

Physical counting is the part of inventory work most often skipped and most often decisive. Two systems agreeing with each other proves only that they were fed the same information; both can be equally wrong. When a count is taken properly, it becomes the anchor the rest of the reconciliation is measured against.

A count that is useful for accounting purposes records the date and time, the location, the product or SKU, the quantity, and the unit of measure — and it identifies who counted. Counts taken while the operation is trading need a documented cutoff. Areas holding product that is not available for sale need to be included and labeled, not ignored.

Differences found at count get recounted before anything is posted. A recount resolves a meaningful share of apparent variances outright, and it prevents the most avoidable error in inventory accounting, which is writing off product that was simply on a different shelf.

Remaining differences are documented, classified by likely cause, and turned into an adjustment only when the support exists. Book inventory does not equal physical inventory automatically, and pretending otherwise at period end is how prior-period errors are born.

Transfers are where inventory most reliably goes missing on paper. The sending location records the departure, the receiving location records the arrival, and those two events happen at different moments, are entered by different people, and are frequently reconciled by nobody. If one side is recorded and the other is not, one location is understated and the other is overstated by the same amount, and a consolidated report will show nothing at all.

We match transfers at both ends: quantity, product, date and cost. Items in transit at period end are identified and treated as such rather than left in limbo. Unmatched items are investigated at both the sending and the receiving location, because the missing record is as likely to be on one side as the other.

Cost has to travel with the product. When a transfer moves at a different value than the sending location carried, the difference has to land somewhere deliberate. Where transfers cross legal entities, intercompany balances and eliminations need to be maintained so consolidated inventory and margin are not distorted by internal movement.

We reconcile the accounting effect of transfers. Regulatory manifesting, transport and reporting obligations are operational and compliance matters that sit with your team and your counsel.

The relationship is mechanical: beginning inventory, plus purchases or production costs, less ending inventory, equals cost of goods sold. Nothing in that equation validates itself. If ending inventory is overstated, cost of goods sold is understated and margin looks better than it is. If ending inventory is understated, the reverse happens and the business looks unprofitable in a period where it was not.

That is why we treat inventory reconciliation as a financial reporting function rather than a warehouse function. Management reporting, product and category margin analysis, pricing decisions, lender and investor reporting, valuation work and tax preparation all consume the same ending inventory figure. One unreconciled balance propagates into all of them.

Reconciliation also gives cost of goods sold something to stand on. A COGS figure produced by a system export is an assertion. A COGS figure produced by a rollforward with a physical count, receiving support, transfer matching and documented adjustments behind it is a supported number, and support is what matters when someone outside the business asks how it was derived.

Where Section 280E applies, inventory and cost accounting carry additional weight, which we address in the next section rather than here.

Reconciliation done as part of the close is a maintenance task. Reconciliation done once a year is an archaeology project. The difference in cost and reliability is large, because source records get harder to retrieve, staff who remember the event have moved on, and the differences compound into an opening balance that nobody can defend.

Inside a close, the inventory work connects to everything else on the balance sheet: the inventory general ledger accounts, accounts payable and vendor credits, purchases, revenue and cost of goods sold, adjustments and accruals, and the period cutoff that keeps them all in the same window. That is bookkeeping work, and it is why the two services sit next to each other.

For operators who keep bookkeeping in-house, we frequently take the inventory reconciliation piece only and hand back schedules and proposed entries for the internal team to post. For operators who want the whole close handled, our bookkeeping engagement includes the reconciliation as a standing step rather than an add-on.

This is the single most common structural failure we see at scale. Total inventory ties within a tolerable margin, everyone relaxes, and underneath it Location A is overstated while Location B is understated by a similar amount — usually because of unmatched transfers, a receiving error at one site, or an adjustment posted at the wrong location. Consolidation hides the offset perfectly.

Reconciliation therefore has to retain location-level visibility from the start. Inventory by location, purchases by location, adjustments by location, counts by location and store-level general ledger inventory are reconciled individually before anything is rolled up. Consolidation is the last step, not the working level.

Multi-location work also raises consistency questions that single-site operators never face. Are products set up identically across sites? Are units of measure the same? Are adjustments approved to the same standard? Is a count at one store taken with the same rigor as at another? Differences in process show up as differences in inventory, and they are worth fixing once rather than reconciling forever.

Where locations sit in separate legal entities, intercompany activity and eliminations get maintained alongside the operational reconciliation so consolidated inventory and margin reflect real external activity.

None of these are exotic. They are the predictable result of several systems being maintained by different people under time pressure, with no one assigned to the space between them. Recognizing which one you have is most of the work.

Notice how many of them are accounting problems rather than operational ones. Product posted to expense instead of inventory, missing vendor credits, unreconciled inventory accounts and prior-period errors have nothing to do with what happened on the floor — they happen in the ledger, and they will not be fixed by counting harder.

Frequency is a business decision driven by transaction volume, license type, number of locations, system complexity, the value at risk in inventory and how often the books are closed. A single-site retailer with high unit volume and a monthly close has different needs from a small producer with a handful of large-value lots.

What holds across all of them is that financial inventory should not be left unreconciled for long stretches. Differences that are found close to the event can usually be traced; differences found a year later frequently cannot, and unresolved differences compound into the opening balance of every period that follows.

For businesses closing books monthly, we recommend integrating inventory reconciliation into the month-end close at a level of detail appropriate to the operation — full reconciliation for high-value or high-risk categories, sampling and analytical review elsewhere, with a deeper count-based reconciliation at longer intervals.

This is accounting guidance about financial reporting, not a statement about any legally required counting or reporting frequency. Requirements applicable to your license come from official Illinois sources and your compliance advisors.

Our work with Illinois licensees is built around that requirement. Whatever reports the applicable state system produces for your license type, those reports become one input to a reconciliation that also draws on point-of-sale data, purchasing and receiving records, transfer documentation, physical counts and the general ledger. We design the process around the data your systems actually generate rather than around assumptions about system behavior.

We deliberately avoid publishing specific claims about current state system rules, required data fields, reporting deadlines or agency procedures on this page. Those details change, they differ by license type, and an accounting firm restating them from memory or from an old article is not a source you should rely on. Confirm current requirements with official Illinois sources and your compliance advisors.

What does not change is the accounting discipline. Regardless of which system the state uses or how its reporting evolves, an operator still needs inventory quantities that can be traced, costs that attach to product on a consistent basis, a general ledger inventory balance supported by a count, and workpapers that show how the figures were derived.

Illinois operators also carry state tax and reporting obligations that consume the same underlying records, which is why we keep reconciliation, bookkeeping and tax work connected rather than treating them as separate exercises.