Master center metrics report

Center Name

Name of the center where the activity occurred.

Name of the center where the transaction or activity took place.

Center Code

System-generated code identifying the center.

Unique system-generated identifier assigned to the center.

Display Name

Guest name as shown on reports.

Full name of the guest as displayed in reports.

Company Name

Company or organization associated with the guest.

Company or organization associated with the guest.

Date

Date on which the transaction or activity occurred.

Specific date when the transaction or activity occurred.

Month

Month during which the activity occurred.

Calendar month in which the transaction or activity occurred.

Week Day

Day of the week for the activity.

Day of the week corresponding to the transaction or activity date.

Service Refund

Total amount refunded for services.

Total amount refunded for service items.

Product Refund

Total amount refunded for products.

Total amount refunded for product items.

Service sales without tax

Service sales including discounts.

Total sales from services, including discounts but excluding refunds. Only Service is considered as the item type, not Day Package or Promo Package. Sale type includes both Sale and Charge.

Note: Unlike other reports, this also includes sales from Day Packages. For example, if a Day Package contains multiple services, their value is counted under service sales here.

Service sales with tax

Total sales from services including tax.

Total sales from services including tax. This value is calculated as {Service Sales (Excl. Tax)} – {Taxable Redemptions}.

Product Sales

Product sales including discounts and taxes.

Total sales from products, including discounts but excluding refunds.

Service discount

Discounts applied to services.

Discounts given on service sales. It captures promotional offers, coupons, or manual discounts applied to service invoices.

For example, if a $100 facial is discounted by $20, the Service Discount is $20.

Product discount

Discounts applied to product sales.

Discounts provided on retail products. This includes promotional markdowns, loyalty redemptions, or special offers applied at checkout.

For instance, if a $50 shampoo is sold with a $5 discount, the Product Discount is $5.

Service discount (free service)

Discounts treated as free service sales.

Campaigns and manual discounts that account for free service sales for the provider.

Service discount (non-free service)

Discounts not treated as free service sales.

Campaigns and manual discounts that do not account for free service sales for the provider.

Product discount (free service)

Product discounts treated as free service sales.

Campaigns and manual discounts that account for free product sales for the provider.

Product discount (non-free service)

Product discounts not treated as free sales.

Campaigns and manual discounts that do not account for free product sales for the provider.

Custom in register

Custom payments in register.

Custom payments recorded in the cash register.

Cash payouts

Cash withdrawn for business expenses.

Cash payouts made from the register for various purposes.

Cash in Register

Cash in register before adjustment.

Total cash in the register before any adjustments are made.

Cash Adjustments

Corrections to cash in register.

Adjustments made to the cash register total.

Cash Deposited

Cash deposited to vault or bank.

Amount of cash deposited into the business's bank account.

CC In register

Credit card totals in register.

Total amount of credit card transaction in register before any adjustments are made.

Card Adjustments

Adjustments to credit card totals.

Adjustments made to the credit card transactions total.

Check in register

Check payments recorded in register.

Total amount of checks recorded in the cash register.

Cash transfers

Cash moved between registers or locations.

Cash transferred between registers or accounts.

Total petty cash expenses

Petty cash used for expenses.

Total expenses covered by petty cash.

Production hours

Total hours the employee spent on sales-generating tasks.

The actual number of hours the employee spent checked in to a production work task.

Non-production hours

Total hours the employee spent on non-sales-generating tasks.

The actual number of hours the employee spent checked in to a non-productive task.

Redo Count

Number of services redone for guests originally served by the employee.

The number of times the employee had to redo a service.

Void Count

Number of invoices voided after creation.

Number of voided invoices, including invoices marked as void or those invoices where all items have been deleted.

Products #

Number of products sold, including refunds.

Number of products sold at each center including refunds.

Services #

Number of services performed, including refunds.

Number of services sold at each center including refunds.

Gift Cards #

Number of gift cards sold.

Number of gift cards that are sold at each center.

Provider Requested #

Number of invoices where the guest specifically requested the employee.

The total number of invoices generated for the services where the employee was specifically requested.

Gift Card Redemptions (Excluding Tax)

Gift card redemptions excluding tax.

Amount paid using a gift card excluding any applicable taxes. This does not include tips, SSG, environmental fee, and so on.

Gift Card Redemptions (Including Tax)

Gift card redemptions including tax.

Amount paid using a gift card including any applicable taxes. This does not include tips, SSG, environmental fee, and so on.

Gift Card Tips

Tips paid using gift cards.

Tips that are paid using a gift card.

Gift Card sales

Sales from gift card and prepaid cards sales.

Total amount of Gift Cards sold.

Gift Card discount

Discount applied on gift card sales.

Total discount applied on the gift cards that also account for the difference between their value and price.

Total guests

Number of unique guests served at the center.

Number of unique guests on the specific date within the selected time period.

Walk-in invoices

Invoices created and completed on the same day without prior appointment.

Total number of invoices where the creation and service dates are the same.

Service tax

Tax collected for services, excluding refunds.

Tax collected for services, excluding refunds. Service Refunds are available as a column.

Product tax

Tax collected for products, excluding refunds.

Tax collected for products, excluding refunds. Product Refunds are available as a column.

Cash tips

Tips collected in cash.

Tips paid through cash.

Card tips

Tips paid through card payments.

Tips paid through card.

Custom tips

Tips paid using custom-defined payment methods.

Tips paid through custom payment.

Total Male invoices

Total number of unique invoices per day for male guests.

Total unique invoices from male guests, counted separately for each day within the date range and then aggregated.

Total Female invoices

Total number of unique invoices per day for female guests.

Total unique invoices from female guests, counted separately for each day within the date range and then aggregated.

Total invoices from new guests

Count of invoices from new guests

Count of unique invoices from guests whose profiles were created during the selected date range.

Total invoices from existing guests

Count of invoices from returning guests.

Count of unique invoices from guests whose profiles were created before the selected date range.

Service Shop cost

Total cost incurred to deliver services attributed to the employee.

The predefined expense for a specific service, configured from the General tab while creating the service.

Shop cost is shown at the appointment level and reflects the value recorded during appointment creation.

For day packages, the cost is distributed across services based on:

(Service Price ÷ Total Service Price of Day Package) × Shop Cost defined at the package level.

In payroll, shop costs are captured at the end of each pay period, whereas in this report, they are recorded at the time of appointment creation. Therefore, shop costs in this report may differ from payroll and should be used only for estimation.

Payroll gives precedence to employee-level shop costs over service-level costs. Therefore, shop costs in this report may not align with those in payroll. These should be used solely for cost estimations.

Total Sales per Production Hours

Ratio of total sales to production hours.

Indicates sales efficiency by dividing total sales by total production hours. Helps assess how effectively employee working hours convert into sales.

Service invoices per Production Hour

Number of service visits handled per production hour.

Average number of service visits completed for each production hour worked by stylists.

It is calculated as,

Service Visits / Stylist (Production) Hours = Service Visits/ Stylist (Production) Hours

Commissionable Service Sales per Production Hours

Commissionable service sales per stylist production hour.

Average commissionable service sales generated for each production hour worked by stylists.

It is calculated as,

Commissionable Service Sales $ ÷ Stylist (Production) Hours

In-service productivity

Ratio of actual service hours to stylist production hours.

Actual service hours performed by stylists to their total production hours.

It is calculated as,

Actual Service Hours/ Stylist (Production) Hours

In-service hours

Total duration between actual start and end times for services marked as both Start and Complete.

Total time spent delivering services, based on actual start and complete timestamps recorded in invoices.

Average in-service time

Average in-service time per invoice with a service item.

Average duration that guests spend receiving services.

It is calculated as,

Average In-Service Time = Sum of invoice service time/ number of invoices with a service item type

Average Haircut Time

Average duration of haircut services.

Calculates the mean time taken to complete haircut services.

Haircut quantity

Number of haircut services performed.

Total number of services delivered under the Haircut Services category during the selected period. This includes all completed service appointments within the haircut category.

Walk-in invoices with no requests

Number of walk-in invoices with no requested time and no specific provider.

Count of all walk-in invoices that include at least one service item type where none of the services have a requested time specified, and the visit is a non-specific request (no provider selected).

Walk-in invoices with requests

Number of invoices with no requested time and a specific provider request.

Counts of all invoices with service item types where none of the services have a requested time specified, and the visit is a specific request, meaning a particular provider or staff member was selected.

Walk-in invoices

Number of service invoices where no services have a requested time.

Count of all invoices that include at least one service item type, where none of the services on the invoice have a requested time specified.

Reservation invoices

Number of invoices where at least one service has a requested time.

Counts of all invoices with service item types where one or more services have a requested time specified.

Reservation invoice with no requests

Number of reservation invoices with no specific provider request.

Count of all reservation invoices that include at least one service item type, where the booking is a non-specific request (no particular provider selected).

Reservation invoice with requests

Number of reservation invoices with a specific provider request.

Count of all reservation invoices that include at least one service item type, where the booking is a specific request, a particular provider or staff member was selected.

Request invoices

Number of invoices with a specific provider request.

Count of all invoices with service item types where the visit is a specific request, meaning a particular provider or staff member was selected by the guest at the time of booking.

Average invoice wait time

Average wait time between guest arrival and service start.

Average time guests wait before their first service begins. It is determined by dividing the total invoice wait time across all invoices with at least one service item by the total number of such invoices.

