Cannabis Inventory Reconciliation: Fix Count Mismatches

When your physical count, POS count and state tracking system count do not match, find the cause first. Do not change any number until you know why the counts differ. Cannabis inventory reconciliation means comparing all three counts and correcting the record that is wrong, not the one that is easiest to fix.

What Causes a Variance Between Physical Counts, POS Records and State Tracking Systems

In Illinois, regulators require every licensed cannabis business to track its products in the state's seed-to-sale system, covering cultivation, manufacturing, transport, testing and retail sale. That system covers more than the register count at checkout alone. METRC is the seed-to-sale system named in that Illinois rule.

A cannabis technology platform's FAQ lists Metrc, BioTrack, Leaf Data and other state-mandated seed-to-sale tracking systems among the ones it integrates with.

Several things can create a gap between the physical count, the POS count and the state system count. A sale might post to the state system after a delay, so the two counts briefly disagree. Waste or spoilage that has not yet been logged is another possibility.

Oregon's medical cannabis program guidance states that its tracking system rules require daily reconciliation of marijuana inventory. The same guidance gives waste from repackaging as an example of what to log, so the tracked quantity matches what is left on the shelf. A package transfer recorded late, or a return or damaged item not yet logged, can also leave the three counts out of step.

How to Reconcile a Count Mismatch: A Worksheet and Investigation Steps

A reconciliation worksheet turns three separate counts into one record a manager can review together. The columns below cover what a dispensary or delivery operator tracks for each package under investigation. They are package identifier, physical count, POS or software count, state-tracking-system count, variance, documented cause, reviewer and resolution status. No figures are filled in; the table is a structure to copy, not a worked example.

Start by comparing the POS record against what the state system actually received, not just the number the POS screen shows. Washington's cannabis examiners can give license holders a copy of their reported data and help them understand and correct it. That step confirms whether the transmission went through before anyone assumes it did.

Next, check whether the package's upload reached the state system at all or was rejected along the way. Washington's Cannabis Central Reporting System FAQ directs license holders to review the upload instructions to learn how to correct the original reporting file. A rejected upload can sit unresolved without showing up as an obvious error.

Only recount the physical package once the POS and state records are checked. Oregon's compliance bulletin on Metrc audits addresses package adjustments. It states they are not a compliant way to resolve negative packages unless no other method can fix the issue.

The same bulletin also calls for checking that POS sales transmit correctly to Metrc, including quantities and timestamps.

Compare the three counts using the POS's real-time inventory record, not a count that only updates once a day.

Investigating a Mismatched Package Count

Example scenario: A delivery operator notices that the physical count for a package sits lower than what the POS screen shows. Before changing any number, a manager opens the worksheet. They record the package identifier, the physical count, the POS count and the state-tracking-system count in separate columns.

The manager then checks what the state system actually received for that package instead of assuming the first upload went through. The submission turns out to be flagged as rejected. The manager pulls the error details and traces the package back through the original reporting file. Only once that record is confirmed does the manager recount the shelf.

The rejected submission explains why the state-tracking-system count differs from the POS count. It does not explain why the physical count was lower than the POS count, so that part of the variance stays open. The manager fills in the documented cause for the state-count gap, lists themselves as reviewer, and marks the resolution status as open until the corrected file is accepted and the physical count is checked again.

What a Compliance-Ready Reconciliation Record Should Document

California requires licensed retailers to keep their inventory reconciliation results on file and hand them over to the Department of Cannabis Control on request. Rules like this vary by state, so check your own state's reporting requirements before you assume the same standard applies.

California also defines a significant discrepancy as a five percent difference between the physical count and the track-and-trace record. It also requires notifying the Department and local law enforcement within 24 hours of discovery. That threshold and deadline are California's rule, not a nationwide standard, so confirm the figure that applies in your own state.

Keep this information somewhere you can find quickly if a regulator asks for it. One option is alongside the inventory adjustment compliance records.

Stock Rotation vs. Inventory Valuation: Two Different Things FIFO and LIFO Describe

FIFO and LIFO get used for two different jobs, and mixing them up causes confusion. The terms can describe stock rotation: the physical choice of which product leaves the shelf first. First in, first out (FIFO) moves the oldest product first, which can help manage freshness and shelf life. Last in, first out (LIFO) moves the newest product first, which can leave older perishable stock sitting longer.

The same two terms also name an inventory valuation method: an accounting choice for costing goods sold. Valuation decides which cost a sale gets charged against on the books. It does not depend on which physical unit actually left the shelf.

This split matters for a dispensary doing a reconciliation. A business can rotate its physical stock oldest first while its books value inventory under a different method. Neither choice, on its own, closes a gap between a physical count, a POS count and a state tracking system count. The two ideas solve different problems and should not be treated as one explanation for a count mismatch.

How Real-Time, State-Synced Inventory Narrows the Reconciliation Gap

New York requires every cannabis licensee to run an electronic, real-time inventory tracking system that captures all cannabis inventory. A point-of-sale system can post each sale to the state system right away instead of in a batch later. That leaves less time for the physical count, the register and the state record to drift apart.

A cannabis point-of-sale system built for licensed dispensaries combines compliant checkout with real-time inventory and METRC integration.

Compliance features in this kind of system can include METRC package intake at receiving and purchase limit enforcement. They can also include METRC sales delivery manifests and inventory adjustments that sync to METRC.

These features can narrow the kind of gap that leads to reconciliation variances, but they do not replace the investigation steps above. An operator still needs to confirm the cause and document it before closing out a mismatch. A review of pages ranking for this topic found none that connect day-to-day counting to a state-mandated seed-to-sale system.

Keep Counts in Agreement and Move On

Real-time inventory that stays synced with the state system can reduce timing-related gaps between your counts, when the underlying records are accurate. Book a Demo to see how WebJoint's real-time, state-synced inventory fits your reconciliation routine.