ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
HOW TO USE THIS TRACKER
2
Strategic Bookkeeping & Consulting | Bookkeeping Reinvented®
3
4
GETTING STARTED
5
Step 1Open the Time Log tab and begin entering your time daily.
6
Step 2Log every activity: client work, admin, email, meetings, everything.
7
Step 3Enter Time In and Time Out. Total Hours calculates automatically.
8
Step 4Mark Billable as Yes or No for each entry.
9
Step 5Enter your Hourly Rate for billable work. Billed Value calculates automatically.
10
Step 6Check the Monthly Summary tab weekly to see your patterns.
11
12
COLUMN GUIDE
13
DateThe date the work was performed.
14
Client / ProjectWho or what the time was spent on.
15
Task DescriptionBrief description of what you actually did.
16
Categorye.g. Bookkeeping, Admin, Sales, Marketing, Operations
17
Time In / Time OutUse consistent format: 9:00 AM, 2:30 PM
Tip: Use military time to automatically have the system log as AM or PM; i.e. 2:30 PM is 14:30 hours 9:00 AM is 09:00 hours
18
Total HoursCalculates automatically from Time In and Time Out.
19
Billable?Type Yes or No. Used for summary calculations.
20
Hourly Rate ($)Your rate for this work. Leave blank for non-billable.
21
Billed Value ($)Calculates automatically when Billable = Yes and Rate is entered.
22
23
JESSICA'S TIP
24
Tool RecommendationI use Clockify (free) to track time in real time, then log summaries here weekly.
25
Minimum CommitmentTrack for at least 4 consecutive weeks before drawing conclusions.
26
The GoalUnderstand the real cost of your time so every pricing and hiring decision is built on data not instinct.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100