Free Time Tracking & Utilization Spreadsheet
Log billable vs non-billable hours and watch weekly utilization.
What this is
Weekly billable vs non-billable hours with utilization %. Helps freelancers see whether low income is a sales problem or a time-allocation problem.
Best for
- Freelancers feeling ‘busy but broke’
- Studios watching utilization targets
- Consultants protecting deep work
What’s included
- Weekly billable and non-billable hours
- Utilization %
- Notes for context
Preview
| Week starting | Billable hours | Non-billable hours | Total hours | Utilization % | Notes |
|---|---|---|---|---|---|
| 2026-07-28 | 28 | 10 | 38 | 73.7 | Admin heavy |
| 2026-08-04 | 32 | 6 | 38 | 84.2 |
How to use
- Utilization % = Billable ÷ Total × 100.
- Aim for a sustainable target (often 70–85% for freelancers).
- If utilization dips, audit non-billable categories.
Tips
- Track for 4 weeks before changing your offers.
- If utilization is high but income is low, rates are the issue.
- If utilization is low, sales/marketing time needs a block on the calendar.
FAQ
What utilization target?
Many freelancers aim for roughly 70–85%. 100% is a burnout plan.