Product Sales Analysis Report

Modified on Mon, 3 Feb at 4:22 PM

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 saved or closed.
Any additional payments made on tickets closed in the past will be reflected on the date the payment was processed.
- Example: If a ticket for a product was closed in October for $20 and later edited in November with an additional payment of $10:
  - The revenue for October will remain at $20.
  - The revenue for November will reflect the additional $10 payment.
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:

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

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.

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.
Product Categories	Select products exclusively within a selected category or all categories.
Date	This range will determine the appointments that were booked during the date range selected.
Revenue At	If Revenue At Time of Use Legacy is selected: Revenue from gift card sales will not be displayed a the gift card column will be hidden Prepaid revenue (revenue from services, classes, or products redeemed through membership item credit or package credit) will not be displayed as the prepaid column will be hidden Membership value credits will be deducted from the membership revenue If Revenue At Time of Use is selected: Revenue from gift card, membership, and package sales will not be displayed Prepaid revenue (revenue from services, classes, or products redeemed through memberships, packages, or gift cards) will be displayed in the respective column If Revenue At Time of Purchase is selected: Revenue from gift card, membership and package sales will be displayed in the respective columns Prepaid revenue (revenue from services, classes, or products redeemed through memberships, packages, or gift cards) will be displayed in their respective columns and then deducted from the prepaid column

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	Prepaid revenue (revenue from products redeemed through membership item credit or package credit) will not be displayed if the "Revenue At Time Of Use Legacy" filter is selected.
Prepaid	This includes package, gift card, referral credit, membership item, and value credit redemptions. The Prepaid column will not be shown if either the "Revenue At Time Of Use" or "Revenue At Time Of Use Legacy" filters are 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	Gross Revenue - Refunds - Prepaids - 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.