“Monthly Sales” sub-report tab
Reporting Requirements
Licensed cannabis retail stores must track and report on all relevant sales transactions for cannabis products purchased from the OCS. The “Monthly Sales” sub-report tab includes data elements associated with cannabis product(s) or stock received by, shipped from, or sold by an authorized store. It contains information that also satisfies operators’ commercial data obligations to the OCS.
Complete the “Monthly Sales” sub-report tab for every reporting period, in compliance with the Sales Data Definitions section and instructions outlined in this guide. Please include all Sales activity per date for the entire reporting period for all cannabis product (excluding accessories).
The “Monthly Sales” sub-report tab should be submitted as part of a completed Integrated Cannabis Retail Report, and not as a separate submission by itself.
The guidelines listed below must be followed when calculating values submitted in the Cannabis Monthly Sales Reporting:
- The “Monthly Sales” sub-report tab contains details of daily sales and on-hand inventory organized by OCS Product SKU for cannabis products that are purchased from the OCS.
- Systems should export opening inventory quantities for each Product SKU in inventory as of 12:01 am on the first day of the reporting period at the beginning of the report. The end of the report should include all closing inventory quantities for each Product SKU as of 11:59 pm am on the last day of the reporting period (this should include all SKUs that had any inventory presence over the course of the month).
- After opening inventory has been entered (and before the closing inventory section), sales data is only required for products that have transactions on a given day within the reporting period.
- Enter data into “Markdown Sales Price ($CA)” and “Quantity Sold - Markdown Units” when a transaction occurs at a price lower than its regular retail sales price. If product (SKU) was sold on the same day at different regular retail price points, then each of these price points should be recorded in separate rows. Do not average prices; rounding errors will result.
- After opening inventory has been entered, sales data is only required for products that have transactions on a given day within the reporting period.
Consent to Share the Sales Data
With your consent, the AGCO will share your completed report with the OCS to allow licensed retail operators to meet their reporting obligations under their OCS Retailer Agreement in a streamlined manner. To provide your consent, answer “Yes” to a corresponding question on the "Landing Page" of the Integrated Cannabis Retail Report. Licensed cannabis retail stores who do not consent to sharing their completed report are required to make arrangements to submit this report directly to OCS, by contacting OCS Client Services at 1-877-627-1627. For more information, please consult the OCS Retailer Handbook.
Sales Data Definitions
The following table details the required data elements associated with cannabis product(s) or stock received by an authorized store in the “Monthly Sales” sub-report tab in addition to definitions and formulas:
|
Data Element |
Definition |
Formula |
|---|---|---|
|
Sales Date (YYYY-MM-DD) |
Date that a transaction for a particular SKU occurred during the reporting period. Transactions should be listed in chronological order throughout the reporting period. |
|
|
Product Barcode/UPC |
This is the unique “universal product code” assigned to cannabis products purchased from the OCS. The authorized store’s system must reference the product barcode provided by the OCS in their perpetual inventory system. UPC codes for each item will be provided to licensees prior to the launch of Authorized Stores. A UPC consists of numeric digits that forms the barcode used for scanning an item at the point-of-sale. |
|
|
OCS Product SKU |
This is the unique product identifier (“stock keeping unit”) assigned to cannabis products sold by OCS to licensees. The perpetual inventory systems of the licensees must reference and use the specific SKU provided by the OCS as the primary cannabis product identifier. |
|
|
Retail Sales Price ($CA) |
The regular retail price, net of sales tax, that an authorized store sets for each unit (represented by SKU) that it makes available for sale. |
(Retail Sales Price) = (equals) (Value assigned to a particular SKU at sale) |
|
Quantity Sold - Regular Units |
The total number of units sold at the retail sales price each day by an authorized store during the reporting period. |
(Quantity Sold - Regular Units) = (equals) (All eaches of a given SKU sold at a given retail sales price each day within a reporting period) |
|
Markdown Sales Price ($CA) |
The price, net of sales tax, that an authorized store sets for each unit (represented by SKU) that has been discounted/marked down and made available during the reporting period. |
(Markdown Sales Price) = (equals) (Value assigned to a particular SKU at sale that has been discounted) |
|
Quantity Sold - Markdown Units |
The total number of units sold at a markdown sales price each day by an authorized store that it has elected to discount/mark down during the reporting period. |
(Quantity Sold - Markdown Units) = (equals) (All eaches of a given SKU sold at a markdown sales price each day within a reporting period that have been discounted or marked down) |
|
Retail Sales - Total Value ($CA) |
The total retail value, net of sales tax, of a particular unit (identified by SKU) sold by an authorized store each day during the reporting period. If there are multiple rows of data for a SKU on a specific day, this value should be calculated only from the sold units in this row. |
(Retail Sales - Total Value ($CA)) = (equals) [ (Quantity Sold - Regular Units) * (multiplied by) (Retail Sales Price) ] + (plus) [ (Quantity Sold - Markdown Units) * (multiplied by) (Markdown Sales Price) ] |
|
Inventory - Units on Hand |
The total number of units on hand for each SKU that an authorized store possesses at the end of each day during the reporting period. If there are multiple entries for a given SKU on a particular day, this column’s value should be the same for those entries. |
|
|
Discrepancy Review (last column of the table) |
This column is not editable by the user. It will display any discrepancies in the data that has been provided. These may be derived from comparisons of data between different populated tabs in the report. If no issues are present, the column will be blank, and the header row will say “No Discrepancy Rows to Review”. If issues are present, the header will indicate the number of discrepancies present in the column below and will appear in red highlighting. To review them, use the drop-down menu available in the same header cell to filter the table to the rows with issues. A detailed list of these issues across all tabs is available in the tab called “Discrepancy Details”. |
|