Retail Reporting

Last Updated

Requirements

This chapter provides detailed information to assist operators of authorized cannabis retail stores in meeting their Automated Retail Data Submission and Incident-Based Retail reporting obligations to the Registrar. Licensees should read and understand the contents of this chapter prior to operating a cannabis retail store.

Automated Retail Data Submission is completed through the Point-of-Sale (POS) Data Reporting Platform that works with your POS software, if it has been successfully onboarded to the data platform. Please review section 8 of the Registrar’s Standards for Cannabis Retail Stores to understand your obligations.

Incident-Based Retail Reports are submitted via the iAGCO online portal and supplementary information is required as based on the Notification Matrix . Please review section 1 of the Registrar’s Standards for Cannabis Retail Stores to understand your obligations.

If you are looking for assistance with data entry and how it contributes to the automated retail data submission, please complete the Cannabis E-learning module (Licence Key: 8444-6196-1617-3306). For information on how to access this course, see these instructions. 

Submitting Your Incident-Based Retail Reports

Timing of Submission

All licensees are required to accurately complete and submit reports to AGCO as necessary, following the applicable timing of submission as set out in the “Regulatory Reporting Requirements – Cannabis ” (Notification Matrix).

Failure to Submit on Time

Failing to submit accurate and complete reports within the required timeframe is a breach of the Registrar’s Standard 1.6 and may result in regulatory action.

Method of Submission

All licensees must upload and submit their completed reports to the AGCO online though the iAGCO  portal. For more information about iAGCO portal, please visit the iAGCO Information page.

Navigate to the corresponding sections of this Guide for further information on Automated Retail Data Submission and incident-based retail reporting requirements.

Cannabis Records: Requirements and Point-of-Sale Data Reporting Platform

Last Updated

Licensees must have a point-of sale (POS) system in the authorized store. The POS system must, at minimum, capture records of all cannabis and cannabis transactions in the authorized store and must be configured and integrated with the automated POS Data Reporting Platform. 

The AGCO and the Ontario Cannabis Store (OCS) launched the automated POS Data Reporting Platform in 2024 to help reduce your regulatory burden by both simplifying your cannabis reporting requirements and improving its accuracy. All authorized retailers in Ontario are required under Standard 8.6 of the Registrar’s Standards for Cannabis Retail Stores to use an in-store POS system that is fully integrated with the automated POS Data Reporting Platform. 

How It Works

The automated POS Data Reporting Platform automatically extracts, standardizes, and validates the data that you already house in your system. This is done via an Application Programming Interface (API) connection between your POS system and the automated POS Data Platform. The OCS processes the extracted data, shares it with the AGCO, and notifies you of any errors.

The automated POS Data Reporting Platform eliminates the need for monthly preparation and submission of reports and improves the accuracy of the data submitted to better fulfil your provincially- and federally-mandated regulatory reporting requirements.

Your POS provider must set up your system to automatically pull your required provincial and federal regulatory reporting data directly from your in-store POS system. You are responsible for ensuring the POS system you use is configured and integrated with the automated POS Data Reporting Platform. Follow up with your POS provider to confirm connection, in keeping with your regulatory requirements.

Once it is processed by the OCS, the data required for provincial and regulatory reporting will be available for federal regulatory reporting. The OCS populates and completes reports required by Health Canada.

Integration of your POS system with the automated POS Data Reporting Platform enables you to meet your provincial and federal regulatory reporting requirements.

A list of POS providers that are fully integrated with the POS Data Reporting Platform can be found here. For more information about the POS Data Reporting Platform email OntarioCannabisDataReporting@ocs.ca .

Ongoing Data Quality

The automated POS Data Reporting Platform will automatically send you a data reconciliation error notification if the data sent from your POS system does not reconcile with the platform. The notification(s) will list the data reconciliation error(s) that you are required to resolve.

Data reconciliation errors may be generated for a number of reasons, including data continuity issues (i.e., data entry error, invalid transfer) and technical issues (i.e., a problem with the POS system). A list of data reconciliation error messages is available from the OCS Wholesale webpage.

It is important that you promptly resolve any data errors you are notified of to maintain data accuracy and compliance. If you have any questions about specific error messages, contact your POS Provider.

The AGCO validates incoming data to ensure retailers’ compliance with their regulatory obligations. If our validation efforts identify any issues, we may directly reach out to you for resolution. The AGCO does not have direct visibility to the error notifications you receive from OCS and cannot provide resolution. 

