2020 Federal Leave Record
Each year we publish a comprehensive Excel leave record that federal employees can use to track their daily record of annual and sick leave, comp, and credit hours used. Our updated 2020 Leave Chart is designed for active federal employees that are planning their retirement and need to establish realistic target retirement dates. This Leave Record Spreadsheet also helps federal employees maximize their annuity through prudent management of their annual, sick, comp, and credit hour balances.
Download the 2020 federal leave record and place it on your desktop to not only track your leave balances but to capture your work schedule for the current year. The spreadsheet automatically tabulates all of your leave balances. Use our Sick leave Chart to determine the amount of additional time you will accumulate towards retirement. Each full month of sick leave ads to your annuity payment. By thoughtfully planning your exit you will be able to maximize your benefits and the one time payout for your accumulated annual leave.
A few users reported a problem with opening the leave spreadsheet, the Excel chart was opening up for them in protected mode and they were not able to enter data into the form. If your spreadsheet opens in protected view click the "enable editing" button in the yellow bar at the top of the form. However, if you don't see the enable editing button you may have an older version of Excel or your IT department may have to allow the form to pass without restrictions. We also inlcuded a newer xlxs workbook version that you can use if you have problems with the earlier version.
A Microsoft Office consulting firm advised me that If the files opens in protected view the protected view status is a result of security settings on your agency's LAN and network. Some agencies increase their security settings to lock out certain documents based on the parameters the IT specialist selects. We do include several hyperlinks in our forms to link users to additional information such as our sick leave conversion chart and that may be the cause. If you have this problem when opening the form I suggest talking with your IT people to have them allow the form to pass without restrictions.
Typically you select several target retirement dates that provide the maximum annuity payment and refund of accumulated annual leave. This process includes setting a retirement date that provides you with another even month of accumulated sick leave which adds to your annuity payment. Each month of accumulated sick leave ads to your monthly annuity check and by conserving your annual leave usage the last few years of employment you will receive a rather large annual leave lump sum check a month or two after you leave. You can gradually accumulate 6 weeks of annual leave over your career and then use as little annual leave as you possibly can the last year of service. If you don't use any leave your last year you can retire with up to 448 hours of annual leave, the maximum amount allowed.
The following partial screenshot presents the layout of the spreadsheet to familiarize you with the format. Download the 2017 leave record and place it on your desktop for easy reference and update.