A parts pricing matrix is a table that sets a different margin for each part cost range: high margin on cheap parts, lower margin on expensive ones. It exists because a flat markup either loses money on a $4 sensor clip or prices you out of a $900 transmission cooler.
Every parts matrix template that ranks for this search sits behind an email form from an accounting firm that wants to sell you a monthly retainer. That’s a strange thing to gate. It’s a table. Here’s the whole table, in the page, with the reasoning.
📥 parts-pricing-matrix-template.xlsx · the grid below as a spreadsheet, plus a one-page PDF version to tape inside the parts room. No form, no email.
Download the parts pricing matrix »
The short version
- A parts matrix sets margin by cost tier, not one markup across everything.
- Cheap parts carry high margin, because ordering, receiving and warrantying a $3 clip costs the same as a $300 alternator.
- Expensive parts carry lower margin, because the dollars are already large and the customer is already shopping.
- Formula: sell price = cost ÷ (1 − target margin). That gives you a multiplier, and the multiplier is what goes on the wall.
- PartsTech surveyed 752 shops in 2025: 51–60% gross margin on parts is the most common band, 58% is the benchmark commonly taught, and 63% of shops come in below it.
- Build the grid, then the exception list. The exception list is what keeps you out of arguments.
Why a flat markup fails
Say you use a flat 1.7x on everything. A $3 O-ring sells for $5.10, and you made $2.10 after someone looked it up, ordered it, received it, stocked it, ticketed it, and agreed to stand behind it if it leaks. Meanwhile a $900 hybrid battery module sells for $1,530, and the customer who’s been calling around finds it for $1,050 down the street and decides you’re a thief.
Same policy, both outcomes. A matrix fixes both by admitting the obvious thing: your cost to handle a part is roughly constant, so your margin percentage has to fall as part cost rises.
If margin-versus-markup arithmetic isn’t second nature yet, read markup vs margin in auto repair pricing first. Getting those backwards is how shops end up at 41% thinking they’re at 58%.
The grid
Copy this. The tiers are a starting structure, not a prediction: where your blend lands depends on your parts mix, which is why the next section is about measuring the blend instead of assuming it. Adjust the tier boundaries for your market, not the structure. Adjust the tiers for your market, not the structure.
| Part cost | Target gross margin | Multiplier | Example cost | Sells for |
|---|---|---|---|---|
| $0.01 – $5.00 | 80% | 5.00× | $3.20 | $16.00 |
| $5.01 – $15.00 | 75% | 4.00× | $12.00 | $48.00 |
| $15.01 – $35.00 | 68% | 3.13× | $28.00 | $87.64 |
| $35.01 – $75.00 | 60% | 2.50× | $60.00 | $150.00 |
| $75.01 – $150.00 | 55% | 2.22× | $110.00 | $244.20 |
| $150.01 – $300.00 | 50% | 2.00× | $220.00 | $440.00 |
| $300.01 – $600.00 | 45% | 1.82× | $450.00 | $819.00 |
| $600.01 – $1,200.00 | 40% | 1.67× | $850.00 | $1,419.50 |
| $1,200.01 and up | 35% | 1.54× | $1,600.00 | $2,464.00 |
The multiplier is derived, not chosen. Multiplier = 1 ÷ (1 − target margin). A 60% target is 1 ÷ 0.40 = 2.50. Pick the margin, let the math give you the multiplier, then price off the multiplier, because multiplying is faster at the counter than dividing.
Round the sell price. $87.64 becomes $87.95 or $89. No quote should look like it came out of a calculator, and rounding up recovers a little of what the tiers give away at the boundaries.
What your blended margin will actually be
This is the part the gated templates don’t explain, and it’s where shops get confused.
The tiers above run from 80% down to 35%. Your blended parts margin will be nowhere near either end. It’s a weighted average, and the weighting is by dollars, not by line count. You might sell 60 cheap parts and 4 expensive ones in a week, but the four expensive ones can be most of the dollars, which drags the blend toward the bottom tiers. That’s why shops that “use a matrix” still come in under target: they check the tiers, not the blend.
Calculate the blend monthly: (total parts revenue − total parts cost) ÷ total parts revenue.
PartsTech’s 2025 survey of 752 shops found 51–60% is the most common gross margin band on parts, that 58% is the benchmark commonly taught, and that 63% of shops land below it. If your blend comes back at 44%, you’re in crowded company, and the cause is nearly always one of three: the big-ticket tiers are too low, discounting off the matrix has become habit, or fleet and wholesale accounts are on a different grid and nobody netted them out.
The exception list
The grid handles almost everything. Write down the exceptions before you need them, because deciding at the counter with a customer watching is how a grid dies.
Tires and batteries. Retail prices are public, and the customer looked them up in the parking lot. Most shops run both on a separate, much thinner grid and make it back on mounting, balancing, and alignment.
Anything with a competitor’s price printed on the internet in bold. Brake pads for common trucks, oil filters, wiper blades. Not because you should match them, but because you should know you’re above them and be ready to say why.
Customer-supplied parts. Different policy entirely. Whatever you decide, write it down and apply it to everyone, including your brother-in-law.
Fleet and wholesale accounts. Usually a flatter, lower grid by contract. Fine, but track them separately or they’ll quietly poison your blend and you’ll re-price everything for retail customers who weren’t the problem.
Special order, non-returnable, and dealer-only. Higher tier or a restocking policy, because you’re carrying real risk.
What happens at the counter when a $12 part shows at $48
Nobody writes about this part, and it’s the only part that actually decides whether the matrix survives contact with your shop.
The grid says a $12.00 part sells for $48.00. The customer sees $48, pulls out their phone, and finds it for $14.99 with free shipping. Now you’re in the conversation.
What doesn’t work: explaining margin. The customer doesn’t care about your margin and shouldn’t be asked to.
What works: price the job, not the part. You sold a working vehicle with a warranty on it: the correct part sourced the first time, in hand that afternoon instead of Thursday, installed, and covered if it fails in four months. The $14.99 online part comes with none of that, and if it’s wrong the customer eats the return shipping and the second appointment.
Three moves that reduce how often this comes up at all:
- Present parts and labor as a job total where you reasonably can. Line-item transparency is good. Line-iteming a $48 clip so the customer can shop it on his phone is not. Both are normal. Know which one you’re doing.
- Have the warranty answer ready in one sentence, in writing on the estimate. “Parts and labor, 24 months or 24,000 miles” ends most of these before they start.
- Never negotiate the grid in the moment. If you move on price, move on the total, once, and note why. A grid you break at the counter isn’t a grid, and your writers will learn within a week that it’s optional.
Shop supplies land on the same estimate and draw the same question: shop supply fees explained.
Building it in 20 minutes
- Pull last month’s parts lines: cost and sell price for each.
- Calculate your current blended margin. (revenue − cost) ÷ revenue. Write it down. That’s your before number.
- Copy the grid into a spreadsheet, with the multiplier column calculated as 1 ÷ (1 − margin).
- Re-price last month’s parts through the new grid and compare totals. Now you know what the change is worth before you inconvenience a single customer.
- Adjust the two tiers that move the most dollars, usually the $150–$600 range.
- Print it, tape it in the parts room, brief whoever writes tickets. Exception list included.
- Re-check the blend in 30 days.
Step 1 goes faster if the parts side is already clean. If you’re doing that on paper, start with our parts inventory spreadsheet for auto repair shops.
What software does and doesn’t do here
Garage doesn’t calculate a parts matrix for you. This is a method and a spreadsheet, and that’s the honest description.
What Garage does is record cost and sell price on every part on every repair order, which is what makes steps 2 and 7 possible at all. On the Premium plan, cost-vs-profit reporting is where you read your actual blended margin instead of estimating it, and the POS and inventory module keeps the cost figure current rather than whatever it was when you last updated a sheet. Without accurate cost data, a matrix is a table of nice intentions.
Frequently asked questions
What is a parts pricing matrix?
A table assigning a different target gross margin to each part cost range, so cheap parts carry a high margin and expensive parts a lower one. It replaces a single flat markup on everything.
What gross margin should I target on parts?
PartsTech’s 2025 survey of 752 shops found 51–60% is the most common band, 58% is the benchmark commonly taught, and 63% of shops fall below it. Your own blended number and its direction over six months matter more than hitting anyone’s target.
How often should I update my parts pricing matrix?
Re-measure the blend every quarter and touch the tier boundaries once a year, or sooner if your supplier costs move sharply. The structure should outlive the numbers: if you built it in percentages, a repricing is one column, not a rebuild. The markup-versus-margin arithmetic behind the multipliers is worked through in markup vs margin in auto repair pricing.
Should tires and batteries go through the matrix?
Usually not. Both have publicly known retail prices, so most shops run them on a separate thinner grid and make their margin on the associated labor instead.
Bottom line
A parts matrix is twenty minutes of setup and it moves real dollars, mostly out of the cheap-parts leak nobody notices. Build the grid, write the exception list, calculate the blend monthly, and don’t negotiate the tiers at the counter.
The number that tells you it’s working is the blended margin, and it only exists if part cost and sell price are on every ticket. Garage records both on every repair order, with cost-vs-profit reporting on the Premium plan.
Seven-day free trial, no credit card, no contract. $39/mo for one user, $69/mo for up to seven.
