Vacation Accrued/Used tracker sheet

Trying to come up with a vacation tracker sheet. I have searched the internet but haven't found one that will work for my situation. We have shift workers and we accumulate vacation pay in dollar amounts at 5.77% of gross income earned. We also need to keep track of the vacation accrued that the employees have available to use from the previous period.
Our employees are union, and in the CBA it states that vacation must be paid out (if not used) 11 months following the date it is available (1 year after start date) We currently have no good system to track how much vacation an employee has to use as all the vacation funds accrued are lumped in with the current years accrual.
Clearly, I will be trying to develop my own tracker sheet but as a fairly new user of Excel, I am just not confident I can do this!!
Does anyone have any tracker sheets I could model from? or any tips and/or tricks for me?

Hi
Whilst I am not quite sure how you want to record your salary data please see attached as a starting point.
Hope this helps.
Tony