[ON] how are you tracking vacation when half your staff is in another province?

we're about 45 people, most in ontario with a smaller group in quebec. up until this year time off was a spreadsheet i keep and it more or less worked.

it stopped working once i clued in that the two groups don't accrue the same way and the stat days don't line up either. so i've been maintaining what is basically two sets of rules inside one sheet, and every time someone books a day i'm double checking which column applies to them.

the part that actually worries me is history. if someone asked me to prove their balance from two years ago i'm not sure i could. the sheet just gets overwritten, there's no record of what it said before, only whatever the number is today.

so for anyone with staff in more than one province, what are you running? did you end up getting a system for this or just building a better spreadsheet? and if you did move, did it handle the provincial differences on its own or were you still setting all that up by hand.