Service Sales Detail Report

Modified on Fri, 7 Feb at 8:55 AM

This report shows a list of every service sale from closed tickets.

Things to know:

Appointments 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 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.
Refunds will show up on the date the refund took place rather than on the original ticket date. For example, if a service sale happened on November 13th but was refunded on November 23rd, this report will display the negative revenue on the 23rd rather than the 13th.
If multiple services are attached to an appointment you will see multiple entries on the report for the ticket (one for each service).
For pet merchants, the report will show the word “deceased” in parentheses next to the name of the pet that was marked as deceased.

To access this report:

Navigate to Dashboard
Select the Reports tab
Under the Point Of Sale section, select the Service 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 where the appointment took place.
Staff	The name of the staff member who performed the service.
Service Category	The category to which a service belongs. For example, a Men's Cut would belong to the Haircut category.
Service	The name of specific services performed in the filtered date range. You can filter by a specific service variation
Date	The date the ticket was closed.
Revenue At	If Revenue At Time of Use Legacy is selected: Revenue from gift card sales will not be displayed and 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
Date	The date the ticket with the appointment was closed.
Location	The location associated with the ticket.
Ticket	The classifying number associated with the ticket. Clicking this link opens the ticket in MyTime POS.
Appointment	The classifying number associated with the appointments. Clicking this link opens the appointment modal in Scheduler.
Client	Client associated with the appointment. Clicking this link opens the client's profile.
Staff	The staff member who performed the service during the date range and location selected. Clicking this link opens the staff member's profile.
Category	The category to which a service belongs. For example, a Men's cut would belong to the Haircut category.
Service	The name of the service
Count	The service's multiplier value
Unit Price	The value of each service before taxes and discounts were applied
Revenue	Prepaid revenue (revenue from services 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.
Service Discounts	Service discounts that were applied during the date range selected.
Refunds	Service refunds that were processed during the date range selected.
Net Revenue	Gross Revenue - Refunds - Prepaids - Discounts
Sales Tax	Tax applied to the service.
Refunded Tax	Tax refunds that were processed during the date range selected.

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