NOTE: The automated POS Data Reporting Platform sends error notifications on a weekly cycle. Once you resolve an error, please factor in the time required by the OCS to validate the correction. This may result in the error still appearing on the following week’s error list. Please be patient. Once the new data has been processed and validated, the error should resolve and you will receive a notification reflecting the status change from New/Existing to Resolved.

Continue to resolve any new error notifications you receive. 

What do I need to do?

  • Review any data reconciliation error notifications you receive and resolve them as soon as possible to ensure data accuracy and compliance.
  • If you require assistance to resolve certain data reconciliation errors, we recommend working with your POS Provider.
  • If you are having difficulty resolving errors with your POS Provider, please notify the OCS Customer Care Team by calling 1-877-627-1627.

NOTE: At this time, only one contact can receive data reconciliation error emails for each Cannabis Retail Store Authorization. To update your primary contact for receiving data reconciliation error emails, please reach out to the OCS Customer Care Team by calling 1-877-627-1627.

Need Help?

If you have any questions about specific error messages, or have an accumulation of unresolved errors, please reach out directly to your POS Provider.

For more information, visit: Cannabis Point-of-Sale Data Reporting Platform: Error Notifications Frequently Asked Questions

For questions about your regulatory requirements:

Closing an Authorized Store

If you are a CROL holder permanently closing an authorized store, you must notify the AGCO of your intent to close by:

  • Notifying the AGCO through the AGCO Notification Matrix; and
  • Submitting a Request to Cancel an Authorization Amendment on the iAGCO online portal.

Prior to the cancellation of the CRSA, the holder must ensure that any cannabis left unsold or undistributed is sold, transferred or destroyed. This means that there must not be any cannabis in the store, and the inventory levels must be reported as zero or null in the point-of-sale system.

If you are selling cannabis to another CRSA holder, you must:

  • provide written notice of the sale to the AGCO as part of the ‘Request to Cancel an Authorization’ Amendment in the iAGCO online portal

Once the CRSA cancellation request has been submitted, and both parties have received written correspondence from the AGCO advising as to whether either CRSA is under suspension or whether any proposals to revoke or suspend either CRSA or CROL have been

issued, and the parties proceed with the sale transaction, both parties must accurately document the cannabis sale and purchase transaction as follows:

  • The CROL who is closing their store must record the sale of cannabis as an outgoing inter-store transfer in their POS system, identifying the CRSA number of the CROL purchasing the cannabis to indicate where the cannabis is being sold to. This must be completed prior to the cancellation of the CRSA.
  • The CROL purchasing the cannabis must record the purchase as an incoming inter-store transfer in their POS system once they have transported it to their store, identifying the CRSA number of the CROL selling the cannabis to indicate where the cannabis was purchased from.
    • Note: Both the purchaser and the seller are responsible for ensuring that the inventory counts match the sale agreement before the cannabis is transported to the purchaser’s retail store.

For detailed regulatory and operational steps required prior to closing a retail store, please refer to the "Request to Cancel a(n) Licence/Authorization” and “Inter-operator Inventory Sales” sections of this guide.

Transfer of a Cannabis Retail Store Authorization

When an CRSA transfers, any existing cannabis inventory transfers with the CRSA. Each CROL holder involved in the CRSA transfer must accurately document the incoming and outgoing cannabis inventory in their respective point-of-sale systems.

When the transfer application is ready to be approved, the AGCO will provide the transfer applicant with guidance on the following steps:

  • The CROL receiving the CRSA will be provided with a new CRSA number.
  • The CROL receiving the new CRSA number must provide this number to the CROL transferring the CRSA.
  • The CROL transferring the CRSA will record the cannabis inventory that remains in the authorized store as an outgoing inter-store transfer in their POS system. The new CRSA number will be used as the recipient where the inventory is being transferred to. This must occur before the transfer application is approved.
  • After the transfer application is approved, the CROL receiving the CRSA will receive their authorization by email. The new holder of the CRSA must connect with the OCS to enter into a commercial agreement and engage their point of sale (POS) provider to integrate their in-store POS system with the OCS Data Reporting Platform. Once the POS system is integrated, the CRSA must record the incoming cannabis inventory as an incoming inter-store transfer in their POS system, identifying the old CRSA number as where the inventory was transferred from.

