Business Snapshot

Modified on Mon, 16 Mar at 12:21 PM

The Business Snapshot compiles data from multiple sources into a single, downloadable PDF. It provides periodic point-in-time summaries across various metrics to help you understand overall company performance at a glance.

Things to know:

Access to this report is controlled by the “Accessing Reports” access control setting
Closed Ticket Date: When run using this filter, the report includes only services, classes, and product/membership/gift card/package sales linked to closed tickets.
Service Date: When run using this filter, all services and appointment values appear regardless of ticket status. For the most accurate financial reporting, we recommend using Closed Ticket Date.
Staff Compensation: The "Include Compensation" checkbox determines if the Staff Compensation table is included. It is unchecked by default to reduce report generation time. This option is only visible if "Track compensation by staff member" is enabled in your account settings.
The layout and logic of your report change significantly based on your selected revenue filter:
Revenue at Time of Use
This filter tracks revenue when a service is actually performed or a product is handed over
Gift Card, Membership, Package, and Prepaid columns are hidden
Revenue from redemptions appears in the respective Service, Class, or Product columns (net of discounts and refunds)
Tips paid via gift card or membership value credit, the full tip amount is displayed in the TIPS column, ensuring totals align with your Tips Report.
Revenue at Time of Purchase
This filter tracks revenue the moment the client pays for an item or credit
Gift Card, Membership, Package, and Prepaid columns are displayed
Collected surcharges are displayed in the Collections Adjustment table
Tips paid via gift card or membership value credit are excluded from the TIPS column in the Collections Adjustment table to avoid duplicate reporting of funds already collected.
The Total Collected column in the Collections Adjustment table and the Total column in the Payments Received table will typically match. However, differences may occur in situations involving deposits or gift card redemptions. These discrepancies exist because each table pulls data from a different report and uses different date logic.
Payments Received Table
Pulls data from the Daily Payments report
Records transactions based on the payment processing date, regardless of ticket status
Includes gift card redemptions
Collections Adjustment Table
Pulls prepaid and net revenue data from the Daily Revenue report
Revenue is based on the ticket close date, or the appointment date if no ticket exists
Gift Card Redemptions & Tax
Timing: If a gift card is redeemed on Sept 18 for an appointment on Sept 23, the Payments Received table shows it on Sept 18, while the Collections Adjustment table shows it on Sept 23.
Tax Handling: The Daily Revenue report does not track sales tax. If a gift card covers a $20 service and $2 tax:
The Prepaid column will only show the $20 service portion
When cross-referencing, add the tax portion back to the Prepaid column to align totals.
Ticket Edits & Tax Recalculation
If a ticket is edited after the original close date, the tax adjustments are recorded on the date the edit occurred: Example:
A ticket closed May 7 with $1.65 tax is edited July 8 to add a service with $1.00 additional tax.
May 7 Report: Shows only the original $1.65
July 8 Report: Shows the additional $1.00
Forfeited Deposits (Cancellation Fees): If a deposit is kept by the business after a cancellation, it is reclassified as a Cancellation Fee. Example: A client pays a $25 deposit but cancels their appointment. If you choose not to refund them, the $25 will appear in the Cancellation Fee column on the date the appointment was canceled and the ticket was finalized.
The Register table is only displayed when generating a snapshot for a single day. It is hidden for multi-day date ranges
To keep the report clean, the system automatically hides columns for features you do not use (e.g., if you don't offer Classes, the Classes column will not appear)
MyTime uses a precision of six decimal places (e.g., $210.132356) for all Snapshot calculations to ensure accuracy.

To access the business snapshot:

1. Navigate to your dashboard

2. Next, select the Business Snapshot PDF link

3. Set your desired filters

Location
Staff
Date
Recognized revenue at time of purchase/time of use
Generate based on service date or closed ticket date
Include / exclude compensation data

4. Select the Generate button

See below the list of tables shown on the snapshot, where the data is taken from and the definition of the columns on each table.

Table

Column Definition

Revenue Summary - This table takes data from the Daily Revenue Report. Compilation of revenue types and totals from closed tickets. This table does not include net revenue.

Note: Not available with 'service date filter.'

Services - Revenue for all appointments during the date range.

Classes - Revenue for all classes and events during the date range.

Products - Revenue for all products sold during the date range. This includes miscellaneous charges.

Gift Cards - Revenue for all gift cards sold during the date range.

Packages - Revenue for all packages sold during the date range.

Memberships - Revenue for all memberships sold and recurring membership charges during the date range.

Environmental Fees - Revenue for environmental fees collected during the date range.

Cancellation Fees - Revenue for all cancellation fees collected and deposits retained by the business after a cancellation during the date range.

Gross Revenue - Sum of all revenue.

Collections Adjustments - This table adjusts gross revenue to show how much money was actually collected.

Note: Not available with 'service date filter.'

Prepaid - Includes package redemption, membership item and value credit redemption, gift card redemption.

Refunds - Includes refunds for all item types (service, product, class, membership, package, gift card, misc. fee, cancellation fee). Refunds are reflected on the date the refund was processed, rather than the original ticket date. For example, if an item was purchased on November 13th for $100 but refunded on November 23rd, the report will display the original revenue on November 13th and the refund on November 23rd.

Discounts - Includes discounts for all item types (service, product, membership, package, gift card, misc. fee, cancellation fee).

CC Surcharge - Shows the total amount collected from credit card surcharges.

Net Revenue - Gross Revenue - Prepaid - Refunds - Discounts.

Taxes - This column takes data from the Sales Tax Collected report. Includes all tax collected.

Tips - This column pulls data from the Tips report and reflects the net amount of tips received, calculated as:

Net Tips = Gross Tips - Tip Discounts - Tip Refunds - Tip Prepaid (tips covered by gift card or membership value credits)

Total Collected - Net Revenue + Taxes + Tips

Payments Received - The data displayed is from the Daily Payments Report. It shows all payments received by payment method from open & closed tickets, broken down by payment method, regardless of whether a register was open at the time the payment was received.

Registers - Takes data from the Register Closeout Report. It shows the cash changes in the register.

Note: The table is not available when if you run the business snapshot report over a date range rather than for a single date. This is because registers must be closed each day and we will automatically close open registers at midnight (and assume a perfect count) if the staff forgets to close the register before leaving for the day.

Service Revenue - The data displayed is from the Service Sales Detail report.

It displays every service sale from closed tickets.

Service Name - The name of the service as displayed on the service menu.

Count - The number of services performed.

Revenue - Total revenue for each service variation.

Discounts - This shows all discounts that were applied to services including membership discounts.

Refunds - Includes all service refunds.

Profit - Value is the same as Net Revenue. Calculation is Revenue - Discounts - Refunds.

Product Revenue - The data displayed is from the Product Sales Detail report.

It displays every product sale from closed tickets.

Product Name - The name of the product as shown in the inventory.

Count - The number of products sold.

Revenue - Total revenue for each product sold. This also includes miscellaneous fees.

Discounts - This shows all discounts that were applied to products including membership discounts.

Refunds - Includes all product refunds.

Cost Of Goods - Sums of all the SKU item stock cost x quantity

Profit - Revenue - Discounts - Refunds

Sales Tax - Tax collected for the product sold.

Refunded Tax - Portion of the sales tax that was refunded.

Booking Source - The data displayed is from the Source of Booking Report. It displays the booking source of each appointment booked during the date range.

Google - The client booked the appointment from your Google listing.

Facebook - The client booked the appointment from your Facebook page.

Mobile App - The client booked the appointment from the custom Guest App.

Online Booking - The client booked the appointment from the My Favorites or My Purchases option in My Account, or from using the Book Now button on your website that redirects them to the MyTime website (mkp or express checkout) links.

Website Online Booking - The client booked the appointment from your website using the Book button that opens the modal without actually redirecting to the MyTime website.

Added by Business - A staff member booked the appointment for the client in-store

MyTime Import - MyTime imported your appointments from your previous software.

Walk-In Online Booking - A client added themself to the walk-in waitlist online

Walk-In - A staff member added the client to the waitlist

Walk-In Kiosk - A client was added to the waitlist via kiosk

Appointment Schedule - Key production metrics are displayed. The information is compiled from multiple reports.

Guests Served - Unique guests OR clients with appointments.

Services Performed - Counts all services (not appointments) performed during the date range. It does not include no-shows or canceled appointments. The data displayed is from the By Service report.

Utilization - Hours Worked / (Hours Available * bookings per time slot). The data displayed is from the Calendar Utilization Report.

Productive Hours Available - Scheduled hours for the date range. The data displayed is from the Staff Productivity report.

$ per Available Hour - Service Revenue / Productive Hours Available

Productive Hours Worked - Hours that were booked with appointments. The data displayed is from the Appointment History report Add up all the appointment durations.

$ per Worked Hour - Service Revenue / Productive Hours Worked.

Client Type - The data displayed is from the Client Type report. It shows appointments and revenue by new and existing clients.

Appointment Status - The data displayed is from the Appointments report. Appointment status totals for appointments on schedule.

Staff Metrics - The data displayed is taken from the Staff Productivity and Compensation reports. It shows key staff productivity metrics that are useful in driving performance improvements.

Note - Only staff members who have ‘Track Compensation’ enabled on their profile will be shown in the report.

Staff - The name of the staff member as shown on their staff profile.

Retail Sales / Hour - Product sales / Clocked Hours

Service Sales / Hour - Service Sales / Clocked Hours

Clocked Hours - Total productive and non-productive clocked hours logged.

Prod Hours - Total productive clocked hours.

Appts - Number of appointments done during the date range.

Services - Revenue for all services/appointments performed during the date range.

Products - Revenue for all products sold including miscellaneous charges during the date range.

Packages - Revenue for all the packages sold during the date range.

Gift Cards - Revenue for all gift cards sold during the date range.

Memberships - Revenue for all memberships sold during the date range.

Discounts - Discount for all item types.

Refunds - Refund for all item types.

Staff Compensation - The data displayed is taken from the Daily Compensation report. It shows commissions generated per staff member, along with tips received for the date range selected.

Note - Only staff members who have ‘Track Compensation’ enabled on their profile will be shown in the report.

Staff - The name of the staff member.

Hours Pay - The hourly wage amount entered on the staff profile. The amount is only calculated for clocked hours.

Services - Service commission for all appointments performed by the staff member during the date range.

Products - Product commission for all products sold by the staff member during the date range.

Packages - Package commission for all packages sold by the staff member during the date range.

Gift Cards - Gift card commission for all gift cards sold by the staff member during the date range.

Memberships - Membership commission for all memberships sold by the staff member during the date range.

Tips - Include tips for the staff member that were not withdrawn.

Backbar - Back bar fees are fees that a stylist or employee incurs for using products at a salon or business. The fee is deducted from the staff member's commission.

Compensation - Total commission for staff members.

Related Articles: