Reports Terminology

Updated 4 months ago by Kory Lamme

Both SuperSalon and iOffice share a multitude of reports to track almost every aspect of a salon's business. Because many of them share a significant amount of the same basic information, major differences between them are mostly cosmetic, and cater to the individual users desire on how the data is filtered.

Terms and Definitions

Average Cut Time

The Average Cut Time is calculated based off of the ticket service times. It only factors in tickets that are sold with a service categorized as Haircut.

Average Time Between Cuts

The Average Time Between Cuts is calculated based off of the time in between tickets that are sold with a haircut on them.

Commission

The Commission total, usually represented as Com. on most reports, is a figure calculated using a mix of the same guidelines to calculate Net and Gross. Only services or products that are eligible for commission are included in the total and this is further affected by any discounts that are used during the transaction as well as Non Commissionable Shop Charges.

In order to ensure that the number for this total is accurate, it is important to make sure that “Apply Discount to Sale Commission” Discounts is configured properly, as well as the correct discounts are used on Check-Out. It is also important to make sure that any Non Commissionable Shop charges are set up properly prior to sales taking place. Non Commissionable Shop charges directly subtract from the Commission amount of a service.

Because of the nature of this field, it is not unusual for the total to fall somewhere in between Net and Gross or even to be the same amount as either of the two other totals depending on your system settings.

Count

The count field is used throughout many of the different SuperSalon reports to refer to how much of a particular item there is. This could be anything from the number of times a discount was used to how many times a certain service or product was sold. This field adapts itself to the report in question when displaying its numerical data.

Customer Statistics

Customer Statistics include Customer Age, Gender, Source, if they’re New or Recurring, as well as which offers and requests they’ve accepted. All of the totals for the statistics are calculated based off of the information entered at the time of customer creation and are only counted when the customer is used on a ticket that completes Check-Out.

When the Statistics are listed in the various iOffice reports, they are usually presented with a count of the number of customers who fall into that category, and in some cases, the amount of Net or Gross revenue generated from their visits. At times, this is further broken up between Net Service/ Product and Gross Service/Product.

In situations where Customer Data is not known because it was not entered, iOffice uses a separate category called Unknown to display the information.

Discounts

Reports that show discount amounts do so by looking at which discounts are applied to a service or product at the time of Check-Out. The total amount subtracted from a particular product or service sale will then be displayed. In order to ensure that the totals represented in this column are accurate, it is important to make sure that the discounts your locations choose to use are set up properly as well as applied correctly at the time of Check-Out.

Discounts have modifiers such as “Free Service” or “Bounce-Back” which can also be used to gather specific data demographic data.

Gross/Net

Gross is the amount of money the location brought in before discounts are subtracted from the total. Net is the amount of money the location brought in after discounts are subtracted from the Gross. Both figures do not include sales tax or employee tips in their total.

When iOffice is reporting Net and Gross it is taking a look at the transaction data generated from employees entering tickets into the system. Since Net and Gross are dependent on ticket information, it is important to make sure that when checking out customers, it is done properly. A misentered ticket could potentiality throw off the calculation resulting in bad data being reported.

iOffice has the ability to divide Net and Gross up between Product and Service sales. In situations where this is occurring, the information is calculated the same way as before, except instead of looking at all of the location’s sales data, iOffice confines it to revenue generated from Product or Service sales. Since iOffice looks at the individual items on a ticket when calculating this information, tickets that include both products and services will still have their information accurately reported.

Because gift cards and certificates do not fall under either Products or Services, they are tracked separately from the two. When a Gift Card/Certificate is sold to a customer, it will have no affect on either the Net or Gross for Product/Service sales. Product/Service Net and Gross will only be affected at the time the Gift Card/Certificate is actually redeemed. It will, however, factor into the Total Net/Gross figures.

Total Net and Total Gross are calculated by adding together Product and Service Net/Gross along with any other extraneous sales figures such as Gift Card/Certificates and Requests

Gross/Net Services or Products an Hour

This figure is calculated by taking the Gross and Net totals for product and/or services and dividing it by the total production hours an employee has. Another name that this figure is also known by is PPH (Production Per Hour).

Haircuts

The Haircut field is calculated using the transaction data from the time of Check-Out. It is the number of services sold that have their Category set as Haircut. Even if a service has the word “Haircut” in it’s name, if the category is not set properly as “Haircut” it will not be counted towards the total.

