Skip to content
Hourly Service Invoice cover: a sample sheet with hours logged, unbilled hours and unbilled value and a bar chart, beside the Summary and Timesheet tabs

Hourly Service Invoice

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Hourly Service Invoice suits tradespeople, freelancers and small service businesses that bill by the hour. The Timesheet tab records each block of work with its date, client, task, hours and rate, and works out the amount. The Summary tab shows total hours, unbilled hours and their value, plus hours and amount for each client. A printable bill for one client's unbilled work sits on the Invoice tab, with a subtotal, a line for parts and travel, and the total due.

The sample rows cover four clients over about three weeks, and the Billing column marks which blocks are already on an invoice. Before you send an invoice, change the matching rows to Billed so nothing is charged twice. Round hours the same way every time, and check that each row's rate matches what the client agreed.

Useful for

  • Invoicing a tenant for repair hours in one month
  • Tracking hours for several clients in one timesheet
  • Billing only the work that has not been invoiced yet

What's included

  • 4 tabs: Summary, Timesheet, Invoice, How to use
  • Summary: a dashboard with 4 summary figures
  • Timesheet: a table
  • Invoice: a ready-to-fill form
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Timesheet tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I stop billing the same hours twice?

Change the Billing column to Billed for every row that is on an invoice. The Summary tab then shows unbilled hours and value separately, showing exactly what is still waiting to be invoiced.

Can I bill for parts or travel as well as labor?

Yes. Use the Parts and travel line on the Invoice tab for costs you pass on. Enter the amount there, and the total due adds it to the labor subtotal. Leave it at zero when you have no extra costs.

Can I bill in quarter hours?

Yes. Enter hours as decimals, such as 1.25 for an hour and fifteen minutes. If your agreement sets a minimum charge, add it as a separate line on the invoice so each row still shows its own hours.

  • #invoice
  • #hourly-invoice
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More invoice templates

See all 23

Also in Finance

All finance templates
Get this template

Preparing your template…