How-to
How to Track Billable Hours for Freelance Projects
Quick Summary
Track billable hours by logging every task as you go, with the date, client, project, start and end time, and whether the work is billable. Use a spreadsheet, notebook or app, and review entries weekly. Consistent logs produce accurate invoices and a clear view of your effective hourly rate.
- Log every task from day one instead of reconstructing hours later.
- Organize entries by client, then project, then task.
- Put billable definitions and rounding rules in your contract.
- Divide project fee by total hours, including non-billable time, for your effective rate.
- A spreadsheet works for free if you log entries consistently.
Table of Contents
- Why Freelancers Should Track Billable Hours
- Billable Versus Non-Billable Hours: What Counts
- Step-by-Step: Tracking Billable Hours by Client and Project
- Free Time Tracking Apps for Freelancers: Comparison and Pricing
- Building a Freelance Hours Tracker Template
- Rounding, Minimum Increments and Disputed Hours in Contracts
- Turning Tracked Hours Into Accurate Invoices and Estimating Your Effective Rate
- Setting Up Your Hours Log This Week
- Frequently Asked Questions
Why Freelancers Should Track Billable Hours
Last Updated: November 16, 2026
Every freelancer knows the feeling of finishing a project and wondering how many hours it really took. Without a record, billable hours for freelance projects tend to disappear into memory, and that usually means underbilling. Tracking your time turns vague guesses into facts you can invoice from, defend in a dispute and learn from. Freelancers who know their hours tend to price their work better.
Tracking gives you three practical advantages:
- Accurate invoices. You bill for what you actually did, not what you remember.
- Better pricing. You can see which clients and project types pay well for your time.
- Clear records. A dated log helps if a client questions a bill or if you need to prove income.
A common mistake is treating time tracking as busywork you do only when a client asks. Start with a simple log for every project from day one. Retroactive reconstruction is where most hours go missing.
Billable Versus Non-Billable Hours: What Counts
Billable hours are time you spend on work a client pays for. Non-billable hours are time you spend running the business, such as emails about scheduling, admin, invoicing, learning new software or marketing your services.
Both matter. Billable hours produce revenue. Non-billable hours show you the real cost of running your freelance business.
Watch out: Some clients expect you to absorb small tasks, like a quick file resend or a short call. Decide your policy in advance and write it into your contract so the line between billable and non-billable stays clear.
Step-by-Step: Tracking Billable Hours by Client and Project
Organize your time in a clear hierarchy: client, then project, then task. This structure lets you see what each client costs you and invoice without digging through notes.
- Create a client entry. Record the client name, billing contact and agreed rate.
- Create a project entry under each client. Note the scope and the deadline.
- Log each task as you go. Write a short description, the date, the start and end time, and whether it is billable.
- Review weekly. Check for gaps, missing entries and any task that ran far longer than expected.
- Export or summarize before invoicing. Total the billable hours for each project and match them to your invoice.
Keep your descriptions specific. "Client call" is less useful than "Revised homepage copy after feedback call."
Setting Up a Manual Workflow Without an App
You do not need software to track time well. A spreadsheet or notebook works if you use it consistently.
- Make one row per entry with these columns: date, client, project, task, start time, end time, total hours, billable (yes or no), and notes.
- Use a formula such as
=(end - start) * 24to calculate hours in a spreadsheet. - Build a summary tab that totals billable hours by client each week.
- Save a copy at the end of each month for your records.
This approach costs nothing, but it demands discipline. Set a daily reminder to log entries before you close your laptop.
Starting and Stopping Timers for Individual Tasks
Timers capture time more accurately than memory does. Start a timer when you begin a task and stop it when you switch tasks or take a break. If you forget to stop it, correct the entry right away while you still remember what you did.
For short tasks under 15 minutes, consider logging them in batches at the end of the day. Round them consistently (see the section on rounding below) so the total stays fair to you and your client.
Free Time Tracking Apps for Freelancers: Comparison and Pricing
Many freelancers prefer an app over a spreadsheet. The table below summarizes common options. Always confirm current pricing directly on each provider's website, since plans change.
| Option | Pricing | Best For | Key Drawback |
|---|---|---|---|
| Spreadsheet (Google Sheets or Excel) | Free or included with your existing software | Freelancers who want full control | Manual entry and no automatic timers |
| Free time-tracking app tiers | Varies; check each provider's pricing page | Solo freelancers with a few clients | Usage limits or fewer reporting features |
| Paid time-tracking apps | Varies; check each provider's pricing page | Freelancers with many clients and invoices | Recurring cost that must be justified by billed hours |
| Hate Ledger | Free-forever tier; see the Hate Ledger pricing page for current plans | Freelancers who want tracked hours connected to income and tax reserves | Best suited to freelancers who want a single view of earnings and obligations |
Pros and cons of each recommended approach:
- Spreadsheets. Pros: free, flexible, easy to customize. Cons: manual, easy to neglect.
- Free app tiers. Pros: automatic timers, clean reports. Cons: limits can push you toward paid plans.
- Paid apps. Pros: deeper reporting and client-facing features. Cons: monthly cost.
- Hate Ledger. Pros: a free-forever tier and a single daily view of what you can safely spend. Cons: it is built for freelancers who want their accounting simplified, not for teams needing heavy project management.
Building a Freelance Hours Tracker Template
A template makes tracking repeatable. Use these headers in your sheet:

