CSV to QBO Converter for Auto Repair Shops: Import Shop Management and Bank CSVs into QuickBooks

Rolling the whole ticket into a single income account is the most common setup error in shop books, and it costs you the two ratios the industry actually manages by. Parts gross profit and labor gross profit behave completely differently. Parts margin drifts down when vendor cost increases outrun your matrix. Labor margin drifts down when you discount, when you add a technician, or when warranty and fleet work at a negotiated rate starts to crowd out retail work at your door rate. Those are two different problems with two different fixes, and a combined sales line shows you neither.

Common industry targets sit around 50 to 55 percent gross profit on parts and 65 to 70 percent on labor. You cannot read either one off a profit and loss that carries one income account called Sales. Separate the income accounts, put the matching cost in cost of goods sold rather than in overhead, and both numbers come off the P&L with no side spreadsheet.

Sublet deserves its own pair of accounts for the same reason. An alignment you sent out, a machine shop head job, glass, towing, upholstery: you bill the customer more than you paid, but the margin is thin compared with in house labor. Bury sublet inside parts and a month heavy on farmed out work looks like a parts pricing problem. Break it out and you can see what you actually earn for acting as a middleman, and decide whether it is worth bringing the work in house.

Set up a Sublet Income account and a Sublet Cost account inside cost of goods sold, then record the outside shop's invoice as a bill coded to Sublet Cost and the amount you charge the customer to Sublet Income. If you are on QuickBooks Online Plus or higher you can also mark that bill billable and tag the customer, and the charge will be waiting to add the next time you invoice them. QuickBooks Online Essentials does not include billable expenses, so on Essentials you record the two sides yourself.

The trap is coding the outside invoice straight to Parts COGS or, worse, to an overhead account like Repairs and Maintenance. Repairs and Maintenance is for fixing your own building and equipment. Sublet is cost of sale on a job you billed a customer for. Put it in the wrong place and your gross profit and your overhead percentage are both wrong in opposite directions.

A core charge is a deposit, not a sale. Washington's rule defines core deposits as the amount representing the value of returnable products such as batteries, starters and brakes, added for the purpose of recycling or remanufacturing, and treats them differently from the price of the part itself. The clean treatment is a Core Charges Payable liability account: you credit it when you collect the charge from the customer, and you debit it when the old unit goes back and the vendor credit lands.

The reason this matters beyond tidiness is that QuickBooks has no core return tracking of any kind. Nothing in the software knows that a core is sitting on your shelf, or that a vendor credit you were owed never arrived. If cores run through an income account, an unreturned core just looks like extra sales, and the missing vendor credit never gets chased. A liability account that should return toward zero every month is the only signal you will get.

No. Neither one is revenue. State environmental fees are collected on your customer's behalf and remitted to the state, and core charges are refundable deposits on a part. Both belong in liability accounts. New York charges a $2.50 waste tire management and recycling fee per new tire at retail, it is not subject to sales tax, and it must be separately stated on the customer's invoice, though a tire service with a physical location in the state may retain $0.25 per tire for administrative cost. California runs a separate lead-acid battery fee that an auto repair shop selling replacement batteries at retail must register for, collect and remit to the CDTFA.

The amounts and the rules vary by state, so check your own, but the accounting principle does not vary: money you collect under a state mandate and then pay over is a liability from the moment you take it. Some states treat converting those collected fees to your own use as a criminal matter, not a bookkeeping preference.

Replace the generic default list. A shop's income section needs Labor Income, Parts Income, Sublet Income, Tire and Accessory Sales if you sell them, and Shop Supplies if you bill it as a line. Cost of goods sold needs Parts Cost, Technician Labor Cost, Sublet Cost and Shop Supplies Cost, mirroring the income accounts one for one so every income line has a cost line beneath it. Liabilities need Core Charges Payable, State Tire and Battery Fees Payable, and Sales Tax Payable.

Two decisions cause most of the argument. Technician wages belong in cost of goods sold, not payroll overhead, because they are the direct cost of the labor you sold; leave them in overhead and your labor gross profit is meaningless. Service advisor pay is genuinely debatable and shops split on it, so pick a treatment and stay with it, because switching mid year makes your own year over year comparison useless.

Indirectly. Tekmetric connects to QuickBooks through Accounting Link, which is built by a third-party partner called The Back Office rather than by Tekmetric itself. Accounting Link supports both QuickBooks Desktop and QuickBooks Online, transfers sales, payments and purchases, and lets you choose whether entries post individually or summarized. Shop-Ware, Shopmonkey and AutoLeap offer their own QuickBooks Online syncs. Mitchell 1 is widely used and dependable but has no cloud sync, so its numbers reach the accountant as reports rather than as a feed.

