Leave Reports

Types of Reports

There are four types of reports which you will be able to download:

• Leave Balances
• Totals by employee
• Totals by unit
• Full leave export

For each report, you will be able to filter by date. You will also be able to exclude employees who do not have approved leave from the report. This means that employees who have not booked leave within the period, as well as employees whose leave is still pending, will not appear in the report. If you want to download a report for all employees, untick the exclude option. This can be done for each of the three reports:

The filters applied in the Leave Schedule will impact the reports you request from the Leave Module.
For example, if there is a filter on Department in the Leave Schedule, the reports generated will only give data relating to that department.

• This report provides an overview of an employee’s current leave balances up to a specified date. These details are very useful to effectively carry out leave management and planning. When the box "show remaining balance for whole year" is checked (by default), the balances thus shown are till year end  but if unchecked, the balances are as of the current period being reviewed.

  

• This report includes leave information on each employee (for whom you have the Request Leave permission). This data is displayed as totals. So, for example, if an employee booked 8 hours of leave for 5 days, the report would show: leave taken: 40 hours, rather than 8 hours on Monday, 8 hours on Tuesday, etc. For detailed data such as this, you will need to download the Full leave export. 

  Prior to downloading the report, you will need to select the report fields (i.e. what fields will show in the report). By default, all are selected, but you may untick/tick whatever you want to see. These are the fields:

  • Full name: the employee's name and surname;
  • Employee code: the unique code which identifies one Talexio user from another;
  • Department: the employee's department as at the date filters selected;
  • Sub-unit: if the employee is in a sub-unit, this will be shown; 
  • Job Schedule: for example: Full time 40 hours;
  • Leave type: the type of leave, for example: Vacation, Sick, Maternity leave, etc. If an employee has taken leave across multiple leave types in the selected period, then the report will display one row for each leave type;
  • Pay type: Full pay, half pay, or unpaid;
  • Leave entitlement: the total leave entitlement which the employee had for the leave type;
  • Adjustments: any manual adjustments made to an employee's leave balance;
  • Accumulated: any leave accumulated as part of the employee's working hours. Click here for information on this; 
  • Paid off: any leave paid off in the payroll module;
  • Leave carried over from previous year: any leave carried forward to this year;
  • Expired leave carried over from previous year: any leave carried forward which had an expiry date which lapsed before the leave was availed of;
  • Paid leave booked within this period: any approved leave within the period which has a full pay or half pay pay type;
  • Unpaid Leave booked within this period: any approved leave within the period which has an unpaid pay type; 
  • Remaining balance: the employee's remaining leave balance (after deducting/adding any adjustments, leave carried forward, and leave taken). This balance will either be as at the end of the year or as the cut off date in the leave filters. Check our explanation on the Show remaining balance for the whole year filter above; 
  • Accrued balance (as of the last day of the month): this is the employee's balance as at current month;
  • Balance value: the employee's remaining leave balance in monetary terms;
  • Leave booked and pending request within this period: leave booked including those requests which are still pending approval. 

  You will then need to select the leave type(s) for which you want in the report. Then click export. 
  
   

  When an employee has multiple positions and has leave booked in each position, 'the Leave booked and pending requests within this period' column in the below report is distributed into the balances on the respective position's business unit.
  
  

• This report is similar to the Totals by employee, with the difference that this report will show information per unit rather than per employee. As such, the 'employee full name' and 'employee code' fields are not available from the filters.

  When an employee has multiple positions and has leave booked in each position, 'the Leave booked and pending requests within this period' column in the below report is distributed into the balances on the respective position's business unit.
  
  

• This report is a detailed version of the Totals by employee report, and includes details on each leave booking for each employee such as the date of the leave, the time from and time to, when the leave request was created, etc. 

  By default, the 'Remaining balance' of the Full leave export is switched off, as this will greatly increase the report generation time. In such a case, we recommend that you generate the Leave Balances report.

When you are in the Leave Scheduler, you may filter by employee, department, country. If you filter by, for example, one employee, and then generate a report, then that report will include information for that employee only. The same applies for other filters such as department. 

Like many other Talexio modules, your reports can be saved as templates and also scheduled.

• If you have a report that you will need to generate on a regular basis, you can create a report template, so that you do not have to re-apply the fields and filters each time you wish to create the report. To create a Report Template in the People Section, you need to:

  1. Click on Reports and then click on Generate a New Report.
  2. Add your Report Settings, then click Save Report Template.
  3. Save the Report Template with a name that will be recognisable to you at a future time. Then click Save.
  4. The Report Template saved will now be easily accessible from the Leave page when you click on Reports. When you click on the Report Template, all the details from Step 2 will be present so all you need to do is click Generate.
  5. To delete a Report Template, you can click on the saved template and in the top right you will see a delete icon which will template shown.

  Report Templates can be overwritten or cloned by accessing the Report Template and making the needed changes. When you click on Save Report Template, a toggle is presented to Save as a new template. Turned on will create a new Report Template with the name provided. Turned off will overwrite the Report Template under the same name.

• Building on the Report Templates feature, you can setup an instruction in the system to automatically generate and send saved Report Templates to selected employees.

  Employees receiving the report will need to have their 'Work Email Address' saved in their profile.

  To schedule Report Templates, you will need to:

  1. Click on Reports button on the People page and then click on Scheduled reports.

  2. Click on the + Add New to show the set up dialog.

  3. Fill out your details and choose your repeat period "Weekly or Monthly", then your "Repeat day" and move on to your "Receivers". There is also the option to set up a dynamic date range for the report. Once complete click on Schedule Report.
  4. Once saved, the report will be generated and sent to the specified employees' Work Email Address with the report name as the subject. In the email will be the report attached as an Excel file.
  5. Scheduled Report rules can be changed and deleted by going to the Scheduled Reports and clicking on the edit or delete icon.

  The maximum file size that can be sent for scheduled reports is 10MB. If a scheduled report exceeds this size, you will receive an email notification stating that it was not able to be sent.

• Your Leave Reports also include a Standard Sick Leave Report that will allow you to generate two different types of reports. These can be downloaded from the Leave section, by clicking on Reports and Employee Sick Leave under the Standard Reports heading:
  
  
  1. Absenteeism rate: This report shows the percentage of work hours lost due to employee sickness, helping to identify trends and areas for improvement in attendance management. This can be grouped by department or employee. This report only considers the default sick leave setting (this means that any custom sick leave types are not included).
  2. Employee Bradford scores: This report calculates the Bradford Factor score for each employee, which is a measure of employee absenteeism based on the frequency and duration of their absences. This report only considers the default sick leave setting this means that any custom sick leave types are not included). 

Simplify your HR with Talexio. Learn more.