Product Sales Detail Report

Modified on Wed, 9 Jul at 4:25 PM

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

Things to know:

The ability to access this report is governed by the "Accessing Reports" access control settings
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.
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
When filtered by "Revenue At Time of Purchase," membership, gift card, and package redemptions appear in their respective revenue columns (e.g., Service, Class, or Product) and the Prepaid column. The value is deducted from gross revenue to calculate net revenue. If the “Deduct Prepaid Amount from Gross Revenue in Reports” hidden setting is enabled:
- Prepaid redemptions are automatically deducted from gross revenue and shown as $0.
- The Prepaid column is hidden entirely from the report.
To request activation, please contact your account manager or email support@mytime.com.

To access this report:

Navigate to the Dashboard
Select the Reports tab
Under the Point Of Sale section, select the Product Sales Detail 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 associated with the product sale Accounts with One Location: No location filter is shown Accounts with Multiple Locations: The location filter allows you to view data for a specific location or all locations within that account
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 Use (Legacy)” is selected: Gift card sales revenue will not be displayed – the Gift Card column is hidden. Prepaid revenue (from services, classes, or products redeemed using membership item or package credits) will not be displayed, as the Prepaid column is hidden. Membership value credits will be deducted from membership revenue, reducing the amount shown in the Membership column. If “Revenue At Time of Use” is selected: Revenue from gift card, membership, and package sales will not be displayed. Prepaid redemptions (for services, classes, or products paid for using memberships, packages, or gift cards) will be displayed in the appropriate revenue columns (e.g., Service, Product, Class). The Prepaid column will not be displayed. If “Revenue At Time of Purchase” is selected: Revenue from gift card, membership, and package sales will be displayed in their respective columns. Prepaid redemptions (services, classes, or products paid for using memberships, packages, or gift cards) will be displayed in the relevant revenue columns (e.g., Service Revenue, Product Revenue, Class Revenue), and also shown in the Prepaid column, which deducts the total prepaid amount from Gross Revenue to calculate Net Revenue.

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	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 column includes redemptions made using package credits, gift cards, referral credits, and membership item or value credits. The Prepaid column is not displayed when the report is filtered by "Revenue At Time Of Use" or "Revenue At Time Of Use (Legacy),
Discounts	Product discounts that were applied during the date range selected.
Refunds	Product refunds that were processed during the date range selected.
Net Revenue	Gross Revenue - Refunds - Prepaids - Discount
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.