Construction Invoice Template in Excel: Setup and Formulas

Formulas & functions · Updated November 22, 2026

A construction invoice template in Excel can track the work performed, quantities, rates, approved changes, taxes or other contract charges, payments, and the balance due. Create a worksheet with one row per billed item, calculate each line as quantity multiplied by rate, and add clearly labeled summary fields; the sample layout and formulas below work in Microsoft Excel for Microsoft 365 on Windows.

What a construction invoice template should do

An invoice is a payment request, not just a list of prices. A useful construction invoice lets a customer connect the amount requested to a project, a billing period, and identifiable work or materials. It should also make it easy to distinguish new charges from amounts already paid or credited.

Construction billing can involve labor, materials, equipment, subcontractors, allowances, approved change orders, deposits, progress billing, and retainage. Not every project uses all of these, and the contract determines which items may be billed and when. An Excel template should therefore be adaptable rather than assume that every contractor bills the same way.

At minimum, plan to include:

  • Contractor or company name and contact details, plus the customer or general contractor receiving the invoice.
  • Invoice number, invoice date, payment due date or terms, and a project name, site address, or contract reference.
  • A description of the work or materials, quantity, unit of measure, unit rate, and line amount.
  • A subtotal and clearly identified adjustments, such as a payment already received or a contract-defined retainage deduction.
  • Payment instructions and a contact for questions, while avoiding unnecessary sensitive information.

Plan the workbook layout

A simple design uses one worksheet per invoice. Put the company and customer details at the top, followed by invoice and project information. Use a consistent table for charges, then place the calculations in a summary block below or to the right. Keeping inputs separate from formulas makes the sheet easier to review and reduces the chance of overwriting a calculation.

For example, set up columns A through F with Item, Description, Quantity, Unit, Unit rate, and Line amount. Use rows 15 through 24 for charge lines. Column C holds quantities, column E holds rates, and column F calculates amounts. The unit column might contain hours, days, cubic yards, square feet, or each; choose units that match the way the contract or approved estimate describes the work.

Above the table, reserve cells for the invoice number and date, project identifier, billing period, and purchase order or contract reference where applicable. If the work is billed by phase or schedule of values, include the relevant phase or schedule item so the reviewer can match the invoice to the agreed billing structure. Do not treat a free-form description as a substitute for any documentation the project requires.

Enter line items and calculate the total

Enter one distinct billed item per row. A specific description such as concrete placement at the east entry is more useful than a generic entry such as labor. For materials, state what was supplied and, where useful, identify the delivery or supporting document. For labor, explain the trade or task and use the correct quantity unit. Split charges when they have different rates, tax treatment, or contract conditions.

With quantity in C15 and unit rate in E15, enter this formula in F15 to calculate the first line amount: =C15*E15. If the row represents 12 labor hours at 85 per hour, the result is 1,020. Copy the formula down the line-amount column for the other rows. Format quantities and rates appropriately; a rate may need two decimal places, while a quantity such as 2.5 hours may need one or two.

With line amounts in F15:F24, enter this formula in the subtotal cell F25: =SUM(F15:F24). If the three filled lines are 1,020, 640, and 275, the subtotal is 1,935. Empty rows within the range do not change the sum. Check that the range includes every billable row and does not include the subtotal cell itself.

A useful habit is to keep the formula in the first line and copy it down before sending the invoice. If you prefer blank unused lines instead of displayed zeroes, a conditional formula is possible; for example, with quantity in C15 and rate in E15, use =IF(OR(C15="",E15=""),"",C15*E15) in F15. It leaves the amount blank until both inputs are present. This is optional: simple multiplication is easier to inspect, and a visible zero can help reveal a missing value.

Build a transparent summary block

Make every adjustment explicit. A reader should be able to trace the amount due from the line items without guessing whether a payment, deduction, or charge has been included. One illustrative summary might use F25 for subtotal, F26 for a tax rate entered as a percentage, F27 for tax, F28 for a retainage rate, F29 for retainage withheld, F30 for prior payments or credits, and F31 for the amount due.

With F25 holding a subtotal of 1,935 and F26 containing 8%, use =F25*F26 in F27 to calculate 154.80. This is arithmetic only, not a statement that the whole invoice is taxable. Taxability, the applicable rate, the taxable base, and required invoice disclosures depend on the jurisdiction, the work, and the parties’ circumstances. Confirm the correct treatment with a qualified tax professional or relevant authority rather than copying a sample rate.

With F25 holding the subtotal and F28 containing a contract-approved retainage rate of 10%, use =F25*F28 in F29 to calculate 193.50. This example assumes retainage is calculated on the full subtotal. A contract may define a different base, rate, cap, or release process, so adjust the layout and calculation to match the actual agreement. Retainage is not the same as a discount or a payment received.

With F27 as tax, F29 as retainage withheld, and F30 as prior payments or credits, use =F25+F27-F29-F30 in F31 for this simplified example. If F25 is 1,935, F27 is 154.80, F29 is 193.50, and F30 is 500, the amount due is 1,396.30. Verify that each figure is appropriate for the particular invoice and that a credit has not already been deducted elsewhere.

Progress billing, change orders, and retainage

