When a biweekly timesheet fits
A biweekly timesheet covers two working weeks. It suits contractors and teams who are invoiced or paid every two weeks: long enough to reduce admin, short enough to stay accurate.
FREE TIMESHEET TEMPLATE
Two weeks of time.
One clean timesheet.
A free biweekly timesheet template covering two weeks of entries by day, client and task, with billable totals and approval. Download it for Excel or Google Sheets (with formulas), Word or as a CSV, without an email gate.
Word, Excel, Google Docs and PDF. No email required.
Last updated
TIMESHEETTemplate preview · Example
01
Who and when
Name, period, client and the person who approves the timesheet.
02
Entries
Mon: On-site work for Elmstead Systems, 3.5 hours, billable.
03
Totals
Total hours, billable hours, non-billable hours and utilisation.
04
Approval
Submitted by, approved by and the date, ready to attach to the invoice.
The template
Details
- Name: [Your name]
- Period: [Start date — end date]
- Client / project: [If the whole timesheet is for one client]
- Approver: [Name]
Time entries
| Date | Client / project | Task | Hours | Billable (Y/N) | Notes |
|---|---|---|---|---|---|
| Week 1 Mon | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 1 Tue | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 1 Wed | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 1 Thu | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 1 Fri | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 2 Mon | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 2 Tue | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 2 Wed | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 2 Thu | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
| Week 2 Fri | [Client — project] | [Task] | [0.0] | [Y/N] | [ ] |
Totals
- Total hours: [0.0]
- Billable hours: [0.0]
- Non-billable hours: [0.0]
- Utilisation: [Billable ÷ available hours]
Approval
- Submitted by: [Name, date]
- Approved by: [Name, date]
How to fill it in
- Fill in your name, the period and who approves your time.
- Add an entry for each block of work: date, client and project, task and hours.
- Mark each entry billable or not, and add a short note where the client might ask.
- Total the hours, split billable from non-billable, and work out utilisation.
- Submit it for approval at the end of the period.
- Use the approved timesheet as the backup for your invoice.
Use it in Word, Excel, Google Docs or PDF
Microsoft Word
- Download the Word (.docx) file and open it. If Word opens it in Protected View, select Enable Editing.
- Use Find (Ctrl+F or Cmd+F) and search for “[” to jump between the placeholders you need to replace.
- Save a clean copy as a Word template (File → Save As → Word Template) so every new document starts from it.
Google Docs
- Upload the .docx file to Google Drive.
- Right-click it and choose Open with → Google Docs, then File → Save as Google Docs to keep an editable copy.
- Use File → Make a copy for each new client so your master stays clean.
Excel and Google Sheets
- Download the Excel (.xlsx) file. It has a blank sheet and a worked example.
- Enter quantities, hours and rates: amounts, totals and tax calculate with built-in formulas.
- To use Google Sheets, upload the file to Drive and choose Open with → Google Sheets; the formulas carry over.
Use Print or save as PDF in the template section above to print just the template, or fill it in Word or Google Docs first and export it (File → Save As → PDF in Word, File → Download → PDF document in Google Docs).
Example: Ridgeway Technical Services week
A filled-in example. The companies are fictional.
Time entries
| Date | Client / project | Task | Hours | Billable (Y/N) | Notes |
|---|---|---|---|---|---|
| Mon | Elmstead Systems — network upgrade support | On-site work | 3.5 | Y | |
| Tue | Elmstead Systems — network upgrade support | Remote support | 2.25 | Y | |
| Wed | Elmstead Systems — network upgrade support | Documentation | 4 | Y | |
| Thu | Elmstead Systems — network upgrade support | Travel | 1.5 | N | Internal |
Tips for accurate timesheets
- Record as you go. Time reconstructed on Friday afternoon is lower and vaguer than time recorded daily.
- Round consistently and say so in your agreements, e.g. to 15 minutes, or 6 minutes for law firms.
- Track non-billable time too. It’s the only way to see real utilisation and price future work properly.
- Use the client’s language. “On-site work” is easier to approve than “work”.
Turn approved hours into an invoice with the hourly invoice template.
Track time in Angelwood
Angelwood’s time tracking runs timers or manual entries against clients and projects, routes timesheets for approval and reports billable hours and utilisation.
Browse all timesheets templates or the full template library.
MAKE IT WORK FOR YOU
Useful structure.
Your way of working.
Capture it daily.
A few minutes at the end of each day beats an hour of guesswork at the end of the week, and recovers time you’d otherwise forget to bill.
Split billable from the rest.
Knowing your non-billable hours shows where time really goes and whether your prices cover it.
Approve before you invoice.
An approved timesheet behind every hours-based invoice means fewer queries and faster payment.
Do independent contractors need timesheets?
If you bill by the hour or day, yes. A timesheet approved by the client is the evidence behind each invoice and the quickest way to get paid without queries.
Can I open this timesheet in Excel or Google Sheets?
Yes. Download the CSV version and open it in Excel, Google Sheets or Numbers, then add a SUM formula to the hours column. The Markdown version is easy to edit in any text editor.
How often should timesheets be submitted?
Weekly is the most common for client work: it’s frequent enough that people remember what they did, and it lines up with weekly or monthly invoicing.
What’s the difference between billable and non-billable time?
Billable time is work you charge a client for. Non-billable time is everything else, such as admin, sales and internal meetings. Tracking both shows your real utilisation.
Can I edit this template in Word or Google Docs?
Yes. Download the Word (.docx) file and open it in Microsoft Word, or upload it to Google Drive and choose Open with → Google Docs. There’s also a Markdown version for any text editor. No account or email address is needed.
How do I save it as a PDF?
Fill it in, then export it: File → Save As → PDF in Word, or File → Download → PDF document in Google Docs. On this page you can also print just the template or save it as a PDF from your browser’s print dialog.
Does the Excel version calculate totals?
Yes. Enter quantities, hours and rates and the amounts, subtotal, tax and total calculate automatically. It also works in Google Sheets: upload it to Drive and open it with Google Sheets.
THE CLIENT EXPERIENCE, IN ORDER
Good habits. A shared home.
Bring the work you share with clients into one place.