Average invoice wait time for walk in with no request

Average wait time for walk-in invoices with no specific provider request.

Average time guests wait before their first service begins on walk-in invoices where no specific provider was requested.

It is calculated as, Average Invoice Wait Time (Walk-in No Request) = Sum of invoice wait time/ number of walk-in invoices with no request

Average invoice wait time for walk in with request

Average wait time for walk-in invoices with a specific provider request.

Average time guests wait before their first service begins on walk-in invoices where a specific provider was requested.

It calculated as,

Average Invoice Wait Time (Walk-in with Request) = Sum of invoice wait time/ number of walk-in invoices with requests

Average invoice wait time for reservation with no request

Average wait time for reservation invoices with no specific provider request.

Average time guests wait before their first service begins on reservation invoices where no specific provider was requested.

It calculated as,

Average invoice Wait Time (Reservation No Request) = Sum of invoice wait time/ number of reservation invoices with no request.

Average invoice wait time for reservation with request

Average wait time for reservation invoices with a specific provider request.

Average time guests wait before their first service begins on reservation invoices where a specific provider was requested.

It calculated as,

Average Invoice Wait Time (Reservation with Request) = Sum of invoice wait time/ number of reservation invoices with requests.

Days with no invoices

Number of days the center was closed.

Counts business days without operations due to holidays, maintenance, or other reasons.

Online Bookings Quantity

Bookings made online.

Count of online bookings from Webstore and CMA.

Online booking Percentage

Percentage of bookings made online.

Percentage of online bookings from Webstore and CMA.

POS Bookings Quantity

Bookings made at POS.

Count of Point of Sale (POS) bookings.

POS Bookings Percentage

Percentage of bookings made at POS.

Percentage of Point of Sale (POS) bookings.

Kiosk Bookings Quantity

Bookings made at kiosk.

Count of kiosk bookings.

Kiosk Bookings Percentage

Percentage of bookings made at kiosk.

Percentage of kiosk bookings

Re-booked Quantity

Guests who rebooked.

Count of rebookings.

Re-booked percentage

Percentage of guests who rebooked.

Percentage of rebookings.

Advance booking quantity

Number of invoices for advance bookings with no rebooked services.

Count of all invoices with service item types where no service was rebooked and the booking date is earlier than the appointment date.

Advance booking percentage

Percentage of service visits booked in advance.

Share of service visits that were booked ahead of the appointment date, excluding rebooked services.

It calculated as,

Advance Booking % = (Advance Booking Quantity/ Total Service Visits) × 100

Same Day Booking > 2 hours Quantity

Bookings made > 2 hours in advance.

Count of invoices where no service was rebooked and Booking Date = Appointment Date, and the booking time is more than 2 hours before the requested start time (original time for walk-ins).

Same Day Booking > 2 hours Percentage

Percentage of bookings made > 2 hours in advance.

Percentage of same-day bookings more than 2 hours before service.

Same Day Booking ≤ 2hrs Quantity

Bookings ≤2 hours in advance.

Count of invoices where no service was rebooked and Booking Date = Appointment Date, and the booking time is within 2 hours of the requested start time (original time for walk-ins).

Same Day ≤2 hours Percentage

Percentage of bookings ≤2 hours in advance.

Percentage of same-day last-minute bookings.

Memberships sold to Guests

Number of memberships sold and added to guest profiles.

Count of all memberships that were sold and successfully added to guest profiles during the selected date range.

Member sales

Net sales from guests with an active membership.

Net sales generated from invoices associated with guests who have an active membership at the time of purchase.

Non-Member Sales

Net sales from guests without an active membership.

Net sales generated from invoices associated with guests who do not have an active membership at the time of purchase.

Member Sales %

Percentage of net sales from guests with an active membership.

Percentage of net sales generated from invoices associated with guests who have an active membership at the time of purchase.

Non-Member Sales %

Percentage of net sales from guests without an active membership.

Percentage of net sales generated from invoices associated with guests who do not have an active membership at the time of purchase.

Average Member Invoice

Average net sales per member invoice.

Average net sales amount for invoices associated with member guests.

It is calculated as,

Average Member Invoice = Member Net Sales/Member Visits

Average Non-Member Invoice

Average net sales per non-member invoice.

Average net sales amount for invoices associated with non-member guests.

It is calculated as,

Average Non-Member Invoice = Non-Member Net Sales/ Non-Member Visits

Member Service Invoices

Number of service invoices made by members.

Count of all service invoices associated with guests who have an active membership at the time of the visit

Non-Member Service Invoices

Number of service invoices made by non-members.

Count of all service invoices associated with guests who do not have an active membership at the time of the visit.

Invoices with service or product

Number of invoices containing at least one service or product item.

Count of all invoices that include at least one item of type service or product (retail).

