“Inventory Adjustments” sub-report tab
Please include all Inventory adjustments made in this reporting period for cannabis product (excluding accessories) to correct for discrepancies between physical inventories and the related inventory book quantity, including any receiving errors. Please ensure that the discrepancy type in column I is selected from the drop-down menu.
According to Standard 8.2 of the Registrar’s Standards for Cannabis Retail Stores, licensees must:
- complete full physical counts of all cannabis products monthly at a minimum or upon request of AGCO.
- maintain a log of the physical inventory count results.
If discrepancies are noted/identified based on the results of the monthly physical count, the licensee must prepare and submit a report to AGCO for all discrepancies identified between the monthly physical inventory count results and the related inventory quantity per record as of the date of the count.
This “Inventory Adjustments” sub-report tab should be submitted as part of a completed Integrated Cannabis Retail Report, and not as a separate submission by itself. Completion of this sub-report is not required if no inventory adjustments of cannabis products occurred during the reporting period.
Inter-store Transfer quantities should not be accounted for here.
Data Definitions
The following table details the required data elements associated with cannabis product(s) or stock received by an authorized store in the “Inventory Adjustments” sub-report tab in addition to definitions and formulas:
|
Data Element |
Description |
|---|---|
|
Category |
Identify the OCS-defined type of cannabis product category being reported as follows: • Beverages |
|
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. |
|
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. |
|
Unit of Measure |
This is the standard of unit or systems of unit by means of which the quantity of inventory for each SKU is expressed or accounted for. The same unit of measure (UOM) should be applied to the report as is provided in OCS’s shipment data. |
|
Date of Physical Inventory Count (YYYY/MM/DD) |
This is the date that a physical inventory was conducted in store. Only dates within the reporting period indicated on the “Landing Page” should be included. |
|
Balance Per Book |
This is the total quantity of each SKU in stock as recorded in the books (perpetual inventory records) as at the date of the physical count. |
|
Balance Per Physical Count |
This is the total quantity of each SKU based on the results of the physical count. |
|
Difference (if = 0, no entry required) |
This is the difference in quantity (overages or shortages) between the preceding columns “Balance Per Book” and “Balance Per Physical Count” for each SKU. This field is locked and calculated automatically by the worksheet, so there is no need to do so separately. If the difference is 0, no entry is required for that inventory transaction. |
|
Discrepancy type (select from drop-down) |
This is a drop-down menu of the following possible reasons to explain the inventory adjustments: • Audit • POS Error • Employee Error • Receiving Error • Lost/Theft • Other Please do not type any other terms other than what is indicated above. |
|
Comment/Disposition |
Use this field to describe the cause or reason for the difference/variance identified and the disposition taken to adjust the balances of the inventory accordingly. |
|
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”. |