A timesheet should spare you the month-end exercise of reconstructing your calendar. If filling it in feels like a separate reporting job, it may be asking for more information than you actually use.
Start with a row for each meaningful block of work. Keep the fields that explain the time and, where relevant, how it becomes a client charge.
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
Choose fields around the way you work
Date, client, project, task and duration are a useful starting point. Start and end times, breaks, billable status and rates may also be relevant. Not every internal field needs to appear in the client’s copy.
Fixed-price projects can still have time records for planning without an hourly charge column. Do not force every engagement into an hourly billing model just because the template includes a rate.
Use one day to see whether the structure works
Imagine 90 minutes of content updates for client A, 45 minutes discussing scope with client B and 30 minutes organizing your own accounts. Separate entries let you group client work and see administration without automatically billing all 165 minutes.
Whether the client activities are billable depends on the agreement. The internal accounting work is part of running your business, not automatically a charge to whichever client happens to be active that day.
| Client or purpose | Task | Actual time |
|---|---|---|
| Client A | Content updates | 90 minutes |
| Client B | Scope meeting | 45 minutes |
| Your business | Organizing accounts | 30 minutes |
Distinguish input fields from calculations
In a spreadsheet, start time, end time and breaks can feed a duration calculation, while duration and rate can feed an amount. Keep formatting consistent and understand how the sheet treats overnight work or empty cells.
One hour and thirty minutes is 1.5 hours, not 1.30 decimal hours. At 200 per hour it is 300. Check a simple known example before relying on a formula across a month of entries.
Prepare a client view with only relevant information
The customer may need dates, tasks, billable hours and charges. Your internal record may also contain actual total time, non-billable reasons or private notes. Separate these views so the supporting document remains useful and appropriate to share.
If client approval is required, agree the frequency, approver and deadline. Keep the approved version and explain later corrections rather than silently changing previously accepted hours.
Review the record each week
Complete missing task descriptions, compare obvious gaps with the calendar and identify records already invoiced. Month-end then becomes a summary task rather than a reconstruction of every working day.
If a field repeatedly interrupts the process without helping billing or planning, reconsider it. The aim is enough evidence to understand the work, collected in a way you can maintain.
Keep a clear link to the invoice
Reference the billing period or invoice when the timesheet supports a charge. The total hours and amounts should reconcile, with different rates and non-billable entries handled appropriately.
When a client asks about a line, you can then find the relevant task rather than searching an unrelated full-month workbook. Retain the sent supporting version alongside the invoice.
Questions you may still have
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.