Forum Discussion

carospen's avatar
carospen
Copper Contributor
Dec 20, 2022

Accrual balance

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. 

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Without seeing sample data, it is hard to advise. Attach a sample file with dummy data so that we can check and suggest.

Resources