Regular Employee Information > Leave Balance Spreadsheet

Leave Tracking for Regular Staff
Microsoft Excel Workbook

Now you can keep your own up to date records for your earned leave with one of the Microsoft Excel Worksheets provided. The Leave Time Worksheets are easy to use and provide up to date leave balances. Leave balances for a future date can be projected by scrolling down to the appropriate pay period. Please note that you may only use sick and annual leave from the previous pay period balance, not the balance of the current pay period.

Make a selection below to download the appropriate Microsoft Excel leave tracking worksheet to your computer.

Regular Holiday Earnings Worksheet

24 Hour Coverage Department Worksheet

After downloading the worksheet file to your computer, open it in Microsoft Excel. Then follow the Three Steps to Begin provided at the top of the file. This will get the worksheet started.From then on, you only have to log your leave used each pay period and the worksheet does all the calculations. There is also a column for the end of the year, "Use or Lose" Annual Leave. Once you have started the worksheet, remember to "Save As" to one of your own folders.

Each Year the Office of Payroll & Employee Services will provide an updated Excel Workbook on the web for the new holiday dates. A separate workbook will be provided for the staff that earns holidays at the first of the month.

If there are any questions, call the Payroll Office at 301-687-4332.