A good timesheet is simple enough to update during a busy day and detailed enough to support an invoice weeks later. The template should reflect the way you sell work, whether by one rate, several roles, retainers, or capped hourly projects.

Treat the template as a source record rather than a decorative report. Use stable columns, clear task names, and a defined approval step. That consistency helps you notice missing time, monitor budget, and answer billing questions without reconstructing the week.

Essential timesheet fields

Every entry needs a date, client, project, task description, and duration. Include start and end times only when the agreement or workflow needs them; a verified duration may be enough for many projects.

Add the billing rate or rate category when one client uses multiple rates. A billable status, approval status, and invoice reference help separate recorded work from hours that are ready to charge.

  • Date, client, and project
  • Task and outcome description
  • Duration and billing rate
  • Billable and approval status

Organize the template for fast entry

Use one row per uninterrupted task or meaningful work block. Standard project and activity names reduce spelling variations and make weekly totals more reliable.

Keep client-facing descriptions separate from private notes. The client column should explain the delivered work, while an internal note can record interruptions, estimate concerns, or follow-up actions.

  • Use one consistent row format
  • Select projects from a fixed list
  • Keep descriptions short and specific
  • Separate private notes from billing notes

Copy-ready weekly timesheet example

Copy the column names and sample rows below into a spreadsheet, then replace the client, task, rate, and status values. This example separates billable delivery from internal administration and gives every approved row enough detail to support an invoice.

The sample records 6.5 hours, of which 5.5 are billable. At $75 per hour, the approved invoice amount is $412.50. Add formulas for recorded hours, billable hours, and billable amount so edits recalculate the totals.

  • Columns: Date | Client | Project | Task | Hours | Rate | Billable | Approval
  • 2026-07-06 | Acme Studio | Website refresh | Homepage wireframes | 3.0 | $75/hour | Yes | Approved
  • 2026-07-07 | Acme Studio | Website refresh | Mobile layout revisions | 2.5 | $75/hour | Yes | Approved
  • 2026-07-08 | Internal | Administration | Weekly bookkeeping | 1.0 | — | No | Not billed
  • Totals: 6.5 recorded hours | 5.5 billable hours | $412.50 approved for invoicing

Use the timesheet with an invoice

At the end of the billing period, filter for approved, uninvoiced entries. Group them at the level promised to the client and confirm that the timesheet total matches the invoice calculation.

Reference the project and service period on both documents. Mark the entries with the invoice number after billing, then keep the source timesheet with the project record for future questions and pricing analysis.

  • Select only approved entries
  • Match hours and rates to invoice lines
  • Reference the billing period
  • Store the invoice number with entries

Frequently asked questions

Questions about timesheet template for freelancers

Should a freelancer use daily or weekly timesheets?

Enter time daily, even when the client receives a weekly or monthly report. Short entry intervals improve accuracy and reduce forgotten work.

Does a timesheet need start and end times?

Not always. Use them when the engagement requires a time-of-day record; otherwise, a clear task, date, and verified duration may be sufficient.

Can one timesheet include several clients?

An internal master sheet can include several clients, but filter and review each client separately before sharing or creating an invoice.