Free Contractor Invoice Template Excel (+ GST Invoice Format for India)

A contractor invoice template is a pre-formatted spreadsheet that contractors use to bill clients for completed work on construction or renovation projects. This free Excel template includes line item sections for labor (broken down by trade), materials with markup, equipment rental, subcontractor charges, and change order adjustments. It also calculates retention holdback, sales tax, and total amount due automatically. A separate Payment Tracker tab logs every invoice sent, tracks payments received, and highlights overdue balances. It is designed for general contractors, subcontractors, and construction project managers who need a professional, print-ready invoice without starting from scratch. Download it below.

What is inside the template

This template has 2 tabs. Here is what each one covers:

Tab 1: Invoice

Tab 2: Payment Tracker

What This Contractor Invoice Template Includes

Contractor Header Block

The top of the invoice identifies your business: company name, address, phone, email, contractor license number, and Tax ID or EIN. Every field is pre-formatted so you only need to replace the sample data once, then save a copy as your master template. Including your license number is not optional in most states; clients and general contractors require it for compliance records.

Client and Invoice Details

The left column captures the client name, project address, contact person, and PO reference (if the client issued a purchase order). The right column holds invoice number, invoice date, due date, and payment terms (Net 30, Net 15, or custom). The PO reference field matters: if your client requires PO numbers on invoices, missing it means delayed payment.

Line Items by Category

The line items table is divided into five sections: Labor, Materials, Equipment Rental, Subcontractor Charges, and Change Order Adjustments. Each section has its own header row so the client can see exactly what they are paying for in each category.

Labor rows include a description, trade or category (Carpentry, Electrical, Plumbing), quantity (hours or units), rate, and a calculated amount. Break labor out by trade so the client can compare against the original estimate.

Materials rows list each material purchase with markup already applied. If you buy $4,200 of lumber and mark it up 15%, enter $4,830 as the rate. Some contractors show the markup separately; this template uses a single rate column for simplicity.

Equipment Rental covers any rented equipment (lifts, generators, compactors) with the number of days or weeks as quantity and daily rate.

Subcontractor Charges lists lump-sum or itemized subcontractor costs. If you are billing the client for work your subs performed, include the sub's trade and scope here.

Change Order Adjustments captures any approved changes to the original scope. Reference the change order number and approval date in the description so the client can trace it back to the signed CO document.

Totals: Subtotal, Retention, Tax, and Amount Due

Below the line items, four formula-driven rows calculate everything automatically:

• Subtotal: sum of all line item amounts across all five sections
• Retention Holdback: a configurable percentage (default 5%) deducted from the subtotal and held until project completion or a specified milestone. The formula is negative, so it reduces the total due.
• Sales Tax: applied to the subtotal at a configurable rate (default 8.25% for Texas). Adjust for your state or municipality.
• Total Due: subtotal minus retention plus tax. This is the amount the client owes on this invoice.

Payment Instructions

The bottom of the invoice includes pre-formatted payment instructions: check payable to your company name, wire transfer details (bank, routing, account), and ACH instructions. A reminder line asks the client to include the invoice number on all payments, which saves you time reconciling deposits.

Payment Tracker Tab

The second tab is a running log of every invoice you send on this project. Columns: Invoice #, Description, Amount, Date Sent, Date Paid, Amount Paid, Balance, and Status. The Balance column is a formula (Amount minus Amount Paid). The Status column auto-calculates: "Paid" if balance is zero, "Outstanding" if no payment date is entered, "Partial" otherwise. Overdue invoices (outstanding with no payment) are conditionally formatted in red so you can spot them at a glance.

Use this tab to track cash flow across an entire project. The totals row at the bottom shows total invoiced, total received, and total outstanding.

How to Use This Template

1. Download and open in Excel. Click the download button above and open the .xlsx file. Enable editing if prompted.
2. Replace the contractor header. Enter your company name, address, phone, email, license number, and Tax ID/EIN. Save a copy as your master template so you do not have to re-enter this information on every invoice.
3. Fill in client and project details. Enter the client name, project address, contact person, and PO reference (if applicable). Set the invoice number, date, due date, and payment terms.
4. Enter line items. Add your labor, materials, equipment, subcontractor, and change order rows. Delete any sample rows you do not need. The Amount column calculates automatically (Qty x Rate).
5. Adjust retention and tax rates. The default retention is 5% and sales tax is 8.25%. Change the percentage in the formula cell if your project or jurisdiction requires a different rate.
6. Review the total due. Verify that subtotal, retention, tax, and total due are calculating correctly before sending.
7. Save as PDF. Go to File, Save As, and select PDF. The print area is pre-set to the Invoice tab only, so it will produce a clean single-page document.
8. Log it in the Payment Tracker. Switch to the Payment Tracker tab and add a row for this invoice. Update the Date Paid and Amount Paid columns as payments come in.

