Freelance timesheet template: track hours before you quote or invoice
A copyable timesheet for Singapore freelancers, with billable hours, unpaid work and an SGD invoicing example.
A timesheet can answer two different questions: what work can you bill under your agreement, and how much time did the business actually take? Keep both answers. Recording only billable hours can hide the proposal writing, preparation and administration needed to earn that income.
This simple template is for Singapore freelancers, tutors and consultants who want to use their own spreadsheet or document. It is a copyable worksheet, not a new online time tracker. Nothing entered in your own copy is sent to freelance.cash.
Copy these columns into your own sheet
| Date | Project reference | Task | Hours | Billing status | Agreed rate | Invoice reference |
|---|---|---|---|---|---|---|
| 2 Nov | Project A | Delivery | 2.50 | Billable | S$80/hour | Pending |
| 3 Nov | Project A | Agreed revision | 1.25 | Billable | S$80/hour | Pending |
| 3 Nov | Project A | Preparation | 0.75 | Not separately billed | — | — |
| 4 Nov | Business | Proposal/admin | 1.50 | Not billed | — | — |
Add start time, end time and unpaid breaks if useful. Write decimal hours consistently: 1 hour 15 minutes is 1.25 hours, not 1.15. The example dates do not imply that these are standard working days or a required billing format.
Calculate hours without billing the same time twice
In this example, billable delivery and revisions total 3.75 hours. At the agreed S$80 hourly rate, the invoice amount is S$300. Preparation and administration add 2.25 hours, so the work used six hours in total.
If the full S$300 is later received, the cash receipt divided by total recorded time is S$50 an hour before business costs, tax, MediSave and personal commitments. This is a retrospective management measure, not taxable profit or a recommended market rate. If only S$150 arrives, the invoice total remains S$300 while cash received is S$150.
For fixed-fee projects, hours are a review measure
If you agreed S$500 for a defined deliverable, recording ten hours does not automatically entitle you to charge ten times an hourly rate. Your agreed scope, billing basis and any approved changes govern the bill. Use the hours to understand delivery effort and improve your next estimate.
Likewise, do not round every small task upward unless your agreement supports that method. Record breaks and overlapping tasks honestly; an hour spent on two tasks is not two hours of elapsed work. This guide does not set employment or contractual rules.
Add spreadsheet checks before copying billable totals
If you use the seven columns above in a spreadsheet, put decimal hours in column D, billing status in E and a numeric hourly rate in F. Format the rate as currency rather than entering text such as “S$80/hour”. Add column H for a calculated line amount.
| Check | Formula or method |
|---|---|
| Line amount in H2 | =ROUND(D2*F2,2); use only for hourly work approved as billable |
| Total recorded hours | =SUM(D2:D100) |
| Hours labelled Billable | =SUMIF(E2:E100,"Billable",D2:D100) |
In the sample, total hours are 6, while Billable hours are 3.75. That is 62.5% of recorded time. At S$80 per approved billable hour, the two billable lines are S$200 and S$100, totalling S$300. This percentage describes this small example, not a recommended target.
Keep H blank for unbilled administration and fixed-fee work; multiplying every row by a rate would overstate the amount owed. A formula cannot decide whether preparation, revisions or travel are chargeable. Follow the agreement and record approved changes. Spreadsheet applications and locale settings may require a different argument separator.
Before generating an invoice, filter the agreed billing period, check the invoice-reference column for work already billed, and reconcile any missing entries. Do not add a part-payment as negative working hours: record payments against the invoice separately. See the Singapore invoice template guide for the next step.
Move from the timesheet to a document
- Review tasks against the agreed scope and resolve billing questions.
- Group the approved billable work for the billing period.
- Check quantities, rate, client name and document number.
- Fill in the quotation or invoice sheet, then print it or save it as a PDF and keep a copy.
- Match later payments separately against its reference.
Our free quotation and invoice sheet supports non-GST-registered suppliers in SGD with up to five lines of work, a total, and print or save as PDF, but no logo option or CSV export. It does not import timesheets, determine what is billable, store history, send invoices or track payment. Enter your checked totals manually. A generated invoice is not a receipt.
Ready to put this into practice? Browse all free freelancer tools for cash planning, pricing and client documents. No account is needed; keep downloaded records on your own device.
Use the review to improve your business
If non-billable work repeatedly takes longer than expected, review scope, preparation, client communication and project selection before assuming that working more hours is the answer. Use the rate calculator to explore a revenue target and the six-month business review to compare the broader pattern. Neither tool decides a fair fee or guarantees demand.
Worked example: from start and end times to decimal hours
Many people find it easier to write when they started and stopped, and to let the sheet work out the hours. Take an invented session from 9:15 to 11:45 with a 15-minute unpaid break. The elapsed time is 2 hours 30 minutes. Taking off the break leaves 2 hours 15 minutes, which is 2.25 decimal hours (15 minutes is 0.25 of an hour).
| Minutes | Decimal hours |
|---|---|
| 15 | 0.25 |
| 30 | 0.50 |
| 45 | 0.75 |
| 10 | 0.17 (rounded from 0.1667) |
The last row is the trap. Ten minutes is a sixth of an hour, so rounding to 0.17 introduces a small error that adds up over many entries. If you track in minutes and convert only the weekly total, the error stays small.
Rounding without overcharging
Suppose you answer seven short client messages, each taking ten minutes. The true total is 70 minutes, or about 1.17 hours. If you round each message up to a quarter of an hour, you record 7 × 15 = 105 minutes, or 1.75 hours. That is more than half an hour more than the time spent. Whether a minimum unit, such as a quarter of an hour, is acceptable depends on what the client agreed to. If your agreement says nothing about it, record the true time and decide separately whether small tasks are billable at all. Never round up silently.
A month at a glance
A weekly total helps you see where time is going. The figures below are invented, for a freelancer with an agreed rate of S$80 an hour for approved billable work.
| Week | All recorded hours | Billable hours |
|---|---|---|
| Week 1 | 18.50 | 14.00 |
| Week 2 | 22.00 | 16.50 |
| Week 3 | 15.75 | 11.25 |
| Week 4 | 20.25 | 15.00 |
| Total | 76.50 | 56.75 |
Billable hours are 56.75 out of 76.50, which is about 74.2%. At S$80, the month’s billable work comes to 56.75 × S$80 = S$4,540. If every dollar arrived, the amount received per recorded hour would be S$4,540 ÷ 76.50, about S$59.35. That figure is before costs, tax and MediSave, and it is a way of looking back at the month. It is not a target or a recommended rate. The 74.2% describes this sample only.
The difference between S$80 and S$59.35 is the cost of unbilled time. If it surprises you, look at which tasks are in the unbilled column and whether they should be priced into your rate or your quotes. The hourly rate calculator turns an income target, business costs and a reserve goal into hourly and daily rates, and can help you test what a rate would need to cover.
Using time records to improve your next fixed fee
Suppose you quoted S$500 for a deliverable and estimated 10 hours. The job took 13.5 hours. That is 3.5 hours over, or 35%. The fixed fee was S$500 ÷ 10 = S$50 an hour on your estimate, and turned out at S$500 ÷ 13.5, about S$37.04 an hour. The client still owes the agreed fee and nothing more unless an extra scope was agreed. The lesson is for the next quote: either estimate more carefully or add a revision limit. Over a handful of projects, a record like this turns a vague feeling that jobs run long into a figure you can use.
Common timesheet mistakes
- Recording hours days later from memory, which usually rounds in your favour without your noticing.
- Counting overlapping tasks twice.
- Typing “2h15” or “1.15” for 1 hour 15 minutes, which a spreadsheet cannot add.
- Putting every row into the billable column, including admin that was never agreed as chargeable.
- Forgetting to fill in the invoice reference, so the same hours get billed again.
- Using a client’s full name in a sheet you share, when a project code would do.
Records to keep
IRAS’s non-GST record-keeping guide does not mention timesheets, so there is no official format. A timesheet is useful because it supports the invoice that follows it. IRAS says proper records should be supported by invoices, receipts, vouchers and other supporting documents, and that records and supporting documents should be retained for five years. Keep the timesheet, the invoice it supports and the agreement that set the rate together, and keep the file using project codes. Do not store more personal information about students or clients than you need.
If your situation differs
The client has its own timesheet or approval process. Use theirs for the submission and keep your own copy. Check which of your entries they consider billable before you invoice.
You work for several clients in a day. Record the project for every entry. Give each client the hours that belong to them, and do not bill the same hour twice because two projects overlapped.
You bill by the day. Define a billable day in your agreement, for example a number of hours or a half-day minimum, and record days rather than hours. Keep hours as an internal check.
You are unsure whether you are an employee or a contractor. MOM’s page What is a contract of service? sets out the factors it considers when telling an employee from an independent contractor. Check that page if you are unsure; this site cannot assess your arrangement.
Frequently asked questions
Do I have to keep a timesheet?
The IRAS guide we checked does not mention timesheets. If you bill by the hour, though, a record of the time is the basis for the invoice and the evidence if the client questions it.
How detailed should each entry be?
Detailed enough that you can match it to the agreed scope. A task name and a date are usually enough, with a note where an item might be questioned.
Should I record unbilled time?
It helps. It shows how long the business really takes, which is useful when you set rates and quotes. Keep it in a separate column from billable time.
Can I bill for travel or admin time?
Only if your agreement says so. A spreadsheet formula cannot decide that for you.
What is the best format?
One you will keep up to date. A spreadsheet with the columns in this guide is enough for most freelancers.
Does the website store my timesheet?
No. Everything in your own copy stays with you.
Related guides
- Invoice template guide, for the next step
- Project pricing: margin, markup and your own time
- Six-month business review
- Freelance contract key terms
Related tools
- Quotation and invoice sheet: a Quotation or Invoice selector, up to five lines of work, a total, and print or save as PDF. It does not import timesheets.
- Hourly rate calculator: turns an income target, business costs and a reserve goal into hourly and daily rates.
Sources and checks
The 4 pages below were fetched on 22 November 2026 for this timesheet guide. Anything not listed was not re-checked.
- IRAS, Keeping proper records and accounts: supporting documents and five-year retention. Checked 22 November 2026.
- IRAS, Record Keeping Guide for Non-GST Registered Businesses: timesheets not mentioned. Checked 22 November 2026.
- TAFEP, Discuss and document key contract terms: payment amounts and scope agreed in writing. Checked 22 November 2026.
- MOM, What is a contract of service?: factors for telling employment from independent contracting. Checked 22 November 2026.
Illustrative only, not tax or financial advice. Hours, rates and results are invented, and the arithmetic was checked on 22 November 2026.
Try it with your own numbers. The money planner is free, runs in your browser and saves nothing.
Open the money planner