Contractor Invoice Template in Excel: What to Include So You Get Paid

Plenty of free invoice templates exist. Most are made for freelancers, not for builders, so they miss the things that cause payment fights on a job site: the original estimate, the signed extras, and money held back as retainage.

The 12 fields every contractor invoice needs

1. Your business name, address, phone and license or registration number.
2. The client's name and the job address (not just the billing address).
3. A unique invoice number and the invoice date.
4. The estimate or contract number the invoice belongs to.
5. Line items: description, quantity, unit, unit price, line total.
6. Labor and materials shown separately, if your contract says so.
7. Approved change orders, each with its own number.
8. Subtotal, tax and the invoice total.
9. Payments already received and the balance due.
10. Retainage held back, if the contract has it.
11. Payment terms and the due date (for example "Net 14").
12. How to pay: bank details, card link or check address.

If any of 4, 7, 9 or 10 are missing, the client has a reason to wait.

Build the invoice from the estimate

Typing the invoice from scratch is where mistakes happen. Keep the estimate and the invoice in the same workbook, so the approved estimate lines flow into the invoice and only the changes need typing. The Contractor Estimate & Invoice Template for Excel and Google Sheets does this: a quote builder with markup and tax, an invoice that fills itself from the quote, change orders, and a profit margin dashboard. It has US, UK and EU wording.

Get extras signed before you build them

The most common unpaid amount on a job is the "while you're here" extra. Write a numbered change order with the cost, the new contract sum and the new completion date, and get it signed before the work starts. The Construction Change Order Form & Log prints a signable form and keeps a running log.

Track retainage and subcontractor payments

If you run subs, your invoice to the client and your payments to subs have to match. A Subcontractor Payment Tracker keeps pay applications, retainage, lien waivers, W-9s and insurance in one place.

Know what the job actually made

An invoice says what you billed, not what you kept. Log income, expenses and mileage per job in a Contractor Bookkeeping Spreadsheet, and log crew hours in a Contractor Timesheet so labor cost is real, not guessed.

Excel or Google Sheets?

Excel works offline and is what most accountants expect. Google Sheets is easier when the office and the truck both need the file. All the templates above open in both, with no subscription.