Posted in

5 Free Contractor Invoice Templates in Excel

5 Free Contractor Invoice Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 6, 2026

A contractor invoice is the bill a builder, tradesperson or independent contractor sends to a client for work done on a job. It separates labour from materials, adds any markup and tax, takes off deposits already paid and shows the balance due. On this page you can download five free contractor invoice templates in Excel: a standard contractor invoice for labour and materials, a progress billing invoice with retainage for larger projects, and a simple handyman invoice for small jobs, plus a time and materials invoice and a progress invoice with retainage.

Every file is a real, editable .xlsx spreadsheet. You type in the yellow cells and the formulas work out each line, the labour and materials totals, the markup, the tax and the amount still owed. This page also has a free contractor invoice calculator for quick pricing on site.

Contractor Invoice Calculator

Balance due now: 0.00
Labour: 0.00   Materials incl. markup: 0.00   Tax: 0.00
Invoice total: 0.00   Retainage held: 0.00

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Contractor Invoice?

A contractor invoice is a formal request for payment. It describes the work, the hours, the materials and the price, and it tells the client when and how to pay. It also forms part of your records. Clients keep it for their files, insurance claims or tax, and you use it to track income, chase overdue payments and prepare your accounts.

Contractors bill in several ways, and the five templates match the most common ones:

  • Time and materials: labour hours at an hourly rate, plus the cost of materials, often with a markup.
  • Progress billing: a large contract split into stages, billed by the percentage of each stage completed, often with retainage held back until the end.
  • Small fixed jobs: a few hours of work, a call-out fee and some parts.

Download Free Contractor Invoice Templates

The files work in Microsoft Excel, Google Sheets and LibreOffice Calc. Example figures show how the formulas work; replace them with your own.

1. Contractor Invoice (Labour and Materials)

Contractor invoice template in Excel with labour, materials, markup, tax and deposit

The standard invoice has separate Labour and Materials sections. Each line has a description, quantity or hours, unit and rate, and the amount is calculated for you. Below the lines the sheet shows the labour total, the materials total, a materials markup at the percentage you choose, tax, any deposit already paid and the balance due. Notes for payment terms and your workmanship warranty sit at the bottom.

Use it for renovations, carpentry, electrical and plumbing work, landscaping and any job billed on time and materials.

2. Progress Billing Invoice with Retainage

Progress billing invoice template in Excel with schedule of values, percent complete and retainage

For bigger projects, this template lists each contract item with its scheduled value and the percentage complete. It calculates the value completed to date, subtracts what you billed before and shows the amount for this period. The totals row shows the overall percentage complete. You set the retainage rate, and the sheet takes it off this period's amount, adds any change orders and shows the amount due. It also shows the total retainage held to date, so both sides know what will be released at the end.

3. Handyman Invoice

Handyman invoice template in Excel with jobs, hours, parts and total due

A shorter version for small jobs, with lines for labour, a call-out fee and parts such as hinges, sealant or paint. Markup is set to zero by default and you can add tax if you charge it. It is quick enough to fill in on your phone before you leave the job.

4. Time and Materials Invoice

Time and materials invoice template in Excel with labour hours, materials, taxable flags and tax total

For jobs billed on time and materials rather than a fixed price. List labour and material lines with quantity or hours, rate and whether the line is taxable. Amounts calculate, tax applies only to lines marked Yes, and the total due includes tax. A call-out fee can be marked non-taxable if your local rules allow it. Trades, IT support and field-service firms use this layout daily. Change the tax rate in the yellow cell to match your region.

5. Progress Invoice with Retainage

Progress invoice with retainage template in Excel for percent complete and amount due

An AIA-style progress bill for construction and large projects. Enter the original contract value, approved change orders, percent complete and previous billings, plus the retainage rate. The sheet works out the revised contract, value of work completed, current billing before retainage, retainage this invoice, amount due and retainage held to date. General contractors and clients both recognise this format. Keep one file per project and add a new invoice number each period.

What to Include on a Contractor Invoice

  • Your business details: name, licence or registration number where required, phone, email and address.
  • Client details: name and billing address.
  • Job or site address if different from the billing address.
  • Invoice number and date: a unique number for each invoice.
  • Labour: description, hours and hourly rate for each trade or worker.
  • Materials: items, quantities and prices, or a lump sum per lot.
  • Markup: if you charge one on materials, show the rate.
  • Change orders: extra work agreed after the original quote.
  • Tax: at the correct rate for your area.
  • Deposits and previous payments, so the client sees the remaining balance.
  • Payment terms and methods: due date, late fee and how to pay.
  • Warranty: how long your workmanship is guaranteed.

