Aside from the raw data and timesheets, the system has the capability to exclude unpaid breaks or calculate overtime. Optionally, you can choose whether to include all employees and all locations on the report, or just a selected group. The payroll report can be divided into two categories:
- Custom payroll report
- Pay periods payroll report
This article will cover only the custom payroll report. If you want to learn more about generating a payroll report when on pay periods, please click here.
When running the custom payroll report, you can select the following options and parameters:
- You can select the beginning and the end date for the payroll calculation.
- You can select the method of grouping the payroll data. By default, the system will group the data by employee names, but you can also group by positions and dates.
- You can also select the order of employees listed in the report. By default, the system sorts employees by their first names.
- You can include the data from all locations, or just one specific location.
- You can choose to include all employees (who have approved hours for a selected period), or just a custom group of users. If you have employees on pay periods, you will not be able to select them.
- You can also decide whether or not to include deactivated employees. If you decide to include deactivated users as well they will be colored differently.
- You can add additional columns to the payroll report. This part is optional, and if you skip it, the system will simply display a group of default data fields.
Once you’ve selected the right information, click on the Generate button option to view the summarized version payroll report where a brief info regarding hours worked and wages for each employee is displayed.
Clicking on a grey arrow on the right will display a detailed payroll report for each employee.
The system will calculate overtime beginning with the start of the work week, configured in the settings section. By default, our system will begin overtime calculations starting with Monday, unless a different day is configured in the Schedules part of the Settings section.
If this option is chosen, the overtime wage will be calculated at 1.5x the employees’ pay rate for each hour worked in excess of the 40 hour week. This is applicable to both the summarized and detailed versions of payroll reports, as well as payroll exports and 3rd party integrations.
When calculating overtime using this method, the system will calculate one half times the employees’ regular pay rate for all hours worked in excess of 8 hours, up to and including 12 hours in any workday, and for the first 8 hours worked on the 7th consecutive day.
Also, employees’ regular rate will be doubled for all hours worked in excess of 12 hours in any workday and for all hours worked in excess of 8 hours on the 7th consecutive day of work in a workweek.
This option will also affect all aspects of payroll as mentioned above.
For more information please refer to https://www.dir.ca.gov/dlse/faq_overtime.htm or contact our support team.
California Overtime – Alternate
This option regards the California 4 10 overtime calculation. This is an overtime calculation applied to employees who choose to work a reduced (4 days working) working week. This means that on any given day the first 10 hours are considered as regular time, the following 2 hours are calculated at time and a half and anything over that will be calculated as double time.
Also, hours beyond 40 hours/week are considered as overtime and are paid at time and a half unless they qualify for a double time by virtue of being part of a shift that has gone beyond 12 hours. Similar to the aforementioned, this is applicable to all payroll options.
For more information please refer to https://www.dir.ca.gov/dlse/FAQ_OvertimeExceptions.htm or contact our support team.