Ontario Customers: Manually documenting the compliance report (Optional)
BLAZE enables customers to download all the required compliance reports into the AGCO template with just one click. Each report will be generated into one template that can be submitted via the AGCO portal.
For more information, go to Ontario Customers: One-click compliance report (Recommended)
However, customers are still able to download individual reports and paste them into the AGCO template. This article will provide instructions for ON customers who choose to download, copy, and paste individual reports into the AGCO integrated template.
Individual Reports (Optional)
Customers can download and paste individual reports into the AGCO template. To download individual reports, click on the "Individual Reports" button in Step 4 (Reports > Compliance).
AGCO Reports: Overview
The AGCO "Integrated Cannabis Retail Reporting Template" has 9 worksheets within the reporting template which will be further explained. This article will also indicate which BLAZE report can be downloaded so the correct information can be pasted into the correct worksheet within the AGCO template.
-
Landing Page
-
Retailer Overview
-
Federal
-
Monthly Sales
-
Inventory Adjustments
-
Destructions
-
Inter-Store Transfer- Incoming
-
Inter-Store Transfer-Outgoing
-
Discrepancy Details
Differences when using the Individual Reports
The following sections explain any differences if you are not using the one-click feature. It will also provide steps on how to paste specific reports.
Landing Page
In the E) Data selection section:
-
Read each question and select from the drop-down menus in column B for all questions in this section. This will enable subsequent tabs and direct you as to what fields and tabs are required for your submission.
Federal Report
BLAZE customers can download the BLAZE "Federal" report and copy the data into the new AGCO template > "Federal" worksheet.
How to report:
-
Download the BLAZE "Federal" report.
-
On the "Inventory and Sales" worksheet, copy (CTRL+C) all the information under the column titles (A to V).
-
Paste the information (values only) to the existing columns in the new AGCO template> "Federal" worksheet.
Monthly Sales
BLAZE customers can download the BLAZE "Sales" report and copy the data into the new AGCO template > "Monthly Sales" worksheet.
How to report:
-
Download the BLAZE "Sales" report
-
On the "Sales Reporting" worksheet, copy (CTRL+C) all the information under the column titles (A to I).
-
Paste the information (values only) to the existing columns in the new AGCO template> "Monthly Sales" worksheet.
Inventory Adjustments
BLAZE customers can download the BLAZE "Inventory Adjustments" report and copy the data into the new AGCO template > "Inventory Adjustments" worksheet.
How to report:
-
Download the BLAZE "Inventory Adjustments" report
-
On the "Inventory Adjustments" worksheet, copy all the information under the column titles (A to G).
-
Paste the information (values only) to the existing columns (A to G) in the new AGCO template> "Inventory Adjustments" worksheet.
-
Column H = "Difference" is auto-calculated. It does not need to be “copied/pasted” from the BLAZE Report.
-
On the "Inventory Adjustments" worksheet, copy all the information under the column titles (I & J).
-
Paste the information (values only) to the existing column (I & J) in the new AGCO template> "Inventory Adjustments" worksheet.
Note: Customers using Windows PCs can edit the 'Date of physical inventory count 'yyyy/mm/dd' column format, before pasting Inventory adjustments report data to the AGCO template.
Note: Column H = "Difference" is auto-calculated. It does not need to be “copied/pasted” from the BLAZE Report. Note: The "Difference" column is validated against the Federal report “Other Additions Qty”
Note: Customers using Windows PCs can edit the date column format, before pasting Inventory adjustments report data to the AGCO template.
Destructions
BLAZE customers can download the BLAZE "Destructions" report and copy the data into the new AGCO template > "Destructions" worksheet.
How to report:
-
Download the BLAZE "Destructions" report.
-
On the "Destructions" worksheet, copy all the information under the column titles (A to M).
-
Paste the information (values only) to the existing columns (A to M) in the new AGCO template> "Destructions" worksheet.
Inter-Store Transfer-Incoming
BLAZE customers can download the BLAZE "Inter-Store Transfer-Incoming" report and copy the data into the new AGCO template > "Inter-Store Transfer-Incoming" worksheet.
How to report:
-
Download the BLAZE "Inter-Store Transfer-Incoming" report
-
On the "Inter-Store Transfer-Incoming" worksheet, copy all the information under the column titles (A to I).
-
Paste the information (values only) to the existing columns (A to I) in the new AGCO template> "Inter-Store Transfer-Incoming" worksheet.
Inter-Store Transfer-Outgoing
BLAZE customers can download the BLAZE "Inter-Store Transfer-Outgoing" report and copy the data into the new AGCO template > "Inter-Store Transfer-Outgoing" worksheet.
How to report:
-
Download the BLAZE "Inter-Store Transfer-Outgoing" report.
-
On the "Inter-Store Transfer-Outgoing" worksheet, copy all the information under the column titles (A to I).
-
Paste the information (values only) to the existing columns (A to I) in the new AGCO template> "Inter-Store Transfer-Outgoing" worksheet.