For a progress invoice, identify the billing period and whether the amount represents work completed to date, work completed during this period, or another contract-defined measure. A schedule of values may list contract activities and their assigned amounts. Depending on the agreed process, a progress application may need columns for the prior billed amount, current work, stored materials, and total completed to date. A basic line-item invoice should not be presented as a complete progress-billing application if the project requires a more detailed format or a prescribed form.

Separate approved change orders from the original contract work. Include the change-order reference and a concise description, and do not silently add unapproved scope to the invoice. If a change order changes the contract value or payment schedule, keep the supporting approval and update the invoice’s reference information consistently.

Retainage commonly means a portion withheld under the contract until a specified milestone or other condition. Show the retained amount separately from the current payment due, and keep a record of amounts held and later released. The template should not imply that a withheld amount has been forgiven. Follow the contract’s terminology and calculation method, and check applicable requirements with a qualified professional when needed.

Format and use the sheet in Excel

Use number formats to make the invoice legible: dates for dates, percentage for rates, and the appropriate currency format for money. In Microsoft 365 for Windows, select cells and use Home > Number to choose a format. Use bold labels and restrained borders to separate the charge table from the summary; avoid relying on color alone to communicate a deduction or status.

For a longer invoice, select a cell below the heading rows and use View > Freeze Panes so column labels remain visible while scrolling. Before printing or saving a PDF, check the preview, page orientation, margins, and scaling under Page Layout. If the sheet is too wide, landscape orientation may help, but scaling every column onto one page can make the text too small to read. Set a print area that includes the invoice details and all billed lines, and confirm that no summary totals are cut off.

On Excel for Mac, the core worksheet formulas and number formats work the same way, though ribbon placement and some dialog layouts can differ. Excel for the web also supports ordinary formulas such as multiplication and SUM, but print and page-layout controls may not match the desktop ribbon exactly. If the workbook will be used in different Excel versions, keep the calculations simple and test the printed or PDF output in the version used to issue invoices.

Common errors and useful checks

Errors often come from the process around the spreadsheet rather than from complicated formulas. Before sending an invoice, compare its project name, invoice number, billing dates, and line descriptions with the contract and supporting records. Then review the calculations and the payment instructions.

  • Check quantities, unit rates, and units against timesheets, delivery records, approved estimates, or other project documentation.
  • Confirm that each line amount is calculated and that the subtotal covers all intended rows without including unrelated cells.
  • Review tax, retainage, prior payments, and credits as separate items. Confirm that none is applied twice or omitted.
  • Make sure a payment already received is labeled clearly and is not confused with retainage or a new credit.
  • Check that the invoice number is unique within the contractor’s numbering system and that the due date matches the stated terms.
  • Save a working copy before editing a reusable master template. Use a clear file name that identifies the project and invoice period, and store records securely.

Excel formulas do not verify that a charge is authorized, a tax rate is correct, or a contract requirement has been met. A spreadsheet can calculate entered values accurately while those values are still wrong. A second-person review can be particularly useful for large invoices, unusual adjustments, or a workbook that has been copied from an earlier project.

Excel versus other invoice options

Excel is useful when a contractor wants a customizable document, familiar arithmetic, and a worksheet that can be adapted to different project types. It can also be convenient for drafting an invoice from a schedule of work. However, a spreadsheet does not automatically provide a reliable approval trail, send reminders, reconcile bank deposits, or maintain a complete accounting ledger. Those tasks require a separate process or suitable business software.

A word-processing document or PDF can be easier to present as a polished, fixed-page invoice, but manually changing totals increases the risk of arithmetic errors. Accounting or construction-management software may connect estimates, purchase orders, billing, payments, and reports, but features and costs vary. Compare options based on required contract forms, number of invoices, approval workflow, recordkeeping needs, and whether more than one person must edit the information. A spreadsheet is not automatically the right choice for every company or project.

Frequently Asked Questions

How do I make a construction invoice in Excel?
Set up company, customer, project, and invoice details; create columns for description, quantity, unit, rate, and line amount; calculate line amounts and subtotal; then show any applicable tax, retainage, prior payments, and final balance separately. Check the contract and project requirements before issuing it.

What should a construction invoice include?
Common fields include the contractor and customer details, invoice number and date, project identifier, billing period, itemized work or materials, quantities and rates, amount due, payment terms, and payment instructions. The contract, customer procedures, and local requirements may call for additional information or a specific form.

How do I calculate the amount due in Excel?
Use line-item formulas to calculate charges and SUM to total the billed lines. Then add applicable charges and subtract separately identified payments, credits, or contract-defined retainage as appropriate. The exact calculation depends on the agreement and billing rules; the example formula above is only a basic illustration.

Can I use an Excel invoice template for progress billing?
Possibly, if the customer and contract accept it and it contains the required progress-billing details. Some projects require a schedule of values, cumulative amounts, stored-material detail, lien-related documentation, or a prescribed application form, which a simple invoice layout may not cover.

Should retainage appear on the invoice?
If retainage applies, showing it as a distinct line or summary field can clarify the current payment calculation and the amount withheld. Use the contract’s rate, calculation base, and release conditions; do not assume a universal percentage or method.

Can I send the Excel file to the customer?
You can, but consider whether the customer needs an editable workbook or a fixed PDF. A PDF can reduce accidental changes to the presented invoice, while the workbook remains useful as a working record. Check the exported document for clipped text, hidden rows, incorrect page breaks, and readable totals before sending.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.