Shop / Guides / Freelance billable hours tracker Excel

Guide · Time & billing

Freelance billable hours tracker in Excel

A freelance billable hours tracker is a simple Excel log of who you worked for, what you did, how long it took, and whether those hours made it onto an invoice — not a vague calendar scribble you reconstruct on Sunday night. Yellowcell’s free billable hours tracker keeps yellow input cells and gray helpers so you can open it in Excel or upload to Google Sheets with no macros.

What a billable hours log should capture

• Date — the day the work happened (not the day you remembered)
• Client / project — who pays, plus a short project tag if you juggle several
• Task — one-line description you would put on an invoice line
• Hours — decimal hours (1.5, not “about 90 minutes”)
• Rate — hourly rate for that client or project
• Amount — hours × rate (helper formula is fine)
• Invoice status — unbilled, on draft, sent, paid

If a row cannot survive a client asking “what did I pay for?”, it is not billable detail yet.

Simple Excel layout (yellow in, gray helpers)

Column	Example
Yellow — date	2026-09-12
Yellow — client / project	Acme · brand site
Yellow — task	Homepage copy revisions
Yellow — hours	1.5
Yellow — rate	85
Gray — amount	=hours×rate
Yellow — invoice status	Unbilled / Sent / Paid
Yellow — notes (optional)	Round to 0.25 if your contract says so

Examples only. Replace every yellow cell with your own time entries before you invoice.

Habits that keep hours from leaking

1. Log same day — even a rough row beats reconstructing the week from Slack
2. One row per work block — do not smash three clients into one “misc” line
3. Invoice from the log — filter unbilled → copy line items → mark sent
4. Separate non-billable — admin and learning belong elsewhere or in a tagged row

• Timers help only if the export lands in a sheet you actually invoice from
• Retainer clients still need a log when scope creep shows up
• Rate mistakes usually mean the rate column was blank — fill it per client

From hours log to invoice

• Filter Unbilled for one client for the billing period
• Copy date / task / hours / amount onto your invoice lines
• Mark those rows Sent the same day you send the invoice
• When payment clears, flip them to Paid (or archive that month’s sheet)

Pair with rate + invoice tools

• Free client rate calculator — turn take-home goals into hourly / day / project fees
• Freelance invoice template — expense + mileage companion when you bill out the hours
• Money Kit ($29) — invoice, budget, and debt sheets in one bundle when you want the paid set

Educational templates for record-keeping only — not tax, legal, or accounting advice.