For detailed regulatory and operational steps required for CRSA transfers, please refer to the "Transferring a Retail Store Authorization” section of this guide.

Please refer to the Cannabis Seed-to-Sale Data Entry Guidelines for instructions on entering data into a POS system section of AGCO Cannabis Seed-to-Sale Data Entry Guidelines: e-Learning Module as noted in the Helpful Resources section of this guide. 

Incident-Based Retail Reporting

Overview

As part of the AGCO’s overall process to ensure compliance with the Registrar’s Standards, laws and regulations, all licensees are required to comply with the minimum notification obligations to the Registrar as outlined in the AGCO’s “Regulatory Reporting Requirements – Cannabis ” (Notification Matrix). They include (but are not limited to)

  • reporting incidences of lost or stolen product
  • changes to store layout
  • failure of surveillance systems
  • providing the AGCO with your website address

Standard 1.6 requires operators to comply with these notification requirements, including meeting the required timeframes for submission.

Standard 8.1 requirement 10 took effect June 30th, 2022, and requires operators of authorized cannabis retail stores to track agreements and acceptance of items, benefits or service (in accordance with Standard 6.5) using the AGCO Cannabis Regulatory Reporting Template for Registrar’s Standard 8.1.10 . These records must be made available to the AGCO upon request (as with any other records under Standard 8.1).

Cannabis Seed to Sale Guidelines: FAQs

Q: What is AGCO’s approved method of destruction?

A: There is no approved method, but your method of choice must comply with Registrar's Standard 3.0.

 

Q: If I want to use my inventory as a display, can I do that through an inventory adjustment?

A: No, all displays must be purchased at a cost greater than $0.00.

 

Q: Can I use an item that I have set aside for destruction as display?

A: No, all displays must be purchased as a sale at a price greater than $0.00.

 

Q: Can I take products out of the inventory at $0.00 for my personal use?

A: No, all cannabis products must be purchased as a sale, at a price greater than $0.00. Cannabis Products provided to any personnel free of charge is in violation of Standard 6.3: “Licensees may not provide cannabis or cannabis accessories free of charge or provide any other thing or benefit, as an inducement for the purchase of cannabis or a cannabis accessory.”

 

Q: If we receive a return from a customer but the product is lost before being put back into inventory, what is the correct way to enter the data?

A: Follow these three steps:

  • Process the return following the instructions in the Return from Customer section in the Cannabis Seed-to-Sale Data Entry Guidelines.
  • Remove the product from inventory as Lost/Theft following the instructions in the Lost/Theft section in the Cannabis Seed-to-Sale Data Entry Guidelines course.
  • Notify the AGCO of the incident within 1 business day.

Helpful Resources

For more information about the POS Data Reporting Platform, email OntarioCannabisDataReporting@ocs.ca

For more information about your Ontario Cannabis Data Reporting requirements, email cannabisreporting@agco.ca  

The AGCO and OCS are committed to ensuring the safe, responsible sale of cannabis in Ontario and will continue to adjust processes to reflect sustainable, scalable solutions.

Cannabis Point-of-Sale Data Reporting Platform: Error Notifications Frequently Asked Questions

Last Updated

Q. What is the Point-of-Sale (POS) Data Reporting Platform?

A. In 2024, the AGCO and Ontario Cannabis Store (OCS) launched an automated data reporting platform that integrates with each retail cannabis store’s POS system. 

This online POS Data Reporting Platform system replaces the need to manually submit Excel-based monthly Integrated Retail Reports to the AGCO for regulatory purposes. 

Q. How does it work?

A. Retailer data is automatically submitted directly to the POS Data Reporting Platform via the retailer’s in-store POS system. 

The platform also automatically notifies retailers if there are errors with their data.

Q. How do I know if my POS provider is integrated with OCS’s POS Data Reporting Platform?

A. You can confirm that your provider is integrated with the POS Data Platform by visiting the POS Provider List on the OCS website at: POS Provider List – OCS Wholesale  

Q. Does the POS Data Reporting Platform automatically send data error notifications? 

A. Yes. The POS Data Reporting Platform automatically notifies retailers if there are errors with their data.

The platform automatically generates emails with data reconciliation errors that require resolution to authorized cannabis retailers.

Q. How often are data error notifications sent?

A. The platform sends retailers automatically-generated emails on a weekly cycle, on Tuesdays, from donotreply@ocs.ca  

