POS, Seed-to-Sale and General Ledger Reconciliation
Retail cannabis throws off three parallel records of the same sale: the point-of-sale system, the seed-to-sale inventory platform, and the accounting ledger. They disagree constantly. Discounts, voided tickets, employee purchases, samples, waste and manual inventory adjustments all create drift between the three.
We build a standing three-way tie-out. Gross receipts per POS reconcile to bank deposits and to ledger revenue. Units sold per POS reconcile to package depletion in the inventory system. Variances get investigated at the SKU level and either explained or corrected before the period closes, because an unexplained inventory gap is both an ADHS compliance exposure and a federal tax exposure at once.
- Daily sales journal from POS to ledger with discount and refund detail
- Unit-level reconciliation of POS depletion to seed-to-sale package activity
- Deposit-to-sales cash tie-out with over/short tracking by shift
- Documented investigation of variances above a defined threshold
Cash Handling and Internal Controls
Limited access to traditional banking means many Arizona dispensaries still handle meaningful currency volume. Cash creates two distinct risks: internal loss from theft, and the appearance of unreported income if an examiner cannot trace it. Controls have to address both at once.
We build segregation of duties across the till, the vault and the deposit; require dual counts with signed sheets; reconcile drawer counts to POS shift reports; and maintain a vault log that ties to the general ledger daily. Where a business banks with a cannabis-tolerant institution, we prepare the reporting packages those relationships require to stay open.
- Dual-control counts and signed count sheets at every custody transfer
- Shift-level over/short analysis with trend reporting by employee
- Vault log reconciled to ledger cash daily
- Deposit documentation packages for cannabis-friendly banking relationships
TPT, Excise Tax and Retailer Obligations
Arizona retailers collect the state's 16% adult-use marijuana excise tax on recreational sales and remit it to ADOR, and they separately collect Transaction Privilege Tax on the retail sale itself. Medical patient sales under the AMMA are exempt from the 16% excise tax but remain subject to TPT, so the point-of-sale system has to distinguish adult-use from medical transactions correctly, every time.
We configure the POS tax logic, verify the calculation against a transaction sample across both channels, and file on a fixed calendar through AZTaxes.gov so returns and payments are never funded out of surprise. Combined state, county and city TPT rates differ across Phoenix, Tempe, Chandler, Glendale and every other Arizona municipality, and we track each rate individually rather than assuming a single statewide figure.
Inventory Valuation and Retail COGS
As a reseller under 280E, a dispensary carries a narrow COGS profile: invoice cost of product plus the costs of acquiring it. Getting that number right depends on accurate landed cost per unit, disciplined receiving, and a physical count process that actually agrees with the system of record.
We standardize receiving so every purchase order ties to a vendor invoice, a seed-to-sale transfer manifest, and an inventory receipt at a specific unit cost. Cycle counts run on a rotating schedule with a full count at period end, and shrink is quantified, categorized and reported rather than absorbed quietly into margin.
Management Reporting That Drives Retail Decisions
Compliance reporting tells you what already happened. Management reporting tells you what to do next. We report gross margin by category and by brand, basket size and ticket count by daypart, discount leakage, labor as a percentage of gross profit, and inventory turns by SKU class.
That reporting answers the questions Phoenix, Mesa and Tucson retail operators actually ask: which brands earn their shelf space, whether the delivery channel contributes after driver labor, and how deep a promotion can go before it destroys margin that 280E will never let the business recover federally.
- Gross margin by category, brand and SKU
- Discount and promotion leakage analysis
- Labor efficiency measured against gross profit, not revenue
- Inventory turns, days on hand and aged-stock exposure
The Daily Close in an Arizona Retail Environment
Retail cannabis generates hundreds of transactions a day across cash, debit workarounds and increasingly ACH-based payment rails, in a store where product is tracked by the state and the till is counted by hand. The close discipline that makes this work is daily, not monthly: shift-level cash counts under dual control, a signed over/short log, a deposit prepared and logged the same day, and a POS Z-report reconciled to both the deposit and the ledger.
A Scottsdale storefront running 400 tickets a day with an average basket of $62 moves roughly $9,000,000 of 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 prevented it, and exactly the kind of pattern that turns a routine examination into a difficult one.
We implement the control set, then audit it monthly: variance trend by shift and by budtender, void and discount frequency by employee, and refunds against the exception policy. Controls that nobody reviews stop being controls.
- 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 Decisions
Because a retailer'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 retailer bears it, and permitted acquisition costs go into unit cost the moment product is received and the transfer manifest is accepted, not estimated later from 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-moving inventory are considered. In a market where price compression has been relentless, a Tucson retailer that reallocated shelf space toward two high-turn categories improved blended margin by four points without raising a single price.
We also report days-on-hand by SKU. Cannabis inventory ages badly, and product written down or destroyed at the back of the store is margin that federal tax law will not give back.
