Billable hours are the difference between working and getting paid — yet most first-time consultants reconstruct them from memory on invoice day, guess the rate math, and never know their real utilization. This template builds a clean, professional one-page timesheet in minutes — client, period, dated entries, hourly or retainer — with every billable total computed automatically. Fill in the fields, preview it live, and copy or download it — free.
The timesheet updates live as you type — free to preview, with every billable total computed automatically. Enter your email to copy or download it.
Amount: $450.00
Amount: $1,200.00
Amount: $1,050.00
Retainer-covered · 2 hrs
Unbillable · 1 hrs (not invoiced)
Amount: $1,625.00
Retainer-covered · 3 hrs
Retainer-covered · 4 hrs
Amount: $450.00
Unbillable · 2.5 hrs (not invoiced)
Enter your email to unlock your finished timesheet — copy the formatted text to your clipboard or download it as a file (opens in any browser, prints to PDF). We'll also send you consulting launch tips — no spam, unsubscribe anytime.
Preview is always free · Email unlocks copy & download
The template above builds all six parts automatically. Here's what each one does and why it matters when a client reviews — or disputes — your hours.
Every timesheet names three things before any hours: who logged the time, which client it's for, and which project or engagement it belongs to. A timesheet with no client attached can't be tied to an invoice later — and a client who receives an unattributed hours list will query it.
Start date and end date, always. The period is what turns a pile of hours into a billable unit: it maps to an invoice line, matches your engagement letter's billing cycle, and gives both sides an agreed cutoff. "Whenever I remember to send it" is not a period.
One row per block of work: the date, what you actually did, and the hours. "Discovery call — goals and CRM access" survives a billing dispute; "worked on project" does not. Log entries the day they happen — reconstructed hours are always wrong, usually downward.
Each entry is one of three things: billable hourly work (priced by your rate), unbillable time (admin, proposals, your own marketing — logged but not invoiced), or retainer-covered work (hours drawn against the monthly retainer). The classification is what makes the totals honest.
Billable entries multiply hours × rate automatically — your default rate, or a per-entry override when a block of work prices differently. Hand-multiplied spreadsheets produce wrong totals at the worst possible moment: on an invoice a client is about to pay. Auto-math can't be wrong.
The bottom block answers the only questions that matter: total hours logged, billable hours and their dollar total, unbillable and retainer hours, your effective blended rate, and the total billable amount. That number flows straight onto your invoice — the timesheet is its evidence.
The classification on each entry isn't bureaucracy — it's the difference between a timesheet that supports your invoice and one that just makes you feel busy. Here's how to sort your hours.
Work your agreement prices hourly: discovery calls, analysis, deliverable time, review sessions. These entries multiply by your rate and land on the invoice. If you're unsure whether something is billable, the answer is in your engagement letter or SOW — not in how you feel that week.
Retainer time is billable in spirit but not by the hour: the monthly retainer already paid for it. Log it anyway. If retainer hours keep exceeding what the retainer covers at a sane effective rate, that's your evidence to raise the retainer — or cap the hours in the retainer agreement.
Invoicing, bookkeeping, writing the next proposal, your own website, learning a tool the client needs. You can't skip it and you can't bill it — so it has to be covered by your rate. Track it for a month and you'll never guess your utilization again.
The extra revision nobody scoped, the "quick question" calls that run 40 minutes, the work that crept past the SOW. Logging it as unbillable makes the creep visible in dollars. Then either price it (a change order), fence it (out-of-scope clause), or stop it.
Because your effective blended rate — billable dollars ÷ all hours worked — is the real number your business runs on. A $300/hr consultant who bills 20 of a 45-hour week earns $133/hr of actual life. That's the number that tells you to raise your rate, tighten your scope, or both.
The timesheet feeds the invoice — build both the same week. Use the consulting invoice template to turn these billable hours into a formatted one-page invoice with payment terms, or the retainer agreement generator to cap the retainer hours in the first place.
Friday's "about 10 hours this week" is always wrong — and almost always low. Log each block the day it happens, rounded to the quarter hour. Same-day entries with real descriptions are also your only defensible position in a billing dispute.
"Worked on deliverables" invites a query and a delayed invoice. "Drafted funnel diagnostic — findings and prioritized fixes, 3.5 hrs" gets approved and paid. Write the description you'd want to read if you were the one paying the invoice.
Unbillable hours you don't log are hours that quietly lower your real rate without telling you. Track admin, proposals, and marketing for one month — the utilization number you get back is the single most useful pricing input a new consultant can have.
A spreadsheet formula dragged one row short, a rate typo, a missed entry — hand-built timesheet math fails silently and surfaces on the invoice. Auto-computed totals (hours × rate, summed) make the number on your invoice the same number your timesheet proves.
A timesheet with no start and end date can't map to an invoice, can't match your engagement letter's billing cycle, and gives the client no agreed cutoff for what's in scope. Two date fields fix all of it.
A timesheet sits in the middle of a chain: agree the rate, scope the work, track the hours, bill them. These free tools cover every step on either side.
The timesheet's billable total becomes the invoice's line items — from/bill-to, hourly or fixed-fee items, payment terms, and a due date in a formatted one-page invoice. Same free tool shape, same email unlock.
Not sure what to put in the rate field? Calculate a defensible hourly rate range by industry, experience, and service type — then track your hours against it.
Entry, median, and top-tier hourly ranges for 15+ consulting niches — see where your rate sits before you commit it to a timesheet.
If you log retainer hours, the retainer agreement is what caps them — generate one with scope, monthly fee, and hour limits before the period starts.
Your timesheet's billable/unbillable line is only as solid as the scope behind it. Generate a one-page SOW that defines what's in and out — so entries classify themselves.
The contract sets the rate and billing terms your timesheet assumes — parties, fees & payment terms, termination, IP, and signatures in a ready-to-sign one-page agreement. Free.
The full invoicing playbook — how to number invoices, when to send, how to chase a late payment politely — with examples for hourly, fixed-fee, and retainer billing.
Rate calculator, proposal, contract, SOW, engagement letter, retainer agreement, invoice template, this timesheet generator, and more — all free, all instant.
The Consulting Launch Kit gives you a one-line positioning statement, 3 productized offers with pricing, a rewritten bio, a cold-outreach email sequence, a proposal template, and a 30-day plan to land your first 3 clients — personalized to your niche and delivered instantly. Just $29.
Get the launch kit — $29 →One-time · No subscription · 7-day money-back guarantee