IT Consultant Tracks Weekly Hours Across Multiple Clients
James is an independent IT consultant juggling three active clients. Here's how he tracks his time professionally for the week of January 8-12, 2025.
James's Client Portfolio
Client A - FinTech Startup: Network security assessment (£85/hour)
Client B - Law Firm: Server migration project (£80/hour)
Client C - Retail Chain: Email system upgrade (£75/hour)
Monday, January 8
| Time | Client | Task | Hours |
|------|--------|------|-------|
| 09:00-10:30 | Client A | Security vulnerability assessment - initial scan | 1.5 |
| 10:30-11:00 | Admin | Emails & scheduling | 0.5 (non-billable) |
| 11:00-13:00 | Client B | Plan server migration timeline | 2.0 |
| 13:00-14:00 | Lunch | - | - |
| 14:00-17:00 | Client B | Document current server configuration | 3.0 |
| 17:00-17:30 | Client C | Status call with IT manager | 0.5 |
Daily Total: 7.5 hours (7.0 billable, 0.5 non-billable)
Tuesday, January 9
| Time | Client | Task | Hours |
|------|--------|------|-------|
| 09:00-12:00 | Client A | Review security scan results, document findings | 3.0 |
| 12:00-13:00 | Lunch | - | - |
| 13:00-13:30 | Client A | Create summary report for stakeholders | 0.5 |
| 13:30-14:00 | Admin | Invoice preparation Client A | 0.5 (non-billable) |
| 14:00-17:30 | Client C | Begin email system configuration | 3.5 |
Daily Total: 7.5 hours (7.0 billable, 0.5 non-billable)
Wednesday, January 10
| Time | Client | Task | Hours |
|------|--------|------|-------|
| 09:00-10:00 | Client B | Morning standup & planning session | 1.0 |
| 10:00-13:00 | Client B | Begin server data backup procedures | 3.0 |
| 13:00-14:00 | Lunch | - | - |
| 14:00-16:00 | Client B | Test backup and recovery procedures | 2.0 |
| 16:00-17:00 | Client A | Follow-up call on security recommendations | 1.0 |
Daily Total: 7.0 hours (all billable)
Thursday, January 11
| Time | Client | Task | Hours |
|------|--------|------|-------|
| 09:00-12:30 | Client C | Complete email system setup & configuration | 3.5 |
| 12:30-13:30 | Lunch | - | - |
| 13:30-15:00 | Client C | User training session for email administrators | 1.5 |
| 15:00-17:00 | Client B | Server migration Phase 1 execution | 2.0 |
Daily Total: 7.0 hours (all billable)
Friday, January 12
| Time | Client | Task | Hours |
|------|--------|------|-------|
| 09:00-11:00 | Client B | Complete server migration, verification testing | 2.0 |
| 11:00-12:00 | Client B | Document new server configuration | 1.0 |
| 12:00-13:00 | Lunch | - | - |
| 13:00-14:30 | Client C | Resolve email sync issues for 2 users | 1.5 |
| 14:30-15:30 | Admin | Weekly reporting, timesheet review | 1.0 (non-billable) |
| 15:30-17:00 | Admin | Professional development (learning new tools) | 1.5 (non-billable) |
Daily Total: 7.0 hours (4.5 billable, 2.5 non-billable)
Weekly Summary
Hours by Client
| Client | Hours | Rate | Total |
|--------|-------|------|-------|
| Client A | 6.0 | £85/hr | £510.00 |
| Client B | 14.0 | £80/hr | £1,120.00 |
| Client C | 7.0 | £75/hr | £525.00 |
| Billable Total | 27.0 | | £2,155.00 |
| Admin/Non-billable | 5.0 | - | £0 |
| Grand Total | 32.0 | | £2,155.00 |
Metrics James Tracks
- Utilization Rate: 84% (27 billable ÷ 32 total hours)
- Average Rate: £79.81/hour
- Target: 75% utilization minimum
How James Uses This Data
For Invoicing
- Creates three separate invoices on Friday afternoon
- Attaches timesheet summary to each invoice
- References specific tasks in invoice line items
Example Invoice to Client B:
Professional Services - Week of 8 Jan 2025
Server Migration Project
14.0 hours @ £80/hour
Detailed timesheet attached
Total: £1,120.00
For Business Insights
James reviews weekly to identify:
- Most profitable clients (rate × volume)
- Time-consuming vs quick tasks
- Whether to adjust rates
- If he can take more work
For Client Communication
When Client B asks "What did you do this week?":
- James sends timesheet excerpt
- Shows specific deliverables
- Demonstrates value provided
Best Practices James Follows
✅ Logs time immediately after each task
✅ Uses consistent 30-minute increments (easier billing)
✅ Specific task descriptions (not vague "consulting")
✅ Separates billable vs non-billable clearly
✅ Reviews daily to catch missed entries
✅ Backs up digitally (spreadsheet + PDF copies)
Common Scenarios & Solutions
Switching Tasks Mid-Work
- James logs the partial time immediately
- Starts new entry for new task
- Doesn't try to remember hours later
Client Calls During Other Work
- Pauses current task timer
- Logs call separately
- Resumes previous task
Tiny Tasks (10-15 minutes)
- James rounds to nearest 0.5 hour
- Notes actual time in description
- Clients appreciate honesty
Create Your Professional Timesheet
Ready to track your time professionally? Use our timesheet builder to create organized, client-ready timesheets.
Disclaimer: This example is for planning purposes only. Time tracking requirements vary by contract and region. Consult with an accountant about proper record-keeping for your situation.