Freelance Timesheet Templates

A freelancer's timesheet does three jobs at once: it backs up the invoice, it tells you whether a fixed-price project is still profitable, and it shows where the unpaid hours go. Most freelancers keep the first and skip the other two, which is why fixed-price work so often ends up paying less than the hourly rate they quote.

These templates cover the three. A daily and a weekly timesheet for the invoice, a per-client tracker for the relationship, a project budget tracker that compares hours logged with hours quoted, and an invoice summary. The Excel file does the arithmetic; the Word and PDF versions print cleanly for a paper log or a client who wants a signed sheet.

Download the templates

What is in the templates

• Daily timesheet. Start, end, client, project, task, billable flag and hours, with amounts calculated in Excel.
• Weekly timesheet. Hours per project per day for the week, totaled and priced.
• Project budget tracker. Fee and hours quoted against hours logged, with the effective rate and an over-budget flag, which is the number fixed-price freelancers most need and least often see.
• Invoice summary. Every invoice with sent, due and paid dates and days late.

Fixed price versus hourly: the number that matters

Hourly work pays the rate. Fixed-price work pays the fee divided by the hours it actually took, and nobody knows that number unless the hours were logged. A $3,000 project quoted at 30 hours is $100 an hour; at 45 hours it is $67. The project budget sheet calculates the effective rate as you log and flags the project at 80 percent of the quoted hours, which is when to raise scope with the client, not after the overrun.

Over a year, the tracker tells you which kinds of project you consistently under-quote, which is the single most useful thing a freelancer's timesheet can reveal.

Track the unpaid hours

Proposals, admin, invoicing, learning and the client call that was "just a quick question" are all working hours with no invoice. Log them under a non-billable client so they show in the weekly total. Freelancers who do this typically find a third of their hours are unpaid, and that knowledge changes what they charge. The billable hours calculator converts the split into utilization and a target rate.

If you are classified as an independent contractor, the hours are also your evidence of control over your own schedule, which is part of the test in the 1099 versus W-2 rules.

Habits that keep the sheet honest

• Start the timer or write the start time when you begin, not when you remember.
• One row per task, not per day; the detail is what gets invoices paid.
• Log to the minute; round once on the invoice at the increment the contract states.
• Reconcile the week on Friday, while the work is still fresh.
• Export to PDF with each invoice so the backup cannot change afterwards.

Key takeaways

• A freelance timesheet backs up invoices, reveals the effective rate on fixed-price work, and shows where unpaid hours go.
• Track project hours against the quote and act at 80 percent, not after the overrun.
• Log non-billable time under its own client to see your real rate.
• Log to the minute, round at the invoice, freeze the sheet as a PDF when you bill.