Each year we publish a comprehensive leave record that federal employees can use to track their annual and sick leave, comp, and credit hours used. Our updated 2021 Excel Leave Chart is designed for active federal employees that are planning their retirement and need to establish realistic target retirement dates. The new Excel 2021 Leave Record Spreadsheet also helps federal employees maximize their annuity through prudent management of their leave balances.
Please share our 2021 leave chart with everyone in your organization. The chart tracks all leave balances and you are able to annotate your work schedule on the chart as well. Simply download the spreadsheet to your desk top for easy availability.
A few leave chart users reported a problem with opening the leave spreadsheet last year, the Excel chart was opening in protected mode and they were not able to enter data. 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 included a newer slsx workbook version that you can use if you have problems with the earlier version.
A Microsoft Office consulting firm advised us that If the spreadsheet only opens in the protected view status and the newer slsx version doesn’t correct the problem talk with your IT staff. Some agencies increase their security settings to lock out certain documents based on set parameters. We include several hyperlinks in our spreadsheet to link users to additional supporting information such as our sick leave conversion chart  and that may be the cause.
Request a Federal Retirement Report
Retirement planning specialists provide a comprehensive Federal Retirement Report™ including annuity projections, expenditures verses income, with a complete benefits analysis. This comprehensive 27-page benefits summary will help you plan your retirement.
Find answers to your questions: The best time to retire, retirement income vs expenditures, FEGLI options and costs, TSP risks and withdrawal strategies, and other relevant topics. Determine what benefits to carry into retirement and their advantages. You will also have the opportunity to set up a personal one-on-one meeting with a CERTIFIED FINANCIAL PLANNER.
Helpful Retirement Planning Tools
- Retirement Planning For Federal Employees & Annuitant 
- GS Pay Scales 
- Budget Work Sheet 
- Medicare Guide 
- Social Security Guide 
- Master Retiree Contact List  (Important contact numbers and information)
- 2021 Leave and Schedule Chart  (Use this chart to set target retirement dates.)
- Annuity Calculator (FREE Excel chart estimates annuity growth)
Disclaimer: The information provided may not cover all aspect of unique or special circumstances, federal regulations, medical procedures, and benefit information are subject to change. To ensure the accuracy of this information, contact relevant parties for assistance including OPM’s retirement center. Over time, various dynamic economic factors relied upon as a basis for this article may change. The advice and strategies contained herein may not be suitable for your situation and this service is not affiliated with OPM or any federal entity. You should consult with a financial, medical or human resource professional where appropriate. Neither the publisher or author shall be liable for any loss or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.
Last 5 posts by Dennis Damp
- Plan Comparisons – Aetna MA to GEHA Standard and BCBS Basic  - November 27th, 2020
- New Medicare Advantage Options Available to Federal Retirees  - November 19th, 2020
- Changes for the 2021 FEHB Open Season and How to Save Some Serious Money  - November 12th, 2020
- 2021 FEHB Plan Selection Guide  - November 5th, 2020
- GEHA Standard to Blue Cross Blue Shield Basic Plan Comparison - 2021  - October 23rd, 2020
- Health Care Premiums Rising for 2021 - What Else is New!  - October 19th, 2020
- 2021 COLA Announced and Annuity Projection Calculator  - October 13th, 2020
- The 2020 Election - Voting This November  - October 1st, 2020
- FEDVIP Options for 2021 (New Providers Added)  - September 26th, 2020
- Required Retirement Application Forms  - September 18th, 2020
- 2021 COLA and the 2020 Health Care Open Season  - September 12th, 2020
- Health Plan Comparisons – The Good News  - September 4th, 2020