Construction Invoice Templates

Construction invoices have specific requirements that generic invoice templates miss. Here is what makes a construction invoice different from a standard business invoice:

Retention holdback. Most construction contracts include a retention clause (typically 5-10% of each progress payment) held until substantial completion or final inspection. This template includes a configurable retention row that deducts the percentage from the subtotal automatically. Without this row, you risk either forgetting to deduct retention (which the client will catch and delay payment) or calculating it manually each time.

Trade-based line items. Construction invoices break labor down by trade (carpentry, electrical, plumbing, HVAC) rather than listing "labor" as a single line. This lets the client cross-reference each trade against the original estimate or subcontract agreement. The template uses a Trade/Category column specifically for this purpose.

Change order adjustments. Scope changes are inevitable on construction projects. The template includes a dedicated Change Order section where you reference the CO number and approval date. This creates a clear paper trail: the client sees the original scope and approved changes separately, reducing disputes at payment time.

Progress billing. On larger projects, you invoice at milestones rather than at completion. The Payment Tracker tab supports this workflow by logging each progress bill sequentially. For formal progress billing using AIA G702/G703 forms, the template provides the data you need (completed work by category) even though it does not replicate the AIA form layout itself.

Manufacturing and Industrial Invoice Templates

If you are invoicing for manufactured goods or industrial services, the same template structure works with a few adjustments:

Material specifications. Replace the generic "Description" with part numbers, specifications, and grades. Manufacturing clients need traceability: which lot or batch was delivered, what material spec it meets (ASTM, SAE, ISO), and whether a mill certificate or certificate of conformance is included.

Unit pricing vs. lump sum. Manufacturing invoices more commonly use unit pricing (price per piece, per pound, per linear foot) rather than lump sum. The template's Qty and Rate columns handle this naturally.

Shipping and handling. Add a line item for freight, crating, or special handling charges. These are often billed separately in manufacturing but bundled into lump sums in construction.

Tax complexity. Manufacturing invoices may involve different tax rules depending on whether you are selling finished goods (taxable in most states) or providing manufacturing services (exempt in some states). Check your state rules and adjust the tax percentage accordingly.

GST Invoice Format for India

If you are billing in India, the invoice format must comply with GST (Goods and Services Tax) requirements under the Central Goods and Services Tax Act, 2017. Here is what the Indian variant of this template includes beyond the standard fields:

GSTIN fields. Both the supplier (your company) and the recipient (your client) must display their 15-digit GSTIN (Goods and Services Tax Identification Number) on every tax invoice. The template includes dedicated fields for both.

HSN/SAC codes. Every line item must include the applicable HSN code (for goods) or SAC code (for services). The template adds an HSN/SAC column next to the description. Common construction SAC codes: 9954 (construction services), 9987 (maintenance and repair). Common manufacturing HSN codes depend on the product category.

CGST + SGST or IGST. For intra-state transactions (supplier and recipient in the same state), the invoice splits GST into CGST and SGST at equal rates. For inter-state transactions, the invoice shows a single IGST line. The template includes both rows; enter the applicable rate (typically 5%, 12%, 18%, or 28% depending on the HSN/SAC code) and zero out the one that does not apply.

Place of supply. Required on every GST invoice. This determines whether CGST+SGST or IGST applies. The template includes a Place of Supply field in the invoice header.

Reverse charge. If the transaction falls under the reverse charge mechanism (where the recipient pays GST instead of the supplier), the template includes a "Reverse Charge Applicable: Yes/No" field.

E-invoice reference. For businesses with turnover above Rs 5 crore, e-invoicing is mandatory. The template includes fields for IRN (Invoice Reference Number) and QR code placeholder, which you fill in after generating the e-invoice on the GST portal.

Currency. All amounts are in INR. The template uses the Indian numbering format (lakhs and crores) where applicable.

What to Look for in a Good Contractor Invoice Template

1. Separate sections for labor, materials, equipment, and subcontractors

A flat list of line items makes it harder for the client to verify amounts against the original estimate. Look for templates that group charges by category with section headers. This is especially important for construction, where the client or their PM will check each trade independently.

2. Retention holdback calculation

If you work on projects with retention clauses, the template should have a built-in retention row with a configurable percentage. Calculating retention manually on every invoice is error-prone and looks unprofessional.

3. Change order tracking

