ABC
1
2
3
4
5
6
STEP 1: KEEP A MASTER COPY
7
Save this tracker as a seprate document on your desktop. Duplicate the tabs you want to use and rename it for yourself. Always keep the original tabs unchanged so formulas and layouts remain available for future planning or alternate scenarios.
8
9
STEP 2: DEFINE DAILY BILLABLE HOURS
10
At the top of each month, enter what a full day and a half day represent for you in billable hours. These values control all calculations and can be adjusted anytime to reflect workload changes.
11
12
STEP 3: PLAN YOUR WORKING DAYS
13
For each date, choose: F for a full day, H for a half day, or O for out of office. Monthly billable totals update automatically as selections are made.
14
15
STEP 4: BUILD IN BUFFER TIME
16
Use half days or out-of-office days to account for vacations, family commitments, or unexpected interruptions. Planning buffer time upfront creates a more realistic and sustainable annual plan.
17
18
STEP 5: SET YOUR ANNUAL TARGET
19
Enter your primary annual billable hour goal. Optional secondary targets can be added to explore stretch goals and see required daily averages.
20
21
STEP 6: UPDATE ACTUAL HOURS MONTHLY
22
At the end of each month, enter actual billable hours worked. The planner will automatically compare expected versus actual hours and update remaining targets.
23
24
OPTIONAL: USE THE "BILLABLE TRACKER HOURLY PLAN"
25
If you prefer detailed planning, use the hourly planner tab to assign exact hours per day. This option is ideal for variable schedules or weekend planning.
26
27
FINAL TIP
28
This planner is designed to be flexible. Review and adjust regularly, plan conservatively, and allow buffer time to support long-term consistency and success. You've got this!
29