This report shows appointment history and revenue by client. Appointments and revenue can be sorted to see your most valuable customers.
Things to Know:
- For pet merchants, the report will show the word “deceased” in parentheses next to the name of the pet that was marked as deceased.
- Taxes and tips are not included in this report.
- Canceled appointments are not reflected in this report.
- Refunds will show up on the date the refund took place rather than on the original ticket date. For example, if a service was completed on November 13th but refunded on November 23rd, the Client Type Revenue report will display the negative revenue on the 23rd rather than the 13th.
- When analyzing revenue from bookings made by clients, the total revenue should be split equally among all clients added to the multi-staff appointment. For example, if three clients were included in the appointment for a combined service that totals $300, each client will account for $100 in revenue.
-
Revenue at Time of Use:
- The prepaid and gift card columns will be hidden
- No revenue displayed for items that were paid for with a membership item credit or package
- Membership value credits will be deducted from the membership revenue
-
Revenue at Time of Purchase:
- The prepaid column will be displayed
- Revenue from items paid with a membership, package, or gift card will be recorded in the prepaid column and deducted from the gross revenue.
To access this report:
- Navigate to Dashboard
- Select the Reports tab
- Under the Bookings section, select the By Client report
When the report opens, you can filter by a specific location, staff, and date. 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.
Below the By Location button, you have the option to download the report as a CSV, PDF, or print version.
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 will take place |
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:
If Revenue at time of use is selected:
|
Report Columns
Column | Description |
Client | Client associated with the appointment. Clicking this link opens the client's profile. |
Phone Number | Phone number of the client |
Email address of the client | |
First Booking | The date of the client's first booking |
Appointment Time | The date and time the appointment took place |
Appointment # | The classifying number associated with an appointment. Clicking this link opens the appointment modal in Scheduler. |
Ticket # | The ticket associated with the appointment. Clicking this link opens the ticket in MyTime POS. |
Service Revenue | Service revenue earned for the date range selected. Prepaid amounts will be deducted from the service revenue when "Time of Use" is selected. |
Prepaid | Includes package, gift card, referral credit, membership item, and value credit redemption for services. The Prepaid column will not be displayed if the "Revenue at the time of use" filter is selected. |
Refunds | Service refunds that were processed during the date range selected. |
Environmental Fees | Revenue generated by environmental fees collected during the date range selected. Does not include taxes. |
Total | Total service revenue generated for the date range selected (Service Revenue - Refunds + Environmental Fees). |
For more information, contact us at support@mytime.com.