Accrual balance

Copper Contributor

I need some assistance creating a spreadsheet to keep track of employees banked time. My payroll system shows me the balance available, however I need a way to keep track of how old the balance is. 

 

When an employee uses hours I need it to be subtracted from the first earned hours, once an employee has hours available to use that are 6 months old I need to know so I can pay them out. 

1 Reply
Without seeing sample data, it is hard to advise. Attach a sample file with dummy data so that we can check and suggest.