Tying POS, BioTrack and the Ledger Together
A single dispensary sale produces three separate records — the point-of-sale system, the state's BioTrack track-and-trace platform, and the accounting ledger — and they never agree on their own. Discounts, voids, staff purchases, comped product, waste and manual BioTrack corrections all pull them apart over time.
We run a standing three-way tie-out: gross POS receipts reconcile to bank deposits and revenue on the books, and unit sales in POS reconcile to package depletion in BioTrack. Anything that doesn't match gets traced to the SKU level and resolved before the period closes — an unresolved inventory gap is a compliance problem and a tax problem at the same time.
- POS-to-ledger daily sales journal with discount and refund detail broken out
- Unit-level tie-out between POS depletion and BioTrack package activity
- Deposit-to-sales cash reconciliation with shift-level over/short tracking
- Documented follow-up on any variance past a set threshold
Cash Handling and Internal Controls
Banking access remains limited, so most Illinois dispensaries still handle real volumes of cash. That creates two separate risks: internal theft, and the appearance of unreported income if an examiner comes calling. The control set has to address both at once.
We segregate duties across the register, the vault and the deposit run; require signed dual counts; tie shift drawer counts back to POS reports; and keep a vault log that reconciles to the ledger every day. Where a store banks with a cannabis-friendly Illinois credit union or state-chartered bank, we also prepare the reporting those institutions need to keep the account open.
- Signed dual-count sheets at every point cash changes hands
- Employee-level over/short trending by shift
- Daily vault-to-ledger reconciliation
- Deposit packages formatted for cannabis-compliant banking relationships
Excise, Sales Tax and Retailer Responsibilities
Illinois retailers collect the Cannabis Purchaser Excise Tax from customers and remit it to IDOR, on top of the 6.25% state retailers' occupation tax and whatever Municipal Cannabis Retailers' Occupation Tax the city and county layer on. The excise rate itself moves with potency: 10% at or under 35% THC, 20% on infused products, and 25% once a product tops 35% THC — so each SKU can sit on a different tax base.
We build the POS tax configuration so potency tiers map correctly to product categories, spot-check the calculation against sample transactions, and put filings on a fixed calendar so returns are never funded on short notice. MCROT filings — which stack differently in Chicago and Cook County than they do downstate — get tracked on that same calendar.
Retail Inventory Valuation and COGS
Because a dispensary is a reseller, its COGS under 280E is narrow: invoice cost plus what it takes to acquire the product. Getting that number right depends on accurate landed cost per unit, tight receiving procedures, and a physical count process that actually matches the system.
We standardize receiving so every purchase order ties to an invoice, a BioTrack transfer manifest and a receipt at a specific unit cost. Cycle counts run on rotation with a full count at period end, and shrink gets measured, categorized and reported rather than absorbed quietly into margin.
Reporting That Actually Drives Retail Decisions
Compliance reporting tells you what already happened. Management reporting tells you what to do next. We break out gross margin by category and brand, basket size and ticket count by daypart, discount leakage, labor as a share of gross profit, and inventory turns by SKU class.
That's the data owners actually need: which brands earn their shelf space, whether a location near a border market like Metro East or the Wisconsin line is capturing cross-state traffic profitably, and how much a promotion can eat into margin before it destroys profit that federal tax law won't let you recover anyway.
- Gross margin by category, brand and SKU
- Discount and promotion leakage analysis
- Labor efficiency measured against gross profit, not top-line revenue
- Inventory turns, days on hand and aged-stock exposure
What a Daily Close Looks Like in Illinois Retail
Retail cannabis generates hundreds of transactions a day across cash, debit workarounds and increasingly ACH-based rails, in a store where the state tracks the product and someone still counts the till by hand. That only works with a daily close discipline: shift-level counts under dual control, a signed over/short log, a deposit prepared and logged same-day, and a POS Z-report reconciled to both the deposit and the ledger.
A Naperville storefront running 400 tickets a day at a $62 average basket moves roughly $9,000,000 in gross receipts a year through that process. A one-percent unexplained variance is $90,000 — more than the cost of the controls that would have caught it, and exactly the pattern that turns a routine exam into a hard one.
We put the control set in place, then audit it monthly: variance trend by shift and by budtender, void and discount frequency by employee, refunds checked against the exception policy. A control nobody reviews stops being a control.
- Dual-control counts at open, shift change and close
- Sequential deposit log tied to the armored carrier manifest
- Daily POS-to-ledger reconciliation with documented variance explanations
- Monthly exception review of voids, discounts and returns by employee
Landed Cost, Category Margin and Merchandising Calls
Because a dispensing organization's inventoriable cost is narrow, the accuracy of landed cost per unit at receiving determines the entire federal tax position. Invoice price, inbound freight where the dispensary bears it, and permitted acquisition costs go into unit cost the moment product is received and the BioTrack transfer accepted — not estimated later off a vendor statement.
That same unit cost drives merchandising. Category margin reporting shows what flower, vape, edibles, pre-rolls and accessories each contribute after cost, and brand-level reporting shows which vendor relationships are actually profitable once discounting and slow movers are factored in. In a market where price compression has been relentless, a Rockford dispensary that shifted shelf space toward two high-turn categories picked up four points of blended margin without touching a single price.
We also track days-on-hand by SKU. Cannabis inventory ages badly, and anything written down or destroyed at the back of the store is margin federal tax law will never give back.
