Construction invoice template: free workbook and filled example

Download the construction invoice template

Download the construction invoice workbook (XLSX). It contains a blank Template sheet and a clearly labelled Example sheet. Both use original current-period line items, with editable quantities, rates, a supported retainage amount, a reviewed tax amount, an approved credit and allocated receipts.

Open the workbook in a compatible spreadsheet application. Start on Template, enter business and project details in the pale-yellow fields, then complete the work descriptions, units, quantities, rates and supporting references. Preserve the formulas in Amount and the calculated summary cells. Keep a clean master and save one dated copy per invoice.

No signup is required for the download. The workbook has two sheets: Template is the blank starting point; Example shows a fictional $5,200 net invoice request and a later $2,000 allocated receipt. Start a live invoice from Template so you do not accidentally send the sample payment history or fictional customer details.

This is an original invoice template, not an AIA form or a cumulative payment application. Use the customer’s required format when the agreement specifies it. The workbook handles eight current-period lines; it does not automatically import your project ledger, validate tax treatment or calculate notice deadlines.

Choose the billing format before copying the numbers

A contractor invoice template works best when its scope matches the request. An itemized current-period invoice can list hours, units or authorized services for that period. A cumulative progress application instead reconciles earned value to date, retained amounts and previously requested amounts. Moving figures between those formats without explaining their basis can duplicate a request.

This workbook supports the current-period format. Enter only the supported work included in this invoice. Do not paste cumulative completed-work totals into the item rows, then subtract prior receipts as though that were a complete progress-application calculation. Use the percentage-complete billing guide for that separate bridge.

If the job requires G702/G703 or another prescribed application, prepare the required documents and use this workbook only as an internal itemization aid where appropriate. AIA’s official guidance describes connected continuation-sheet and payment-application records; it does not make a generic invoice interchangeable with those documents.

For a side-by-side comparison and one project worked through both formats, read pay application vs invoice. The example separates the current request from earlier unpaid amounts so the same work is not requested twice.

Give the reviewer enough detail to identify the work

Replace the fictional names on Example before using any copy for a live job. On Template, identify your actual billing entity, the contracted customer, the project location, invoice number, work period and contract or purchase-order reference. The bill-to party and property owner may be different people; a billing address is not a verified legal notice recipient.

Describe each item so the reviewer can connect it to an agreed scope and supporting record. Use the agreed billing rate rather than a payroll rate. For material quantities, connect the amount to accepted deliveries and the contract’s billing basis. Record the labor-ticket, delivery or approval reference in the last column.

Check the customer’s submission instructions before sending. Use the invoice packet checklist to gather the required attachments and the PO matching guide when a reference or quantity does not reconcile.

Fill in the Excel template: exact cells and first-copy checks

Save a working copy before entering real information. On Template, use the first cell of each highlighted identity field, complete only supported current-period line items and leave the calculated Amount cells intact. The table below matches the downloadable workbook.

For the fictional example, enter the three supported work items in rows 15–17. Their amounts should be $3,000, $1,800 and $800, with $5,600 in F24. Enter the agreed $280 hold in F25, the reviewed zero-tax assumption in F26 and the approved $120 credit in F27. F28 should calculate $5,200. These are example assumptions, not default rates for your project.

Before issuing that example invoice, F29 would be zero and F30 would show $5,200. The supplied Example sheet instead shows a later reconciliation: F29 is $2,000 and F30 is $3,200. Keep the original $5,200 issued request identifiable when recording later receipts.

Fix the workbook’s Check and Review messages

Start with the earliest affected line or input, then recalculate and review the summary again. A message in F30 can originate from a bad item or deduction further up the sheet. Keep the formulas intact while correcting the source input.

The formulas do not verify every fact needed for a complete invoice. A blank description makes that row’s amount blank even if quantity and rate remain entered. An invoice number, customer identity, support reference or agreed tax treatment can also be wrong without triggering a formula warning. Compare the file with the contract and evidence before sending it.

Check your first copy before entering a live invoice

Use a disposable copy of Example to learn the calculation, then start the actual invoice on Template. Restore the sample or close the practice copy after each independent check so one test does not contaminate the next.

