Auto repair estimate template

A repair estimate template is a form with seven blocks: shop identification, customer, vehicle, one block per job, the parts under each job, the totals and a dated authorization line. Every block below is a field list you can copy into a spreadsheet, with a worked diesel example underneath so the arithmetic is visible.

Key takeaways

• Seven blocks, and the authorization line is the one that decides disputes.
• Labor and parts subtotal separately, because that is what makes the number comparable.
• Shop supplies get a stated rule and their own line.
• A part nobody could price is flagged, never shown as zero.

What blocks does an auto repair estimate template need?

Seven, in a fixed order. The top three identify who is paying, what they are paying for and which vehicle it lives on. The middle two carry the work. The bottom two carry the money and the signature. A shop that changes the order confuses its own advisors; a shop that drops a block loses an argument later.

Block 1. Shop and document identification

Block 2. Customer

Block 3. Vehicle

Block 4. Job block, repeated once per job

Block 5. Parts lines, nested under each job

Block 6. Totals

Block 7. Authorization

What does a state written-estimate rule require?

Several states regulate the estimate itself. California's automotive repair statute is the version most often copied and the most specific, and it puts the requirement before the work rather than on the invoice. Quoting it directly, from Business and Professions Code section 9884.9:

"The automotive repair dealer shall give to the customer a written estimated price for labor and parts necessary for a specific job, except as provided in subdivision (e). No work shall be done and no charges shall accrue before authorization to proceed is obtained from the customer."

Read the second sentence again. Charges do not accrue. A shop in that state which starts a teardown on a verbal go-ahead and no written estimate has no billable hours to point at when the customer disputes the invoice. Your own state's rule may set a dollar threshold, may require the estimate only on request or may not exist at all, so check the statute your licence is issued under before you print anything.

What does a filled-in estimate look like?

An illustration, not a quote from any shop. Every input is stated so that every figure below can be checked against the one above it. A 2015 Ram 2500 with the 6.7L Cummins, turbocharger removal and replacement. Assume the labor lookup returns 6.6 hours for the operation, the shop labor rate is $165.00 per hour, and the parts costs are illustrative supplier costs run through the bands in the parts matrix template.

Labor

Parts

Parts subtotal: $1,675.60 + $90.09 + $150.28 + $120.90 = $2,036.87

Totals

The tax line is left blank on purpose. Which of those subtotals your state taxes, and at what rate, is an answer you get in writing from your own revenue department, and a shop that guesses it finds out in an audit two years later. Put the rate and the base in the derivation column once you have that answer, so the estimate explains itself.

Four things in that block are doing work no template farm's blank grid does. The oil feed line is there because a turbo failure sends debris down it, so replacing it is part of the operation instead of a comeback. The oil and filter are there for the same reason. The gasket set is a separate line so the customer can see the job includes new hardware. And the shop supplies line shows its rule, which is why nobody argues about it.

Which lines get an estimate rejected?

The rejected ones share a pattern: the customer cannot tell what they are buying. A blank grid with three rows reading parts, labor and tax gives a person nothing to say yes to. The fixes are small and they are all structural.

That last one has teeth. Section 9884.8 is direct about it:

"If any used, rebuilt, or reconditioned parts are supplied, the invoice shall clearly state that fact."

The remanufactured turbocharger in the worked example above is exactly the line that rule is pointed at.

Why do downloadable estimate templates fall short?

Search for a repair estimate template and you get a Word file with a grid on it: description, quantity, price, total. It was built by somebody who has never watched an advisor try to sell a head gasket job over the phone. The grid is the least valuable part of the document.

What a shop needs from the form is the reasoning it enforces. A description column with no concern and no cause means the customer reads "head gasket" and hears "expensive". A price column with no source means the advisor answers "why so many hours" with "that's what the book says", which is true and unpersuasive. A totals block with no shop supplies rule means the number at the bottom includes a figure nobody can explain.

The version on this page enforces four things the blank grid does not. Every job carries its concern and its cause, so the customer reads the reason before the price. Labor lines name where their hours came from. A parts line states its condition, so a remanufactured unit is disclosed on the estimate instead of discovered on the invoice. And the authorization block captures amount, signature, date, time and method together, which is the record that settles a dispute six weeks later.

There is a second reason the free files disappoint. A template is a container and the hard work is filling it: the labor lookup for the exact engine, the parts list the procedure calls for, the three supplier calls behind each price. A blank grid does none of that. It sits open on the second monitor while the advisor does all of it by hand, and a better-looking grid does not shorten a single one of those steps.

How do you copy this template into a spreadsheet?

Paste the header row below into the first row of a sheet, then one row per parts line under each job. The job-level fields sit in a header band above the parts rows so a job with six parts still reads as one job.

job_name,concern,cause,correction,labor_hours,labor_rate,labor_extension,hours_source,part_name,part_number,condition,qty,unit_price,extension,availability,core

totals_line,amount,derivation
labor_subtotal,,sum of labor extensions
parts_subtotal,,sum of parts extensions
shop_supplies,,percent of labor with cap
sublet,,cost plus margin
sales_tax,,state rate on the taxable base
estimate_total,,sum of the above

What does this mean for the advisor writing it?

The template is the easy half. The slow half is filling it: looking up the hours, chasing three suppliers for a price and keying every line in while the phone rings. That is where the day goes, and the estimate turnaround checklist is how a shop puts a number on it.

When a shop already sells the work as a canned job, the template fills itself from the shop's own hours and wording. When it does not, the hours come from a published labor guide and the parts come from a live supplier quote, which is what how an estimate gets priced walks through line by line. Mechanica writes those priced job lines onto the repair order from the completed inspection, with the source shown on each one, then stops. Shop supplies, sublet, cores and tax stay on the lines your shop already sets. A person reads the draft, edits it and decides what the customer sees.

The repair order template covers the document this estimate becomes once the customer says yes, and the authorization form covers the signature block in detail. Markup arithmetic behind the parts column lives in the parts matrix template. The rest of the forms are in the shop forms roundup, and the full set is on the guides hub.

Sources

• California Business and Professions Code 9884.9
• California Business and Professions Code 9884.8
• Businessperson's Guide to Federal Warranty Law, Federal Trade Commission
• Automotive Service Technicians and Mechanics, U.S. Bureau of Labor Statistics
• Last verified: July 2026