The Cost of Goods Sold (COGS) report surfaces each product variant's profitability for the selected time frame. This report also breaks down total units sold, total revenue, total cost, and margin per product sold.
This report is useful for:
Viewing the profitability of product variants.
Viewing the profitability of products by vendor by exporting the data and filtering by vendor.
View a breakdown of units sold.
All figures in the report will:
Account for refunds
Include discounts
Exclude taxes
Adding Cost Information for a Product
To add cost information for a product, navigate to Products and select “Edit” on the product of interest.
If the product is set to “All Locations”, select “Edit” for one of the product variants and enter the cost of the product under “Unit Cost.”
If the product is set to “By Location”, select “Edit” for any of the product variants, then navigate to the location(s) for which you’d like to enter the cost.
If you update the cost associated with an item, this will be recorded for future sales but will not impact historical sales data.
Pulling up the Report
Navigate to Reports from the left panel > Inventory > Cost of Goods Sold > View.
Specify the date range from the date picker.
This report sums all relevant transactions for the selected time frame. If items were refunded during the period selected, the refunded items are accounted for in the relevant Variant’s row.
Apply any additional filters.
Select Generate Report. and export the data if necessary.
Understanding the Report
The Cost of Goods Sold report includes 22 data fields:
Product Type: Classification of product.
Product Type cannot be changed once a product has been uploaded and is linked to the tax rate.
Product: Name of the product at the time of purchase.
Variant Color: If applicable, the variant color (i.e., for a red shirt).
Variant Size: If applicable, the variant size (i.e., for a size small shirt).
Each variant will populate its own row.
Vendor: Brand of product.
This field is optional and will update to reflect any changes.
Location: Location where the product was sold/refunded.
Currency: Currency configured for the location of the sale.
If a single product is sold/refunded in multiple currencies, the product will surface as multiple rows (for each currency)
Total Cost: The sum of the cost of each item sold during the period selected.
When a sale occurs, Mariana records the cost currently set for the item sold -- it is “locked in” for historical reporting.
$0 appears for items where:
The unit cost was left blank.
$0 was explicitly entered as the unit cost.
The same number of sales and refunds (with the same cost) occurred during the period selected.
Total Revenue: The total revenue for the variant at each location over the period selected. This figure is net of refunds and discounts.
$0 will appear in instances where the same number of sales and refunds (with the same price per item) occurred during the period selected, as well as if all items were priced at or discounted to $0.
Profit: Total Revenue - Total Cost.
Margin: Profit divided by Total Revenue.
Purchased Quantity: The quantity of product sold.
Refunded Quantity: The quantity of product refunded.
Total Quantity: Purchased Quantity - Refunded Quantity.
Current Cost: The unit cost of the product (or variant) is set to now.
Average Unit Cost: When a sale occurs, Mariana records the Cost currently set for the item sold -- it is “locked in” for historical reporting. “Average Unit Cost” is the average Cost of units sold over the time period selected. This will be equal to the Cost configured for the variant unless the Average Unit Cost was updated during the applicable period.
Current Price: The price the product (or variant) is set to now.
Average Unit Price: The average revenue generated by (or unit price of) units sold during the period selected after any discounts were applied.
This will vary from the price configured from the variant if the price was updated over the selected period and/or one or more discounts were applied to applicable orders.
Barcode
This data will never change. If a product's barcode changes and you generate an updated report, the data will still reflect the barcode of the product at the time of purchase.
SKU
This field will update to reflect any SKU changes.
Product ID: ID of sold product (Parent ID)
This data will never change.
Variant ID: ID of the product variant (Child ID)
This data will never change and is one number higher than the Product ID.