This report allows you to view changes to an employee's leave balance over time and can help troubleshoot balance discrepancies.
The Leave Balance History Report is one of the most commonly used standard reports in TeamKeeper and can quickly identify how an employee's leave balance has changed over time. This is especially helpful when trying to troubleshoot discrepancies in an employee's leave balance. The report also records which user made each change logged by this report. Employees will need to have a leave setup in Leave Management > Employee Leave Setup to appear in the results of this report.
For clarity, we recommend running the report for only one user at a time.
This report can be found by going Administrator -> Reports
Input:
Employee Options - Select the employee(s) you wish to see the leave balance history for. To load previously inactive employees, select "Load non-active", or select "Load all" to view all employees past and present. We recommend running this report for only one employee at a time.
Leave Types - Select the leave(s) you would like to view the history of for the chosen employees. Choosing only one leave at a time will make the report easier to read but is not necessary.
Dates - Select the date range you would like to view leave balance changes over.
Output:
The results are first filtered by employee if multiple employees are selected and then filtered by each employee's leave assignments if multiple leave are selected at the same time. Each row is one change that occurred to the employee's leave balance.
The width of each column can be adjusted to make the report easier to read by moving the cursor in-between two columns.
Each column is described below in detail.
Employee Number - The employee number of the current employee's leave. If the report was run for only one employee, this column can be ignored.
Last Name - The last name of the current employee's leave. If the report was run for only one employee, this column can be ignored.
First Name - The first name of the current employee's leave. If the report was run for only one employee, this column can be ignored.
Action Date - This is the date that the change in leave balance occurred.
Action Type - This is what occurred to cause the leave balance to change.
Performed By - This is the account that performed the action. The automatic rollover done by the system on the rollover date is has "admin" listed for this column.
Date - This column represents the date that the change is for.
Leave Type - The name of the Leave Config the employee has assigned to them. These are found in Accounting -> Leave Management -> Leave Config.
Beginning Balance - The employee balance after leave rollover occurs.
Accrued - The amount of hours accrued or earned since the last rollover date.
Used - The amount of leave hours the employee has used on the timesheet for this leave type. Timesheets must be submitted for leave hours to move into the Used column. Unsubmitting a timesheet will remove the hours from the Used column and place them back in the employee's leave balance.
Lost - These are the amount of accrued or earned hours that have been lost due to the employee reaching his maximum leave balance. These hours are not available for the employee to use on their timesheet.
Paid - This column is for your use to keep track of leave hours that are paid to the employee directly without being used on the timesheet.
Ending Balance - This is the employee's current balance that they are able to use on timesheets. The formula is Beginning Balance + Accrued - Used - Lost - Paid = Ending Balance.