Welcome to the Help Center

Product Sales Detail Report

This report gives you a breakdown of product revenue for each unique SKU on a closed ticket.

Things to know:

  • Products on open tickets will not appear in the report until the ticket is closed
  • The revenue generated from product sales is assigned to the staff member chosen in the commission filter within the POS ticket
  • Refunds will show up on the date the refund took place rather than on the original ticket date. For example, if a product was purchased on November 13th but refunded on November 23rd, this report will display the negative revenue on the 23rd rather than the 13th.
  • When two distinct product SKUs are purchased together in a single transaction, the report will display two separate lines, with each line corresponding to a specific SKU
  • The report offers the option to incorporate brand, category, and vendor filters. However, the visibility of these filters is managed by a hidden setting that can only be activated by the MyTime team. For assistance in enabling this hidden setting, kindly reach out to our Support Team at support@mytime.com.
  • All columns are sortable except the SKU column 

To access this report:

  1. Navigate to the Dashboard

  2. Select the Reports tab
  3. Under the Point Of Sale section, select the Product Sales Detail report

11851141-9df3c7161131fede6109b63579f071aa.png

When the report opens, you can filter by a specific location, staff, and date. You can also choose to view the report by date or location. If the By Location button is used at the top of the report, you will be able to easily compare metrics across locations and location groupings to see which locations are doing better or worse on that dimension. You can also export to Excel, PDF, or print.

11185093-8665c18de5acce72bb5a7ec3bdb17f36__1___1_.png

Once you have selected your filters, click on the UPDATE button to generate the desired data.

Report Filters

Filter Description
Location The location where the product was sold
Staff The name of the staff member who sold the product
Product Categories Select products exclusively within a selected category or all categories. Note that this filter becomes visible only upon enabling the hidden setting
Brands Select products exclusively within a selected brand or all brands. Note that this filter becomes visible only upon enabling the hidden setting
Vendors Select products exclusively assigned to a specific vendor or all vendors. Note that this filter becomes visible only upon enabling the hidden setting
Date The date the product was sold.  
Revenue At

If Revenue at time of purchase is selected, the prepaid column is displayed, and products that were paid for with a membership, package, or gift card are deducted from the revenue column.

If Revenue at time of use is selected, the prepaid columns will be hidden and there will be no revenue displayed for products that were paid for with a membership item credit or package

Report Columns

Column Description
Date The date the product was purchased
Location The location associated with the product sale
Ticket The classifying number associated with a ticket. Clicking this link opens the ticket in MyTime POS
Client Client associated with the purchase. Clicking this link opens the client's profile
Staff The name of the staff member assigned in the commission filter on the POS ticket.
Product The full name of the SKU.
SKU The unique stock-keeping unit associated with the specific version of a product
Category Category associated with the product
Brand Brand of the product
Vendor The vendor responsible for supplying the product
Quantity Sold The quantity sold for each product
Unit Price The price of each product before taxes and discounts were applied
Revenue Total revenue generated from each product sold before taxes and discounts were applied. Prepaid amounts will be deducted from the product revenue when "Time of Use" is selected.
Prepaid Includes package, gift card, referral credit, membership item, and value credit redemption for products. The Prepaid column will not be displayed if the "Revenue at the time of use" filter is selected.
Discounts Product discounts that were applied during the date range selected.
Refunds Product refunds that were processed during the date range selected.
Net Revenue Product Revenue - Product Refunds - Product Discounts
Total Cost The price paid to the vendor for each SKU. 
Profit Net Revenue - Total Cost
Sales Tax Tax applied to the product.
Refunded Tax Tax refunds that were processed during the date range selected.

 

For more information, contact us at support@mytime.com.            

 

Powered by Zendesk