WFM UK: Rotas: Reviewing the Rota Wage Cost

Overview

A business can choose which pay elements are included in the Rota Wage Cost and which elements are displayed, in line with their own specific requirements. This article will explain how this is configured within the Wage Function setting. It is important to include as many elements as possible so as to narrow the gap between the Rota and Payroll Reports.

It is also important to keep rotas accurately updated as any payments for missing hours will not be included in the Rota Wage Cost. This can then contribute to a gap and may also impact flexible employees' holiday pay and entitlement.

Please note: Adding a Salaried holiday accrual will create a gap. Please read the article on how to set up a salaried holiday accrual - WFM - Salaried Holiday Accrual

Also please note: Since this article was first written, new functionality has been introduced to the system that allows salaried employee costs to be calculated based on the working days in a calendar month instead of Annual Salary/52/Actual days worked. Further details on this can be found at the end of this article.

What should be included in the rota wage cost

This is business-specific, however the wage function setting can include:

• National Insurance for both Salaried and Hourly employees
• A holiday accrual for Salaried and Hourly paid employees
• Actual Holiday pay for Hourly Paid staff
• Payments entered via the Rota module in additional payments
• Tronc – this can only be included if using the Tronc Module (Not Tronc2)
• Fixed costs – if Fixed Cost Areas are in use
• Statutory Payments such as SMP, SAP, ShPP. This will include 100% of the cost paid out and will not reflect the 8% that is the actual cost to the business
• Statutory Sick Pay (SSP)
• Pension Accrual can be entered using 'Factor X'
• Other payments entered using metrics – this will be business-specific

Access Requirements

This area of this system requires the Admin login to access. 

Wage Function Setting Elements
 

• Go to Rotas > Administration > Wage Function Settings

Fig.1- Accessing the Wage Function Setting

Considerations before making changes:

• The page is a series of tick boxes than can be ticked or unticked as required
• The changes are global and will have an immediate effect

Fig.2 – Wage Function Settings page

Headers
 

 
Pay Elements

These are broken down into sections:

• Hourly pay
• Salaried Pay
• National Insurance
• Holiday and Tronc 
• Additional Payments entered through the rota
• Fixed Costs, Overtime and Statutory payments.

Hourly Pay

The cost of Hours or shifts (or both) can be included in the rota wage cost as required by the business.

The example in Fig.3 shows:

• Basic pay for hourly paid staff included in the Rota Wage cost
• NI being calculated on this pay element. This is at the standard rate for National insurance
• A holiday accrual is being calculated on the hours entered on the rota
• An additional accrual (Factor X) is being calculated on the hours entered on the rota
• The Pay Element is displayed on the Analysis page
• The Cost of Shift paid employees is not included in the Rota Wage cost.

Fig.3 - Hourly pay elements

Salary Pay Elements
 

• Managers Lent is the cost of salaried employees working in different locations. This will display as a credit, as the full cost of the employee will show in ‘Salaried Total Pay’ for the home location
• Managers Borrowed is the cost of salaried employees that are employed at other locations
• Salaried Total Pay is the total cost of all salaries scheduled at that location (salary divided by 52)
• Absence Deduction for Salaried Employees will remove the cost of a salary when an absence is entered, regardless of the configuration of the absence type. It is recommended that this is left un-ticked to avoid understating the Rota Wage Cost when salaried employees receive paid leave
• Total Pay will display hourly pay plus salaried pay and will include adjustments for managers borrowed and lent

Fig.4 - Salary pay elements

The example in Fig.4 shows:

• NI is calculated on all Salaried pay elements
• A holiday accrual is not being calculated on Salary Cost
• An additional accrual (Factor X) is being calculated on the salary cost.
• The Pay element is displayed on the Analysis page

National Insurance Elements

The cost of National Insurance can be displayed separately if required.
 

Fig.5 - National Insurance elements

Holiday and Tronc Pay Elements
 

