Contractor Invoice Template (Free) with Tax Excel
A Excel Contractor invoice with a built-in tax row tracks Sales Tax or VAT without extra math. Enter your rate, and the total updates automatically.
Get the free contractor with Tax Excel invoice
Open the generator, fill in your job details, and export a Excel in seconds. Everything stays in your browser.
Why contractors need a tax-ready Excel invoice
Service businesses handle tax differently by state and by job type — some services are taxable, some are not, and the rate changes with the jurisdiction. A Excel invoice with a dedicated tax row keeps the taxable subtotal, the tax amount, and the grand total visible, so the client can see exactly what is tax and what is not. Include your Tax ID or registration number on the invoice when your area requires it.
- Formulas add up line items, apply tax and discounts, and track what is still unpaid.
- Drop-downs for your usual services keep data entry consistent across months.
- One workbook per client or per season makes year-end bookkeeping a copy-paste job.
Fields a contractor with tax invoice should include
Every job is different, but these contractors fields belong on the invoice. Keep them on the template so nothing gets missed:
| Field | What to enter |
|---|---|
| Project name & scale | e.g. "Kitchen remodel, 2nd floor" — lenders match draws to the job address |
| Materials markup rate | State the markup, commonly 10–20%, so the owner can verify the math |
| Subcontractor fees | List each trade separately with the agreed amount |
| Deposit / retention & insurance | Show the deposit already paid and any retention withheld |
| Permit fees | Pass-through permit and inspection fees at cost |
| Change order total | Reference the approved change-order number and date |
| Progress payment split | Common 50/40/10 or 30/30/30/10 schedule — mark the current draw |
| Late payment interest | Optional line: 1.5% monthly or state-legal rate on overdue balances |
Real scenario: a bathroom remodel milestone draw
Mid-size remodelers usually bill in three to four draws tied to completed phases — demolition, rough-in, finishes, and punch list. Here is a worked example using typical contractors pricing:
| Line | Qty | Rate | Amount |
|---|---|---|---|
| Carpentry labor — rough-in (per hour) | 16 | $70 | $1,120.00 |
| Subcontractor — plumbing rough-in (per job) | 1 | $950 | $950.00 |
| Subcontractor — electrical rough-in (per job) | 1 | $620 | $620.00 |
| Materials — lumber, fixtures ordered (itemized) | 1 | $1,480 | $1,480.00 |
| Materials markup 15% | 1 | $222 | $222.00 |
| Permit & inspection fees (pass-through) | 1 | $185 | $185.00 |
| Change order CO-004 — vent relocation (approved) | 1 | $350 | $350.00 |
Draw subtotal $4,927.00, less the 50% deposit already collected, leaves a balance due of $2,463.50 on this draw — Net 10 after inspection sign-off. Listing subs, markup, permits, and the change order separately is what makes the draw approvable without a phone call.
How to invoice with tax in Excel in 3 steps
Set your tax rate
Enter the Sales Tax or VAT rate for the job location. Keep separate invoice templates if you work across different rates.
Mark taxable vs. non-taxable lines
Keep service lines and taxable product lines separate, or flag them so only the taxable subtotal is taxed.
Show the grand total clearly
The invoice lists subtotal, tax amount, and total — so the client can reconcile against their own books.
Contractor with Tax Excel invoice questions
Should all contractor services be taxed?
It depends on your state and the service type. Many states exempt some labor but tax products and certain services. Confirm with your tax authority.
Where does the Tax ID go on the invoice?
In the header block next to your business details, or in a dedicated "Tax ID / VAT number" row near your address.
Can I switch between tax-inclusive and tax-exclusive totals?
With the tax row on this template you can show either — set the rate to 0 for tax-exclusive jobs or toggle the display of the tax line.
Does the Excel invoice calculate tax automatically?
Yes. In Excel the formulas do it; in PDF fill the taxable subtotal and rate and the total row is ready to print.