Haircuts/Hour

When the total number of haircuts an hour is displayed, this figure is calculated by dividing the Haircut count with the Production hours for a given employee.

Non-Production/Production Hours

Production and Non-Production hours are calculated based off of the position used when an employee clocks in. If an employee clocks in under a position that is not flagged for production, then calculations that require production hours to complete their calculations will be incorrect.

In almost all cases, employees who perform services or sell products will want to be clocked in using production hours while employees who focus only on administration or receptionist duties will want to be clocked in under a position not flagged for production.

iOffice displays hours that are not considered Production as “Other Hours”. In situations where employees have both Production Hours and Other Hours, these are combined into a third field known as Total Hours.

Payment Methods

On reports that deal with Closeout Information, a list of the different payment methods created in the system as well as the amount they have closed out with will be displayed.

Products Per Guest (PPG)

PPG is calculated by dividing the Net Product sales total by the Total Number of Customers to visit the location during the date range selected.

Refund/Redo

Refund totals are calculated using the service and product information entered at the time of Check- Out. On every report where the Refund amounts are listed, this figure has already been subtracted from the location Net and Gross totals, as well as the Commission total if applicable. There is no need to manually subtract the totals yourself as this figure is mostly for auditing purposes.

Redo totals are calculated using the service information entered at the time of Check-Out. Redoes vary slightly from refunds in that they are specific to service sales. When a refund is completed in iOffice, the funds for the service or product are given back to the customer.

When a Redo is completed, the service is both refunded and sold back to the customer so there is no gain or loss to the location. For auditing purposes, on reports where refunds are listed, the Refund total will increase by the amount that was refunded to the customer without taking into account the service that was sold back.

Reported +/- and Actual +/-

This field appears on certain reports as a diagnostic aid to determine whether or not the location is uploading their information to iOffice correctly. It does so by comparing the computed close out totals in the iOffice database to the ticket totals in the iOffice database. In the event the two fields do not match, that usually means that the upload did not complete correctly and it is necessary to re-save the closeout and upload again.

Requests

Requests are calculated using the service request feature. When an employee is selected as being requested by a customer, it increases the request count for that employee. Because Requests are counted as a service, they can artificially inflate your service count and even average service sales (if your location charges for employee requests).

This can be circumvented by turning off the option that includes Requests in Service Sales (See Software Settings). If this is done, requests will be counted separately from the service totals.

Retail to Net (RTN)

Retail to net is the percentage of retail sales to total net sales. It is calculated by taking the net product sales, dividing it by the total net (combination of product, service, gift, requests), and then multiplying the resulting number by 100.

On the payroll report, RTN is calculated using the Product and Service Commission totals as opposed to actual Net.

Retail to Service [Net] (RTS)

Retail to Service Net is the percentage of retail sales to net service sales. It is calculated by taking the net product sales, dividing it by the net service sales, and then multiplying the resulting number 100.

On the payroll report, RTS is calculated using the Product and Service Commission total as opposed to true net.

Sales Per Hour (SPH)

SPH is specific to the payroll report. Whereas PPH is calculated using Net and Gross depending on what the report is trying to accomplish, SpH is always calculated by dividing the employee Commission total by the number of production hours worked for the given time range.

Service and Product Categories

On reports that provide a breakdown of different service and product sales based on their category, the information is pulled from the transaction data created when a ticket has finished Check-Out. In order to ensure that the correct categories are presented, it is important to make sure service and product categories are set up correctly.

Ticket Average

Ticket Average, or T.A., is calculated by adding together the total of amount due for all completed tickets during a given range and then dividing the resulting number by the amount of completed tickets there were.

Depending on the report, modifiers can be used to provide a more thorough breakdown, such as only giving the ticket average for male or female customers, or even only giving the average service sale or product sale per ticket.

Tips

Tips are calculated using the employee tip information entered at Check-Out. In order to ensure that accurate tip data is gathered for employees, it’s important to make sure that “Track Employee Tips” on page 75 is enabled and that employees are actually entering their tip data.

By default, any tip on a credit card transaction that is not assigned to an employee will be credited towards house.

Voids

Reports that list the total number of voids pull the data from tickets that have been cancelled. Only tickets that have their status set as void are counted in the calculation.


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)