What a store’s own numbers can tell it

2 of 1632 costed sales lines sold under unit cost. 40 more sales lines had no unit cost we could match, and were not checked (often a product sold out and so not in your on-hand file). Pre-tax amounts are read from your “Net Sales” column.

≈ $4.50 (estimated) lost over the 30 days the sales export covers (≈ $1.05 (estimated) a week).

Why it matters

Every unit sold under what it cost you is margin paid out of pocket, usually from a stale price, a stacked discount, or a cost that changed after the price was set.

What to do

Re-price the listed items (or end the discount driving them under cost), then re-run this check on next week's export.

3 of 180 products have no unit cost (1% of pre-tax sales).

≈ $573 (estimated) of pre-tax sales on products with no cost, so margin on it is unknown (≈ $134 (estimated) a week).

Matched 180 of 180 products by SKU.

Why it matters

Without a cost, margin on that product cannot be known, and any below-cost sale on it is invisible to every other check.

What to do

Enter unit cost from the vendor invoice for each listed product; the busiest ones first.

2 products have a cost worth verifying, of 177 with a cost. Cost was compared with selling price for 173 of 177 products with a cost; the rest had no sales line we could read a price from.

Why it matters

A placeholder cost, a cost at or above the selling price, or a case cost entered as a unit cost passes as "has a cost", and then every margin and below-cost figure on that product is wrong.

What to do

Verify each listed cost against the vendor invoice or manifest, and correct the cost on the product in your POS where it's wrong.

3 of 172 in-stock products have no sale in the last 30 days of sales.

≈ $218 (estimated) of stock at cost that has not sold.

Matched 169 of 172 products by SKU.

Why it matters

Stock that sits is cash that isn't buying what sells, and the longer it sits the harder it is to sell at full price. This is cash tied up, not money lost: most of it will sell, just slowly.

What to do

Start with the most valuable. Mark it down, or bundle it at a price (never free), and order less of it next time.

None of the 169 in-stock products we could match sold steadily and then went quiet for the last 14 days. 3 in-stock products had no sale we could match in your sales export, so we can't tell whether they were selling; they are not counted here. 2 products were left out because all of their stock was received in the last 14 days and may simply not have sold yet.

Why it matters

A product that was selling steadily and then went quiet while the system still shows stock is the kind most likely to be missing from the shelf: sold through and never counted down, rung up as another product, or lost. It may also be real stock that's been moved or is out of sight. Either way it stays on your menu, and a customer can still order it.

What to do

Check the shelf and the back stock for these first, starting at the top. If the count is off, record an inventory adjustment in your POS with its real reason, so it reaches CCRS with that reason. Don't just overwrite the count: a write-off with no reason can be taxed as a sale. Product you can't sell is destroyed under the waste rules, with a record. Then re-run this check on a new export.

15 of the 109 products we could work out a weekly rate for hold more than 12 weeks of supply. Each rate is over the last 28 days of your sales, or from when the product first sold or arrived, if that is later. With no received date, a product whose sales stopped for 7 or more days and started again is read from when they started again. Left out: 7 in-stock products have no sale at all (see "Not selling"); 16 products sold fewer than 3 units or on fewer than 3 days, too few to call a weekly rate; 40 products first sold or arrived in the last 13 days, too new to call a weekly rate.

≈ $1,051 (estimated) of stock at cost beyond 12 weeks of supply.

Why it matters

Weeks of supply is what you hold divided by what you sell in a week. Past 12 weeks, about a quarter, the cash in it could have turned over several times, and flower and carts are getting old on the shelf. This is cash tied up, not money lost: it will sell, just slowly. It needs no received date.

What to do

Order less of these, or skip the next order, until they come down. To move them sooner, mark them down or bundle them at a price (never free), starting with the most cash tied up.

4 in-stock lots or products are 90+ days old.

≈ $1,894 (estimated) tied up at cost in stock 90+ days old.

Why it matters

Cash sitting in old stock is cash not buying what sells, and older product is harder to sell at full price. This is cash tied up, not money lost.

What to do

Mark down, or bundle at a price (never free), the oldest lots first, and lower the re-order quantity on the products that keep landing here.

Skipped. Your export lists only items in stock (8 rows show 0 or less, too few to tell that sold-out items are included), so we can't tell which best sellers have sold out. That's common. If your system can include products with 0 on hand in the export, upload again to include this one.

1 of 42 products with a dose in the name have no potency value on file.

Why it matters

The figure lives only in the name, so menus and reports that read the potency field show nothing, and an edited name can drift from the lab result.

What to do

Fill the potency field from the lab certificate for each listed product. Don't copy the figure from the name; the name may be out of date.

2 of 40 result rows came back with an error: duplicate row (1), required field missing (1). A result file shows one submission: a row corrected and accepted later still shows here as rejected, and a submission without a result file is not checked here.

Why it matters

A rejected row was sent but never accepted. Until it is corrected and sent again, the state's record of your inventory or sales does not match yours.

What to do

Duplicate row: Check the CCRS portal first. This row may already be accepted. Don't send it again until you've confirmed it isn't on file. Required field missing: A required field is blank. Fill it in on the record in your POS with what actually happened, and let your POS or integrator send it again. Never change an on-hand count or a quantity just to get a row accepted. If the row is right and CCRS still refuses it, that is a question for WSLCB, not an edit.