How should an auto repair shop set up its chart of accounts in QuickBooks Online?

Separate income by how the shop actually earns it — labor, parts, sublet, tires, diagnostics, and shop supplies or fees — and mirror each one with its own cost of goods sold account. That parallel structure lets QuickBooks show gross profit by category instead of only for the shop as a whole.

Why can't my QuickBooks reports show whether parts or labor is more profitable?

Usually because all revenue lands in one Sales income account and the related costs sit in a single general expense line. Without income and cost separated in parallel, margin by category stays invisible — it's a chart-of-accounts structure problem, not a QuickBooks limitation.

How do I get my shop management system to tie out with QuickBooks Online?

Align the QuickBooks chart of accounts with the categories your shop system — such as Tekmetric, Mitchell 1, or Shopmonkey — pushes over. When the accounts match how the shop system summarizes sales and payments, month-end reconciles cleanly instead of turning into detective work.

QuickBooks for Auto Repair Shops: Building a Chart of Accounts That Actually Tracks Parts, Labor, and RO Profit

Mary Davis
2 days ago
4 min read

Auto repair technician working on a vehicle in a service bay

Most auto repair shops running QuickBooks Online have a chart of accounts that fights them. It was either accepted straight out of the box when the file was created, or it grew one account at a time as the shop needed somewhere to put a transaction — and now it can tell you roughly how much money came in and went out, but it can't answer the questions that actually run a shop. Which is more profitable, parts or labor? What's your true effective labor rate after discounts and comebacks? Are your parts marking up the way your shop management system says they should?

Those aren't accounting curiosities. They're the numbers that tell you whether the shop is healthy. And the reason so many QuickBooks files can't produce them isn't the software — it's the chart of accounts underneath it. Build that correctly, and QuickBooks becomes a reporting tool that actually reflects how a repair shop makes money. Leave it generic, and you're flying on a dashboard with half the gauges missing.

Start by separating income the way a shop actually earns it

The single most common problem we see is a shop that books everything into one big "Sales" or "Services" income account. Every repair order, every tire, every diagnostic fee, all of it landing in one bucket. That bucket will match your bank deposits, so it feels correct — but it makes it impossible to see where the money actually comes from.

A repair shop earns money in genuinely different ways, and the income side of the chart of accounts should reflect that: labor, parts, sublet work, tires, diagnostics and inspections, and shop supplies or fees. When those are separate income accounts, you can finally see the mix — and the mix is where the insight lives. Two shops with identical total revenue can be in completely different financial health depending on whether that revenue leans on high-margin labor or on lower-margin parts and tires.

Match every income account with its cost, or margin stays invisible

Separating income is only half the structure. The other half is separating the cost of that income the same way. This is where most files fall apart. If parts income sits in one account but the cost of those parts is buried in a general "supplies" or "cost of goods" line mixed with everything else, you can never calculate parts margin — and parts margin is one of the most important numbers in the shop.

The fix is a cost of goods sold section that mirrors your income section: cost of parts, cost of labor (if you're allocating technician wages to jobs), cost of sublet, cost of tires. When income and cost are structured in parallel, QuickBooks can show you gross profit by category, not just for the shop as a whole. That's the difference between knowing you made money last month and knowing your parts are quietly underperforming while labor carries the whole operation.

The numbers a correct structure unlocks

Once income and cost are split properly, the reports that matter start falling out of the file almost for free. Gross profit per repair order becomes visible. Your effective labor rate — what you actually realized per billed hour after discounts, warranty work, and comebacks — becomes something you can track instead of guess. Parts margin can be compared against the target your shop management system assumes. And you can watch these trend over time, which is where you catch a problem while it's still small: a slipping labor rate, a parts margin that's eroding because pricing hasn't kept up with supplier increases.

This is also exactly the layer that shop owners lose when they DIY their bookkeeping. It's not that they can't reconcile a bank account — it's that a generic chart of accounts never gave them the structure to see profitability by category in the first place. The data was in the shop the whole time; the books just weren't built to surface it.

The shop management system connection

Most shops run a system like Tekmetric, Mitchell 1, or Shopmonkey alongside QuickBooks, and that integration only works as well as the chart of accounts it points into. These systems typically push summarized sales and payment data into QuickBooks, and if the accounts on the QuickBooks side don't align with the categories coming out of the shop system, the numbers drift — sales that don't tie out, payments that don't match deposits, and a monthly reconciliation that turns into detective work.

Getting the QuickBooks chart of accounts to mirror how the shop management system categorizes work is what makes the two systems agree. When they agree, month-end close is fast and the reports are trustworthy. When they don't, you get the all-too-familiar situation where the shop system says one thing, QuickBooks says another, and nobody's sure which to believe.

If the structure is already wrong, restructuring comes first

If you're reading this and recognizing your own file — one income account doing all the work, costs you can't separate, a shop system that never quite ties out — the fix isn't to start tracking new numbers on top of a broken structure. It's to rebuild the structure first, then reconcile the history into it so your past and future reports are consistent.

That's the heart of an auto repair bookkeeping cleanup: restructuring the chart of accounts around how a shop actually earns and spends, correcting and reconciling the history, and aligning QuickBooks with the shop management system so the two finally speak the same language. The result is a file that answers the questions an owner actually asks, instead of one that only balances the checkbook.

If your books can't tell you whether parts or labor is carrying the shop, that's a structure problem worth fixing. Book a free discovery call and we'll take a look.

Mary E. Davis, C.P.B. holds Advanced QBO ProAdvisor certification and 20+ years of bookkeeping experience, with a background as an ASE Certified Parts Specialist.