Business Snapshot

Modified on Thu, 16 Jan at 12:35 PM

The Business Snapshot report compiles data from multiple reports into a single, downloadable PDF. The report allows you to automatically capture periodic point-in-time summaries, across various types of data. This report is useful in quickly understanding the overall company performance across different metrics.

Things to know:

When running the report based on closed ticket dates, only services and product sales associated with closed tickets will be included, with the report reflecting the date the ticket was closed.
When running the report based on service date, all services and their appointment values will appear, regardless of ticket status. For more accurate reporting, we recommend running the report based on closed ticket dates, especially if you collect and record payments through MyTime.
The "Include Compensation" checkbox determines whether the Staff Compensation table is included in the generated PDF report. By default, this checkbox is unchecked, as including compensation data for multi-day date ranges significantly increases the time required to generate the business snapshot report.
If the "track compensation by staff member" setting is not enabled on your account, the "Include Compensation" checkbox will not be visible, and the Staff Compensation and Staff Metrics tables will not be included in the generated snapshot.
The Payment Received table will include referral credits and loyalty points only if the business is configured to offer these incentives to clients.
The Total Collected column on the Collections Adjustment table and the Total column on the Payments Received table generally align but may show discrepancies in cases where a deposit was taken. This difference arises from the data sources used:
- The Payments Received table pulls data from the Daily Payments report, which records transactions based on the date payments were processed, regardless of whether the ticket was closed.
- The Collections Adjustment table reflects net revenue from the Daily Revenue report, which tracks revenue based on the ticket's closing date or the appointment date (if no ticket is present).
  Example Scenario:
- An appointment is scheduled for March 9th with a value of $200, and a deposit of $50 is taken on March 4th.
- When the snapshot is generated for March 4th, the Payments Received table will show $50 as revenue for the deposit.
- On March 9th (the appointment date and ticket closure date), the Payments Received table will display the remaining $150 for the service (excluding the deposit), while the Collections Adjustment table will show the full $200 as revenue.
The Register table will only be displayed if the snapshot is generated for a single day. It will be hidden when the snapshot is generated for multiple days or date ranges
If "Recognize revenue at time of use legacy" is selected:
- The Gift Cards column will not be displayed on the Revenue Summary table
- The Prepaid column will not appear on the Collections Adjustments table
- Membership value credits will be deducted from the membership revenue
If "Recognize revenue at time of use" is selected:
- The gift card, membership, and package columns will be hidden, which means that revenue from gift card, membership and package sales will not be displayed
- The prepaid column will be hidden; however, prepaid revenue (revenue from services, classes, or products redeemed through memberships, packages, or gift cards) will be displayed in the respective columns and included in the gross and net amounts after deducting discounts and refunds
If "Recognize revenue at time of purchase" is selected:
- The gift card, membership and package columns will be displayed on the Revenue Summary table
- The prepaid column will appear in the Collections Adjustments table

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
To include the compensation table or not

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 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).

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

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/appointments 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 - Available Bookable Hours (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 - Productive 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.