The Employee Vacation/Leave Reconciliation Report will compare information on the vacation screen (considered to be vacations date that have been approved) to vacation absences (those considered to be taken) entered into HR, and report on any discrepancies. It will also report any discrepancies that exist between leaves and their absences. The two problems that are reported are:
-
Vacation has been approved but not taken (not logged in the absence system).
-
Vacation taken (logged as an absence) without approval.
-
A leave has been approved but not taken (not logged in the absence system).
-
An absence requiring approval is missing a leave.
-
The total time on a leave does not match to total absences.
You can select the records you want to reconcile by year, date range, employee category and bargaining unit. You can report on absences missing vacation or leave approval, or vacation or leave approvals missing absences.
The report can be sorted by employee name or number.
The information can be optionally exported into a mail merge file.
Vacation Checking
-
The report makes two passes. It first scans through all absences that have a vacation absence code and searches for the corresponding vacation approval. It then reads through all vacation approvals to make sure that all the proper absences have been logged.
-
Because of the difficulty in translating hours to days, the report makes no attempt to reconcile the hours logged as absences to the vacation days approved.
-
The report will display the following information: Employee name and number, absence date, absence days, vacation from and to dates, vacation days, and problem. If a vacation has been approved but not logged as an absence, the absence date will appear enclosed by opening and closing angle brackets. For example, if a vacation day has been approved for 10-Jan-2005, but no vacation absence had been logged for that date, then the absence date would appear as <10-Jan-2005>.
Check Vacations/Leaves/Both
-
Enter 'V' to reconcile vacations only.
-
Enter 'L' to reconcile absences only.
-
Enter 'B' to reconcile both vacations and leaves.
Vacation Absence Code
-
Enter the absence code you use to log vacation absences. Search to view valid absence codes.
Vacation Year
-
Enter the year for the vacation information you want to see. Only vacation information for the specified year will display.
Leave Absences Codes
-
Enter up to 10 absences codes. When processing leaves and their absences, only those leaves/absences that have the specified absence code(s) will be selected. If you do not enter any absence codes, then all leave and absences will be selected. Search for valid absence codes. Leave this field blank and Enter key to continue.
This Prompt Will Only Be Activated If You Have Chosen To Reconcile Leaves
Uninterfaced Leaves
-
Enter 'Y' to report on uninterfaced leaves only. An uninterfaced leave is one where the time used is less than the total time.
-
Enter 'N' to include both interfaced and uninterfaced leaves.
-
Enter 'G' to include only leaves where the time used is greater than the total leave time.
-
Enter 'O' to include only fully interfaced leaves.
This Prompt Will Only Be Activated If You Have Chosen To Reconcile Leaves
Interfaceable Absences
-
Enter 'Y' to report those absences that are supposed to be interfaced into payroll.
-
Enter 'N' to report on all absences.
Uninterfaced Absences
-
Enter 'Y' to report on uninterfaced absences only. An uninterfaced absence is one that has not yet been interfaced into payroll.
-
Enter 'N' to include both interfaced and uninterfaced absences.
Date Range
-
Enter the range of dates as (YY)YYMMDD that you want the report to reconcile.
Employee Categories
-
Enter valid employee categories to a maximum of 10.
Employee Bargaining Units
-
Enter valid Bargaining Units to a maximum of 10
Problems To Check For
-
Enter '1' to only read through existing absences looking for corresponding vacation or leave approvals.
-
Enter '2' to only read through existing vacation and leave approvals looking for corresponding absences.
-
Enter '3' to read through both the absences and vacation/leave approvals.
Only Display Problems
-
Enter 'Y' to only display vacation absences or approvals that cannot be reconciled.
-
Enter 'N' to display all vacation absence and approval information.
Display Absence in Hours/Days
-
Enter 'D' to display the vacation absence units in days. Enter 'H' to display the vacation absence units in hours.
Report/Merge
-
Run in report mode, or merge to Excel
Employee Sort
-
Choose 'A' to sort alphabetically by Employee Name
-
Choose 'N' to sort Numerically By Employee Number
Employee Selection
-
select on individual employees are include all employees
Report Title
-
Enter a report title