
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 [7] = Regular Hours Used [6]Estimate of current liability hours
Percent of hours used from beginning balance
By detail employee [1], when regular hours taken [6] is greater than regular hours earned [4], calculate excess of hours taken over hours earned [10]. When hours taken is less than hours earned, this amount should be zero.Total Excess of Regular Hours Taken over Regular Hours Earned [10] / Total Regular Hours Beginning Balance [3] = Percent of Hours Beginning Balance Used Each Year [bottom of column 10]
Dollars Reporting and Calculation 
Reporting entity by detail employee
Beginning Balance $ [11] = Dollar balance calculated for the prior year (prior year pay rate including fringes)The report developed should reflect detail by employee [1] and total dollars beginning balance [11], total dollars additions [12], total dollars deductions [13], total dollars ending balance [14], and total dollars current liability by reporting entity [15].Additions $ [12] = (Regular Hours Earned [4] + Bonus Hours Earned [5]) X Current Year Employee Pay Rate [2] (including fringes)
Ending Balance $ [14] = Total Ending Balance Hours [9] X Current Year Employee Pay Rate [2] (including fringes)
Total Deductions $ [13] = Total Beginning Balance $ [11] + Total Additions $ [12] – Total Ending Balance $ [14]
Current Leave Liability $ [15] = Percent of Hours Beginning Balance Used Each Year [bottom of column 10] X Ending Balance $ [14]
[Click for MS Excel worksheet]