Q. Why am I receiving a data error notification?

A. Data reconciliation errors are sent as part of the POS Data Reporting platform, which automatically receives data from your POS system as part of your provincial and federal regulatory reporting requirements. 

The notifications show all data reconciliation errors that require resolution for your store. 
To ensure the accuracy of your data, review the data reconciliation errors you receive and make any necessary adjustments as soon as possible.

Q. Is there a list that explains what each data error means?

A. A guide on the meaning of each error message and their explanations is posted on the Ontario Cannabis Store’s (OCS) Data Reconciliation Errors web page. 

Q. What should I do if I receive a data error notification?

A. If you receive a data error notification, review the error and make any necessary adjustments as soon as possible to help ensure the accuracy of your data. 

  • To resolve an error, you (or your POS provider) may be required to make a data submission to the POS Data Reporting Platform.
  • In some cases, you may need to contact your POS provider or OCS (e.g., invalid transfer) to resolve a data error.
  • If you are unsure, reach out to your POS provider for questions about, or assistance with, resolving error messages.

Q. Are there some data errors I can resolve myself, without the input of my POS provider?

A. In some cases, you can resolve an issue yourself. However, you often need support from your POS provider to resolve errors such as transfer errors. 

Q. What are the most frequent data errors?

A. Frequent data errors include:

  • Data quality errors (e.g., SKU and UPC barcode could not be matched, invalid SKU transfer)
  • Data continuity errors (e.g., negative inventory, transfers not balanced, inventory position quantity does not match observed quantity, SKU missing in inventory position)

Q. Once an error is corrected, is there a way to confirm it’s been corrected?

A. To resolve an error, the cannabis retailer (in collaboration with their POS provider) must make a data submission to the POS Data Reporting Platform. Once the new data has been processed and validated, the error should resolve, and the status of the error will from New/Existing to Resolved in the next email of error notifications. 

Q. What steps do I need to take to address the accumulation of unresolved errors?

A. Contact your POS provider to correct each error separately. If your POS provider cannot resolve them, reach out to the OCS Customer Service Team for assistance by calling 1-877-627-1627 or contact them through chat .

Q. What should I resolve first – the very old errors that keep showing up in my weekly error report or the new ones?

A. If you receive a data error notification, review the error and make any necessary adjustments as soon as possible to help ensure the accuracy of your data. 

To avoid an accumulation of errors, resolve your old errors first.

Q: Can more than one person receive data reconciliation error emails? 

A: At this time, only one contact can receive the data reconciliation error emails for each CRSA. If you would like to update your primary contact for receiving data reconciliation error emails, please reach out to the Customer Care Team by calling 1-877-627-1627 or contact them through chat .  

Q: What happens if I don’t resolve the error messages? 

A: All licensed cannabis retailers are subject to the Registrar’s Standards for Cannabis Retail Stores which outline your regulatory requirements with respect to record keeping.

To help ensure the accuracy of your data, we encourage you to review the data reconciliation errors you receive and make any necessary adjustments as soon as possible.

Q. What are my cannabis recordkeeping regulatory requirements?

A. For information about your cannabis recordkeeping regulatory requirements, please refer to the Cannabis Records: Requirements and Point-of-Sale Data Reporting Platform page and Section 8.0: Record Keeping Requirements of the Registrar’s Standards for Cannabis Retail Stores on the AGCO website. 

For questions about regulatory requirements, please reach out to the AGCO at customer.service@agco.ca .

Q: I received the data reconciliation error “Invalid Transfer (Sender/Recipient Not Approved for Transfer).” How do I resolve this? 

A: To resolve this error, please contact the AGCO at customer.service@agco.ca . To help ensure the accuracy of your data, we encourage you to review the data reconciliation errors you receive and make any necessary adjustments as soon as possible.

Q. How do I resolve a data continuity error caused by an inter-store transfer?

A. Data continuity errors are often caused during an inter-store transfer (i.e., when a product is moved between different retail stores under the acceptable avenues approved by the AGCO). 

