Understanding Timmi Timesheet report columns

Before you get started

The Timmi Timesheet report module lets you choose which columns to include and how to arrange them. Here are a few details on the various columns.

If you are looking for an introduction and more general information in Timmi Timesheet reports, please consult this help page: Analyzing your data with reports and dashboards

Details of available columns and their calculation

Times report

The "Time" report type can be used to add the following periodic columns on submitter times:

• theoretical time = contractual time (defined by the submitter's work cycle) - public holidays +- exceptions in the schedule (days off or days worked defined in Timmi Absences > Schedule management > Manage days off). This is the time that the submitter must justify either by working time or by absences.
• working time = time entered by the employee in Timmi Timesheet, or the employee's theoretical time if nothing has been entered.
• absences = duration of absences (from Timmi Absences).
• difference = attendance time + absence time - theoretical time.
• absences considered as actual working time = duration of absences set up in Timmi Absences as working time for Timmi Timesheet (e.g. training, remote working, delegation time, etc.). You can check your absence account settings from Timmi Absences > Settings > Accounts.

• other absences = absences not considered as actual working time.
• actual working time = working time + absences considered as actual working time.
• actual working rate = actual working time / ( theoretical time - absences not counted as actual working time). Or, to put it more simply, it is the ratio between actual working time and employee availability.
• break time duration (only for scheduled regulations): the sum of break durations. If an employee has not entered anything, the theoretical break duration (based on their work cycle) is displayed.
• longest break (only for hourly regulations): duration of longest break. If an employee has not entered anything, the theoretical break duration (based on their work cycle) is displayed.

Timesheets report

• If your approval process involves several steps (e.g. approval by the manager, then by the N+2), the timesheet will only appear with "approved" status once all the approvers have approved it. The "last approval on"/"last approval by" columns, as their name suggests, concern the last approval step.
• "Rejected" status refers to a canceled, refused or invalidated timesheet. The "refused by"/"refusal comment"/"invalidated by"/"invalidation comment" and other columns provide further details, which you can add by clicking on add columns.
• If a timesheet is approved, then invalidated, then submitted and approved again, then there will be 2 rows in the report. One row with "rejected" status and one row with "approved" status. This provides a history of the timesheet's status, and the addition of the "refused by", "last approved by" and other columns provides further details. 

Differences between times and activities reports

There may be a difference between the duration of activities calculated in the activities report and the attendance time in the times report for a given employee. There are two possible reasons for this difference.

Theoretical time

The times report considers that as long as the employee has not entered anything for a day, they has respected their theoretical working time (useful for making projections, for example: are my employees likely to exceed their package by the end of the year?)

The activities report will correctly state that no activity was allocated to the day.

Contract dates

The attendance duration shown in the times report is limited by the start and end dates of the employee's contracts, unless there are submitted timesheets outside these dates. Therefore, times entered outside this period on timesheets that have not been submitted are ignored.

This is not the case with the activities report, which keeps track of all activities.