Template

Free Hourly Invoice Template:Every Field and a Filled Commercial Oven Repair Example

Hourly invoice template for time-and-materials work: hours by technician and date, rates, trip charges and parts, filled for a commercial oven repair in Boise.

Updated 9 min read

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

An hourly invoice template is the bill for time-and-materials work: one row per technician per date with hours and rate, a trip charge per visit, parts at unit price, sales tax on the lines the state taxes, and the balance due. The example below fills every field for a two-visit commercial oven repair in Boise, Idaho.

The field list is free and ungated, one of the free field service templates published by FieldRanger, which makes field service software that runs inside HubSpot. A general invoice template bills the job as a set of lines; an hourly invoice also carries the time record behind the labor lines, so the customer can check each quarter hour against the visits.

Hourly invoice template fields: time, rates, trips and parts

The table lists the template's fields, offered on this page as a free .xlsx download with no sign-up. The rate schedule and the time rows are the fields a flat-rate invoice does without.

Hourly invoice template fields and what goes in each
FieldWhat goes in it
Business name and contactLegal or trading name, address, phone and billing email
Invoice numberA unique number from one sequence, never reused
Invoice date and due dateThe issue date, and the issue date plus the days in the payment terms
Payment termsDue on receipt, Net 15 or Net 30
Bill toCustomer name, billing address and the contact who approves invoices
Service addressThe site where the work was done, when it differs from the billing address
ReferencesWork order number, the customer's purchase order number and any not-to-exceed amount
Equipment or work descriptionWhat was repaired, with make, model and serial number where equipment is involved
Rate scheduleEach rate by role, the standard hours, the after-hours multiplier and the billing increment
Time rowsOne row per technician per date: name, role, start and finish times, hours, rate type, rate and line total
Trip chargesOne line per visit at the stated trip charge, with the visit date
Parts and materialsOne line per part: description, part number, quantity, unit price and line total
Shop suppliesSmall consumables billed as one line, where the rate schedule allows it
Labor subtotalThe sum of the time rows
Sales taxThe rate and the taxable base, applied only to the lines the state taxes
TotalLabor, trips, parts, supplies and tax added together
Amount paid and balance dueDeposits received, and the total less those deposits
Payment methodsCard or bank payment link, check payee and any other accepted method
Work notesFindings, the work performed, the test that confirmed the repair, and any follow-up quoted separately

One technician on one date fits a single labor line. Two technicians or two visits need the rows, because the rate changes with the role and the time of day.

Filled hourly invoice: convection oven repair at a Boise restaurant

A restaurant's electric convection oven stopped heating. The first visit found a failed fan motor; the second, booked before opening, replaced it. The business, the customer and the rates are illustrative, not market rates.

Filled hourly invoice, header and rate schedule (example business, illustrative entries)
FieldExample entry
Business name and contactExample Kitchen Service LLC, 400 Example Way, Boise, ID 83702 · 208-555-0140 · billing@example.com
Invoice numberHR-2026-0219
Invoice date and due dateNovember 6, 2026 · December 6, 2026
Payment termsNet 30
Bill toExample Bistro LLC, attention Taylor Morgan, general manager · 210 Sample Street, Boise, ID 83706
Service addressSame as billing address
ReferencesWork order WO-2026-0731 · Customer PO 1188 · Not to exceed $1,500.00 before tax
Equipment or work descriptionFull-size electric convection oven, single deck, serial number from the data plate; no heat, convection fan not turning
Rate scheduleLead technician $125.00 an hour; apprentice $75.00 an hour; standard hours 7:00 AM to 5:00 PM on weekdays; outside standard hours, 1.5 times the rate; billed in quarter hours; trip charge $65.00 per visit
Work notesVisit 1: fan motor windings open, terminal block scorched. Visit 2: replaced the motor and terminal block, rewired, ran the oven to 350 °F and held it 20 minutes with the fan and elements cycling
Filled hourly invoice, time rows by technician and date (illustrative rates)
DateTechnician and roleStart and finishHoursRate typeRateLine total
Nov 3, 2026Jordan Lee, lead technician8:40 AM to 10:10 AM1.50Standard$125.00$187.50
Nov 5, 2026Jordan Lee, lead technician6:00 AM to 7:00 AM1.00After hours$187.50$187.50
Nov 5, 2026Jordan Lee, lead technician7:00 AM to 8:15 AM1.25Standard$125.00$156.25
Nov 5, 2026Sam Rivera, apprentice6:00 AM to 7:00 AM1.00After hours$112.50$112.50
Nov 5, 2026Sam Rivera, apprentice7:00 AM to 8:15 AM1.25Standard$75.00$93.75
Labor subtotal6.00$737.50
Filled hourly invoice, trips, parts, tax and balance (illustrative prices; Idaho state rate)
LineQuantityUnit priceLine total
Trip charge, November 3 and November 52$65.00$130.00
Convection fan motor, OEM replacement1$412.00$412.00
Terminal block, high temperature1$38.50$38.50
High-temperature wire and connectors1 kit$24.00$24.00
Shop supplies1$12.00$12.00
Subtotal before tax$1,354.00
Sales tax, 6% on parts of $474.50$28.47
Total$1,382.47
Amount paid$0.00
Balance due$1,382.47

The not-to-exceed amount caps the job at $1,500.00 before tax. After the first visit, $252.50 of labor and trip charge plus a $474.50 parts order left $773.00 for the second. A job that would pass the cap stops for a new approval, as set out in NTE meaning.

Idaho sales tax on separately stated repair labor

