Understanding timesheet summary tables

This article is intended for: 

Admin
Manager
Employee

Module concerned:

Capture d'écran

 

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.

 

tableau de synt.png

 

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:

 

Capture d'écran - horaire de travail

  • 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

Capture d'écran - jour férié valorisé

  • 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.

Capture d'écran - jour férié non valorisé

  • 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.

 

Capture d'écran - types de congés

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.

 

Capture d'écran - activation heures supplémentaires

 

A note on terminology

Heures suppp.png
  • 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.

 

Capture d'écran - exclusion des heures

 

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.

Capture d'écran - inclusion des absences

 

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

Was this article helpful?

7 out of 15 found this helpful

Comments

Please sign in to leave a comment.