Invoices with service and product

Number of invoices containing both service and product items.

Count of all invoices that include at least one service item type and at least one product (retail) item type.

New Service Invoices

Number of first-visit invoices with at least one service item.

Count of all invoices that include at least one service item type where the visit is the guest’s first visit.

Repeat Service Invoices

Number of invoices from returning guests containing one or more service items.

Total number invoices that include at least one service item and are associated with visits that are not the guest’s first visit.

Service Invoices

Total number of visits that included services.

Count of invoices containing one or more service items.

Invoices with service and product %

Percentage of invoices that included both service and product items.

Proportion of service invoices that also contain at least one product item type.

It is calculated as,

Invoices with Service and Product % = count of combo visits/ count of service visits

Service Only Invoices

Number of invoices with only service item types.

Count of all invoices that include at least one service item type and no other item types.

Product Only Invoices

Number of invoices with only product item types.

Count of all invoices that include at least one product item type and no service or other item types.

Average Invoice (service or product)

Average net sales per invoice with at least one service or product item.

Average value of net sales from invoices that include at least one service or product item type.

It is calculated as,

Average Invoice (Service or Product) = Net Sales from invoices with service or product/ Number of such invoices.

Average Invoice (service)

Average sales per service invoice.

Calculated as total service sales divided by the number of service visits.

Combo percentage

Percentage of visits with both service and product.

Share of visits that included both services and products compared to total visits.

Product percentage of sales

Percentage of sales from retail.

Proportion of total net sales that come from product (retail) sales.

It is calculated as,

Product Percentage of Sales = Net Retail Sales/ Net Sales

Production Hours

Total hours checked in as production work tasks.

Total number of hours employees have logged under production work tasks with Is Production Hour flag enabled.

It includes only the hours marked as productive or billable time, excluding administrative, break, or non-production activities.

Net Service Sales per Production hour

Service sales per hour.

Net service sales generated for each production hour worked by stylists.

It is calculated as,

Net Service Sales/ Stylist (Production) Hours

Net Sales

Total net sales from services and products after discounts, loyalty redemptions, and refunds.

Total net sales from services and products after discounts, loyalty redemptions, and refunds.

Net sales represent the combined total of net service sales and net product (retail) sales. This value reflects the actual sales realized across all item types after deducting applicable discounts, loyalty redemptions, and refunds.

For instance, if Gross Product Sales is $500 and a $50 discount is applied, the Net Product (Retail) Sales will be $450.

Net Sales per Production Hours

Total net sales per stylist production hour.

Average net sales (from both services and products) generated for each production hour worked by stylists.

It is calculated as,

Net Sales / Production Hour = Net Sales/ Stylist (Production) Hours

Gross Service Sales

Gross service sales including discounts.

Gross service sales including discounts. Gross service sales = Net service sales + total discounts.

Gross Product Sales

Gross product sales including discounts.

Gross product sales including discounts. Gross product sales = Net product sales + Total product discounts.

Net service sales

Net service sales after discounts, loyalty redemptions, and refunds.

Net service sales after discounts, loyalty redemptions, and refunds.

Net service sales represent the total sales from service item types after deducting applicable discounts, loyalty point redemptions, and any refunds issued. This value reflects the actual sales realized from services.

Net product sales

Net product sales after discounts, loyalty redemptions, and refunds.

Net product sales after discounts, loyalty redemptions, and refunds.

Net product sales represent the total sales from product item types after deducting applicable discounts, loyalty point redemptions, and any refunds issued. This value reflects the actual sales realized from products.

Discount

Total discounts applied on services and products.

Discounts represent the combined value of all discounts given on service and product (retail) sales. This amount is the sum of Service Discount $ and Product Discount $, reflecting total reductions applied before calculating net sales.

Service category net sales

Net sales and percentage by service category.

Net service sales (after discounts, before taxes) grouped by service category such as Hair, Spa, Nails, or Massage. The percentage indicates each category’s contribution to total net service sales.

For example, Hair services may contribute $10,000 (40%) of total service sales.

Service category quantity

Number of services performed per category.

Count of services performed within each category.

For example, under the Hair category: 120 services, under Massage: 45 services.

Service category discount

Discounts applied within each service category.

Discounts provided for services within a specific category.

For example, if $500 of discounts were given for Hair services and $200 for Spa services, the respective amounts will display under this column.

Service redemption

Loyalty points redeemed on invoices for service sales.

Total loyalty points applied or redeemed as payment on invoices containing service item types.

Product redemption

Loyalty points redeemed on invoices for product sales.

Total loyalty points applied or redeemed as payment on invoices containing product (retail) item types.

Service guests

Number of guests with an invoice containing a service.

Count of all unique guest profiles that have at least one invoice with a service item type.