Billing workflow
Construction Invoice Template and Worked Example
Use a construction invoice to connect agreed work, labor, materials, approved changes and payments to one project record.
Download the free construction invoice files
No signup or email is required. Your entries stay in your own file. The spreadsheets contain formulas and eight item rows; the PDFs are matching print previews, not interactive forms.
Blank template
Enter your own project details and agreed billing items.
Worked example
Follow a fictional repair job through the calculation.
Worked example: labor, materials and an approved change
Invoice INV-EXAMPLE-01 references fictional project REPAIR-EXAMPLE-01. These are illustrative billing inputs after scope review, not prices derived from a customer's unverified estimate request.
| Work / reference | Quantity | Unit price | Amount |
|---|---|---|---|
| Labor: verified repair work | 12 | $100.00 | $1,200.00 |
| Materials: reviewed materials | 1 | $600.00 | $600.00 |
| CO-01: approved extra work | 1 | $200.00 | $200.00 |
- Subtotal
- $2,000.00
- Tax (example assumption: 0%)
- $0.00
- Total billed
- $2,000.00
- Payments received
- $500.00
- Remaining balance
- $1,500.00
The material line is marked taxable in the example, but the example rate is 0%. This is a calculation demonstration, not a tax rule. Apply the correct rate and taxable flags for your own work. A payment already received reduces the balance; it does not reduce the value of the work billed.
Complete and check the invoice
- Replace the invoice reference, project reference, business, client and job details. Enter the issue date, billing period and agreed due date.
- Edit the amber input cells. For every used item row, enter a work reference, description, quantity, unit price and a taxable flag: 1 for taxable, 0 otherwise. Leave unused rows entirely blank.
- Enter the applicable tax rate and payments received, using 0 when none. The amount cells calculate line totals, subtotal, tax, total billed and remaining balance.
- Resolve any “Check inputs”, “Set tax rate”, “Check tax / lines” or “Set payments” message before issuing an invoice. A negative balance shows an overpayment or credit to review.
- Review the result against the agreed scope and payment record. Save an issued copy, and keep supporting receipts and approved changes with the project.
Amounts are rounded to cents at each line and at the tax calculation. The worksheet uses a single tax rate and is intended for simple itemized billing. Review more complex tax treatment, retention, progress billing or payment schedules separately before using it for those jobs.
Keep estimate requests, changes and invoices connected
Start with an estimate request checklist to gather initial project details. Prepare and agree the actual scope and price separately. Use a change order record when that agreement changes, then reference the approved change on the invoice so it can be checked against the billed amount.
Record payment dates, amounts and transaction references separately from the invoice. Keep receipts and reconcile payments before updating the remaining balance. Do not add bank credentials or other sensitive payment data to a shared template.
When a spreadsheet is no longer enough
The free files work on their own. If you need to manage recurring estimates and invoices alongside expenses and customer records, consider whether a dedicated system fits the work you do.
For a separate free invoicing option, review Zoho Invoice's contractor templates. Zoho Invoice and Zoho Books are different products; the optional affiliate link above is for Books. See the official Zoho Books feature overview when comparing the workflow you need.
Related contractor tools
Browse contractor forms and checklists for the rest of the project workflow.
FAQ
Can I use this construction invoice template without signing up?
Yes. Download the XLSX spreadsheet or PDF directly. No software account or email address is required. Edit the spreadsheet in a compatible spreadsheet app; the PDF is a printable reference.
How does the construction invoice spreadsheet calculate the balance?
Each complete line is quantity multiplied by unit price, rounded to cents. The subtotal adds those lines. Tax applies only to lines marked 1, using the rate you enter. Total billed is subtotal plus tax; remaining balance subtracts payments already received.
Is an estimate request or change order an invoice?
No. An estimate request gathers information before pricing. An approved change order records a scope, price or schedule change. An invoice records the agreed work being billed and references the relevant project and approved changes.
Does the example set the tax rate or payment terms for my project?
No. The fictional example assumes a 0% tax rate to demonstrate the calculation. Enter the applicable tax treatment, billing dates and agreed payment terms for your own work. The worksheet does not determine tax or billing compliance.