From the supplied example, change F29 from $2,000 to $3,000: F28 should stay $5,200 while F30 becomes $2,200. Return F29 to $2,000 before another test. Clearing a required quantity on a described item should produce Check quantity/rate; entering a genuine zero quantity should instead calculate a zero item amount.

On a separate clean Template copy, put one described item in the last supported row, row 22: quantity 2 and rate $125. With F25, F26, F27 and F29 set to their supported zero inputs, F22, F24, F28 and F30 should each be $250. This checks the eight-row boundary without inserting rows or copying formulas beyond the supported range.

Each item formula rounds quantity times rate to two decimal places, and the gross total sums those item amounts. If quantities or rates carry extra decimals, compare the rounded items and gross total with the agreed billing basis in your own application. Number formatting alone is not the same as rounding a calculation. Avoid changing precision-as-displayed settings simply to force a match; preserve the original data and investigate the difference.

Filled construction invoice example: from $5,600 to a $5,200 request

Original fictional example: Cedar Trade Services bills Oak Commercial Builders for a Texas commercial fit-out. Supported current-period items are 40 conduit-installation hours at $75, 12 approved fixture units at $150, and eight authorized testing hours at $100. All names, references and figures are illustrative.

The three item amounts are $3,000, $1,800 and $800, for gross work of $5,600. Under the fictional agreement, retainage is 5% of gross work before the approved credit: $280. A separately approved $120 credit reduces this request. The example tax amount is zero solely to isolate the billing arithmetic; it does not mean the real transaction is tax-exempt.

The net invoice request is $5,200: $5,600 minus $280 retainage minus $120 credit. If $2,000 is actually received and allocated to this invoice, its remaining net balance is $3,200. The $280 retained amount stays in the separate retainage record. Together, the remaining net request and held amount are $3,480; do not request the retainage twice.

Allocated receipts on this invoice means funds assigned to this particular invoice after issue. It is not a place to enter cash received on older invoices. A payment promise or an unallocated customer deposit should not reduce this balance as though the allocation were complete.

Record a partial payment without changing the original request

Continue the fictional $5,200 invoice. Save the issued version, then record each actual receipt in your controlled payment log with its date, reference and allocation. In the reconciliation copy, F29 holds the total of receipts assigned to this invoice, not just the most recent receipt.

If $2,000 is allocated first and another $1,000 later, F29 becomes $3,000 and F30 becomes $2,200. Leaving F29 at only the latest $1,000 would incorrectly display $4,200 still due. A promised payment is not a verified receipt.

A lump-sum deposit needs an allocation first. If a $6,500 deposit is supported as $3,000 for an older invoice and $3,500 for this invoice, enter only $3,500 in this invoice’s F29. Its remaining net balance is $1,700. Record the older invoice allocation separately, and keep the $280 held retainage outside the current net request.

If a customer pays more than the supported invoice allocations, leave the unexplained amount in the appropriate customer-credit or unallocated-receipt record for review. Do not force it into this invoice merely to make the deposit total match. Use the partial-payment guide and remittance-allocation guide for the supporting records.

Review retainage, tax and credits before entering them

Enter a supported retainage dollar amount rather than selecting an assumed universal percentage. Confirm the calculation base and any approved rate changes. The retainage basics guide explains the terminology; the retainage ledger guide shows held and released-but-unpaid amounts.

The tax field is a manually reviewed amount. Texas Comptroller guidance distinguishes construction and repair categories and contract treatment. Classify the actual work and transaction before calculating tax. The construction sales-tax review points to the relevant official guidance; the workbook is not a tax decision engine.

Use the credit field only for an approved adjustment supported by a credit memo or other authorized record. An asserted back charge is not automatically an agreed credit. Keep unresolved deductions in the dispute log so they remain visible.

Use the blank template without losing the calculation

The pale-yellow fields are inputs. Quantity multiplied by rate produces the rounded item amount. Gross work totals the completed item rows; the net request then subtracts the entered hold and credit and adds the reviewed tax. Enter a separate verified receipt only when you are reconciling this invoice after issue.

A description with a missing or invalid quantity or rate displays a review message rather than a plausible total. A zero quantity is treated as zero, so check whether that reflects the intended line. Unused rows should keep their descriptions empty. Do not overwrite a formula to remove a review message.

