Step 1:

our template in Excel and a copy of your most recent leave and earnings statement (aka pay stub). In lines B &C on the template fill in your accrual rates for sick and annual/vacation (sick accrual is the same for most full-time feds on a bi-weekly pay schedule and annual/vacation usually depends on years of service/position level). On most statements you can see your accrual rates under “Earned Current” in the leave section. Go ahead and fill in line D with the pay period end date of that pay stub so you’ll know the last time you updated your budget. Be sure to use the pay period ending date and not the date you received your direct deposit.

Step 2:

Fill in the sick and annual/vacation ending balances as of that pay stub date on line E. If you were advanced leave and have a negative balance be sure to fill in line E with a negative number. If you have a time off award or earned comp time go ahead and add those to the vacation balance number before you enter it on line E. Be mindful of any deadlines to use that other leave. Next add up how many pay periods are left for the calendar year and add that to line F. Line G will then auto calculate your accrual rates against the number of pay periods left to show you how much more you will earn this calendar year. Line H will add that to your balance.

Step 3:

Next enter in any planned absences, one per line, for the remainder if the calendar year in section I. Enter the expected hours of leave needed in the appropriate line for either annual/vacation or sick leave. You should include as many vacations, school events, personal errands during the work day, doctors appointments, medical procedures, etc. that you can think of. After you include all those items, line K will give you the estimate of how much leave you will have at year-end.

So how does the balance look to you? If you’ve captured all your planned absences, does the remaining balance look sufficient to cover unexpected emergencies, illnesses, funerals, the car breaking down, etc. and all the other things that happen to folks each year? Do you have the safety net you need for peace of mind? Do you have use it or use it annual/vacation leave you need to plan for?

A few final thoughts.

• This template gives you a look at the entire year. If your leave balances are low, you may not have enough for an upcoming absence and will need to rethink things (e.g., if you have a balance of eight hours of annual/vacation leave left in April, you won’t accrue enough to take off 40 hours in May, but would have enough leave in December to take a week off).
• Family Medical Leave Act in and of itself is unpaid leave, or really a permissible absence during which you can use previously accrued paid leave. Learn more about FMLA here: https://www.opm.gov/policy-data-oversight/pay-leave/leave-administration/fact-sheets/family-and-medical-leave/
• If you or a family member have ongoing medical appointments, try to schedule them in the early morning, so you can reduce your number of hours out of the office. You might also look into alternative transportation (such as community services or taxi/ride sharing) for family members when the appointment is routine and you are accompanying them more for transportation reasons than to be a supportive patient advocate.
• We suggest updating this budget at least once per quarter, more often if there are a lot of things going on and you might have mid-year shortages. As part of our emergency hardship work we see a lot of families who are struggling with insufficient leave to deal with their unexpected emergencies. In some cases they have been operating without a budgeted leave safety net to carry them through a hardship. You can learn more about FEEA’s emergency hardship program here: www.feea.org/emergency.