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

  1. In Zenoti, from the main menu, click the Reports tab.
    The Reports Dashboard page opens.

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

Enables you to view the 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

Enables you to 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

Enables you to 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

Enables you to view the report data for all product categories or for only the selected product categories.

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.

Cost Of Goods

Cost of the product sold based on Perpetual Average cost method.

Did this answer your question?