The template should have a dedicated section (or at minimum, a clear way to label line items) for approved change orders. Without this, change order amounts get buried in the regular line items and become dispute bait.

4. Payment tracking

A separate tab or section for logging payments received, dates, and outstanding balances. This turns a one-off invoice into a project-level accounts receivable tracker.

5. Working formulas

Line item totals, subtotals, tax, retention, and total due should all calculate automatically. A template that requires you to manually calculate and type in totals defeats the purpose of using a spreadsheet.

6. Print-ready layout

The invoice should print cleanly on a single page (letter or A4) with proper margins, headers, and a professional appearance. Clients receive dozens of invoices; a clean layout signals that you run a professional operation.

7. PO reference field

Many clients, especially property management companies and general contractors, require a PO number on every invoice. If the template does not have this field, you will end up adding it manually or missing it entirely (which delays payment).

When You Outgrow Excel for Invoicing

This template works well for contractors handling a handful of invoices per month on one or two projects. Excel gives you full control over the layout, and you can customize every field to match your business.

The pain points emerge when your billing volume grows. With 10 or more active projects, you start spending hours matching invoices to purchase orders and delivery receipts. Tracking partial payments and retention releases across multiple clients becomes a spreadsheet management job in itself. If you need to generate progress billing (AIA G702/G703 format), the manual data entry from Excel into the AIA forms creates duplication and errors. Managing multiple tax jurisdictions (different state or local tax rates per project) means maintaining separate templates or formulas for each. And syncing invoice data with your accounting software (QuickBooks, Tally, Xero) requires manual re-entry unless you build custom macros.

Billing and project management software handles all of this in one place. Invoices link automatically to purchase orders and change orders. Retention is tracked per project and released at milestones. Tax rates are configured per jurisdiction and applied automatically. Payment data syncs to your accounting system without re-entry.

Related Templates

If you are using this contractor invoice template, you will also need:

• RFQ Template (Request for Quotation): Send structured quote requests to vendors and compare responses side by side. Use before issuing purchase orders.
• Construction Cost Control Templates: Budget tracking and cost category breakdown for construction projects. Use alongside invoices to track budget vs. actual.

Coming soon: Construction Estimate Template (for quoting before work begins) and Purchase Order Template (for ordering materials and tracking delivery).

Frequently Asked Questions

What should a contractor invoice include?

A contractor invoice should include your company details (name, address, license number, Tax ID/EIN), client information (name, project address, PO reference), invoice metadata (number, date, due date, payment terms), line items broken down by labor, materials, equipment, subcontractor charges, and any change order adjustments. It should also show subtotal, retention holdback (if applicable), sales tax, total due, and payment instructions (check, wire, or ACH details).

What is a retention holdback on a construction invoice?

A retention holdback (also called retainage) is a percentage of each progress payment withheld by the client until the project reaches substantial completion or passes final inspection. The typical retention rate is 5-10%. The purpose is to ensure the contractor completes all punch-list items and meets contract obligations before receiving the full payment. The retained amount is released in a final invoice after the project is accepted.

How do you invoice for change orders?

List each approved change order as a separate line item in a dedicated Change Order section of the invoice. Include the change order number, a brief description of the added or modified work, the approval date, and the agreed amount. This creates a clear paper trail. Only invoice for change orders that have been formally approved and signed by the client or their authorized representative.

What is progress billing (AIA G702/G703)?

Progress billing is the practice of invoicing at project milestones rather than at completion. The AIA G702 (Application and Certificate for Payment) and G703 (Continuation Sheet) are standardized forms published by the American Institute of Architects. The G703 lists each line item from the schedule of values, the work completed to date, stored materials, and the percentage complete. The G702 summarizes the total application amount, previous payments, retention, and the current amount due. Many commercial construction contracts require invoicing in this format.

What is the GST invoice format for India?

A GST-compliant invoice in India must include the supplier and recipient GSTINs (15-digit tax identification numbers), HSN or SAC codes for every line item, the place of supply, and the applicable tax breakdown: CGST + SGST for intra-state transactions or IGST for inter-state transactions. The invoice must also indicate whether reverse charge applies. Businesses with turnover above Rs 5 crore must also generate an e-invoice through the GST portal and include the IRN (Invoice Reference Number) on the document.

When should you switch from Excel invoicing to billing software?

Consider switching when you regularly manage more than 5-10 active projects simultaneously, when you spend more than an hour per week matching invoices to POs or tracking payments, when you need progress billing in AIA G702/G703 format, or when you need your invoice data to sync automatically with accounting software like QuickBooks or Xero. Billing software eliminates manual data entry, automates retention tracking, and provides real-time visibility into accounts receivable across all projects.