← All guides

Washington rule

How the WSLCB CCRS weekly report works, and why files get rejected

CCRS is the LCB’s reporting system for cannabis licensees. A retailer reports by uploading CSV files. A file fails when it breaks a format rule or arrives out of order.

By CannAgent4 min read

What the rule requires

WAC 314-55-083(4) says licensees “must track cannabis from seed to sale”. The required information “must be kept completely up-to-date in a system specified by the LCB.” That system is CCRS.

LCB’s CCRS FAQ sets the week: “Week is defined as Sunday - Saturday.” Reporting is expected “by no later than Sunday for the previous week.”

A quiet week needs no file. The FAQ says “if there is nothing new to report, there is no report to submit.”

What a retailer uploads

LCB’s Upload User Guide lists seven files for a retailer. Later files are checked against earlier ones, so order matters.

  1. First: Strain, Area and Product.
  2. Next: Inventory.
  3. Last: Inventory Transfer, Inventory Adjustment and Sale.

The guide warns that files “will fail if the prerequisite data has not been uploaded.”

Why files get rejected

These causes come from LCB’s guide and FAQ.

  • The record count in the header does not match the rows in the file.
  • The file is not a CSV, or a template column was added or removed.
  • “Invalid Product”: the product was never uploaded, or its name is spelled differently.
  • “Invalid InventoryExternalIdentifier”: the inventory ID was never reported, or is formatted differently.
  • “CannabisExciseTax does not equal 37% of UnitPrice.” Only a medical sale can report zero.
  • “Duplicate Sale for Licensee”: lines of one sale disagree on sale ID, type or date.
  • An update was sent for a record that was never inserted.

Who gets the error

The error email goes to whoever uploaded the file. When a software vendor uploads, the FAQ says “the licensee will not receive an email.”

The duty stays with the store. The FAQ says “The licensee is ultimately responsible to meet data reporting obligations.”

Stuck on an error? LCB asks you to send its Examiners the CSV and the error email.

Takeaways

  • The CCRS week runs Sunday to Saturday. The report is expected by the next Sunday.
  • Upload in order: Strain, Area and Product, then Inventory, then transfers, adjustments and sales.
  • The licensee answers for the report, even when a vendor uploads it.

Sources

Frequently asked

When is the CCRS weekly report due in Washington?
LCB’s CCRS FAQ defines the week as Sunday to Saturday. Reporting is expected no later than Sunday for the previous week. With nothing new to report, no file is due.
Why was my CCRS file rejected?
LCB’s upload guide lists the causes. A prerequisite file was not uploaded first. The header record count is wrong. A product or inventory ID does not match. The excise tax is not 37% of the unit price.

Related guides

Ready to talk through your migration?

30-minute demo. We end by quoting the cutover from your current setup — fixed scope, no hourly games.