Template

Free Invoice Template:Every Field and a Filled Plumbing Example

Invoice template with every field a bill needs, a filled plumbing example, field-by-field instructions and the point where invoicing software replaces it.

Updated 8 min read

Download .xlsxExcel spreadsheet · 13 KB · Free, no sign-upFill it in online

An invoice template is a fixed list of the fields a bill must carry: who issued it, who owes it, an invoice number and dates, what was supplied, the price of each line, tax, the total and how to pay. The template below lists every field, then fills it in for a plumbing job.

The field list is free and ungated, and it is one of the free field service templates published by FieldRanger, which makes field service software that runs inside HubSpot. A Word, Google Docs, Google Sheets, Excel or Canva copy can follow this field list without change: each field becomes a labeled box in a document or a cell in a spreadsheet.

Invoice template fields

The table lists the template's fields, offered on this page as a free .xlsx download with no sign-up. Core fields belong on every invoice; optional fields depend on the job and the customer.

Invoice template fields and what goes in each
FieldWhat goes in itCore or optional
Business nameLegal or trading name of the business that did the workCore
Business contactStreet address, phone number and billing emailCore
License or tax numberContractor license number or tax registration, where the state or customer asks for itOptional
Document titleThe word "Invoice", so the document is not mistaken for a quoteCore
Invoice numberA unique number from one sequence, never reusedCore
Invoice dateThe date the invoice is issuedCore
Service dateThe date or dates the work was doneCore
Payment termsDue on receipt, Net 15 or Net 30: the days allowed after the invoice dateCore
Due dateThe invoice date plus the days in the payment termsCore
Bill toCustomer name, billing address, email and phoneCore
Service addressThe job site, when it differs from the billing addressOptional
ReferencesQuote number, work order number and the customer's purchase order numberOptional
Description of workOne or two sentences naming the work doneCore
Line itemsOne row per labor charge, part or flat-rate service: description, quantity, unit, unit price, line totalCore
SubtotalThe sum of the line totalsCore
DiscountAny agreed reduction, as an amountOptional
Sales taxRate and amount, under the rules of the state and locality of the job siteCore
TotalSubtotal less discount plus taxCore
Amount paidDeposits or part payments already receivedOptional
Balance dueTotal less amount paidCore
Payment methodsCard or bank payment link, check payee, and any other accepted methodCore
Late payment termsA late fee or interest rate, if the contract allows oneOptional
Notes and warrantyWarranty on parts and labor, and anything the customer must do nextOptional

A blank invoice template holds these fields with no entries. A sample invoice template holds them filled in, as in the example below. A simple or basic invoice template keeps the core fields and drops the optional ones.

Filled invoice example: water heater replacement in Portland, Oregon

The example is a plumbing job: a 50-gallon gas water heater replaced in a house in Portland, Oregon. The business, the customer and the prices are illustrative, not market rates.

Filled invoice template, header fields (example business, illustrative entries)
FieldExample entry
Business nameExample Plumbing LLC
Business contact100 Example Street, Portland, OR 97201 · 503-555-0100 · billing@example.com
License or tax numberLicense 000000 (example)
Document titleInvoice
Invoice numberINV-2026-0147
Invoice dateNovember 10, 2026
Service dateNovember 10, 2026
Payment termsNet 15
Due dateNovember 25, 2026
Bill toDana Smith, 200 Sample Avenue, Portland, OR 97214 · dana@example.com
Service addressSame as billing address
ReferencesQuote Q-2026-0112 · Work order WO-2026-0388
Description of workRemoved a leaking 40-gallon gas water heater; installed a 50-gallon gas water heater with a new expansion tank and connectors; tested for leaks and lit the pilot
Filled invoice template, line items (illustrative prices)
DescriptionQuantityUnit priceLine total
50-gallon gas water heater1$1,180.00$1,180.00
Installation labor (hours)3.5$135.00$472.50
Thermal expansion tank1$85.00$85.00
Flex connectors and fittings1 set$42.00$42.00
Haul-away and disposal of old tank1$60.00$60.00
Subtotal$1,839.50
Sales tax$0.00
Total$1,839.50
Amount paid (deposit on quote acceptance)$500.00
Balance due$1,339.50

Payment methods on the example read "Card or bank payment by the link in the invoice email, or check payable to Example Plumbing LLC". The notes read "Manufacturer's warranty on the tank; one-year warranty on installation labor".

The tax line is zero because of the job's location. The Oregon Department of Revenue states that Oregon has no general sales or use tax (oregon.gov, Sales tax, checked November 2026). In a state that taxes materials, labor or both, the same line carries the rate and the amount, and the rule for repair labor differs from state to state.

Invoice template instructions: field by field

