Sample report: a fictional shop with made-up figures

What a shop’s own state (CCRS) records say when they are read next to its monthly excise reports and the rest of its area. The shop is made up and every figure is shifted, so nothing here describes a real store.

State records check

Example Cannabis Co

Compared with
Example County
Sales
Jan 1 – Sep 26, 2026

5 record checks

1Priority
3To review
1No gap found

Do these first

  1. Ask your POS provider to resend your sales for 2026-03-26, 2026-03-27, 2026-03-28.
  2. Check 7 sale line(s) ($240) on products named as trade samples.
  3. Ask your rep about Product 1: you paid $13.19, other shops' median $9.39.
Sales on a year ago+2.1%Example County -3.4%
Largest record gap-11.6%vs excise report, 2026-03
Paid above other shops$2,140on $656,853 of matched purchases
Statewide rank#157of 461 shops, 2026-09
01

Your state records

The checks

Checks of the state (CCRS) records against the monthly LCB excise reports. LCB publishes no tolerance for these; the thresholds are ours.

  • Priority
    State record vs your monthly LCB excise report: 4 months compared; largest gap -11.6% (2026-03); 1 month(s) more than 5% apart.
    Why, and what to do

    3 date(s) with no sales in the state record: 2026-03-26, 2026-03-27, 2026-03-28. Resending those dates may close much of the gap.

  • Review
    Trade samples: 7 sale line(s) ($240) on products named as trade samples, 2026-04-03 to 2026-05-20.
    Why, and what to do

    Trade samples are meant to be free (WAC 314-55-096), so either these were not trade samples and the product name is wrong, or they should not have been sold. Worth checking which.

  • Review
    Old negative inventory: 4 lot(s) still show negative quantity on hand in the state record (-6 units).
    Why, and what to do

    None has been updated since June 2025 (the state record has held no negative stock since then), so these are leftovers: if these lots are empty, record an adjustment with its reason, as the CCRS FAQ asks.

  • Review
    Reporting days: 3 date(s) with no sales in the state record: 2026-03-26, 2026-03-27, 2026-03-28.
    Why, and what to do

    Dates blank for most shops at once (2026-04-01, 2026-04-02) are not counted against any shop.

  • No gap found
    Inventory adjustments: 410 count corrections (900 units, 0.6% of units sold; median shop 0.6%) and 30 units written off as destroyed, stolen or lost (0.02%; median shop 0.01%).

State record vs monthly LCB excise report, by month

We flag months more than 5% apart. The state publishes tax-reported sales about two months behind.

MonthTax-reportedIn CCRSGap
2026-01$190,000$189,240-0.4%
2026-02$190,000$188,290-0.9%
2026-03$190,000$167,960-11.6%
2026-05$190,000$187,720-1.2%
02

Money

Average price per sale line against the area

Average price of one sale line by category against the median of other Example County shops. Pack size moves this as much as price does (a 28-pack and a single pre-roll are both one line), so read it as your mix, not your margin.

CategoryYouExample County median
Usable Cannabis$13.95$21.09
Concentrate For Inhalation$17.32$23.69
Solid Edible$19.28$21.84
Liquid Edible$12.11$12.58
Cannabis Mix Infused$9.25$12.23

What you pay suppliers, against other shops buying the same item

Matched on the grower's own product record across 4,044 items ($656,853 of your purchases). Paid above the median shop: $2,140. Paid below: $1,310.

SupplierYour matched spendPaid above other shopsItems
Supplier A$15,272$2,177118
Supplier B$4,101$80927
Supplier C$4,436$33738
Supplier D$18,152$43484
Supplier E$7,610$32764
Supplier F$3,050$25430

Items to raise with the rep (bought by 5 or more other shops)

ItemYou paidOther shops (median)Other shops buying itAbove, this year
Product 1$13.19$9.3930$170
Product 2$7.95$6.0548$108
Product 3$4.27$3.28127$82

Do you carry Example County's top suppliers?

For each category, the ten suppliers other Example County shops bought the most from this year, and how many of them you buy from.

CategoryYou buy fromTop-10 suppliers you don't
Cannabis Mix Infused6 of 10Supplier K, Supplier L, Supplier M, Supplier N
Concentrate For Inhalation8 of 10Supplier K, Supplier L
Liquid Edible7 of 10Supplier K, Supplier L, Supplier M
Solid Edible9 of 10Supplier K
Usable Cannabis5 of 10Supplier K, Supplier L, Supplier M, Supplier N, Supplier O
03

Market

This year in Example County

What changed around you, from every shop's and supplier's state reporting.

  • Growth on a year ago (tax-reported sales, 2026-01 to 2026-05): you +2.1% · Example County median -3.4% (24 shops) · shops your size statewide -6.0% (100 shops) · all Washington -7.5%.
  • Rank: #157 of 461 Washington shops in 2026-09 (#177 in 2026-06). #22 of 24 in Example County.
  • Example County market: -9% in Jul–Sep against Jan–Mar 2026 (tax-base sales).
  • New shops: 1 new shop(s) in Example County started reporting sales this year.
  • Shops no longer reporting: 2 Example County shop(s) have reported no sales for over a month (closed, sold, changed licence, or not reporting).
  • Supplier picking up: 13 of 24 Example County shops ordered from Supplier Q in Jul–Sep, up from 4 in Apr–Jun. You did not order from them in Jul–Sep.
  • Supplier picking up: 9 of 24 Example County shops ordered from Supplier R in Jul–Sep, up from 2 in Apr–Jun. You did not order from them in Jul–Sep.
04Details

Which days carry your week

Share of your sales by day of week, against the median of other shops in the area.

DayYouExample County median
Sun18.78%12.76%
Mon12.6%13.13%
Tue12.13%12.76%
Wed12.96%13.37%
Thu13.57%13.89%
Fri15.24%17.96%
Sat13.98%15.08%

Your share of Example County sales

From 2.0% in 2026-01 to 2.0% in 2026-09. Shops reporting in the area: 24 to 24.

Stocked by other Example County shops, not by you

Products at least three other shops in the area bought this year that you never bought.

SupplierProductCategoryShops
Supplier GProduct 40Concentrate For Inhalation44
Supplier HProduct 41Concentrate For Inhalation42
Supplier IProduct 42Usable Cannabis42
Supplier JProduct 43Cannabis Mix Infused37
Supplier KProduct 44Solid Edible43
Supplier LProduct 45Usable Cannabis44
Supplier MProduct 46Concentrate For Inhalation44
Supplier NProduct 47Concentrate For Inhalation39
Supplier OProduct 48Usable Cannabis34
Supplier PProduct 49Concentrate For Inhalation37
Sources: WSLCB CCRS monthly data drops (public records) and WSLCB “Cannabis Sales Activity by License Number” (tax-reported). CCRS is self-reported and incomplete. Other shops’ figures appear only as area medians and counts. CannAgent is not affiliated with the LCB. This is a reading of public records, not legal or tax advice.

Want this for your own shop?

Reports on a shop’s own records aren’t open yet. Tell us about your store and a person will get back to you.

Ask about a report for your shop