How to Create a Timesheet

Friday afternoon. You need to invoice a client for the week. You open a blank document and try to remember what you actually did on Tuesday.

If that sounds familiar, a timesheet is the fix.

---

What a timesheet is for

A timesheet is a record of hours worked over a given period. Each row captures a date, what you did, how long it took, and your rate. The total tells you and your client exactly what the work cost.

For any work billed by the hour, a timesheet is the evidence behind the invoice number. It answers the client's question before they have to ask it.

---

What to track

Each row should have four things.

Date. The specific date, not just the week. If a client questions a charge, you need to show which day the work happened.

Description. What you actually did, not just the project name. "Strategy call with marketing team, prep and follow-up notes" is useful. "Consulting" is not. Write it in enough detail that a stranger could understand what the work was.

Hours. The actual hours, including fractions if you work in 15-minute or 30-minute increments. If your rate is hourly, round down when you are unsure.

Rate. Your hourly or daily rate. If you charge different rates for different types of work, show the rate on each row.

The row total is hours multiplied by rate. At the bottom, the grand total is what you invoice.

---

The period matters

A timesheet covers a defined period: a week, a fortnight, a month. The start and end dates appear on the document so the client knows exactly what they are paying for. If you work on a retainer with a cap, the period helps both of you track whether the cap was hit.

Most freelancers who bill by the hour run weekly or monthly timesheets. Pick one and stay consistent with each client. Clients who receive a timesheet on the same schedule each month build a mental model of your billing rhythm. That tends to make payment faster. For more on fitting time records into a freelance routine, see timesheets for freelancers.

---

Why the detail matters

A detailed timesheet does two things.

First, it makes your invoice defensible. If a client says "this seems high," you can point to specific dates, tasks, and durations. The conversation is usually short and ends with them approving the invoice.

Second, it makes your estimates better. If you track time consistently, you start to know how long things actually take. That knowledge is worth real money when you are quoting a new project.

From timesheet to invoice

A timesheet is not an invoice. It is the source document behind one.

Once the period ends, use your timesheet totals to fill in the line items on your invoice. The description, hours, and rate on each timesheet row become a line item. Or you summarize: "Week of 12 May 2026: 18.5 hours across strategy, copy review, and client calls." If billing is new to you, how to create an invoice covers the rest of the document.

Some clients want the timesheet attached to the invoice. Others just want the invoice. Ask once at the start of the relationship and you will not need to ask again.

The timesheet tool on Invoice No. generates a clean PDF with the period dates, and rows for date, description, hours, and rate. Once the timesheet is done, go to the invoice generator to bill the client. Both documents live in your browser, no account required.

---

Track as you go, not at billing time

The biggest mistake with timesheets is waiting until billing day to fill them in. Memory is unreliable. What actually took three hours can feel like ninety minutes two weeks later. What felt like a full day was probably closer to six hours.

Log each session when it ends. A note on your phone, a line in a spreadsheet, a comment in your task manager. The method does not matter as long as you actually do it.

A few seconds when the work is fresh saves fifteen minutes of guesswork every Friday.