How to Track Billable Hours as a Freelancer

Why Tracking Billable Hours Matters

Every freelancer who bills by the hour knows the problem: you think you worked 30 hours this week, but when you sit down to log everything, you can only account for 22. Those 8 lost hours represent real money — potentially hundreds or thousands of dollars per month that you're giving away for free.

Tracking billable hours isn't just about invoicing clients accurately. It reveals your true hourly rate (which is almost always lower than your stated rate once you factor in admin, marketing, and communication time), helps you identify which clients and projects are most profitable, and gives you the data to make better decisions about your rates and workload.

Billable vs. Non-Billable Time

Before you start tracking, you need to clearly define what counts as billable. This varies by freelancer and client agreement, but here's a general framework:

Typically Billable

• Active project work (design, development, writing, consulting)
• Client meetings and calls
• Research directly related to the project
• Revisions requested by the client
• Project-specific communication (detailed email threads about deliverables)

Typically Non-Billable

• Marketing and business development
• Invoicing and bookkeeping
• Learning new skills (unless the client is paying for training)
• General email and administrative tasks
• Proposal writing and pitching
• Setting up your workspace or tools

Setting Up a Time Log in Excel

A good time log needs just six columns. Keep it simple — the more complex your tracking system, the less likely you are to use it consistently.

Key Formulas for Your Time Log

Choosing a Time Tracking Method

There are three common approaches to time tracking. Each has trade-offs, and the best one depends on your work style.

Method 1: Real-Time Logging

Start a timer when you begin a task, stop it when you switch. This is the most accurate method but requires discipline. It works best if you tend to work in focused blocks and don't context-switch frequently.

Method 2: End-of-Day Recall

At the end of each workday, write down what you did and estimate the hours. This is less accurate than real-time logging but much easier to maintain. Most freelancers can recall their day with reasonable accuracy if they do it the same evening.

Method 3: Calendar-Based

Block your calendar for each task as you work, then transcribe the blocks into your time log at the end of the week. This gives you a visual record of your day and helps with both time tracking and scheduling.

Calculating Your True Hourly Rate

Your stated rate and your actual effective rate are rarely the same. Here's how to calculate what you're really earning per hour of work.

Stated rate: What you quote clients (e.g., $85/hour).

Effective rate: Total revenue ÷ Total hours worked (including non-billable time).

For example, if you bill 25 hours at $85/hour but work 40 hours total that week, your effective rate is $2,125 ÷ 40 = $53.13/hour. That's 37% less than your stated rate.

This number is what you should actually use when evaluating whether a project is worth taking, comparing freelancing to full-time employment, or deciding when to raise your rates.

Rounding and Minimum Increments

Decide on your minimum billing increment and stick to it. Common options:

• 6-minute increments (0.1 hours): Standard in legal and consulting. Most precise, but can be tedious to track.
• 15-minute increments (0.25 hours): The most common for freelancers. A good balance of accuracy and simplicity.
• 30-minute increments (0.5 hours): Simple but can feel unfair to clients for short tasks. Consider using this only for tasks that naturally take at least 30 minutes.

Always round up, not down. A 7-minute phone call billed at 15-minute increments is 0.25 hours. This is standard practice and accounts for the context-switching cost of interruptions.

Weekly and Monthly Summaries

Raw time logs are useful for invoicing, but to understand your business, you need summaries. Create a separate section or sheet that aggregates your time data into weekly and monthly views.

Useful summary metrics include total hours by client, billable vs. non-billable split, revenue by client and project, your effective hourly rate for the period, and your utilization rate trend over time.

These summaries tell you which clients take more time than they're worth, whether your utilization is improving or declining, and when you have capacity to take on new work.

Common Time Tracking Mistakes

Not tracking non-billable time. You need to see the full picture. If you only track billable hours, you have no idea what your utilization rate is or where your non-billable time goes.

Batching time entries at the end of the week. Memory degrades quickly. By Friday, you'll have forgotten the 20-minute client call you took on Tuesday and the hour you spent researching a solution on Wednesday.

Using too many categories. Keep your project and task categories simple. If you have 50 different task types, the overhead of categorizing each entry will discourage you from tracking at all.

Not reviewing the data. The whole point of tracking is to make better decisions. Set a monthly reminder to review your time data and look for patterns — which clients are most profitable, which projects take longer than estimated, and whether your utilization is trending in the right direction.

From Time Log to Invoice

Your time log should feed directly into your invoicing process. At the end of a billing period, filter your time log by client and date range, sum the billable hours, multiply by the agreed rate, and transfer those numbers to your invoice.

If you're using Excel, this can be as simple as a SUMIFS formula that pulls billable hours for a specific client and date range. No manual counting required.