How to Track Parts Costs in QuickBooks for Repair Shops

Most repair shop owners can tell you what they charge for a part. Very few can tell you what that part actually costs them — landed, with freight, after returns and credits. The result is that margin calculations are based on gut feeling, not data. And gut feeling is usually wrong by 10-20 points.

If you use QuickBooks Online for your books, you already have the tools to track parts costs properly. The problem is that almost nobody sets it up correctly from the start.

Why Your Parts Margins Are Probably Wrong

Here is a common scenario. You buy a replacement armature for a Makita HR2475 rotary hammer. Your supplier charges $38. You charge the customer $62. That is a 63% markup, or a 39% gross margin. Solid, right?

But that $38 does not tell the whole story. You paid $14.50 in shipping on a small order. The first unit arrived defective, so you ate the return shipping. Your actual landed cost on the working part was closer to $58. Your real margin on that job was 6%.

This is not an edge case. It happens constantly in shops that do not track cost of goods sold at the line-item level. You think you are making 35-40% on parts. Your P&L at year-end says 18%. The gap is all the costs you never recorded.

Setting Up Cost of Goods Sold in QuickBooks

COGS is the account that captures what you paid for the parts you sold. It is not the same as your purchases account — COGS only counts parts that went out the door on a repair, not parts sitting on your shelf.

To set this up in QuickBooks Online:

1. Go to Chart of Accounts and create an expense account called "Cost of Goods Sold — Parts" (type: Cost of Goods Sold).
2. If you want more granularity, create sub-accounts: "COGS — OEM Parts," "COGS — Aftermarket Parts," "COGS — Supplies and Materials."
3. Every product or service item in QuickBooks that represents a part should have this account assigned in the "Expense" field.

When you create an invoice with a part on it, QuickBooks records the revenue in your income account and the cost in your COGS account. Your gross profit on parts shows up automatically on your Profit & Loss report.

Without this setup, parts costs land in a generic expense account and your P&L shows labor and parts revenue as a single blob with no way to calculate margins.

Inventory Items vs. Non-Inventory Items

QuickBooks Online gives you two choices for parts: inventory items and non-inventory items. This is where most repair shops make the wrong call.

Inventory items track quantity on hand, cost basis, and value. QuickBooks adjusts the asset value when you purchase and sells down the cost when you invoice. This is proper accrual-based inventory accounting.

Non-inventory items have a cost field but do not track quantity. You record a cost when you set up the item, but QuickBooks does not adjust it based on actual purchases.

For most repair shops, non-inventory items are the better choice for the majority of parts. Here is why:

• Repair parts have high variety and low volume. You might stock 200 different parts but only keep 2-3 of each on hand.
• Full inventory tracking in QuickBooks requires receiving purchase orders, which adds overhead that most shops will not sustain.
• If you use shop management software (like Bench), inventory tracking belongs there — not in your accounting system. (For more on physical inventory management, see our guide on managing parts inventory.)

Use inventory items only for high-volume, high-value parts where you need QuickBooks to track the asset value for your balance sheet. Think screen assemblies if you do phone repair (buying 50+ per month at $45 each), or common small engine carburetors if you service outdoor equipment at volume.

Everything else — the one-off armatures, brushes, capacitors, belts, switches, gaskets — should be non-inventory items with an accurate cost field.

Tracking Markup and Margins

Once your items have costs assigned, you can run two reports in QuickBooks that will change how you think about your parts business.

Sales by Product/Service Summary shows revenue by item. Filter by date range and you can see which parts generate the most income.

Profit and Loss by Item (or the Gross Profit report) shows revenue minus COGS. This is where you find out that the $62 armature you thought was a 39% margin is actually running at 22% after you account for all the costs.

The numbers that matter:

• Markup percentage = (Sale price - Cost) / Cost. If a part costs $38 and you sell it for $62, markup is 63%.
• Gross margin percentage = (Sale price - Cost) / Sale price. Same part, margin is 39%.

Your accountant cares about margin. Your purchasing decisions should be based on markup. Track both.

A healthy repair shop targets 40-50% markup on common parts and 75-100%+ on small consumables (screws, adhesives, thermal paste, filters). If you are below 30% markup on anything, you are probably losing money on that part after you account for freight, handling, and the occasional defect. For industry-specific markup benchmarks, see our guides on power tool repair pricing, small engine repair pricing, and phone screen repair pricing.

Handling Cores, Returns, and Defective Parts

Repair shops deal with parts issues that a typical retail business does not. QuickBooks can handle all of them, but you have to record them.