| Date | Client | Project | Task | Start | End | Hours | Billable | Notes |
|---|---|---|---|---|---|---|---|---|
| 11/03 | Acme Co. | Website redesign | Homepage wireframes | 9:00 | 11:30 | 2.5 | Yes | Round 1 feedback pending |
Add a monthly summary below the log that totals billable hours per client. Compare the totals against your invoices each month. If a client's hours are consistently higher than their invoices, your rate or scope needs review.
Rounding, Minimum Increments and Disputed Hours in Contracts
Clients dispute hours when the agreement is vague, not when the work is wrong. Put four things in writing before the first invoice: what counts as billable, how time is rounded, how hours are approved, and how corrections are handled.
What counts as billable
List the activities explicitly. A workable clause reads: "Billable time includes project work, client-requested revisions, scheduled calls, and file preparation. Non-billable time includes general email, invoicing, and marketing." If a client expects small tasks to be absorbed, say so: "Requests under 10 minutes are not billed individually but are logged and reviewed monthly." That sentence prevents the slow accumulation of unbilled work.
Rounding rules with a worked example
Pick one method and apply it to every client. Three common options:
- Round up to the nearest quarter hour per task. A 22-minute task bills as 0.5 hours. Simple, but it can look padded on a detailed invoice.
- Round to the nearest tenth of an hour (six minutes). A 22-minute task bills as 0.4 hours. More defensible when a client audits the log.
- Round to the nearest quarter hour at the end of the day. Daily totals are rounded, not individual tasks. This smooths short-task noise but requires a daily total.
A worked example: three tasks of 22, 18, and 35 minutes. Rounding each up to the quarter hour gives 0.5 + 0.5 + 0.75 = 1.75 hours. Rounding each to the nearest tenth gives 0.4 + 0.3 + 0.6 = 1.3 hours. Rounding the daily total (75 minutes) to the nearest quarter hour gives 1.25 hours. The method changes the invoice, so state it in the contract and show it on the invoice.
Minimum increments
A minimum increment sets the smallest billable block. "The minimum billable increment is 15 minutes" means a 5-minute call bills as 15 minutes. This is common for client calls and quick reviews. Set the increment high enough to cover the interruption cost but low enough that a client will accept it. Fifteen minutes is a common starting point for solo freelancers.
Approval and correction mechanics
Approval should be a defined step, not an assumption. A practical clause reads: "Time summaries are sent weekly. The client has five business days to object to specific entries.
Send the summary as a short table: date, task, hours, and a one-line note. Clients approve tables faster than paragraphs. Keep the sent copy; it is your evidence that the hours were reviewed.
When a dispute happens
Do not renegotiate the whole invoice over one line. Isolate the disputed entry, show the dated log and the task description, and offer a correction on that line only.
Watch out: Rounding up on every task and also applying a 15-minute minimum can double-count short work. Choose one mechanism per task type and write it down.
Keep the detailed log after invoicing. If a client questions a bill months later, the dated entries and the sent summary are what resolve it.
Turning Tracked Hours Into Accurate Invoices and Estimating Your Effective Rate
Once you have accurate hours, invoicing becomes simple. List each project, the billable hours, your rate and the total. Attach or reference the time summary when a client wants detail.
To find your effective hourly rate, use this formula:
Effective hourly rate = Project fee ÷ Total hours spent (billable and non-billable)
For example, if you charge $2,400 for a project that took 30 billable hours and 6 hours of revisions and admin, your effective rate is $2,400 ÷ 36 = about $66.67 per hour. Compare that number to your target rate. If it falls short, adjust your scope, rate or process for the next project.
Remember that taxes apply to your net earnings, so set aside a portion of each payment. Consult a qualified tax professional for guidance specific to your situation.
Watch out: Estimating too low on your first project with a new client often leads to scope creep. Track carefully from the start so you have data for future quotes.
Setting Up Your Hours Log This Week
Start small this week. Create your client and project list, set up the template above, and log every task for seven days.
Do this consistently for one month. By then you will have real numbers on your clients, your rates and your effective hourly income.
If you want one place to see your earnings, expenses and tax reserves alongside your work, Hate Ledger offers a free-forever tier. Start free and see how your billable hours look next to what you actually take home.
Frequently Asked Questions
How do I track billable hours for freelance work?
Log every block of client work with the date, client, project, task description, and start and end times, then mark each entry as billable or non-billable. Record entries the same day you work them, since memory is unreliable after a few days. A simple spreadsheet, a notebook or a free time tracking app all work, as long as you keep the same fields every time. At the end of each week, total billable hours per client so you can check them against your invoices and your contract terms.
Is there a free way to track billable hours?
Yes. A spreadsheet with columns for date, client, project, task, start time, end time, duration and billable status is free and works well for most freelancers. Many free time tracking apps also offer a basic tier with timers and client or project tags, which can export reports for invoicing. Check whether a free plan limits the number of clients, projects or exports before you rely on it for billing.
How often should freelancers record their project hours?
Record hours daily, or at least at the end of each work session. Daily logging reduces forgotten work, which is a common source of revenue leakage, and makes disputed hours easier to resolve because the entries are close to the work. Review your log weekly to catch gaps, and reconcile totals against each client's approved budget before sending an invoice.
How do freelancers turn tracked hours into accurate invoices?
Filter your tracked entries by client and billing period, include only entries marked billable, and apply the rounding rule and minimum increment set in your contract. Multiply the total by your agreed hourly rate and list each project or task on the invoice so the client can match it to the time log. Keep the detailed log on file in case the client questions any hours.