worksheet to track vacation accrual by employee and cost/job cente

[Vacation Accrual by cost/contract/employ]

I am searching for a spreadsheet that will accrue employee vacation time and
cost balance by cost center and then reverse the accrual when the vacation is
used later, even if the employee is assigned to another contract~semi-monthly
payroll accrual period.

In essence, make sure that vacation accrual expense is accurately accounted
for as accrued, not when taken. Then when taken, the accrual will reverse
and usage will be reflected in the employees payroll balance.

 

[The Code Cage Team]

Do you have a dummy workbook you could post so we can see you
structure

--
The Code Cage Tea

Regards,
The Code Cage Team
http://www.thecodecage.co