Understanding timesheet summary tables
This article is intended for:
Module concerned:

The summary and overtime summary tables included in your timesheets enable you to understand and detail the calculations carried out by Eurécia.
The first part of this article concerns the summary table for hours worked. To go directly to the second part concerning the overtime table, click here !
Please note: If the summary tables are not displayed in your timesheets, contact Eurécia Support!
Summary table for hours worked
Access: Time & Activities module > My timesheets
The first summary table for hours worked shows the calculation between the number of hours that should have been worked and those actually worked.
For weekly timesheets, the first column shows the calculation for the week (green), while the second column shows the calculations for the total period (pink). For monthly timesheets, each column represents a week.
A note on terminology
- Theoretical time = Working hours - Holiday/absence hours "deducted from theoretical time" / Non-valued bank holiday
- Counted as worked = Working hours + Holiday/absence hours "counted as worked" / Valued bank holiday
- Difference = Theoretical time - Hours counted as worked
Where can these settings be found?
- Theoretical working hours
The number of theoretical hours is determined by the working hours of the employee concerned:
- Whether or not bank holidays are valued (Access: Admin area > General settings > Working hours > Working days section > more options)
Bank holidays can be:
- valued, meaning that they are counted in the hours worked. In this case, it is usual to enter the number of hours normally worked in the 'Hours counted in the event of bank holidays' column
- not valued, in which case the system will deduct the number of hours theoretically worked on that day from the expected theoretical hours. The 'Hours counted in the event of bank holidays' column must therefore be set to 00:00.
- Setting up holiday & absence types (Access: Admin area > Holidays & Absences > Holiday & absence types)
Your holiday and absence types can either be deducted from theoretical time, counted as worked, or neither.
For example, absences for working from home or training are generally counted as worked because the hours completed constitute work, even if the employee is not physically at the company.
Conversely, hours of absence for annual leave or RTT are usually deducted from theoretical time because the employee is expected to work fewer hours in a week in which they have taken an RTT day.
Overtime summary table
Access: Time & Activities module > My timesheets
When overtime management is enabled and an overtime calculation rule is configured in the overtime profile, the overtime summary table is displayed only on the relevant tab: either the 'Time tracking' tab or the 'Activity tracking' tab.
A note on terminology
- Counted for the overtime calculation = hours counted as worked that are not excluded from the overtime calculation (certain types of time or certain types of absence, for example)
- Overtime calculated = overtime calculated according to the rules established
- Approved overtime = overtime actually transferred to a time-off-in-lieu counter or to payroll after the timesheet or transfer has been approved.
Exclude hours from the overtime calculation
Access: New admin area > Time & Activities > Overtime profiles
It may sometimes be necessary to exclude certain hours worked from the overtime calculation when several rules are combined, so that these hours are not valued several times.
Include absences in the overtime calculation
Access: Admin area > Holidays & Absences > Holiday & absence types
Some absences are not counted as effective working time; however, they must be included in the weekly overtime calculation. You can configure this setting in the absence type.
Please note: For more information on configuring overtime rules, see this article: Managing overtime in Eurécia
Keywords: timesheet · activity sheet · overtime · overtime profile · summary table · calculation rules · theoretical time · working hours · bank holiday · valued · valuation · include · exclude · deducted · counted as worked · holiday type · absence · difference · calculation · CRA · reporting · report
Comments
Please sign in to leave a comment.