Time-Off Balance Details Report
The Time-Off Balance Details report contains a complete breakdown of each employee’s time-off changes. This report is useful when you need more information than what is available on the Time-Off Balance Summary report. It contains an entry for each adjustment that was made to an employee’s time-off. This includes the date of the change, and the type of adjustment (for example, manual increase or usage). It also shows the type of time-off the adjustment was made to (for example, vacation time, or sick leave).
To view the Time-Off Balance Details report, go to Reports > Employees/HR > Time-Off Balance Details.
This report displays the following for each employee:
-
Time-Off Type - Displays the employee’s name and the time-off types that are available to them.
-
Date -The date the change was applied.
-
Adjustment Type -Distinguishes whether the adjustment was due to regular usage or whether a manual increase or decrease was made.
-
Amount -The amount of time-off that was debited or credited.
-
Balance -Displays the current balance.
-
Accrual Rate -If the time-off change is an accrual based on hours worked, displays the accrual rate.
-
Hours Worked - If the time-off change is an accrual based on hours worked, displays the hours worked reported on the employee’s approved time entry.
If you must search for a balance summary between a specific date range, note that the standard report does not display year-end expiry values. To get an accurate balance summary the search dates must be in complete years and start on January 1st. If required, you can customize the report to include year-end expiry.
To customize this report and display it in the Report Builder, click Customize. For more information, see Report Customization.
The following selections are included for customization on the Time-Off Balance Details report:
-
Time-Off Balance Adjustments:
-
Amount (Including year end expiry) -The balance calculated includes the year end expiry. Any positive balances are automatically adjusted to zero on December 31st and carry over is credited back to the employee on January 1st.
-
Amount (Excluding year end expiry) -Calculates the balance without taking year end expiry into account. Use this when running a report within a single year.
-
Amount - Displays a running total of an employee’s balance.
-
Carried Over -If an employee has carried over unused time-off from the previous year it appears in this column.
-
Carryover Expiry -If any carryover expired it appears in this column.
-
Date Applied -The date the change was applied.
-
Earned -The number of hours that have been accrued as of the current date.
-
Expired -The amount of time-off that has expired at year end.
-
Used -The amount of used time-off for each time-off type.
-
-
Time-Off Change Type:
Name -The name of the time-off change type. For example, manual adjustment or automatic accrual.
-
Time-Off Type:
-
Display Name -The time-off type display name.
-
Inactive -Indicates when a time-off type is inactive.
-
Increment Unit -Indicates whether the minimum increment of time-off is in days or hours.
-
Minimum Increment -The minimum increment of time-off required for the time-off type.
-
Name -The name of the time-off type.
-
Track Only -Indicates when a time-off type is track only.
-