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-Forward
Go to the “Inventory Roll-forward”, and change the “Quantity Start Date” to the beginning of the period you’re looking to see, and the “Quantity End Date” to the End of the period.
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.