Timesheet invoice generator

Timesheet and hours-to-invoice generator

Enter the days you worked with start and end times and breaks. The sheet adds up your hours, applies your rounding rule and rate, and sends the lines to the invoice generator so you can bill them in a minute.

  • ✓ Start/end times
  • ✓ Breaks & rounding
  • ✓ Per-entry or one line
  • ✓ To invoice in one click
DateStartEndBreak (min)DescriptionHoursAmountRemove
Total00

Turn it into an invoice

Your lines open in the invoice generator. Add your details, tax and payment terms there.

How to turn a timesheet into an invoice

  1. Set your rate and currency. Enter your hourly rate. Choose whether to round each entry up to 5, 6, 15 or 30 minutes, or not at all.
  2. Add your work entries. For each entry, add the date, start time, end time, any unpaid break in minutes and a short description.
  3. Check the totals. The sheet shows the hours and amount for each entry, and the total for the sheet.
  4. Choose how the invoice lines look. Either one line per entry, or one line with your total hours. Detailed lines build trust, a single line looks tidier.
  5. Create the invoice. Click “Create invoice”. The lines and currency open in the invoice generator, where you add your details, tax and payment terms.

What a timesheet invoice is

A timesheet invoice bills a customer for time rather than a fixed price. It lists the hours worked, the rate and the total, usually with dates and a short description of what was done. Freelancers, consultants, contractors, tutors, designers, developers and many trades use it. Clients like it when the entries are clear, because they can check them against what they expect.

This page does two jobs: it works as a lightweight timesheet (you can print it or export it as CSV to attach to an invoice), and it works as a bridge to the invoice generator, so you never retype hours.

Rounding rules: what is fair?

Many people round time up to a block, so a call of 7 minutes is billed as 15. The usual block sizes are 5, 6 (a tenth of an hour), 15 or 30 minutes. Rounding is allowed if your client agrees to it in the contract or quote. Without that agreement, bill actual time, or the client could dispute the invoice. Law firms and agencies often use 6-minute increments, and some consultants set a minimum charge per task.

Actual timeNo roundingUp to 6 minUp to 15 minUp to 30 min
7 min0.12 h0.2 h0.25 h0.5 h
50 min0.83 h0.9 h1 h1 h
3 h 10 min3.17 h3.2 h3.25 h3.5 h

The generator rounds each entry up. If you use a daily total instead, make the entry the whole day.

Worked example

DateTimeBreakWorkedRounded (15 min)At 50 / h
Mon09:00–12:3003 h 303.5 h175.00
Mon13:15–17:0003 h 453.75 h187.50
Tue09:00–11:1002 h 102.25 h112.50
Total9 h 259.5 h475.00

What to put on an hourly invoice

  • Your name or business and contact details, and the client’s.
  • A unique invoice number and the invoice date.
  • The period covered, for example “1–15 March”.
  • The hourly rate and the hours, either per task or in total.
  • A short description of the work for each line or day.
  • Any tax: VAT, GST or sales tax, with your registration number if required.
  • Payment terms, due date and how to pay.

The invoice generator adds tax, discounts and payment details. For your country’s requirements, see the country pages such as UK, Canada and Australia.

Tips for billing hours

  • Track as you go. Notes made later are less accurate and clients notice vague entries.
  • Write entries a client can read. “Homepage layout revisions” is better than “Work”.
  • Agree rounding and minimums in writing.
  • Bill often. Invoice weekly or fortnightly to keep amounts small and cash flowing.
  • Agree an estimate or cap for large jobs, and warn the client when you are near it.
  • Consider other pricing. The hourly rate calculator and day rate calculator help set a rate that covers your costs.

Glossary

Timesheet
A record of hours worked on dates and tasks.
Billable hour
Time that can be charged to a client.
Rounding increment
The block, such as 15 minutes, that time is rounded up to.
Minimum charge
The least amount billed for a task or call.
Retainer
A fee paid in advance for a set amount of time.

Frequently asked questions

How do I invoice for hours worked?
List the hours with the rate, the dates or period, and a short description, then add tax if it applies and your payment terms. This page turns timesheet entries into invoice lines.
Should I round hours up?
Only if your client has agreed to it in the contract or quote. Common rules are rounding up to 6, 15 or 30 minutes. Otherwise bill actual time.
How is time between start and end calculated?
The sheet takes the end time minus the start time, then subtracts any break in minutes. If the end time is earlier than the start time, it assumes the work crossed midnight.
Can I show one line instead of every entry?
Yes. Choose “one line with total hours” when creating the invoice. Detailed lines are better when the client wants to see what was done.
Where is my timesheet saved?
In your browser, on this device. Nothing is uploaded. Clear the sheet or your browser data to remove it.
Can I export the timesheet?
Yes. Use the CSV button to download it for a spreadsheet, or print the sheet to attach it to an invoice.
What does “Create invoice” do?
It saves your lines in your browser and opens the invoice generator, which loads them as items. You then add your details, tax and payment terms.
Can I use different rates for different entries?
This sheet uses one rate. For several rates, create the invoice and edit the rate on individual lines, or make separate sheets.
How do I add tax to an hourly invoice?
Do it in the invoice generator, which supports VAT, GST and sales tax lines. Your rate here is before tax.
Is this a time tracker?
It is a manual timesheet, so you enter times yourself. It does not run a timer.

Related topics

  • timesheet invoice
  • hourly invoice template
  • timesheet calculator
  • hours to invoice
  • bill hourly
  • freelance timesheet
  • time rounding
  • timesheet template
  • invoice for hours worked
  • hourly billing