The tax line covers the $474.50 of parts and nothing else, and the layout of the invoice decides that. The Idaho State Tax Commission states that repair labor is not taxable when the invoice lists labor and parts separately, and that tax is calculated on the entire amount when they are combined (Idaho State Tax Commission, Repair Shops, last updated September 12, 2024). The same guide says shop supplies used during a repair are not taxed on the invoice, because the business pays tax when it buys them. The rate is 6% of the sales price under Idaho Code 63-3619 (Idaho Legislature, 63-3619, checked November 2026); a job in a city with its own local sales tax adds that city's rate.

Two limits apply. The guide concerns repairs to tangible personal property, such as a freestanding oven; repairs to real property by plumbers and electricians fall under the contractor rules. It is silent on trip charges, so the example leaves the trip charge outside the taxable base, a treatment to confirm with the Tax Commission.

Hours worked and hours billed under the FLSA

The invoice bills 6.00 hours; the payroll for the same two days counts more. The Department of Labor states that travel from job site to job site during the workday is work time and must be counted as hours worked, while ordinary travel from home to work is not (DOL Wage and Hour Division, Fact Sheet #22, revised July 2008). Where an employee must report to a meeting place to collect tools or instructions, the trip from there to the work site is hours worked as well (29 CFR 785.38, via Cornell LII, checked November 2026). On November 5 both technicians collected the motor at the shop first, so the drive to the bistro is paid time for both. The invoice recovers it through the trip charge, not the time rows.

Overtime under the Fair Labor Standards Act is owed for hours over 40 in a workweek, at not less than one and one-half times the regular rate (DOL, Overtime Pay, checked November 2026). The invoice's 1.5 multiplier is a contract term for early-morning work: the apprentice earns FLSA overtime for the 6:00 AM hour only in a week that passes 40 hours. Payroll rounding to the quarter hour is accepted only where, over time, it still pays for all the time actually worked (29 CFR 785.48, via Cornell LII, checked November 2026). Billing in quarter hours is a separate term, accepted by the customer in the rate schedule.

Hourly invoice instructions: from clock-in to balance due

  1. Fill in the business details and the rate schedule once, in the master copy, so each invoice states the rates the customer accepted.
  2. Assign the next invoice number, and copy the work order number, the purchase order number and any not-to-exceed amount from the work order.
  3. Enter one time row per technician per date, from the start and finish times recorded on site, split at the boundary between standard and after-hours rates.
  4. Round each row to the billing increment, and multiply the hours by the rate for that role and rate type.
  5. Add one trip charge per visit, with its date.
  6. List each part with its part number, quantity and unit price; add shop supplies only if the rate schedule names them.
  7. Apply sales tax to the taxable lines only, under the rules of the state where the work was done, and show the rate and the base on the tax line.
  8. Add the subtotals and tax into the total, subtract deposits, and compare the subtotal with the not-to-exceed amount.
  9. Write the work notes: findings, the work performed, the test that confirmed the repair, and any follow-up quoted separately.
  10. Check the time rows against the work order: every row matches a recorded visit, each row's hours equal finish less start, and no technician appears twice in the same period. Then send the invoice with the work order attached.

Hourly, flat-rate and contractor invoices

An hourly invoice prices labor by the time the job took: the customer carries the risk of a long job and sees the hours. A flat-rate invoice prices the task, and the business carries that risk; its labor line shows no hours. A contractor invoice template adds the license number and the labor and materials split that construction work needs, and it may bill hourly, flat or by progress. A not-to-exceed job bills hourly up to an approved cap.

Time tracking and contractor invoicing software

A paper timesheet reaches the office after the visit, and the office retypes its hours, rates and parts into the bill.

In FieldRanger, a won HubSpot deal becomes a job with its context carried over. Technicians clock in and out in the mobile app with time logged against each job, and each clock-in and clock-out records where the technician was, so the hours match the job site. The GPS time tracking page describes those records. Parts and materials used on each job are logged for job costing. The invoice is generated from the completed work order, payment can be taken in the field through Stripe, and invoices and payments sync with QuickBooks. The contractor invoicing software page sets out the sequence from the last time row to a paid invoice.

The FieldRanger price book holds the regular and after-hours labor rates, and the split of a row at 7:00 AM is made on the work order or in the invoice lines.

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

What is an hourly invoice template?

A bill layout for time-and-materials work: business and customer details, an invoice number and dates, a rate schedule, one time row per technician per date with hours and rate, trip charges, parts, sales tax on the taxable lines, the total and the balance due.

How to write an invoice for hours worked?

State the rates and billing increment before the work starts. List each date worked with its start and finish times, hours, rate and line total, add materials and trip charges as separate lines, apply any sales tax, and state the due date and the payment methods.

Should labor and parts be listed separately on an hourly invoice?

Yes, wherever tax depends on it. In Idaho, repair labor on tangible personal property is not taxable when the invoice lists labor and parts separately; combined, the whole amount is taxed. Separate lines also let the customer check the hours against the visit record.

Is travel time billable on an hourly invoice?

Travel is billed only as the rate schedule allows: as a trip charge per visit, as hourly drive time, or not at all. Pay is a separate question; under the FLSA, travel between job sites during the workday counts as hours worked.

The Boise oven repair under its $1,500 cap

Invoice HR-2026-0219 bills 6.00 hours across two dates and lands $146.00 under the bistro's cap before tax, a figure the office could check before it booked the 6:00 AM visit. The work order behind the bill sits with the other free field service templates. FieldRanger plans are sold per technician, as listed on pricing. Start free trial runs 14 days without a card, and a time row recorded on site in that period reaches the invoice without being retyped.

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