How to Fill In the Contractor Invoice Template

  1. Download the template that fits the job and open it in Excel or Google Sheets.
  2. Add your business name, licence number and contact details at the top.
  3. Enter the client's name, billing address and the job address.
  4. Give the invoice a new number and date.
  5. List labour lines with hours and rates.
  6. List materials with quantities and costs. Use the "lot" unit for bundled supplies.
  7. Set your materials markup and tax rate in the yellow cells.
  8. Enter any deposit already received.
  9. Check the balance due, save the file with the invoice number and send it as a PDF.

How Progress Billing and Retainage Work

On larger jobs, waiting until the end to be paid is not practical. Progress billing lets you invoice as the work moves forward. The contract is split into a schedule of values, for example site preparation, foundation, framing, roofing and finishes. Each period you estimate the percentage complete for each item. The template multiplies the scheduled value by that percentage to get the value completed to date, then subtracts what you have already billed.

Retainage, also called retention, is a part of each payment that the client holds back until the job is finished and any defects are fixed. It protects the client, and it is released at the end. Rates and rules differ by country, state and contract, so always use the rate in your signed contract. The template shows both the retainage for this invoice and the total held to date.

Pricing Your Work

Good pricing starts with knowing your costs.

  • Labour: include your wages or your own target hourly income, plus employment costs for staff.
  • Materials: use current supplier prices and include delivery.
  • Overheads: vehicle, tools, insurance, phone, software and office costs.
  • Markup on materials: many contractors add a markup to cover the time spent ordering, collecting and handling materials, and the risk of waste.
  • Profit: a margin on top so the business can grow and handle slow months.

The calculator at the top of the page shows how changes in hours, rate, materials and markup affect the final invoice.

Tips for Getting Paid Faster

  • Agree terms in writing before starting, including deposits, stage payments and the due date.
  • Invoice promptly at each stage or the day the job is finished.
  • Be specific. Clear lines for labour and materials prevent disputes.
  • Record change orders and get them signed before doing the extra work.
  • Offer easy payment options such as bank transfer and card.
  • Follow up politely after the due date, then firmly if needed.
  • Keep photos of finished work in case questions come up later.

Common Contractor Invoicing Mistakes

  • Mixing labour and materials in one vague line.
  • Forgetting the deposit, which makes the balance look too high.
  • Not recording extra work as a change order.
  • Using the wrong tax rate or forgetting tax entirely.
  • No licence number where clients or law expect one.
  • Overwriting formulas when editing. Type only in the yellow cells.

Contractor Invoice vs Estimate

An estimate or quote is sent before the job and tells the client what the work is likely to cost. The invoice is sent after the work, or after a stage, and asks for payment of the actual amount. Keep the two linked: put the quote number on the invoice and explain any differences, such as extra hours or materials approved by the client.

Keeping Good Records

Save every invoice with its number in the file name and keep it in a folder for each client or job. At the end of each month, list which invoices are paid, which are due and which are overdue. Keep supplier receipts for the materials on each invoice; they support your markup and help at tax time. For progress jobs, keep a copy of every period's invoice so the "billed before" column always matches what the client has already seen.

Related Templates

You can also check these useful templates like the price quote templates for estimating jobs, and the construction proposal templates for bidding on projects.

You may also like the work order templates and the repair invoice templates.

Frequently Asked Questions

How do I make a contractor invoice in Excel?

Download a free template above, add your business and client details, list labour and materials, set your markup and tax rate, enter any deposit, and the sheet calculates the balance due.

What should a contractor invoice include?

Your business and licence details, client and job address, invoice number and date, labour and materials lines, markup, change orders, tax, deposits, the balance due, payment terms and warranty.

What is retainage on a contractor invoice?

Retainage is a part of each progress payment that the client holds back until the job is complete. The progress billing template calculates it from the rate in your contract.

Should I charge a markup on materials?

Many contractors do, to cover ordering, handling and waste. Show it clearly on the invoice and make sure it matches what you agreed with the client.

Can I use these templates in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.