Is a QuickBooks sync one-way or two-way?

It depends on the software and the record. Ask which records go which way. In MetaFleet, invoices, bills and purchase orders go to QuickBooks and payments sync both ways.

How do I avoid duplicate customers?

Clean up QuickBooks first and match each shop customer to an existing record before the first sync.

Who should check sync errors?

Assign one person to review them daily.

How to Sync a Repair Shop with QuickBooks Online

Not sure you need both systems? See QuickBooks vs shop management software.

Why sync matters

Most truck shops keep their books in accounting software and run jobs somewhere else. When the two are not connected, someone retypes every invoice, payment and bill. That takes hours, causes errors and means the books are always behind. A good sync moves records automatically and flags anything that does not match.

This guide is about QuickBooks Online, which many shops use. The same ideas apply to other accounting systems. See truck repair software for QuickBooks.

What usually syncs

Ask any shop software vendor exactly which records sync and in which direction. Typical records:

Customers. Billing name, address, terms.
Vendors. Parts suppliers.
Items. Parts and labor items with income and expense accounts.
Invoices. From the shop system to accounting.
Payments. Card, ACH, check and cash.
Bills and purchase orders. For parts bought.

One-way and two-way

"Integrates with QuickBooks" can mean very different things:

One-way export. The shop system sends invoices to accounting. Changes in accounting do not come back.
Two-way sync. Some records move in both directions, such as payments recorded in either system.
Manual export. A file you download and import yourself.

Ask which records go which way, how often, and what happens on a conflict. Ask to see a live sync on the demo, not a slide.

Step 1: Decide the source of truth

For each record type, decide which system owns it:

Invoices are usually created in the shop system and sent to accounting.
Payments may be recorded in either place, so two-way sync matters.
The chart of accounts lives in accounting.
Parts may start in accounting and be pulled into the shop system, or the other way round.

Write these choices down so the office and the bookkeeper agree.

Step 2: Clean up QuickBooks first

Before connecting, clean the accounting side:

Merge duplicate customers and vendors.
Make customer names match how the shop knows them.
Review items: one item per part or labor type, with the right accounts.
Check sales tax settings.
Close out old open invoices that will never be paid. See IRS topic 453 on bad debt and talk to your accountant.

Step 3: Match customers and vendors

The first sync is where duplicates are born. A good process matches each shop customer to an existing QuickBooks customer, with a person confirming each match, instead of creating new ones. Do the same for vendors.

Step 4: Map items and accounts

Map labor, parts, fees, mileage, service call fees, core charges and shop supplies to the right income accounts. Map parts cost to the right expense or cost of goods account. If you track inventory in accounting, decide how parts usage reaches it. Ask your accountant to review the mapping once.

Step 5: Test

Before going live:

Create a test invoice with labor, parts, a fee and tax.
Sync it and check every line in QuickBooks.
Record a card payment and a check payment.
Check that both reach QuickBooks and the invoice shows as paid.
Create a purchase order or bill and check it.

Fix the mapping until everything matches.

Step 6: Watch the errors

No sync is perfect. A customer gets renamed, an item is deleted, a tax rate changes. A good sync flags mismatches and retries them instead of failing quietly. Assign one person to check sync errors daily. A small error fixed the same day is easy. A month of errors is a project.

Payments and fees

If you take card or ACH payments, decide how processing fees are recorded. Some shops record the gross payment and a separate fee expense. Others record the net deposit. Agree with your accountant and set up the sync to match. Payments that sync both ways help the books show what is really paid.

Bills from parts receipts

Parts bought at a counter often arrive as a paper receipt in a technician's pocket. If the receipt becomes a purchase order or bill in the shop system, the sync can carry it to QuickBooks, and the part can reach the customer's invoice. Without that step, the cost reaches the books late and the part may never be billed.

Month-end checklist

All invoices in the shop system appear in QuickBooks.
All payments match the bank deposits.
No open sync errors.
Accounts receivable aging matches in both systems.
Parts bills and purchase orders are entered.
Customers on Net 30 or other terms have statements sent. See statement billing.

Example: one road call through the books

Example only. This is an illustration, not real data.

A technician finishes a road call. The office approves the invoice in the shop system, and it syncs to QuickBooks with labor, parts and a service call fee on separate lines. The customer pays by card from a link. The payment syncs to QuickBooks and the invoice shows as paid. The parts used were bought on a purchase order earlier in the week, which already reached QuickBooks as a bill. Nobody retyped anything.

Sales tax

Sales tax on parts and labor varies by state and sometimes by customer. Exempt customers need their status on file. Make sure the shop system and QuickBooks agree on tax rates and on which customers are exempt, and test a taxable and an exempt invoice before going live. Ask your accountant how tax should be set up for your state.

Signs your sync is not working

The bookkeeper is still typing invoices.
Customers appear twice in QuickBooks.
Paid invoices show as open in one system.
Deposits do not match recorded payments.
Nobody knows when the last sync error was fixed.

If you see any of these, stop and fix the mapping or matching before more records pile up. Most problems trace back to a skipped cleanup step or a record created by hand in the wrong system.

Who does what

A sync works best when roles are clear:

Office staff create and send invoices in the shop system and record payments taken there.
The bookkeeper works in QuickBooks: reconciles bank deposits, reviews reports and handles bills.
One named person checks sync errors every day.
The accountant reviews account mapping and tax setup once, and again if things change.

Avoid having the office and the bookkeeper both enter the same invoice or payment by hand. That is how double payments and duplicate invoices appear.

When to sync parts

Shops differ on where the parts catalog lives. If your parts list is already in QuickBooks, pulling it into the shop system saves setup time. If you change parts often in the shop system, decide how those changes reach accounting. Either way, keep one list as the master. See parts markup.

Common mistakes

Connecting before cleaning up duplicates.
Letting the sync create new customers instead of matching.
Mapping every item to one income account.
Ignoring sync errors until month end.
Recording payments in both systems by hand.
Assuming "integrates" means two-way.

How MetaFleet helps

MetaFleet connects to QuickBooks Online. Invoices, bills and purchase orders go from MetaFleet to QuickBooks. Payments sync both ways. Customers and vendors are matched to your existing QuickBooks records with you confirming each match, and your parts catalog can be pulled in from QuickBooks. Mismatches are flagged and retried. Card and ACH payments run through Stripe. See QuickBooks sync and payments. Get a walkthrough.