Core charges. Some suppliers charge a core deposit on alternators, starters, compressors, and similar rebuildable parts. You pay $15 extra when you buy the part and get it back when you return the old core. In QuickBooks, record the core charge as a separate line item on the purchase. When you get the credit back, record a vendor credit. If you do not track this, your COGS is inflated by the core charges you never recouped.

Defective parts. When a part arrives dead on arrival or fails within warranty, you need a vendor credit or replacement. Record the credit in QuickBooks against the original purchase. If you just eat the loss and order a new one, your COGS on that job doubles and your margin report is a mess.

Customer returns. When a customer returns a repair (and the part), issue a credit memo in QuickBooks. This reverses both the revenue and the COGS, keeping your margins accurate.

The discipline here is simple: every parts transaction needs a matching entry in QuickBooks. Purchase, credit, return — they all need to be recorded or your numbers drift.

Supplier Credits and Price Breaks

Suppliers offer volume discounts, early-payment discounts, and periodic credits. These affect your actual cost basis and should be reflected in QuickBooks.

If your electronics supplier gives you 2% net-10 terms and you pay within 10 days, that 2% discount reduces your parts cost. Record it. On a $500 monthly parts spend, that is $10/month or $120/year. Small, but it adds up across all suppliers.

Volume rebates are trickier. If a supplier sends you a quarterly rebate check based on total purchases, record it as a vendor credit allocated against COGS. Do not record it as "other income" — it is a cost reduction, not new revenue.

When to Use QuickBooks Inventory vs. Shop Software Inventory

This is the question that confuses most repair shop owners who use both a shop management system and QuickBooks.

The short answer: your shop software tracks physical inventory. QuickBooks tracks the financial value.

Your shop system needs to know that you have 3 Briggs & Stratton 799866 carburetors on the shelf so your tech can grab one for a job. QuickBooks needs to know that you spent $87 on carburetors this month and sold $214 worth. These are different problems.

Trying to use QuickBooks as your physical inventory system means your techs are updating accounting software every time they pull a part from a bin. That will not happen. Trying to use your shop software as your financial system means you are reconciling bank statements in a tool that was not built for it. That will not work either.

Let each system do what it is good at. Sync the financial data (invoices, payments, COGS) to QuickBooks. Keep the physical counts, bin locations, and reorder alerts in your shop software.

Common Mistakes

Not recording freight costs. If you pay $12 shipping on a $30 part, your actual cost is $42. Either add freight to the item cost or track it in a separate "Freight — Parts" expense account. Do not let it disappear into a general shipping line.

Using the same item for different cost levels. If you buy the same capacitor from two suppliers at different prices, your average cost in QuickBooks drifts. Create separate items per supplier, or update the cost field each time you purchase. QuickBooks Online uses FIFO (first in, first out) for inventory items, which handles this automatically — but only if you are using inventory items with purchase orders.

Never updating cost fields. Supplier prices change. That brush set that cost $6.50 last year is $8.25 now. If your QuickBooks item still says $6.50, every margin report you run is wrong. Review and update costs quarterly at minimum.

Mixing parts revenue with labor revenue. If all your income goes to one account, you cannot calculate parts margins separately from labor margins. Use distinct income accounts and distinct COGS accounts for parts vs. labor. Getting your labor pricing right is just as important as getting your parts margins right — both need to be tracked separately to see where your profit actually comes from. For niche-specific chart-of-accounts examples, see our guides for small engine repair shops, electronics repair shops, and appliance repair businesses.

How Bench Syncs Parts Costs to QuickBooks

Bench connects directly to QuickBooks Online and syncs invoices with line-item detail. When a technician closes out a repair, the invoice flows to QuickBooks with parts and labor separated into the correct income accounts. The cost field on each part is pulled from your Bench parts catalog, so COGS is recorded automatically.

Supplier credits, warranty replacements, and voided invoices all sync as well. You do not have to touch QuickBooks for day-to-day operations — just review the reports your accountant needs.

The result is that your P&L shows real gross margins on parts, broken out by category if you want it. No double-entry. No guessing. No finding out at tax time that your parts margins were half of what you assumed.

If you are currently entering invoices into QuickBooks by hand, or if your parts costs are a black box, the fix is not complicated. Set up your COGS accounts, assign costs to your items, and keep them updated. Or let your shop software handle it for you. If you want to automate the invoice-to-QuickBooks flow entirely, see our guide on integrating your repair shop software with QuickBooks.