Free timesheet template and hours calculator for freelancers

Log your work week: client, date, start and end times (or just the hours), breaks, billable or not, and your hourly rate. It adds up total hours, billable hours and the amount to bill, then lets you download a CSV or print the timesheet and save it as a PDF. No account, no email, no watermark.

How to use it

1. Set the currency and, if most of your work is at one rate, a default hourly rate.
2. Add an entry for each block of work: date, client or project, and what you did. Add an entry copies the last entry's date and client, so a day of work is quick to fill in.
3. Type the start and end times and any break in minutes, or leave those blank and type the hours.
4. Mark admin, sales calls and other unpaid time as Billable: No. It still counts in your total hours, which shows where the week went.
5. Give an entry its own rate if it differs from the default (a different client or a rush job).
6. Pick a week or a client to see just that part, then Download CSV or Print / Save as PDF. Both follow the week and client you picked.

How the hours and amounts are worked out

• Hours = end time − start time − break, in whole minutes. If the end time is earlier than the start, the entry ends the next day (21:30 to 00:45 is 3:15), and the timesheet marks it “+1 day”. One entry can be at most 24 hours.
• Typed hours can be decimals (1.5, 2.75) or hours and minutes (1:30). Decimals are turned into whole minutes, rounded to the nearest minute: 7.33 hours counts as 7:20.
• Amount = hours × rate for each billable entry, rounded to the cent (half a cent up), using the entry's own rate or the default rate. Non-billable entries add hours but no amount. A billable entry with no rate at all still counts as billable hours, and the timesheet says it isn't in the amount.
• Totals add up the entries' exact minutes and their rounded amounts, so the total amount always equals the sum of the lines you can see. The billable share is billable hours ÷ total hours.
• Hours are shown both ways: hours and minutes (7:30) and decimal hours to two places (7.50), because invoices usually use decimals.
• It works in whole minutes and whole cents, so no floating-point rounding creeps in. It refuses negative numbers, junk text, a break as long as the work, and both times and hours on the same entry, with a plain message next to the field.

Minutes to decimal hours

Invoices and spreadsheets usually want decimal hours. Divide the minutes by 60; here are the common ones, rounded to two places the same way the timesheet rounds them:

So 3 hours 45 minutes is 3.75 hours, and 7 hours 20 minutes is 7.33. If your contract says how to round time (for example up to the next 15 minutes), round the way it says; this tool doesn't round entries for you.

What to put on a freelance timesheet

There's no single official format for a freelancer's own timesheet; what matters is that you and your client can both follow it. Most timesheets show:

• Who and when: your name or business, the client and the period (a week is common).
• Each block of work: the date, what you did, and either the start and end times or the hours.
• Breaks taken out of timed blocks, so the hours are time actually worked.
• Billable or not, and the rate for billable work, so the client can check the invoice against it.
• Totals: hours, billable hours and the amount.

Fill it in as you go rather than at the end of the week; times written down the same day are easier to stand behind if a client asks. If your contract asks for a particular format, approval or rounding, follow the contract. This page is general information, not legal or tax advice.

From timesheet to invoice

• Pick the client (and the week, if you bill weekly). The Billable line at the bottom of the timesheet is your hours × rate.
• Put those hours on an invoice with our free invoice generator (one line per rate, or one per task), or the .xlsx invoice template, and attach the printed timesheet or the CSV as backup.
• Not sure what to charge? The hourly rate calculator works back from the income you need and the share of your time that's billable, the same billable share this timesheet shows you.

If you'd rather keep your hours in a spreadsheet that fills in the invoice for you, our paid Freelance Billing Kit by Small Rows (US$12, one-time) has a Time Log tab with start and end times, breaks, billable yes/no and rates, and builds each invoice from it. Like this page, it's a record-keeping tool, not tax advice.

We also make Hourly, a Google Sheets add-on that turns Toggl Track hours into billing reports (not released yet). You don't need it to use this timesheet.

About the CSV file

• One row per entry, in date order, with these columns: Date, Client, Task / notes, Start, End, Break (min), Hours (decimal), Hours (h:mm), Billable, Rate, Amount, Currency. There's no totals row, so it sorts and filters cleanly; add a SUM in your spreadsheet if you want one.
• Numbers are plain (3.50, 210.00) with no thousands separators, and dates are year-month-day, so spreadsheets read them as numbers and dates.
• It's UTF-8, so names with accents survive. Any text you typed that starts with =, +, - or @ gets an apostrophe in front, so a spreadsheet won't treat it as a formula.
• We checked that the downloaded file opens with the right columns and numbers in LibreOffice Calc. We haven't tried it in Google Sheets or Excel ourselves; both can import CSV files.

What it doesn't do

• It doesn't save anything. There's no account and no history; download the CSV or save the PDF. It can't load a CSV back in.
• No timer. You type the times. If you'd rather start and stop a timer, a time tracker does that (our Toggl Track Free plan guide covers one free option).
• No rounding rules, overtime or payroll. It's a freelancer's billing record, not an employee timesheet: no overtime rates, pay periods, deductions or labour-law checks.
• One currency per sheet, and no tax lines. Taxes go on the invoice, not the timesheet.
• At most 60 entries per sheet and 24 hours per entry.

Related free resources

• Free invoice generator: bill the hours in any currency, with your own tax lines.
• Freelance hourly rate calculator: the rate to put on the timesheet.
• Free freelance invoice template (.xlsx): hours × rate as live formulas.
• Free receipt generator: confirm a payment once the client has paid the invoice.
• Free expense and receipt log: the purchases side of your records.
• All free tools.

Found a problem? Tell us via Support and we'll fix it.