• Holiday pay for hourly paid employees with authorised holiday can be included in the Rota wage cost
• The calculation for this holiday will be based on the employees working unless the rota global setting to calculate holiday on Hours x Rate is enabled
• If employees are paid extra for Bank Holidays, this additional cost can be included if Statutory Days are set up
• If an accrual is being calculated, hourly holiday pay can be displayed but not included in the rota wage cost
• The cost of allocated tronc can be included if the Tronc module is being used (not Tronc2)

Fig.6 - Holiday elements

Additional Payments
 

• Where additional payments are entered through the Day Content screen in the Rota, these can be included in the Rota Wage Cost
• This may be used for Bonus Payments, Back Pay or Responsibility pay
• If an admin fee is applied to these payments, this can also be included in the rota wage cost

Fig.7 - Additional Payments

Fixed Cost, Overtime and Statutory Pay Elements
 

• Where Fixed Cost Areas are in use, these costs can be included in the rota wage cost and displayed on the Analysis page
• If Overtime functionality is set up, this cost can be included in the rota wage cost and displayed on the Analysis page. This information will only populate once the overtime has been approved
• SMP,SPP, SAP and ShPP costs can be included in the rota wage cost but this will reflect 100% of the cost paid out in the Payroll module rather that the 8% actual cost to the business
• SSP entered in the Rota module is only an estimate and the cost will be associated with each absent day on the rota. The value of one days’ absence is defined within the wage function setting to allow an estimated cost of a sick day to be included in the rota wage cost. However, SSP is paid as a weekly amount in payroll and the rota cost will not reflect waiting days

NB SSP is no longer claimed back from HMRC.
 

Fig.8 - Statutory Payments

Calculated Values

This section allows a business to decide the order in which the system calculates the costs. This enables NI to be included in holiday accrual calculations.

The Calculation Order column determines the order in which the pay elements are calculated.

• If the values are all set to 1, the system will calculate the pay elements on basic pay

Fig.9 - Calculated on base pay

• If the employer's NI is set to 1 and holiday accrual and other accrual are set to 2, the system will calculate NI before calculating holiday accrual and other accrual so that NI is included in the calculation

 
Fig.10 - NI included in holiday accrual calculation

• The Wage Cost column must be ticked if NI, holiday accrual or other accrual are to be calculated by the system
• These elements can be displayed on the Analysis page
• Using the radio button(s) applies that percentage or calculation to that individual wage element. Rather than entering 13%, the order of the values can be changed and the percentage 12.07% kept
   

Display Settings

The Display Settings control the information that is available on the Analysis page.
 

Fig.11 - Display Settings

Percentage Elements

The amount that is added to an absence and the percentage for holiday accrual is controlled in the Display Costs section.
 

• Statutory Sick Pay Day Rate is the cost added to the rota when an SSP configured absence is entered

This is usually:

£92.05 divided by 5 = £18.41
or
£92.05 divided by 7 =  £13.15
 

• This is the percentage that calculates the Holiday Accrual. It is also used by the Holiday Accrual Journal in Payroll.

Fig.12 - Display Costs settings

Configuring Other Accrual
 

• To include an additional cost calculated on a percentage into the Rota Wage Cost, Factor X must be set up and the Other Accrual columns must be ticked (see Fig.2 & Fig.9)

This is most often used for Pensions.

The percentage value needs to be entered in each location and can vary by location if required.
 

• Go to Rotas>Administration>Configure Locations
• Select a Location
• Select Edit Factor X and Fixed Costs
• Enter a percentage value in the Factor X field

Fig.13 - Edit Factor X and Fixed Costs button
 

 
Fig.14 - Inputting a percentage value for Factor X

Fixed Cost
 

• Fixed Costs areas need to be set up to include a static cost in to the Rota Wage Cost.

The following guide explains how to set up and use Fixed Costs - WFM - Using Fixed Costs

Salary Job Titles

For the Rota Wage Cost to accurately calculate, all Salaried Job titles associated with that cost must be included in the Rota Wage Cost. This can be checked in Configure Locations.
 

• Go to Rotas>Administration>Configure Locations>Select Location

 
Fig.15 Job title not included in Salary

• To include this cost, select Edit Job Title Salary and tick Include Salary?
• All Job titles can be included by selecting Apply

 
Fig.16 - Tick to include Salary in Rota Wage Cost