The COGS report provides a high level and granular view of how much each product you’ve sold costs to make, your profits, and your margins.
You can easily sort the report by batch, margins, and profit for a quick analysis of your costs. Sneak a peek below. And for the Excel wizards and accountants, you’ll have a foundational report that can save you hours of time.
Benefits of the COGS report:
Get quick insights into your profit margins
See all of your costs side-by-side and which source materials may fluctuate
See which products or batches are profitable to make and which aren’t
Generate a more accurate P&L report for accounting
Better understanding of finances
Financial Reports:
You can pull your COGS report in Reports → Financial. Choose a date range for Sales Orders and which export you'd like to see: Granular View or Single Cost View, then download the CSV file. Note, you will only see COGS for completed orders.
You can also download your COG (Metrc Inventory) report for Metrc Inventory that will show you the cost of goods of your current active and WIP Metrc package inventory. WIP in this case refers to packages that are being used as an ingredient in a pending assembly.
Granular View
The granular view breaks down the cost of each individual input used in a product, plus the final cost of the finished product.
Click here to see an example of what a Granular View report download will look like.
Single Cost View
This is a higher level view and exports a report of how much the final product costs.
Click here to see an example of what a Single Cost View report download will look like.
How does my COGS report get calculated?
The report pulls data from all inventory that was purchased from October 8, 2020 onward
Cost is calculated from the line item price from the batch or package used on a PO
Approximate costs will populate based on default purchase cost on the product
COG (Metrc Inventory) Report:
The COG (Metrc Inventory) report allows you to view current active inventory and WIP Metrc package inventory that’s part of a pending assembly.
This allows you to see accurate costs of inventory that's not yet sold:
How can I guarantee seeing costs on my report moving forward?
Simply bring all of your inventory into Distru via a Purchase Order and you will see costs populate. You can still import a transfer as a Purchase Order even if you’ve already imported the packages from it, without doubling inventory.
If you can’t bring all of your inventory in through Purchase Orders, the next best thing is to fill in Purchase Costs for your inventory at the Product level.
Why am I not seeing costs on my COGS report?
Here are several scenarios that can result in empty values for your costs:
Positively adjusting inventory
Positive package repair
Source packages were not brought into Distru via a PO
Source packages have missing cost information (this can result in no values or partial values)
Packages were imported into Distru directly
Creating stock/batches out of thin air (Metrc only)
Source packages were purchased prior to Oct 8th