The Staff Wages Report (not to be confused with Staff Wages - Weekly%) is used to calculate staff members' wages over a set period of time, taking into account hourly basic rates, holiday pay rates, activity pay types, contracted hours, absences, and break reduction. The report can be downloaded to your device as either a PDF or CSV file.
This article is split into two sections: generating the report, and understanding which data each report field draws from.
Generating the report
You can find the report by going to
Reports in the side bar, then clicking on Standard Reports. If you have trouble finding it from the list, you can use the search bar. Once you click on it, you'll be brought to a set-up screen.
The Start Date and Finish Date allow you to select the date range this report covers, so that you can see the wages owed for a particular week or month.
The Select Branch and Select Staff fields allow you to filter which nursery branches to include in the report, and which staff within the selected branches to be included in the report. If more than one branch is selected, then the Select Staff and Activity fields will be set to All, and this cannot be changed.
If you only pick one branch, you'll be able to select which activities to include in the report from the Activity field. Activities are only shown in the report if they have been scheduled within the selected time period, including unpaid activities.
The Type of Absence field allows you to select which absence types to include in the report (e.g. Sickness, Holiday, Compassionate Leave). Absences are only shown if they have been booked within the scheduled time period, including unpaid absences.
You have the option to further filter which staff to include in the report using the Filter by Tags field. Select a tag from the menu, then choose whether you want to Include or Exclude all staff with the tag. Note that if you have selected more than one branch, you will not be able filter by tags.
Once you have selected a tag to filter by, or checked Include or Exclude, then the system will say that a tag is required to generate the report, even if you delete it. In this case, if you want to proceed without filtering by tags, it's best to refresh the page.
Understanding the report
Once you've generated the report, you'll see a table containing data about each relevant staff member, their hours, activities, pay rates, and absences. To help you understand where each piece of data is being drawn from, let's go through the key headings.
Branch/Nursery, Staff URN, Payroll ID, Staff Name: These four fields help you identify which staff member you are looking at in each row. Most of the data is taken from their staff profile.
Job Title: The job title a staff member is assigned on the system.
Start Date, Leave Date: The date the staff member started at the company, and the date they are scheduled to leave. These can be edited on the staff profile.
Contract Hours: The number of hours the staff member is contracted to work each week, which can be edited from the Contracts/Entitlements page of the staff profile.
Hourly Basic Rate: The hourly rate staff members are paid for activities or paid absences. This value is multiplied by Total Hours (Paid) to determine the Pay Total.
Activities: This heading is split into sub-headings for each different activity scheduled over the selected time period. It displays the number of hours worked in each activity, including paid and unpaid hours. Whether an activity is paid or unpaid depends on whether the activity has been marked as Unpaid in System Settings > Activities and Pay Types.
Total Activity Hours (Paid): The total number of paid activity hours worked by a staff member.
Absences: This heading is split into sub-headings for each absence type scheduled over the selected time period. It displays the absence hours scheduled for each absence type, both paid and unpaid.
Total Absence Hours: The combined absence hours taken by a staff member over the selected time period, both paid and unpaid.
Break Reduction: The number of hours deducted from the Total Hours (Paid) to take into account daily lunch breaks. This can be assigned for a whole nursery or individually through the system-wide HR Settings, or through HR Settings on the Contracts/Entitlements page of the staff profile, respectively.
Total Hours (Paid): The sum of all paid activity hours and paid absences, with break reduction being deducted from the total.
Total Hours (Unpaid): The sum of all unpaid activity hours, and unpaid absences.
Pay Total: Total wages owed over the selected time period. This is calculated by multiplying Total Hours (Paid) by the staff member's Hourly Basic Rate.