Welcome to the Help Center

Product Sales Analysis Report

This report shows inventory turn, revenue, and profit by SKU.

Things to know:

  • Products on open tickets will not appear in the report until the ticket is closed.
  • Sales tax is not included in the product revenue displayed.
  • 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.

To access this report:

  1. Navigate to Dashboard
  2. Select the Reports tab
  3. Under the Point Of Sale section, select the Product Sales Analysis report

11845476-310fb02b856b9d9148fc2d87df8c0cf6.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 also have the ability to 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 appointment is scheduled.
Staff The staff member who performed the service during the date range and location selected.
Date This range will determine the appointments that were booked during the date range selected.
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 product revenue column.

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

Report Columns

Column Description
SKU Name The full name of the SKU.
Brand The brand name of the product.
Quantity Sold The quantity sold for each product.
Product 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 dollar credit redemption for products. The Prepaid column will not be displayed if the "Prepaids at the time of use" filter is selected.
Product Discount Product discounts that were applied during the date range selected.
Product Refund Product refunds that were processed during the date range selected.
Net Revenue Product Revenue - Product Refunds - Product Discounts
Product Cost The price paid to the vendor for the SKU. 
Profit Net Revenue - Product Cost
 

 

 

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

Powered by Zendesk