Home / Guides / Billable hours tracker

Guide · Time tracking · Excel

Billable hours tracker in Excel

You cannot invoice what you did not log. A one-sheet billable hours tracker in Excel separates client work from unpaid admin so your rate, quotes, and invoices stay honest — no another time-tracking subscription required.

May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.

What a billable hours sheet must capture

Column	Why it matters
Date	Ties hours to the week you will invoice and to quarterly income later
Client / project	Stops “misc work” from becoming an unbillable black hole
Task	Short label you can paste onto invoice line wording
Hours	Actual time, including the five-minute Slack reply you usually forget
Billable Y/N	Separates client work from admin, sales, and learning
Rate + estimated fee	Shows what those hours are worth before you open the invoice

Gray totals should show total hours, billable hours, non-billable hours, estimated fees, and billable %. If blank rate cells fall back to a default hourly rate, you stay consistent with your floor from the rate calculator.

Why Excel beats another time app (for many freelancers)

• Same stack as invoices — hours live next to the workbook you already bill from
• No monthly fee — one free file versus another SaaS login
• Honest utilization — billable % makes unpaid admin visible before you underprice next month
• You own the data — export, archive, or copy rows into Sole Ledger without waiting on an API

Keep a dedicated time app if you need automatic screenshots, team approvals, or client portals. For solo freelancers who already live in spreadsheets, a yellow-input sheet is enough.

Daily workflow that sticks

1. Log same day — date, client, task, hours, billable flag before you close the laptop.
2. Default rate — set once from Yellowcell’s free client rate calculator; override only for special project rates.
3. Weekly review — check billable %; if admin ate the week, fix next week’s schedule before you cut the rate.
4. Invoice from totals — group billable rows by client, copy hours × rate (or fixed fee) onto the invoice PDF.

Common traps

• Logging only “big” blocks and forgetting email / revisions
• Marking sales calls as billable when the client never agreed
• Using 40 × 52 as billable capacity when your real billable % is 50–60%
• Tracking time in one app and invoicing mismatched hours in another
• Never connecting the log to a rate floor — busy weeks that still underpay

From hours → rate → invoice

The free Yellowcell billable hours tracker logs time. Pair it with the free client rate calculator so your default hourly / day / project floor is not a guess. When you are ready to put those hours on a client PDF with expenses and a 2026 mileage sheet in one workbook, Sole Ledger (the invoice kit) is the soft upgrade — yellow inputs, no macros, no subscription.

Related SoloDesk guides

• Hourly rate calculator Excel vs pricing apps
• Client rate calculator in Excel
• Freelance day rate calculator in Excel
• Project fee calculator in Excel
• Progress billing invoice in Excel
• Name-your-price invoicing in Excel