Condensed timesheets for reporting
- Aimee Jay
- James Barnsley
Condensing timesheets is a way to split out over time hours from the ‘normal’ agreed hours. This information is then coded differently for the payroll import.
Contract work cannot be condensed however it will contribute to the total hours and split
Pros
Hourly payslips are a lot simpler
Hourly payslips are shorter
Cons
Task detail is removed for hourly work
Cost coding is generalised for hourly work
Organisation settings
To enable this feature you currently need to get in touch with the team and provide the task name and costing code for your ‘ordinary time’ and ‘over time’.
These new codes directly relate to your payroll provider, please ensure they are correct
We will then set up your account with condense timesheets and the new pay elements:
Employee settings
This feature is applied to each employee individually and requires their agreed hours per week to be entered and for condense timesheets in payroll to be ticked.
Reports
The table below shows an employee with 40 agreed hours per week and condense timesheets in payroll selected. This is formatted for IMS Payroll but can be applied to others.
Employee with hourly work only:
Employee ID | Task | Units | Unit rate | Costing Code |
|---|---|---|---|---|
1234 | T1 | 40 | 35.00 | Labour |
1234 | EXTRA-T1 | 5 | 35.00 | Labour |
1234 | DAYS | 6 |
|
|
Employee with hourly work and contract work:
Employee ID | Task | Units | Unit rate | Costing Code |
|---|---|---|---|---|
1234 | PRUNING | 300 | 0.80 | Client 1 |
1234 | PRUNING | 300 | 0.80 | Client 1 |
1234 | PRUNING | 300 | 0.80 | Client 5 |
1234 | PRUNING | 300 | 0.80 | Client 7 |
1234 | PRUNING | 300 | 0.80 | Client 1 |
1234 | RESTB | 2.5 | 30.00 | Labour |
1234 | CONTH | 40 |
|
|
1234 | EXTRA-T1 | 5 | 35.00 | Labour |
1234 | DAYS | 6 |
|
|
Diagram to show split limitations: