Skip to content
Contractor Invoice cover: a sample sheet with invoiced, paid and outstanding and a bar chart, beside the Dashboard, Invoice and Log tabs

Contractor 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

Independent contractors, remodelers and repair crews use this template to bill a client for a job in stages. The Invoice tab sets out each task with its hours, an hourly rate, materials and a line amount. Subtotal, retainage and the amount due calculate themselves. The Log tab records every invoice with its project, date, amount, payment date and status. The Dashboard closes with billed, collected and outstanding totals.

Create one invoice for each billing stage, then add its amount due to the Log. Hold back retainage only when your contract says so, and set the rate to match it. Check the due date against the payment terms you agreed. Change the status to Overdue when a payment is late, which turns the row red and adds it to the overdue count on the dashboard.

Useful for

  • Billing a client in stages for a remodel or repair
  • Tracking which invoices are still unpaid
  • Showing a client each task, its hours and its materials

What's included

  • 4 tabs: Dashboard, Invoice, Log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Invoice: a ready-to-fill form
  • Log: a table
  • 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 Invoice 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

What is retainage?

Retainage is a share of each payment that the client holds back until the work is finished and checked. The rate comes from your contract, not from this template. Enter the rate on the Invoice tab to match the agreement before you send the bill.

How do I bill labor and materials separately?

Use the hours and hourly rate columns for labor, and the materials column for parts and supplies at their cost. Some contracts add a markup on materials, which you can add into that figure. Check your contract before you bill.

What is the quickest way to issue the next invoice?

Duplicate the Invoice tab, give it a fresh number and dates, then rework the tasks and totals. Record the finished invoice on the Log tab, which feeds it into the Dashboard totals.

  • #invoice
  • #contractor-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…