Exporting overtime (or any VRI)

Before you get started 

The Timmi Timesheet export module can be used to generate entry files with times recorded by Timmi Timesheet time accounts and/or assigned activities.

Payroll variables can be exported to your payroll software or to Timmi Absences on a recovery account, depending on your company policy. 

This page explains how exports to Timmi Absences and payroll work.

This other help page explains how to configure export parameters.

Export to Timmi Absences 

Export to Timmi Absences is triggered automatically when the timesheet has been approved. If you have several approval steps, the export will only take place after the last approval step.

Exported amounts appear in Timmi Absences with the effective date set as the last day of the timesheet.

For a weekly timesheet, for example, if the timesheet is submitted and fully approved on Friday evening, the information will appear in the Timmi Timesheet export history, but will not be taken into account in Timmi Absences until Sunday evening.

Export operations to Timmi Absences can be found in the export history: 

If you would like to generate a report on exported movements, you can go to Timmi Absences and create a report on the balance evolution. 

Export to payroll

Export to your payroll software is not automatic, and needs to be performed manually. When you perform your payroll at the end of the month, you will generate an export file from the export tab in Timmi Timesheet, from the corresponding VRI export (1).

Select the period carefully (2) so that it includes full weeks (and not automatically the 1st day of the month), as the rules for calculating payroll variables (VRI) are generally configured for the week. If the export period end date is in the middle of the week, VRI accounts will be balanced on this date, i.e. before the calculations for the week, which may trigger adjustments in the export for the following period. So be sure to include Sundays.

Choose an export, like this example, until the Monday following the last full week of the month (3).

Finally, export your VRIs (4)

You will find adjustments and delays in the dedicated tab. They will be exported with the new period, but you can also choose to export them only.

To view a previously generated export, go to the export history (1). This is where you will find all your exports, so you can view exported data from the interface or download the file(s) (2). 

The date shown in the "From date" column corresponds to the day after the last day exported.
Be careful not to delete an export that has already been imported into your payroll software! This will trigger duplicates in the next payroll export.

Explanation of the final balance on timesheets 

If accounts that are exported to payroll are visible on timesheets, they may display a final balance that increments with each timesheet. This balance is displayed when times recorded on previously submitted timesheets have not been exported.

The final balance is reset to zero when an export to payroll is generated. More precisely, when the export accounting date has passed (i.e. the end of the exported period, or the date indicated as "From date" in the export history)


If an employee works 2 hours overtime in week 1 and submits their timesheet, as long as the corresponding period is not exported, they will have a final balance of 2 hours on the timesheet for week 2.

If they work 1 extra hour in week 2, their final balance will be 3 hours, i.e. the sum of hours not yet exported from previous timesheets and movements in the current timesheet.

If a payroll export is generated with the Sunday of week 2 as the accounting date, the overtime balance will be emptied on this date, so there will be no remaining balance on the timesheet for week 3.
On the other hand, if a payroll export is generated with the Sunday of week 3 as the accounting date, there will be the final balance until the end of week 3.

Note: The same applies to monthly submissions. 

Special case: Export generated with an accounting date in the middle of the timesheet

  1. If an export is generated with an accounting date in the middle of a timesheet (mid-week or mid-month), the final balance will remain on the timesheet until the end of the timesheet. 
  2. If overtime is submitted on a day after the accounting date of the export, these hours will be included in the final balance of the following timesheet. 

For example:
First, I do 2 hours of overtime in week 1

Then 1 extra hour on Monday of week 2 and 1 extra hour on Friday of week 2

If I generate an export with Wednesday of week 2 as the accounting date, then I have a final balance of 4 hours on my week 2 timesheet
. However, on my week 3 timesheet, I only have 2 hours in the final balance because my weekly rules were not triggered on Wednesday, so the hours were not exported. 

Note: If you have a rule that calculates the negative difference, you could have a negative final balance in week 3. Using the example above, if we work 1 hour less on Friday of week 2 (instead of 1 hour more), we have a final balance of -1 hour on the timesheet for week 3. 

Explanation of the timesheet display for monthly submissions with weekly calculation rules

If you have a monthly submission, weekly increased amount calculation rules and the last week of the month overlaps the current month and the following month, then overtime increase will be displayed on the timesheet of the following month.


November timesheet: 3 hours of overtime assigned November 30

December timesheet: 3 hours appear in the HS25 section when there are no additional hours on the timesheet

Explanation: Rule 1, which calculates all extra hours, is performed per day, which is why 3 hours appear in the HS section of the November timesheet. However, rule 2, which counts the hours which must be increased by 25%, is set on a weekly basis, meaning it is calculated at the end of the week (Sunday). As a result, hours assigned on Monday November 30 are not included on the November timesheet in the HS25 section, as the calculation is made on Sunday December 6. Therefore, they appear on the December timesheet, as shown in Screenshot 2. 



Page content

Was this article helpful?
1 out of 1 found this helpful