Every one of those paths handles the sales side. None of them handles the bank side, which is where this converter comes in. Your shop management system knows what you invoiced. It does not know what actually cleared your operating account, what the card processor deposited net of fees, when the fleet account finally paid, or what the parts vendor drafted. That reconciliation still runs off bank data, and bank data arrives as CSV.

Because QuickBooks Desktop cannot import a bank CSV in any version. There is no menu item for it, no add-on from Intuit, and no version where it works. Intuit's own Import Excel and CSV toolkit imports exactly four list types: customers, vendors, items and the chart of accounts. It does not import transactions. The only supported way to get transaction data into Desktop is a Web Connect file, through Banking, then Bank Feeds, then Import Web Connect File.

That is the whole reason this tool exists. You upload the CSV your bank, processor or shop system exported, and you get back a real .qbo file with the transactions, dates, amounts and descriptions intact, structured the way Web Connect expects. QuickBooks Online will also take it, which matters if you run one shop on Desktop and another on Online, or if you are mid migration.

Treat it as a receivable from the warranty administrator rather than a customer payment, because the money arrives weeks later and usually arrives smaller than the ticket. Administrators pay a negotiated labor rate that is lower than your posted door rate and often cap or substitute parts. The difference between what you billed and what they approved is a contractual adjustment, and it belongs in a contra revenue account, not written off as bad debt and not quietly deleted from the original invoice.

The same shape applies to fleet and municipal accounts on net 30 or net 45 terms. The work is done today, the deposit lands next month, and the deposit covers several tickets at once. When that lump sum shows up in your bank CSV, matching it back to the right repair orders is the job, and it goes much faster when the original invoices were split into labor, parts and sublet in the first place.

If you carry parts on the shelf and want QuickBooks to track them, yes. Inventory tracking starts at QuickBooks Online Plus; Essentials does not have it, and neither does Simple Start. Plus also brings project profitability and class tracking, which is what you would use to compare two bays, two locations, or retail work against fleet work. QuickBooks Desktop has classes in every edition.

Plenty of shops deliberately do not track parts inventory in QuickBooks and expense parts as purchased instead, relying on the shop management system for what is on the shelf. That is a defensible choice for a shop that stocks little and orders per ticket. It stops being defensible once you are carrying real tire or filter inventory, because then your balance sheet is missing an asset and your monthly margin swings with purchase timing rather than with sales.

Yes, and most independent shops do, but not as the shop management system. QuickBooks has no repair order, no vehicle history, no VIN decoder, no digital inspection and no parts catalog, so it cannot run the front counter. What it does well is be the general ledger: the place where the four pieces of every ticket land in the right accounts, where the bank reconciles, and where the P&L and balance sheet your lender and your CPA want actually come from.

The working split for a well run shop is the shop system as system of record for the work, QuickBooks as system of record for the money, and a defined bridge between them. This converter is the bank side of that bridge for any shop whose accounting sits on Desktop, or whose bank exports a CSV format QuickBooks Online rejects.

Export the month from your operating account and your card processor as CSV. Upload both here and download the .qbo files. Import them through Bank Feeds on Desktop or the upload screen on QuickBooks Online, match the deposits to the invoices your shop system already produced, and reconcile. What is left over at the end is the useful part: the parts vendor drafts you did not expect, the fleet payment that covered eleven tickets, the core credits that finally arrived, and the processor fees that never appeared on any invoice.

Watch three accounts as you close. Core Charges Payable should trend toward zero as cores go back, and a balance that only grows means cores are sitting on your shelf or credits are not being claimed. State fee liabilities should clear when you file. Undeposited Funds should empty every time a batch lands, and a pile there is the classic sign that customer payments and bank deposits are being recorded twice.

Class tracking is how you keep two or three locations in one company file without three sets of books. Tag every income and cost line with a location class and QuickBooks will produce a profit and loss by class, so you can see that shop two's labor margin is six points behind shop one before it becomes a year end surprise. On QuickBooks Online this needs Plus; on Desktop it is available in every edition.

Bank CSVs convert the same way regardless. Convert each account's export separately, import each into its own QuickBooks bank account, and let the class tags on the transactions carry the location detail.

It reads .csv, .txt, .xls, .xlsx and .xlsm, which covers what banks, card processors and shop management systems actually export. It writes .qbo for Web Connect, plus .ofx, .qfx, .xlsx, .csv and .json if you need the data somewhere other than QuickBooks. Column order does not need to be fixed in advance, since dates, descriptions, amounts and separate debit and credit columns are all detected on upload.