Bank Statement to QuickBooks for Auto Repair Shops: Convert PDF Statements to QBO

Bank feeds usually reach back only about 90 days, so connect one in spring and most of last year's parts buys, card deposits, and equipment payments never enter your books. The deeper problem is that the feed hands you numbers that do not match the work you did. Card processor deposits arrive net of the merchant fee, so the batch that hits checking is smaller than what customers paid.

It gets worse once a shop management system is in the mix. Tekmetric, Shop-Ware, Mitchell 1, and Shopmonkey settle credit card payments in daily batches that bundle several tickets together. One deposit might cover a brake job, an oil change, and a diagnostic, so the bank line will never equal a single repair order. You have to split the deposit or match it against the day's sales, which importing clean statement data makes far easier than a feed's guesswork does.

Some parts are bought per repair order and go straight onto the car; others sit on the shelf as stocked inventory until a job needs them. A part bought for a specific ticket flows to cost of goods sold when the job closes; stocked inventory stays on the balance sheet until used.

The bigger wrinkle is the supply house. Your jobber account with NAPA, O'Reilly, or WorldPac is billed on statement terms, so you pay it monthly against dozens of individual parts invoices. That single payment does not correspond to one purchase, so the bank line has to be split across jobs or matched to a bill payment you already entered. Lump it into one expense account and you lose the per job cost that tells you whether a repair made money. Here is how to split a bank transaction in QuickBooks.

A core charge is the deposit you pay on a rebuildable part like a starter, alternator, or brake master cylinder. You get it back as a credit when the old core goes back to the supplier. Record it as an asset or a receivable from the vendor rather than an expense, so when the credit returns on a later statement it clears that receivable instead of showing up as income, and neither your cost nor your revenue ends up overstated.

Towing, machine shop work, alignments, and windshield glass all get farmed out to another vendor, then billed back to the customer on your repair order. That is sublet: you pay the vendor and collect from the customer, usually with a markup. Keep sublet in its own income and cost accounts so it does not distort your parts margin, and treat the payment as a cost of sublet, not shop overhead.

Two line items on every ticket need care. Shop supplies charges, the percentage you bill for rags, cleaner, and fasteners, are income. Hazardous waste and tire disposal fees, though, are collected and remitted to a disposal vendor or the state, so they are a pass through liability, not profit. Sales tax is the other split: in most states you charge tax on parts but not on labor, so a single invoice mixes a taxable parts sale, an untaxed labor sale, and the tax you owe.

A warranty reimbursement or vendor rebate has nothing to do with a customer paying for service, so post it to the account that offsets the original cost, not to sales. Fleet and commercial accounts are another special case: you invoice them on net 30 terms, so the work happens weeks before money hits the bank. That is accounts receivable at the time of service, and the deposit later clears the receivable, not new income.

Lifts, alignment racks, and scan tools are often bought on equipment loans, and each monthly payment splits between principal and interest. The principal reduces the loan balance, and only the interest is deductible, so use the amortization schedule to split every payment. Card batches that land a day after the sale often route through undeposited funds.

Here is how common statement lines map to QuickBooks treatment as you review the import.

1. Upload your PDF bank and credit card statements to the converter at the top of this page. Add checking, the shop card, and the processor account together. It accepts PDF and image files.
2. The tool parses every line and reconciles the running balance, keeping the date, description, and amount for each transaction.
3. Download a .qbo file per statement, plus Excel and CSV copies for margin sheets.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In Desktop, go to Banking, then Bank Feeds, then Import Web Connect File.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 transactions or 350 KB per file, so split a long statement if it runs past those limits. To bring in a full prior year, the bulk bank statement to QuickBooks workflow converts many statements together, and you can import old bank statements into QuickBooks that no feed will reach. Bookkeepers handling several shops can use the accountant workflow, or the PDF to QBO converter for one statement.

How do I record core charges in QuickBooks?

Record the core charge as an asset or a receivable from the vendor, not as a parts expense. It is a deposit you get back when the old core returns in rebuildable condition. When the credit lands on a later statement, apply it against that receivable so it clears the balance rather than showing up as income.

What is a core charge on auto parts?

A core charge is a refundable deposit you pay on a rebuildable part such as a starter, alternator, or brake master cylinder. You pay it upfront to encourage returning the old part for remanufacturing. Once you send the old core back in acceptable condition, the supplier refunds the charge as a credit on your account.

How do I use QuickBooks for an auto repair shop?

Set up separate income accounts for parts and labor, add accounts for sublet and shop supplies, and track core charges as receivables. Import each bank and card statement, then categorize parts to cost of goods sold and match card deposits to the day's sales. Reconcile every account monthly against the statement.

How do I categorize auto repair expenses in QuickBooks?

Split parts into cost of goods sold and keep labor as its own income line, then give sublet, shop supplies, and disposal fees dedicated accounts. Post the supply house bill as a bill payment rather than one lump expense. Importing statements to .qbo keeps each line at its date and amount so categorizing is faster.

Should auto repair shops separate parts and labor income?

Yes. Most states tax parts but not labor, so you must split the two to charge and remit sales tax correctly. Separating them also gives you a real parts to labor ratio, which tells you whether the shop is making money on the work itself or leaning on parts markup.

Can I import old bank statements into QuickBooks?

Yes. Manual uploads carry no date limit, unlike bank feeds that reach back only about 90 days. Convert older PDF statements to .qbo files and upload them, which is how most shops backfill a prior tax year or a processor account the feed never touched. Import account by account and reconcile each month.