Payroll Report

Updated 5 months ago by Kory Lamme

Location: Reports > Payroll > Payroll

Comprehensive report for determining payroll costs and each of their components.

Use Cases by Role

  • Salon Owner: This is primarily the go to report for salon owners when tabulating their labor costs for each pay period.
  • Salon Manager: Salon managers can utilize this report both to help salon owners understand costs, and as a resource for their own queries.
  • Salon Employee: Stylists and other frontline salon staff may not see any value in this report, and may not be authorized to access it.

Data Filters

  • Select Store: Clicking or tapping here will open the interface that allows the user to select the store(s) that will be be used for the report.
  • Select Pay Period: For locations that utilize multiple pay periods, this drop down menu allows them to switch between them for the purposes of the report.
  • Select Date Range: This drop down menu enables users to select a date range of the report, based on established pay periods.
  • Select Export: Accounts that utilize different export methods for their payroll can toggle between them with this drop down menu.
  • Include OT in Labor Costs: Checking this box will factor in overtime hours when tabulating total labor costs.
  • Generate Report: Clicking or tapping on this button will generate the report based on the other filter criteria.

Metrics Tracked

Hours Section
  • E. #: The unique payroll ID number for the employee represented in the current row.
  • Employee: The name of individual staff members along with Receptionist, Stylist, and Store totals represented as well.
  • Total: The total hours accumulated by the given employee or position.
  • %: The percentage value of the hours associated with the staff member, compared to the whole.
  • Production: The total number of Production hours worked by the given employee/total.
  • Non-Production: The total Non-Production hours accumulated by the given employee/total.
  • Tips: The total dollar value of tips received by the staff member during the given pay period.
  • Regular: The total number of regular hours worked during the time frame of the report.
  • Overtime: The total number of overtime hours accumulated by the employee in the time frame of the report.
  • Additional: Any additional hours will be shown and tabulated in this column.
  • Vacation: If the staff member has used any vacation hours during the pay period, they will be shown in this column.
  • Holiday: The total number of holiday hours worked by the staff member during the timeframe of the report.
  • Split: This column will show the number of split shift hours that were worked by the staff member during the given time frame.
Non-Production Details
  • E. #: The unique payroll ID number for the employee represented in the current row.
  • Employee: The name of the individual employee corresponding to the row.
  • Non-Production Positions: Each time clock position that represents Non-Production will have its own column showing these three metrics:
  • #: Total hours worked at this position
  • Reg: The total number of regular hours worked at this position.
  • Over.: The total number of overtime hours worked at this position.
  • Off Floor Adjust: Any other adjustments from Production to Non-Production hours will be tabulated in this column.
  • Total: The far right column will contain totals for each of its associated rows, including a grand total.
Sales and Commission Totals
  • E. #: The unique payroll ID number for the employee represented in the current row.
  • Employee: The name of the individual employee corresponding to the row.
  • Hours: The total number of hours worked by the employee for the given pay period.
  • Guests Serviced: This column displays the total number of salon clients attended to by the employee.
  • RtS: This displays the percentage value of retail sales to net service sales
  • RtN: This column displays the percentage value of retail sales to total net sales.
  • Service
    • Sales: The total dollar value of all service sales by the staff member. Please note this is the Commisionable number, you can reference this on the Production Report
    • SpH: The dollar value of commission sales per hour for this employee.
    • Com.: The total dollar value of commission earned by the employee for service sales.
    • Bonus: Any bonuses earned by the staff member will be displayed with their dollar value in this sub column.
    • Req.: If employees receive a bonus for being specifically requested to perform a service, the dollar value will be represented here.
    • Total: The total dollar value of all commissions, requests, and bonuses.
  • Product
    • Sales: The total dollar value of all retail product sales made by the staff member. Please note this is the Commisionable number, you can reference this on the Production Report
    • SpH: The dollar value of commission sales per hour for this employee.
    • Com.: The total dollar value of commission earned by the employee for retail product sales.
    • Bonus: Any bonuses earned by the staff member will be displayed with their dollar value in this sub column.
    • Total: The total dollar value of all commissions and bonuses under the "Product" header.
  • Pay Rate: The current hourly pay rate for the given staff member. Employees who are salaried will show zeros for values here.
  • Base Pay: The current dollar value owed to the employee, without overtime or other factors.
  • OT Pay: The total dollar value of overtime pay currently owed to this staff member.
  • Add/Vac/Hol Pay: Any additional money owed to the staff member from additional, vacation, or holiday sources is listed in this column.
  • Com. Total: The total dollar value of commissions currently owed to the employee.
  • Gross Pay: The total gross dollar value of wages owed to the staff member for the current pay period.
  • Labor Cost: This column displays the percentage value for every staff member in regards to overall labor costs.

Report Calculations

Sales and Commission Totals
  • RtS: Product Sales divided by Service Sales then multiply that result by 100
  • RtN: Product Sales divided by (Service Sales + Product Sales) then multiply that result by 100
  • Sales
    • SpH: Service Sales divided by Production Hours. The hours number in this section is actually Total hours so don't use that in your calculation. Use the Production hours number in the first section at the top of the report.
    • Com.: This is calculated based on the commission plan that is set on the employees profile.
  • Products
    • SpH: Product Sales divided by Production Hours. The hours number in this section is actually Total hours so don't use that in your calculation. Use the Production hours number in the first section at the top of the report.
    • Com.: This is calculated based on the commission plan that is set on the employees profile.
  • Com. Total: Sales Com + Product Com
  • Gross Pay: Base Pay + Com Total
  • Labor Cost: 


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)