The file reserves eight item rows. If the job needs more, use an additional clearly referenced schedule or a project-required billing system; inserting rows requires checking all affected ranges. Keep the approved invoice version and reconcile later payments in a dated copy rather than silently changing what was sent.

If allocated receipts exceed the net request, the workbook exposes a negative balance for review. That can represent an overpayment or allocation problem. It does not automatically create a refund, settle a dispute or authorize a lien waiver.

Seven checks before you submit the invoice

Use this short review on the actual file you will submit. The complete invoice-packet checklist covers supporting attachments in more detail.

• Confirm the billing entity, bill-to customer, project and contract/PO references. Remove fictional sample names and references.
• Check that the invoice number is unique and the work period, cutoff and agreed submission channel are correct.
• Match each description, quantity and agreed rate to its support. Do not duplicate items already requested on an older invoice.
• Resolve every Check or Review message using the message guide, then reconcile gross work, retainage, reviewed tax, approved credit and the net request. No formula warning is not a completeness approval.
• Confirm F29 contains only actual receipts allocated to this invoice. Keep older invoice balances, unallocated deposits and held retainage separately identifiable.
• Preview the full submitted workbook or exported PDF in your own spreadsheet application. Confirm all rows, references and totals are readable, nothing is cut off and the recipient gets the required format.
• Save the exact issued version, attachments and submission confirmation. Record corrections as identifiable replacement versions, then track acceptance and payment separately.

Build one identifiable submission packet

For the fictional $5,200 request, assume this is the first issue and no money has yet been received. The submitted copy therefore uses F29 = $0 and F30 = $5,200. The supplied Example sheet’s later $2,000 receipt belongs to a reconciliation copy, not an invented payment history on the first submission.

Use a single invoice reference across the file, supporting schedule and submission message. The names below are an original organization example, not a customer-mandated naming rule. Follow the receiver’s actual upload fields, file types and size limits.

Send one identifiable version and track its response

Before sending, check that the item totals match the evidence and the requested amount matches the packet. Save the workbook version, any PDF or system output actually submitted, and the submission receipt. If a correction is needed, identify the replacement version and ask how the recipient will handle it.

A completed invoice does not prove that the customer has accepted or paid it. Keep submission acceptance, payment follow-up, actual receipts and statutory review as separate tasks. Use the rejected-invoice guide for replacements and the remittance-allocation guide for a deposit covering multiple invoices.

For a Texas subcontractor, the work period remains relevant to the separate notice review even if the invoice is prepared later. Use the work-month guide to preserve that record. The invoice date alone should not determine the legal calendar.

If a reviewer asks for a correction to INV-2026-041-v1, identify the replacement, such as v2, and state what changed. Ask the recipient to supersede the earlier submission so both versions are not entered as separate new payables. Preserve the original and the replacement trail; do not increase the request merely because the first packet was returned.

Construction invoice template questions

Is this a free construction invoice download? Yes. The XLSX link opens the workbook directly; it contains a blank template and an illustrative example.

Can it replace every customer’s pay application? No. Check the agreement and receiver’s requirements. This file is a current-period invoice, not a reproduced AIA payment application.

Can I use the sample’s retainage and zero tax on my own invoice? Only use amounts supported by your actual agreement and reviewed tax treatment. The sample assumptions are fictional.

Should older unpaid invoices be added to this invoice? Preserve them as separate receivables rather than duplicating the work. A customer statement can summarize those open balances.

Does the download send invoices or update my workspace? No. It is a local workbook. Save and submit the reviewed file through the agreed channel.

Can I open it in Google Sheets? Google Sheets can import XLSX files. Check the imported formulas, dates and totals before using the converted copy; the original was checked in the authoring engine, not every spreadsheet application.

Why is the Example balance $3,200 when the invoice request is $5,200? The sample includes a later $2,000 receipt allocated to that invoice. In a new unpaid copy, use zero allocated receipts. The original request and the remaining balance are different amounts.

Should I enter 5% in the retainage cell? No. F25 expects a supported dollar amount. In the fictional example, 5% of $5,600 is entered as $280; your actual agreement and calculation basis must be reviewed separately.

Does a workbook with no warning messages mean the invoice is ready to send? No. The formulas check selected numeric conditions. Verify the identity fields, descriptions, support, actual agreement and required submission format as well. A blank description can hide an otherwise populated line.