Recalculate and compare a car-repair estimate total

The short answer

To check a repair estimate, add up the parts, labor and fees. Subtract any discounts, then add tax: Total = Parts + Labor + Fees − Discounts + Tax. Subtract the shop's written total from your result. A difference of zero means the arithmetic agrees. Any other result is a mismatch you should reconcile with the shop. The worksheet shows that a difference exists, but it cannot tell you which line is wrong.

Two terms matter here. A line item is one charge on the estimate, such as a part, a block of labor or a fee. The taxable base is the portion of the estimate that tax is calculated on. The base can differ from the full subtotal, so the tax step is where most recalculations go wrong.

What to collect from the written estimate

• Currency used on the estimate
• Each parts line: either the line amount, or the quantity and unit price
• Each labor line: either the line amount, or the hours and hourly rate
• Each fee, such as shop supplies, disposal or diagnostic charges
• Each discount, coupon or credit, entered as a positive amount
• Tax: either the dollar amount shown, or the rate and the charges it applies to
• The written estimate total

Enter each line only one way. If an estimate shows "2 × $120.00 = $240.00," use either the $240.00 line amount or the quantity times the unit price. Using both counts the part twice. Labor billed by the hour works the same way: hours multiplied by the hourly rate.

A worksheet you can copy, print or save as PDF

The layout below works on paper, in a spreadsheet, or printed to PDF from any spreadsheet or word processor. Leave a cell marked UNKNOWN when the estimate doesn't show an amount. Write 0.00 only when the estimate confirms there is no charge.

Section	Line description	Qty or hours	Unit price or rate	Line amount	Status
Parts					entered / unknown
Labor					entered / unknown
Fees					entered / confirmed zero / unknown
Discounts					entered / confirmed zero / unknown
Tax	Mode: amount or rate	Taxable base:	Rate %:		entered / calculated / unresolved
Calculated total
Written estimate total
Difference (calculated − written)

The calculation, step by step

• 1. Parts (P): add every parts line.
• 2. Labor (L): add every labor line. For hourly lines, multiply hours by rate first.
• 3. Fees (F): add every fee.
• 4. Discounts (D): add every discount as a positive number. You subtract the total in step 6.
• 5. Tax (T): use the tax amount printed on the estimate. Or, if you know both the rate and which charges are taxed, calculate T = taxable base × rate ÷ 100.
• 6. Total = P + L + F − D + T.
• 7. Difference = calculated total − written total.

Pick one rounding rule and write it on the worksheet. For example, round each calculated line to two decimal places before adding. Shops may round per line or only at the end, and either approach can produce a difference of a cent or two.

Spreadsheet formulas for the same logic, with each section in its own column range:

Labor line amount:   =ROUND(hours * rate, 2)
Parts line amount:   =ROUND(qty * unit_price, 2)
P:                   =SUM(parts_line_amounts)
L:                   =SUM(labor_line_amounts)
F:                   =SUM(fee_amounts)
D:                   =SUM(discount_amounts)
T (rate mode):       =ROUND(taxable_base * rate_percent / 100, 2)
Calculated total:    =P + L + F - D + T
Difference:          =calculated_total - written_total

Worked example (hypothetical figures)

Suppose an estimate lists parts of $240.00, one labor line of 1.5 hours at $120.00 per hour ($180.00), fees of $20.00, a $15.00 discount, and a printed tax amount of $29.75. The written total is $459.75.

P = 240.00
L = 1.5 × 120.00 = 180.00
F = 20.00
D = 15.00
T = 29.75 (entered from estimate)

Total      = 240.00 + 180.00 + 20.00 − 15.00 + 29.75 = 454.75
Written    = 459.75
Difference = 454.75 − 459.75 = −5.00

The recalculated total is $5.00 lower than the written total. That points to something to reconcile. Possible causes include a fee not printed as its own line, a discount applied differently, or a line that was added. The arithmetic alone doesn't show which one it is.

Handling tax correctly

Use only one tax method for each tax charge. Either copy the tax amount the estimate shows, or calculate it from a rate and a taxable base you have confirmed. Never do both for the same charge.

In rate mode, write down exactly what the base includes. Note whether it covers parts only, or parts plus labor, and whether fees count. Also note whether the discount was subtracted before tax was figured.

As an illustration only, if the taxed base were $240.00 of parts at a 7% rate, tax would be 240.00 × 7 ÷ 100 = $16.80. The rate and base in this illustration are made up.

Whether labor, fees or discounts affect the taxable base depends on the state and sometimes the locality. This changes the result, so confirm the base with the shop or your state revenue agency rather than assuming. If you have neither a printed tax amount nor a confirmed rate and base, mark tax as unresolved. In that case, compare the pre-tax subtotal only.

Reconciling a difference

• Check that no amount is marked unknown. A missing line counted as zero makes your total look low.
• Confirm that no part was entered both as a line amount and as quantity × unit price.
• Check whether a fee, such as shop supplies, is already included in a parts or labor line.
• Check whether the printed tax already covers a charge you listed separately.
• Compare discount handling: before or after tax, flat amount or percentage, and which lines it applies to.
• Compare your rounding rule with the shop's. Differences of a few cents usually come from rounding.
• Recheck hours × rate on each labor line against the printed line amount.

If a difference remains after these checks, ask the shop to walk through the line that accounts for it. A specific question works better than a general one. For example: "My subtotal before tax is $425.00. Which charge makes up the extra $5.00?"

Comparing estimates from two shops

Run each estimate through the same worksheet, but compare totals only after confirming the shops quoted the same job. Check these points:

• The repair scope, meaning the same parts replaced and the same work performed
• The part type: OEM (made by or for the vehicle manufacturer), aftermarket (from another manufacturer), or used/remanufactured
• The labor hours quoted and the hourly rate
• Which fees appear, and whether a fee shows up separately on one estimate and inside a line on the other
• How tax was applied and to which charges
• Whether any unknown or unresolved amounts remain on either worksheet

A lower total isn't the better quote if it covers fewer parts, uses a different part type, or leaves tax or fees unresolved. When the scopes match and both worksheets are complete, the side-by-side difference in each section shows where the price gap comes from. That gives you a concrete question to bring to either shop.