Table of Contents
- Sales
- Purchases
- Inventory Roll-Forward
- Month-End Inventory
- Outstanding AR - Month End
- Outstanding AP - Month End
Introduction
Canix is a powerful software that is used to track inventory and costs.
In this document, we explain how to run common month-end reports used by accountants.
Reporting Tips
It's recommended to schedule these reports for delivery to your email every month. This provides the report at the specific time and date you want each month, allowing you to capture true month-end values before changes are made in the new month.
Follow these steps to schedule email delivery to you and your team.
All reports can be exported to CSV or Excel spreadsheet. Follow these steps to export reports.
Sales
Total Sales Orders In A Month
This report will show you all of the sales orders that were delivered or created in a certain month.
To find this, go to the Sales Orders Over Time report, and change the Delivery Date, or the Created At date, to your desired date range.
Tabs at the top of this report provide different sales order details, such as viewing by line items sold in the specified time range, packages, payments or invoices.
Total Sales Invoices by Month
The "Invoices" tab of Sales Orders Over Time report will show you all of the invoices that were created or Delivered in a certain month. The filters applied at the top of the dashboard apply to all tabs in this report, unless specified in parenthesis in the filter name.
Sales COGS by Month
On the “Orders” and "Packages" tabs of the Sales Orders Over Time Report, there are columns showing:
- Total Labor COGS
- Total Cannabis COGS
- Total NCI COGS
Purchases
Purchase Orders by Month
Go to the Purchase Orders Over Time report to view total purchase order values for the filtered month. Select the Requested Delivery Date filter to update the date range in the report.
Purchase Order Items by Month
Go to the Purchase Order Items Over Time report to view cannabis and non-cannabis items purchased in the filtered month. Select the Requested Delivery Date filter to update the date range in the report.
Inventory Roll-Forwards
Inventory Rollforward Reports show the changes in a given inventory type over the specified time period. See additional details below for each report.
The Package Rollforward shows the change in Cannabis Packages between the start and end dates. Quantities are normalized to consistent units. The report contains one tab for Grams/Milliliters and another tab for Pounds/Gallons and a third tab which displays the change in Costs.
Please Note the following limitations:
- Changes in Metrc will not be recorded
- When running the report across multiple facilities, Internal Transfers will show in both the Received and Transferred
- If a single Package is Transferred in and out of the same facility multiple times, we will show the Quantity Received and Quantity Shipped Dates based only on the most recent two transfers.
The column definitions are as follows:
| Column Name | Definition |
| Start Quantity |
The Quantity of the Packages for each Item at the Start Date. Calculated by summing Packages Created and Packages Received less the total Quantity consumed in production, wasted via Adjustments, or Sold/Transferred. |
| Created | The sum of the Original Quantity of Packages where the "Packaged Date" is between the Start and End Date (including the Start and End Date), where Original Quantity is the Quantity of the Package when it was first created in Canix. This column excludes Packages that are included in the "Received" column. |
| Received | The sum of the Original Quantity of Packages where the "Received Date" is between the Start and End Date (including the Start and End Date), where Original Quantity is the Quantity of the Package when it was first created in Canix. |
| Consumed |
The Quantity pulled from Packages of this Item to create other Packages where the Created Date of the Package Conversion record is between the Start and End Quantities. This column is displayed as a negative value. Please note: The current iteration of this report includes Split Packages of the same Item in both the Consumed and Created columns. For example splitting 100 units of 1/8ths into cases of 20 would result in -100 in the consumed column and +100 in the created column, netting to 0 change for the Item. A future update is planned for this report which will have this scenario displayed as 0 in each column in this scenario. |
| Adjustments | The Quantity of Adjustments for the Item where the Adjustment Date is between the Start and End Date. |
| Sold |
The Quantity of Packages in "Transferred" status where the "Last Active Date" (Transferred Date) is between the Start and End Date AND the Package is associated to a Sales Order in Canix. When using the LeafLink integration Sales Orders created from LeafLink will also be represented in this column after the Packages are allocated to the Sales Order in Canix. |
| Transferred | The Quantity of Packages in "Transferred" status where the "Last Active Date" (Transferred Date) is between the Start and End Date AND the Package is NOT associated to a Canix Sales Order. |
| Other Changes |
This column displays changes not accounted for in the other columns. This could potentially happen from a Metrc sync, or from a Package being depleted past 0 quantity accidentally.
There should be very few rows in the report that display a quantity in "Other Changes". If you see these quantities appearing regularly please contact help@canix.com for investigation. |
| End Quantity | The Start Quantity plus Created, Received and Adjustments (if adjustments are net positive) minus Consumed, Adjustments (if adjustments are net negative, the most likely scenario), Sold and Transferred. |
| Start ($) |
The costs on the Packages for each Item at the Start Date. Calculated by summing Package Original Cost at Creation, Cost of Packages Received, and the Non-Cannabis materials and Labor costs added before the start date less the total cost consumed in production, or Sold/Transferred. |
| Created ($) | The sum of the Original Costs of Packages where the "Packaged Date" is between the Start and End Date (including the Start and End Date), where Original Cost is the Cost of the Package when it was first created in Canix. This can include Non-Cannabis materials from Bill of Materials and Production Batches, as well as Labor added to Production Batches. This column excludes Packages that are included in the "Received" column. |
| Received ($) | The sum of the Original Cost of Packages where the "Received Date" is between the Start and End Date (including the Start and End Date), where Original Costs is the Cost of the Package when it was first created in Canix. |
| Costs Added ($) | Non-Cannabis Costs and Labor Costs manually added to Packages between the Start and End Date (based on the usage/labor date recorded) that were not included in the original creation of the Package. For example additional Packaging that occurs after Production. |
| Consumed ($) |
The costs pulled from Packages of this Item to create other Packages where the Created Date of the Package Conversion record is between the Start and End Costs. This column is displayed as a negative value. Please note: The current iteration of this report includes Split Packages of the same Item in both the Consumed and Created columns. For example splitting $1,000 into 5 cases would result in (-$1,000) in the consumed column and +$1,000 in the created column, netting to 0 change for the Item. A future update is planned for this report which will have this scenario displayed as 0 in each column in this scenario. |
| Sold ($) |
The Cost of Packages in "Transferred" status where the "Last Active Date" (Transferred Date) is between the Start and End Date AND the Package is associated to a Sales Order in Canix. When using the LeafLink integration Sales Orders created from LeafLink will also be represented in this column after the Packages are allocated to the Sales Order in Canix. |
| Transferred ($) | The cost of Packages in "Transferred" status where the "Last Active Date" (Transferred Date) is between the Start and End Date AND the Package is NOT associated to a Canix Sales Order. |
| End ($) | The Start Cost plus Created, Received and Costs Added minus Consumed, Sold and Transferred. |
Non-Cannabis Inventory Rollforward:
This report is currently in testing and will be released shortly!
The Non-Cannabis Rollforward shows the change in Non-Cannabis Lots between the start and end dates. Quantities are normalized to consistent units. The report contains one tab for quantity changes and one tab for cost changes.
The column definitions are as follows:
| Column Name | Definition |
| Start Quantity |
The Quantity of the Non-Cannabis Products before the Start Date. This value considers all Adjustments, Application and Quantities received/shipped before the Start Date. |
| Adjustments Logged |
The Quantity of NCI consumed that was not directly applied to any inventory with a Usage Date in between the Start and End Date specified. For example adjustments logged after cycle counts, or wasted quantities. |
| Applied to Inventory |
The Quantity of NCI consumed that was directly applied to a Package, Plant, Plant Batch or Harvest where the Usage Date specified is in between the Start and End Date specified. |
| Received from Purchase Order |
The Quantity of NCI where the Received Date is between the Start and End Date AND the Lot is associated to a Purchase Order. This includes lots created on Purchase Orders in Canix. |
| Other Created Lots |
The Quantity of NCI where the Received Date is between the Start and End Date and the Lot is NOT associated to a Purchase Order. This includes Lots created manually, or via the Uploader. |
| Sold | The Quantity of Lots that are associated to a Sales Order where the Usage Date of the Lot is between the Start and End date. The Usage Date corresponds to the date the Lot was allocated to the Order. |
| Transferred In | The Quantity of Lots that are associated to an internal Incoming NCI Transfer, where the Transfer Date is between the Start and End Date and the status of the Transfer is accepted. |
| Transferred Out |
The Quantity of Lots that are associated to an internal Outgoing NCI Transfer, where the Transfer Date is between the Start and End Date and the status of the Transfer is accepted. |
| De-Activated Lots | The Quantity of Lots that have been de-activated between the Start and End Date, based on the Last Active Date. |
| End Quantity |
The Start Quantity +Other Created Lots, Received from Purchase Order, and Transferred In, -Adjustments Logged, Applied to Inventory, Transferred Out, Sold and De-Activated Lots. |
| Start ($) |
The Costs of the Non-Cannabis Products before the Start Date. This value considers all Adjustments, Application and Quantities received/shipped before the Start Date. |
| Adjustments Logged ($) |
The Cost of NCI consumed that was not directly applied to any inventory with a Usage Date in between the Start and End Date specified. For example adjustments logged after cycle counts, or wasted quantities. |
| Applied to Inventory ($) |
The Cost of NCI consumed that was directly applied to a Package, Plant, Plant Batch or Harvest where the Usage Date specified is in between the Start and End Date specified. |
| Received from Purchase Orders ($) |
The Cost of NCI where the Received Date is between the Start and End Date AND the Lot is associated to a Purchase Order. This includes lots created on Purchase Orders in Canix. |
| Other Created Lots ($) |
The Cost of NCI where the Received Date is between the Start and End Date and the Lot is NOT associated to a Purchase Order. This includes Lots created manually, or via the Uploader. |
| Transferred In ($) | The Cost of Lots that are associated to a Sales Order where the Usage Date of the Lot is between the Start and End date. The Usage Date corresponds to the date the Lot was allocated to the Order. |
| Transferred Out ($) | The Cost of Lots that are associated to an internal Incoming NCI Transfer, where the Transfer Date is between the Start and End Date and the status of the Transfer is accepted. |
| Sold ($) |
The Cost of Lots that are associated to an internal Outgoing NCI Transfer, where the Transfer Date is between the Start and End Date and the status of the Transfer is accepted. |
| De-Activated Lots ($) | The Cost of Lots that have been de-activated between the Start and End Date, based on the Last Active Date. |
| End Quantity ($) |
The Start Cost +Other Created Lots, Received from Purchase Order, and Transferred In, -Adjustments Logged, Applied to Inventory, Transferred Out, Sold and De-Activated Lots. |
Month-End Inventory
If you’d like to see how much inventory is available on a certain date, select the “Quantity End Date” to be your desired date.
Then, go to the “Quantity End” column to see what the quantities are.
Outstanding AR - Month End
To find your current AR balance, go to Accounts Receivable (AR) Aging by Customer.
You can see your AR aging broken down by customer.
Outstanding AP - Month End
Go to your Accounts Payable report, where you will see your Outstanding Balance by Customer and Days Past Due.