The order below follows the order in which the information becomes known, and it ends with a check.

  1. Fill in the business name, contact details and any license number once, and keep them in the master copy.
  2. Assign the next number in the invoice sequence. A skipped or repeated number makes the books harder to reconcile.
  3. Enter the invoice date and the service date, choose the payment terms, and count forward from the invoice date to the due date.
  4. Copy the customer's billing details and the service address from the quote or the work order, not from memory.
  5. Add the references: the quote number, the work order number and any purchase order number the customer issued.
  6. Write one line per charge. Labor is hours times the hourly rate; materials are quantity times unit price; a flat-rate job is one line at the agreed price.
  7. Add the line totals into the subtotal, subtract any discount, and apply sales tax under the rules for the job site.
  8. Subtract deposits already paid, so the balance due is the amount the customer owes today.
  9. State how to pay, the late payment terms if any, and the warranty.
  10. Check the arithmetic: the line totals sum to the subtotal, and the total less the amount paid equals the balance due. Then save a copy with the job's other records.

The IRS lists invoices among the documents that support gross receipts (IRS, What kind of records should I keep, reviewed August 3, 2026). Its general rule is to keep records that support income for 3 years, with longer periods in specific cases (IRS, How long should I keep records, reviewed June 30, 2026).

Invoice template formats: Word, Google Docs, Excel, Google Sheets and PDF

The format changes the layout and the arithmetic, not the fields.

A Word or Google Docs invoice template lays the fields out as text, and each line total must be calculated by hand. An Excel or Google Sheets invoice template can compute line totals, the subtotal, tax and the balance with formulas, which removes the arithmetic step from the checklist above. The cell layout and formulas for a Google Sheets version, with numbering and PDF export, are set out in the Google Drive invoice template. A PDF invoice template fixes the layout, so the customer sees exactly what was sent; a printable invoice template is the same document on paper. A Canva invoice template changes the design and leaves the fields as they are.

An online invoice template is a field list or form used in a browser. The field table on this page serves as a free online invoice template, to be copied into whichever format the business already uses.

Invoice types: service, sales, contractor and commercial invoices

A service invoice bills for labor and the materials used on a job, and the plumbing example above is one. A sales invoice bills for goods sold, with quantities and unit prices and no labor lines. A contractor invoice template adds the contractor's license number, the job site and a split between labor and materials.

A commercial invoice template serves a different purpose: a commercial invoice is a document required for export and import clearance, and customs officials in the buyer's country use it to assess import duties and taxes (International Trade Administration, Commercial Invoice, checked November 2026). It is not a bill for service work.

Invoice generator apps and invoicing software

An invoice generator app fills the same fields from a form and produces a PDF. It saves the formatting step, and the office still types the customer, the work and the prices.

Field service software removes the typing, because the invoice starts from the job record. In FieldRanger, a won HubSpot deal becomes a job with its context carried over, the technician records the work in a mobile app built for technicians in the field, and the invoice is generated from the completed work order. Job status shows on the HubSpot deal record, and job completions, notes and updates are logged to the HubSpot timeline. The contractor invoicing software page describes the sequence from the last task on site to a paid invoice.

A template is enough for one person who bills a handful of jobs a month and keeps customer records elsewhere. Software earns its place when several technicians finish jobs each day and the office retypes their job sheets into invoices.

Fill it in here, or download the spreadsheet

The form below is the same template: totals calculate as you type, with the spreadsheet's own formulas, and your entries stay in this browser. Download it filled in, print it or save it as a PDF, or take the blank file.

Frequently asked questions

How to make an invoice template?

List the core fields from the table on this page: business details, invoice number, invoice and due dates, payment terms, customer details, line items, subtotal, tax, total, amount paid, balance due and payment methods. Lay them out once in a document or spreadsheet, save it as the master copy, and duplicate it for each new invoice.

What should an invoice include?

The business name and contact details, a unique invoice number, the invoice date and due date, the customer's details, a description of the work, one line per charge with quantity and unit price, the subtotal, sales tax, the total, any amount already paid, the balance due and how to pay.

Is there a free invoice template for Word or Google Docs?

The page offers a free .xlsx download with no sign-up: a Template sheet with every field and the line items, and a Sample sheet with the filled example. Google Sheets opens it, and a Word or Google Docs copy can take the same fields: each field a labeled box, and the line items a table with columns for description, quantity, unit price and line total.

What is the difference between an invoice and a receipt?

An invoice asks for payment and states a due date. A receipt confirms that payment was received. An invoice marked paid, with the payment date and method, serves as the receipt.

What is the difference between an invoice template and an invoice generator?

An invoice template is a fixed layout of fields that someone fills in by hand. An invoice generator is an app that collects the same fields through a form and produces the finished document.

How long should invoices be kept?

The IRS general rule is to keep records that support income for 3 years, with longer periods in specific cases such as underreported income. Invoices are among the records the IRS lists for gross receipts.

Templates and the job record

The plumbing invoice above draws every entry from two earlier documents, the quote and the work order, and both have their own pages in the free field service templates hub. FieldRanger generates that invoice from the completed work order instead of a blank form. Per-technician plans are on FieldRanger pricing, and Start free trial runs 14 days with no card, long enough to bill one real job that began as a HubSpot deal.

FieldRanger runs field service inside HubSpot

Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.

Book a demo