To help resolve a data continuity error caused by an inter-store transfer, remember that:

  • An inter-store transfer is only completed once the receiving store acknowledges the transferred product.
  • Transferred products should not be removed from inventory until the receiving store completes the transfer.
  • Products should always be accounted for in a POS system. Inventory cannot be deducted from one retail location’s POS system without being added to another active retail store’s POS system at the same time. Inventory should always be associated with a specific retail store location.
  • Outgoing inter-store transfers must be reconcilable on the receiving store’s end. This means that the quantity sent out must match the quantity received.
  • If an outgoing shipment is not accepted by the receiving store and is returned to the sending store, the inventory should not be recorded as a transfer.

Q. How do I resolve errors related to math reconciliation on data from my POS system?

A. Contact the OCS to identify the date when your SKU quantity was no longer in alignment. Then perform a physical stock count and provide an adjustment transaction using the date where alignment became asymmetrical (OTHER_ADDITION / OTHER _REDUCTION) representing the difference between your submitted total and the expected total to bring both sides into alignment. 

Q. If an error notification is sent to two retailers (i.e., for a transfer), will I continue to receive an error notification if the other retailer has not made their corrections?

A. Yes, error corrections that involve two retailers require both retailers to resolve the error.

Helpful Resources

Data Reconciliation Error Messages:

Error MessageError Message DefinitionResolution

SKU could not be matched

SKU [<SKU>] could not be matched.

This error message indicates that we are unable to match this SKU. Please validate the SKU and update the information in your system.

UPC barcode could not be matched

UPC Barcode [<UPC_BARCODE>] could not be matched.

This error message indicates that we are unable to match this UPC.  Please validate the UPC and update the information in your system.

SKU and UPC barcode could not be matched

SKU [<SKU>] and UPC Barcode [<UPC_BARCODE>] could not be matched.

This error message means that both the SKU and/or UPC are invalid. Please validate both the SKU and UPC and update the information in your system.

Negative inventory

Observed negative inventory for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that aggregation of your data is displaying a negative inventory status. Please validate your on-hand inventory and update your system.

Transfers not balanced (sender)

Observed transfer imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>] sent to CRSA [<COUNTER_PARTY_CRSA>].

This error message indicates that the transfer has not been received on the receiving end. Please validate that the Counter Party CRSA is correct. If any changes need to be made, please contact your POS Provider for assistance.

Inventory position quantity does not match observed quantity

Observed Inventory Position imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that the aggregation of events does not equal the values in the Inventory Position. Please validate your on-hand inventory and update the information in your system.

Invalid SKU transfer (unexpected CROL)

Observed a transfer to unexpected CROL for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that we are unable to complete the transfer transaction as the Counter Party CRSA can not be validated.  Please validate that the Counter Party CRSA information is correct. If any changes need to be made, please contact your POS Provider for assistance.

Invalid SKU transfer (same CRSA)

Observed a transfer between same CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that the transfer is occurring with your own location, which is not permitted. Please validate that the transfer information is correct. If any changes are required, please contact your POS Provider for assistance.

Invalid SKU transfer (invalid CRSA)

Observed a transfer to invalid CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that we are unable to complete the transfer transaction as the Counter Party CRSA cannot be validated. Please validate that the Counter Party CRSA information is correct. If any changes need to be made, please contact your POS Provider for assistance.

Transfers not balanced (recipient)

Observed transfer imbalance for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>] received from CRSA [<COUNTER_PARTY_CRSA>].

This error message indicates that the transfer has not been sent on the sender's end. Please validate that the Counter Party CRSA is correct. If any changes need to be made, please contact your POS Provider for assistance.

SKU and UPC barcode mismatch

SKU [<SKU>] and UPC Barcode [<UPC_BARCODE>] were matched for different products.

This error message indicates that both the SKU and UPC for this transaction reference different products. Please validate the SKU and UPC and update the information in your system.

SKU missing in inventory position 

SKU [<SKU>] has no associated Inventory Position

This error message indicates that the inventory position for this SKU does not exist in the system. Please validate that the indicated SKU is included in the Inventory Position file.

Invalid Transfer (Sender Not Approved for Transfer)

Observed a transfer from unexpected CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that the Sender transfer store is not approved for this type of transfer with AGCO.Please validate that the Sender transfer store is correct. Please contact the AGCO for assistance.

Invalid Transfer (Recipient Not Approved for Transfer)

Observed a transfer to unexpected CRSA for SKU [<SKU>] starting on [<POS_TRANSACTION_DATE>].

This error message indicates that the Recipient transfer store is not approved for this type of transfer with AGCO.Please validate that the Recipient transfer store is correct. Please contact the AGCO for assistance.