timr offers an Excel or PDF export to pass time and vacation balances on to payroll and to create your own evaluations. You can export the data of any single closing or collect the data of all closings within a period.
1. Export data of time account balance
2. Contents of the Excel export
2.1 Time and vacation account overview
2.2 Overtime and allowances overview
2.3 Payouts overview
2.4 Hours by working time type
2.5 Absences overview
3.1 Excel export
3.2 PDF export
1. Export data of time account balance
Go to Time & Vacation Account → All Accounts and click Export in the top right corner.
First, select the format:
- Marker 1: Overview as an Excel file. Minutes can be shown as minutes or as decimals.
- Marker 2: Time sheets per employee as PDF
Then select the period. All closing dates are available for selection.
-
Single closing: Select the date of the closing you want to export.
-
Period: Enter a start and an end date. All closings within this period are exported together.
Tip: For an annual overview, for example of sick days or home office days from last year, enter January 31 to December 31 of that year.
Note: The export includes only employees who have a closing on the selected date or within the selected period.
You can export all closings or filter by specific users or organizations (module Extended Permissions).
2. Contents of the Excel export
The exported XLS file contains the following spreadsheets:
2.1. Time and vacation account
2.1. Time and Vacation account overview
This view gives you an overview of the status of the time and vacation account at the time of balancing.
The contents correspond to the data you will find on the individual timesheets:
2.2 Overtime & Allowances Overview
The Overtime and Allowances module is currently in beta testing. If the module is activated and rules for overtime and allowances have been created, you will see here the totals of hours accrued based on the respective rules and the status of the overtime account. See "Introduction Overtime & Allowances".
2.3 Payouts Overview
This sheet shows the details of every payout made in the period. You can also export this overview on its own, see 3. Exporting payouts.
2.4 Overview of hours by working time types
The Working Time Types sheet breaks down all hours in the period by category and working time type. You manage your working time types under Administration → Working Time Types.
2.5 Overview of absences
This sheet lists all absences in days, whether they were requested or entered directly.
Note: If a vacation is requested for a date range that includes non-working days, the number of working days differs from the number of calendar days.
Absences spanning more than one month
If an absence runs past the end of a month, the export splits it by month.
Example: Sick, Oct 26 – Nov 2
- October export: Oct 26 – Oct 31
- November export: Nov 1 – Nov 2
3. Exporting payouts
You can export the payouts of a selected month as an Excel file or as a PDF. Here too, minutes can be shown as minutes or as decimals.
3.1 Excel export
The Excel export lists the details of each payout.
3.2 PDF export
The PDF export gives you an overview of each payout and the total paid out in the selected month.
Comments
0 comments
Article is closed for comments.