Compensated Absences Policy Recommended Procedure

Note: The numbers shown in brackets below are references to the columns in the accompanying accrued vacation worksheet.

Hours Reporting and Calculation

Reporting entity by detail employee

Add prior year ending balance data to calculated leave earned, subtract ending leave balance to compute hours taken.
Regular Hours Beginning Balance [3] + Regular Hours Earned [4] – Regular Hours Ending Balance [8] = Regular Hours Used [7]


Percent of hours used from beginning balance
By detail employee [1], when regular hours taken [7] is greater than regular hours earned [4], calculate excess of hours taken over hours earned [12].  When hours taken is less than hours earned, this amount should be zero.

 

Total Excess of Regular Hours Taken over Regular Hours Earned [12] / Total Regular Hours Beginning Balance [3] = Percent of Hours Beginning Balance Used Each Year [bottom of column 12]

Reporting entity by detail employee

Beginning Balance $ [13] = Dollar balance calculated for the prior year (prior year pay rate including fringes)

Additions $ [14] = (Regular Hours Earned [4] + Bonus Hours Earned [5] + Special Annual Bonus Earned [6]) X Current Year Employee Pay Rate [2] (including fringes)

Ending Balance $ [16] = Total Ending Balance Hours [11] X Current Year Employee Pay Rate [2] (including fringes)

Total Deductions $ [15] = Total Beginning Balance $ [13] + Total Additions $ [14] – Total Ending Balance $ [16]

Current Leave Liability $ [17] = Percent of Hours Beginning Balance Used Each Year [bottom of column [12] X Ending Balance $ [16]

 

The report developed should reflect detail by employee [1] and total dollars beginning balance [13], total dollars additions [14], total dollars deductions [15], total dollars ending balance [16], and total dollars current liability by reporting entity [17].

[Click for MS Excel worksheet]