In this article, we will show you some examples of how to use custom reports. For a detailed description of how to create a custom report, please refer to this article.
Please note that the best practice examples are merely recommendations. You can always customize your reports to meet your company's needs, add required data and adjust time periods.
1. Point in Time Report Type: Annual Accounts
For the annual accounts, in order to pull up employee data for a specific date, select the Point in time report type. The following example shows the annual accounts for all of the employees in the Growth department as of 31.12.2019.
We recommend the following settings for your annual accounts:
- Report type: point in time
- Date: 31.12.
- Table columns: email, fixed salary (100%), cost center, weekly hours
- Filter employees by: e.g. department; status equal active.
2. Timeframe Report Type: Paid Vacation
A typical use for timeframe reports is showing absences. In the following example, all employee vacation periods for 2019 are listed.
We recommend the following settings:
- Report type: timeframe
- Date: 01.01.2019–31.12.2019
- Table columns: paid vacation entitlement, paid vacation taken days, paid vacation periods, paid vacation balance at beginning of timeframe, paid vacation balance at end of timeframe, paid vacation carryover from previous year, paid vacation expired days from carryover
- Filter: Status equal active during chosen timeframe
To see your employees' upcoming vacation periods, we recommend you use a future timeframe (e.g. from today to the end of 2020) and add the Paid Vacation planned days attribute.
3. Historical Data Report Type: Career Development
The historical data report type enables you to track changes in employee data over a customized time period. This is useful, for example, for reviewing career and salary development within a department, as in this example:
We recommend the following settings:
- Report type: historical data
- Date: any
- Table columns: department, position, fixed salary (100%)
- Filter: department equal (chosen department)
4. Timeframe Report Type: Attendance Overview (Short-Time Work – KUG)
This report provides you with an overview of the hours worked and hours missed for an employee during the time period of your choice. If your company has introduced short-time work, this report can serve as a good basis for providing the labor office with the calculations and reports they require.
To maintain consistency, we have changed the minute format of the attributes Working hours (confirmed) and Overtime (confirmed) from industrial minutes to a normal minute format (60 minutes). Please take this into account when exporting any existing custom reports.
This report includes five new attributes:
- Contractual target working hours:Total target hours in the selected period based on the work schedule and the employee's hire and termination dates before deducting public holidays and absences*.
- Effective target working hours:Total target hours in the selected period based on the work schedule and the employee's hire and termination dates after deducting public holidays and absences*.
- Contractual working hours falling on public holidays: Total contractual working hours that fall on public holidays only (see above).
- <Absence type> – Contractual hours thereon excluding overlaps with public holidays: Working hours lost due to an employee absence (e.g. sickness or vacation) that do not fall on a public holiday.
- Working hours (pending approval)In addition to the confirmed working hours, the attendance periods for which approval has been requested but not yet confirmed can be shown separately.
* Only applies to absences for which attendances during the absence period are counted as overtime (see Settings > Absence > Validity settings).
Please note that, in contrast to the Contractual working hours, the target hours displayed in the employee's attendance tab have already had public holidays deducted.
We recommend the following settings:
- Report type: timeframe
- Date: previous month
- Table columns: contractual target working hours; effective target working hours; working hours (confirmed); working hours (pending approval); contractual working hours falling on public holidays; paid vacation – Contractual hours thereon excluding overlaps with public holidays; sickness – Contractual hours thereon excluding overlaps with public holidays, not including overlaps with public holidays; unpaid vacation – Contractual hours thereon excluding overlaps with public holidays, not including overlaps with public holidays; parental leave – Contractual hours thereon excluding overlaps with public holidayss; maternity leave – Contractual hours thereon excluding overlaps with public holidays (or any other absences that are relevant to your company).
- Filter: Status equal active during chosen timeframe
Please note that the attributes <Absence type> –Contractual hours thereon excluding overlaps with public holidays do not take into account any absences that fall on public holidays. To take these into account, use the Contractual working hours falling on public holidays attribute as well.
5. Timeframe Report Type: Goals and Subgoals Overview
This report provides you with an overview of the employee's progress on their goals and subgoals during the time period of your choice. This data helps to inform employee performance planning and monitoring.
This report includes the following groups of attributes:
- Goal attributes:
Goal name: Name of the performance goal
Goal status: Status of the performance goal
Total goal achievement: Overall goal achievement percentage, combining all subgoals
Goal time frame: Time frame of the performance goal
Goal time frame start date: Start date of goal time frame
Goal time frame end date: End date of goal time frame
- Subgoal attributes:
Subgoal name: Name of the subgoal
Subgoal description: Description of the subgoal
Subgoal achieved percentage: Achievement of subgoal in percent, contributing to the Total goal achievement
Subgoal achieved: Achievement of a quantitative subgoal in number
Subgoal target: Target of a quantitative subgoal in number
Subgoal type: Can be number, percentage or yes/no
Subgoal weight: Share of the subgoal within the entire goal in percent
We recommend the following settings:
- Report type: Timeframe
- Date: This year
- Table columns: First name, Last name, Position, Department, Goal name, Goal status, Total goal achievement, Goal time frame, Goal time frame start date, Goal time frame end date, Subgoal name, Subgoal description, Subgoal achieved percentage, Subgoal achieved, Subgoal target, Subgoal type, Subgoal weight.
- Filter: Status equal active during chosen timeframe.