Cost Of Goods v2 Report

-----------------------------------------------------------------------------------------------------------------------------
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.
-----------------------------------------------------------------------------------------------------------------------------

The Cost of Goods report retrieves detailed information on the sale of retail and consumable products at your centers as well as the cost associated with those products.

Note: You will see this report on the dashboard only if you have the Edit Lock (90 days) option enabled for your business.

This article contains the following sections:

Navigation
Filter Criteria
Column Descriptions

Navigation

In Zenoti, from the main menu, click the Reports icon.
Click Try the New Version.

3. Search for and open the report.
The Cost of Goods report opens on a new tab.

4. Depending on your requirement, select the desired filters.
Note: You can view the report only for those centers to which you have access.

5. Click Refresh.
The report is generated based on the selected filters.

Filter Criteria

Filter Name	Options	Description
Centers	All List of centers	View report for all centers or for only the selected centers.
Stock Costing Method	Perpetual Average Cost	Filter the cost of goods data for a particular method of stock costing.
Transaction Date	Yesterday Today Last 7 days Last 14 days This Month 2 Months 3 Months 6 Months 1 Year Custom	Select the day or date range on which the product was sold, consumed, or restocked.
Product Type	All Retail Consumable	Filter the cost of goods data for the required type of product: retail, consumable, or both.
Consumption Type	For Consumable: Service Consumption Manual Consumption All For Retail: Sale Refund & Restock All	Select the type of consumption of the product. The list options are displayed depending on your selection for the Product Type list.
Category	All List of categories	View report data for all product categories or for only the selected product categories.
Brand	All List of brands	View report data for all brands or for only the selected brands.

Column Descriptions

Column Name	Description	Additional Information
Center Code	Code of the center in which the product was sold, consumed, or restocked.
Consumption Type	Type of consumption of the product: Sale (for Retail products) Refund & Restock (for Retail products) Service Consumption (for Consumable products) Manual Consumption (for Consumable products)
Transaction Date	Date on which the product was sold, consumed, or restocked.
Center Name	Name of the center in which the product was sold, consumed, or restocked.
Invoice No.	Invoice number of the transaction: For Consumption Type as Sale: Invoice number of the product on which the product was sold. For Consumption Type as Refund & Restock: Invoice number of the product invoice. For Consumption Type as Service Consumption: Invoice number of the service invoice. For Consumption Type as Manual Consumption: The invoice number is not updated and Not Specified is displayed for the field.
Cust Guest Name	Name of the guest displayed on the invoice who purchased the product or refunded the product.
Sold By	Name of the employee who performed the transaction.
Service Code	Code of the service during which the product was consumed.	Notes: This value is displayed only if you have selected Consumption Type as Service Consumption. For other consumption types, Not Specified is displayed for the field.
Service Name	Name of the service for which the product was consumed.	Notes: This value is displayed only if you have selected Consumption Type as Service Consumption. For other consumption types, Not Specified is displayed for the field.
Product Code	Code of the product that is displayed on the invoice.
Product Name	Name of the product that is displayed on the invoice.
Product Type	Type of the product: either Retail or Consumable.
Qty	Number of items sold as part of the invoice.
Brand	Brand to which the product is associated.
Cost Of Goods	Cost of the product sold based on Perpetual Average cost method.
Category	Category to which the product belongs
Subcategory	Subcategory of products that belongs to the selected product category
Size	Product size or quantity
Color	Color of the product