Staff Wages Report
The Employee Wages Report (not to be confused with Employee Wages - Weekly%) is used to calculate employees' 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 Employee fields allow you to filter which nursery branches to include in the report, and which employees within the selected branches to be included in the report. If more than one branch is selected, then the Select Employee 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 employees 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 employees 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 employee, 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, Employee URN, Payroll ID, Employee Name: These four fields help you identify which employee you are looking at in each row. Most of the data is taken from their employee profile.
Job Title: The job title an employee is assigned on the system.
Start Date, Leave Date: The date the employee started at the company, and the date they are scheduled to leave. These can be edited on the employee profile.
Contract Hours: The number of hours the employee is contracted to work each week, which can be edited from the Contracts/Entitlements page of the employee profile.
Hourly Basic Rate: The hourly rate employees 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 an employee.
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 an employee 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 employee 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 employee's Hourly Basic Rate.
Related Articles
Standard reports
Many of our eyworks products come with a list of standard reports that collate data on various aspects of the system, from invoices to employee scheduling. This article contains a list of all standard reports, along with a brief description of what ...Filling out the employee profile
Most of the fields in the employee profile are just used to record information. However, there are several fields that have system functionality. Let’s go over them. Profile First Name/Last Name: These are mandatory fields. You cannot create a new ...Register Report
The Register Report is a way of keeping track of in/out times for children and employees. This takes two forms: a sign in/out sheet that can be downloaded as a CSV or PDF, printed, and filled out manually; or a record of sign in/out times based on ...Customising employee wages
You can keep track of how much staff are getting paid through employee wage reports. These reports calculate how much is spent on wages according to an employee’s sessions and hourly rate. The hourly rate for each employee can be set in their ...Creating custom reports
eyworks gives you the ability to create Custom Reports for eyenquiries and eymanage. Because the reports are customisable, they are quite simple compared to Standard Reports, and usually take the form of a dataset that provides you with a summary of ...