Cost of Goods report (v2)
Disclaimer
This article is only for the latest version of Zenoti Reports. Do not compare the data in this version with the data in the previous version.
Caution
You will see this report on the dashboard only if your business has enabled the Edit Lock (90 days) setting.
Note
First, try to enable this report for your organization. Refer to the Enable Specific Reports article for this. However, there is a chance that this report is not available for your organization. If so, you will not be able to see the report in the Reports > List of Reports section. If this is the case, reach out to your Zenoti representative to enable this report for you.
Inventory managers can use this report to view the cost of retail sales and refunds and the cost of bill of material at a center.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Cost of Goods report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you generate the report for over a year, click the Email button.
Column | Description |
Center Code | Unique code that identifies the center in which the product was sold |
Consumption Type | Type of consumption of the product |
Transaction Date | Date on which the product was sold, returned, or consumed |
Center Name | Center in which the product was sold, returned, or consumed |
Invoice No. | Invoice on which the product was sold, returned, or consumed For manual consumption, you can see Not Specified in this column. |
Guest Name | Guest name on the invoice who purchased or refunded the product |
Sold By | Employee who performed the transaction |
Service Code | Unique code that identifies the service in which the product was consumed |
Service Name | Service for which the product was consumed |
Product Code | Unique code of the product on the invoice |
Product Name | Name of the product on the invoice |
Product Type | Type of the product |
Qty | Number of items sold on the invoice |
Cost Of Goods | Perpetual average cost of the product |
Effective cost of goods | When the stock quantity falls into negative values and new stock is subsequently added, the system allocates the cost of goods sold (COG) for quantities below zero to the unit price of the most recently added product. This column holds this value. |
Brand | Brand associated with the product |
Category | Category to which the product belongs |
Subcategory | Subcategory of products that belongs to the selected product category. Product subcategory that is based on the category |
Business unit | Business unit to which the product belongs |
Size | Product size or quantity |
Color | Color of the product |
Configured purchase price | The purchase price of the product configured in the master |
Configured purchase price (incl discount) | The purchase price of the product configured in the master, including any discounts that were applied. |
COGS (Configured purchase price including discount) | The sum of all expenses related to producing or acquiring the goods. It is calculated as: COGS = (Configured purchase price) × (Quantity sold) |
Last procured price | The price at which the product was recently procured |
COGS (Latest procurement price) | Cost of goods sold based on the most recent purchase price from the transaction date. It is calculated as: COGS = (Last procurement price) × (Quantity sold) |