WHERE THE HOURS WENT
Content—
Local profile—
Ads—
Email & CRM—
Reporting—
Client comms—
HOURS AGAINST THE BUDGET
Hours worked, all in—
Hours charged against the retainer—
Hours you gave away—
Hours left in the budget—
Share of the budget used—
Overage you could invoice—
WHAT THE MONTH IS WORTH
Revenue this month—
Direct cost to serve them—
Gross profit before your own time—
Gross margin—
WHAT YOU ARE REALLY EARNING
EFFECTIVE HOURLY RATE—
Retainer alone, per hour worked—
Above or below your target rate—
Hours this client can absorb at your target rate—
PROMISED VERSUS DELIVERED
Deliverables finished—
Profile / social posts still owed—
Website pages still owed—
Blog posts still owed—
Videos still owed—
Emails / campaigns still owed—
Reports still owed—
EVERYTHING STILL OWED—
Hours per finished deliverable—
Work Log
One row per session of work. Log it the day you do it — a month rebuilt from memory always undercounts.
| Date | What you did | Activity | Deliverable | How many | Hours | Counts against retainer? | Status | Notes | Hours used to date | Budget flag | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | — | — | |||||||||
| 2 | — | — | |||||||||
| 3 | — | — | |||||||||
| 4 | — | — | |||||||||
| 5 | — | — | |||||||||
| 6 | — | — | |||||||||
| 7 | — | — | |||||||||
| 8 | — | — | |||||||||
| 9 | — | — | |||||||||
| 10 | — | — | |||||||||
| 11 | — | — | |||||||||
| 12 | — | — | |||||||||
| 13 | — | — | |||||||||
| 14 | — | — | |||||||||
| 15 | — | — | |||||||||
| 16 | — | — | |||||||||
| 17 | — | — |