Log every block of work with its date, start time, task and hours. The total hours and amount due add up as you type, so the timesheet doubles as the invoice. Download PDF, Word or Excel. Free, no sign-up.
CLIENTBrightside Media220 Pine St, Seattle, WA 98101
HOURS22
RATE / HR85.00
DUE1,870.00
DATETASKSTARTHOURSAMOUNT
Sep 2Homepage layout09:006510.00
Sep 4Contact form and email10:303.5297.50
Sep 9Blog templates09:005425.00
Sep 15Speed and image fixes13:002.5212.50
Sep 18Client review call11:00185.00
Sep 25Launch and handover09:304340.00
PaymentBank: Chase · Account 6610 0293 18PayPal: sam@samortiz.devReference: INV-001TermsPayment is due by the due date shown. Thank you for your business.
Total hours22
Subtotal$1,870.00
Amount due$1,870.00
Hours tracked in Toggl. Detailed log available on request.Thank you!
Sample monthly timesheet invoice. Yours will show your own hours and rate.
What is a timesheet?
A timesheet is a record of time worked: which days, when work started, what was done and how many hours it took. Employers use them to pay hourly staff. Freelancers, consultants and contractors use them to bill clients by the hour, because a clear log of dated hours is the easiest way to show what an invoice is for. This template keeps both in one document: the timesheet lines on top, the total hours, rate and amount due underneath.
The period it covers, for example one week or one month
A line for each block of work: date, start time, task and hours
Total hours for the period
Your hourly rate and the amount due (if you are billing it)
How to pay, the due date, and a note on how time was tracked
How to fill in a timesheet
Open the timesheet template. It is set up with a date, start time, task and hours on every line, and a period at the top.
Set the period. A week, two weeks or a month: the dates the timesheet covers, so the client knows what is billed.
Log each block of work. The date, when you started, what you did and the hours, to the quarter hour. Use the hours calculator if you tracked start and end times.
Check the rate and total. Enter your hourly rate. Total hours and the amount due add up as you type, with tax if you charge it.
Send it as an invoice. Add how to pay and a due date, then download PDF, Word or Excel and send it. The Excel version keeps the totals as formulas.
Hours worked calculator
Enter start and end times and any unpaid break to get the hours worked, in hours and minutes and as a decimal for your timesheet.
Hours per day
9 h 00 min
Decimal hours per day
9.00
Total hours
45.00 h (45 h 00 min)
Pay at your rate
$1,125.00
An end time earlier than the start counts as an overnight shift. Decimal hours = minutes ÷ 60, so 7 h 45 min is 7.75 hours.
The sample above is Sam Ortiz's timesheet for Brightside Media, Sep 1 – Sep 30: 22 hours at $85.00 an hour.
Date
Start
Task
Hours
Amount
Sep 2
09:00
Homepage layout
6
$510.00
Sep 4
10:30
Contact form and email
3.5
$297.50
Sep 9
09:00
Blog templates
5
$425.00
Sep 15
13:00
Speed and image fixes
2.5
$212.50
Sep 18
11:00
Client review call
1
$85.00
Sep 25
09:30
Launch and handover
4
$340.00
Total
22
$1,870.00
Minutes to decimal hours
Minutes
Decimal hours
5 min
0.08
10 min
0.17
15 min
0.25
20 min
0.33
30 min
0.50
40 min
0.67
45 min
0.75
50 min
0.83
From timesheet to invoice
If you bill by the hour, you don't need two documents. The hourly timesheet invoice lists every dated block of time, then the total hours, your rate and the amount due. Not sure what to charge? The hourly rate calculator works it out from the income you want. Running a crew? The labor cost calculator turns hours and wages into a job cost. Billing a retainer or the same hours every month? See the invoice examples.
Questions about timesheets
What is a timesheet?+
A timesheet is a record of the time someone worked: the dates, start and end times or hours, and what they worked on. Employers use timesheets for payroll; freelancers and contractors use them to show clients the hours behind an invoice.
How do I calculate hours worked for a timesheet?+
Subtract the start time from the end time, take off any unpaid break, then convert the minutes to a decimal by dividing by 60. 8:00 am to 5:30 pm with a 30-minute break is 9 hours. The hours worked calculator on this page does it for you.
How do I convert minutes to decimal hours?+
Divide the minutes by 60. 15 minutes is 0.25, 30 minutes is 0.5, 45 minutes is 0.75. So 7 hours 45 minutes is 7.75 hours on a timesheet.
What is the difference between a timesheet and an invoice?+
A timesheet records hours; an invoice asks to be paid for them. A timesheet invoice does both: it lists each block of time with its date and hours, then totals them at your rate with the amount due and how to pay.
Should I round time on a timesheet?+
Many people log to the nearest quarter hour. Agree a rounding rule with your client up front and apply it the same way every time. For employees, check the rounding rules where you work.
Is there a weekly timesheet template in Excel?+
Yes. Fill in the timesheet online for any period, a week or more, and download it as Excel: the hours, total and amount due stay as working formulas, so you can keep adding lines.
Ready to bill your hours?
It takes a few minutes. Your details stay in your browser.