Excel Invoice Template for General Contractors
A general contractor’s invoice is the only one in the trades that is mostly other people’s work. The framer, the electrician, the plumber, the drywall crew, the tile setter — you carry their cost, you add your margin, and you hand the homeowner one number. Which means your invoice is doing something no specialty trade’s invoice has to do: it has to be legible to someone who did not hire any of those people and is trying to understand where forty thousand dollars went.
What a GC invoice needs that a generic template does not
Money arrives in stages, and the document has to keep score. Deposit at signing, progress payments at agreed points, final payment at completion. That means the question on every invoice after the first is not “what does this job cost” but “what is still owed” — contract amount, less what has been billed, less what has been paid. A template that only knows how to total a column of line items cannot answer that, so most contractors end up tracking it in a second spreadsheet, or in their head.
Change orders are where projects and relationships go wrong. The homeowner moves a wall, upgrades the tile, adds a bathroom fan. Each of those changes the contract amount, and if it is not documented at the moment it is agreed, it becomes an argument at the end. A change order needs to be its own document with its own number and its own approval, and it needs to be visibly connected to the original contract rather than folded quietly into a later invoice.
Subcontractor cost and your margin are different numbers. You paid the electrician a fixed amount. You billed the homeowner more. That spread is your actual income on that portion of the job, and it varies by trade — some subs you make real margin on, some you barely mark up because their number was already high. Across a whole project, that difference is the job’s profit, and it is invisible if the invoice only records what you charged.
Three kinds of GC work, three different documents
The fixed-price remodel
Kitchen, bathroom, basement finish, addition. Quoted as one number against a defined scope, billed in stages as work completes. The quote is a sales document and often the only thing standing between you and a cheaper bid, so the scope detail matters — what is included, what allowances cover, and what happens when the homeowner picks a tile that costs three times the allowance.
Cost-plus and time and materials
Used where scope cannot be pinned down in advance — older homes, insurance work, jobs that start as one thing and become another. Billing is actual cost plus an agreed fee or percentage, which means every invoice is a substantiation exercise: here is what it cost, here is the markup we agreed, here is the total. These invoices get read line by line, and the cost detail behind them has to be real.
New construction and multi-phase builds
Months of work, a draw schedule tied to completion milestones, and often a lender or inspector between you and payment. Sometimes retention — a percentage held back until final completion — which means the amount billed and the amount collectible are never the same number until the very end. This is where “which of my jobs is actually profitable” becomes genuinely hard to answer without something tracking it.
Line items general contractors actually bill
- Subcontracted trades — demolition, framing, electrical, plumbing, HVAC, insulation, drywall, tile, flooring, painting, cabinetry, countertops, roofing
- Self-performed labor — carpenter hours, laborer hours, cleanup, punch list work
- Project management — supervision, scheduling and coordination, general conditions, site protection, temporary facilities
- Permits and fees — building permit, trade permits, plan review, impact and inspection fees, engineering or architectural
- Materials and allowances — lumber and framing package, fixtures and finishes against allowance, appliances, waste and dumpster
- Change orders — added scope, allowance overages, owner-requested substitutions, unforeseen conditions
Most GCs work with the same subs and the same phase structure job after job. Having those saved with your usual pricing means the third kitchen this year is quoted against what the last two actually cost, not against what you hope they will.
What a progress invoice looks like
A kitchen remodel, second of three progress billings, with one approved change order. The four columns on the left are what the homeowner receives. The three on the right stay in your workbook and never print.
| Description | Qty | Price | Amount | Taxable | Cost | Margin |
|---|---|---|---|---|---|---|
| Electrical rough-in — subcontracted | 1 | 4,200.00 | 4,200.00 | ☐ | 3,150.00 | 1,050.00 |
| Plumbing rough-in — subcontracted | 1 | 3,800.00 | 3,800.00 | ☐ | 2,950.00 | 850.00 |
| Drywall — hang, tape, finish | 1 | 3,450.00 | 3,450.00 | ☐ | 2,400.00 | 1,050.00 |
| Cabinetry — delivered and set | 1 | 9,600.00 | 9,600.00 | ☑ | 7,450.00 | 2,150.00 |
| Project supervision — phase 2 | 1 | 1,850.00 | 1,850.00 | ☐ | 920.00 | 930.00 |
| Change order CO-002 — added under-cabinet circuit | 1 | 680.00 | 680.00 | ☐ | 450.00 | 230.00 |
| Subtotal | 23,580.00 | — | 17,320.00 | 6,260.00 | ||
| Tax (6.5%, taxable lines only) | 624.00 | — | — | — | ||
| Total | 24,204.00 | Profit $6,260 (26.5%) | ||||
| Amount Paid | 14,000.00 | — | — | — | ||
| Balance Due | 10,204.00 | — | — | — | ||
Contract #2026-118, kitchen remodel. Progress billing 2 of 3, covering rough-in through cabinet set. Change order CO-002 approved by owner 6/18 for added under-cabinet circuit. Final billing on completion of countertops, tile, and punch list.
The deposit and first progress payment are recorded against this contract, so Amount Paid and Balance Due are current on the document itself rather than worked out separately. Each progress billing updates as money arrives.
The right-hand columns are the whole argument on a job like this. Electrical cleared 25 percent, cabinetry cleared 22, supervision cleared 50 — and supervision is the line nobody thinks of as a profit center. Blended across the phase it is 26.5 percent, which is a number you cannot get to from the customer-facing side of the invoice alone. On a job that runs three months and six subcontractors, knowing that as you go is the difference between finding out you made money and finding out you did not.
Where the template approach breaks down
Every problem on this page compounds with project length, which is why general contracting is the worst fit for a template of any trade.
The contract total lives in one file, the change orders in three more, the progress invoices in a folder, and the payments received in your bank app. Answering “what is still owed on the Henderson job” means opening all of it and doing arithmetic. Answering “did we make money on the last kitchen” means reconstructing sub costs from invoices you paid months ago. And a change order agreed verbally on a Tuesday and never written down is the one that turns into a dispute at final payment.
What we built instead
EG Quote & Invoice is a macro-enabled Excel workbook that turns Excel into an actual quoting and invoicing application. It keeps a client list and a priced catalog of your phases and subcontracted trades, so the third kitchen is quoted against what the first two cost. It converts a won quote into an invoice in one click, records deposits and progress payments against it so the balance is always current, and shows cost and margin on every line — including the subcontracted ones, where most of a GC’s profit actually lives or dies.
It runs on your own PC. No account, no cloud, no subscription. The free edition has no limit on how many quotes or invoices you create and does not expire.
See EG Quote & InvoiceFree edition · Windows Excel · 32-bit and 64-bit
Other trades: Browse all invoice templates by trade →
★★★★★
“David does phenomenal work. We brought him in during the middle of a project and he was able to pick up a significant workload very quickly. His communication and ability to hit deadlines early was great.”
Report creation client · via Upwork, 2022
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →