This report shows inventory turnover, revenue, and profit by SKU.
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.
- 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.
- When filtered by "Revenue At Time of Purchase," product sales covered by membership, gift card, or package will appear in the product revenue column 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 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 product was sold.
|
| Staff | The name of the staff member assigned in the commission filter on the POS ticket. |
| Product Categories | Select products exclusively within a selected category or all categories. |
| Date | The date the product was sold. |
| Revenue At | If “Revenue At Time of Use (Legacy)” is selected:
If “Revenue At Time of Use” is selected:
If “Revenue At Time of Purchase” is selected:
|
Report Columns
| Column | Description |
| SKU Name | The full name of the SKU. |
| Brand | The brand name of the product. |
| Category | Category associated with 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 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), or when the “Deduct Prepaid Amount from Gross Revenue in Reports” hidden setting is enabled. |
| 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.
Related Articles:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article