Bank Statement to QuickBooks for HVAC and Plumbing Contractors: Convert PDF Statements to QBO

A trade shop runs several accounts at once: operating checking, one or more fuel cards, a supply house card, and often an equipment loan. The QuickBooks bank feed usually reaches back only about 90 days and skips loan accounts and store cards, so if you connect it in spring, most of last year's parts and fuel spend never arrives. The feed also imports transactions exactly as the bank labels them, which is where trade accounting breaks. A single $8,400 payment to a supply house covers dozens of invoices, and a field service payout lands net of processing fees, and the feed cannot split either one. Converting the PDF statement gives you every line with its date and amount, and manual uploads carry no date limit, so you can backfill a whole prior year or a card the feed never touched.

Most HVAC and plumbing shops collect card payments through ServiceTitan, Housecall Pro, or Jobber. The processor keeps its cut and deposits the rest, so a customer who paid $600 might show as a $582.60 deposit after a roughly 2.9 percent fee. If you record only the net, your revenue is understated and the fee never hits an expense account. Book the gross sale, then record the merchant fee as its own expense line so both stay accurate. See how to record credit card processing fees in QuickBooks and how Undeposited Funds holds payments until the deposit clears.

Ferguson, Grainger, Winsupply, and your local supply house usually run on 30-day terms. You pull parts all month, they invoice, and you pay one lump total that shows on the bank statement as a single payment covering many jobs. Enter the vendor bill with the invoice detail as parts arrive, then apply the lump bank payment against those bills at reconcile time. The Excel copy from your conversion helps here: sort the supply house lines and confirm the total matches the statement before you post.

Trade contractors carry parts two ways. Truck stock is the fittings, capacitors, and copper riding on every van, held as inventory until a tech installs it. A condenser bought for one install is usually expensed straight to that job as cost of goods sold. Most service shops do not track every fitting as inventory because the overhead outweighs the value, so they expense parts as non-inventory items when purchased. If you do keep warehouse stock, purchases add to an inventory asset and only move to cost of goods sold when the part is used.

Fuel cards should map to vehicle expense, and shops running several trucks track fuel per truck to see which van costs most to run. Permit and inspection fees are a direct cost of the job that pulled them, so tag them there rather than to overhead. When a plumber subs out excavation, those payments are 1099-NEC work: pay $600 or more by check or ACH in a year and you owe the sub a 1099. Collect a W-9 first and flag the vendor for 1099 tracking, since card and app payments are reported by the processor instead. Our construction bookkeeping page covers AIA billing and retainage in more depth.

Maintenance agreements and service plans are money collected up front for visits you have not made yet. That is unearned revenue, a liability, recognized as income as each seasonal visit happens, rather than booked in full on day one. Warranty callbacks are the opposite problem: a return trip on a unit you already installed generates cost with no new revenue, so track it against the original job to see real install margin. Equipment financing payments split principal from interest, since only the interest is an expense while the principal reduces the loan balance. Customer deposits on an install are also a liability until the job is billed.

Here is how a trade contractor's statement lines map to QuickBooks treatment as you review each one.

1. Upload your PDF bank and credit card statements to the converter at the top of this page. You can drop in several accounts at once, including fuel and supply house cards. 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 splitting lump supplier payments.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks 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. Shops closing out a full year across several cards can save time with bulk bank statement to QuickBooks conversion, and firms handling several trade clients may prefer the accountant workflow. To bring in prior years, see how to import old bank statements into QuickBooks.

How do I set up QuickBooks for an HVAC business?

Start by rebuilding the chart of accounts to match how an HVAC shop earns and spends: service revenue, install revenue, and maintenance plan revenue on the income side, then parts, equipment, and subcontractor labor as cost of goods sold. Add per-truck vehicle expense and keep true overhead separate. Then import your statements so real transactions post to those accounts.

How do I record parts used for services?

Record parts as non-inventory items expensed to the job when you buy them for a specific service call, which is what most trade shops do. If you keep warehouse truck stock, set those parts up as inventory items so purchases hit an inventory asset and only move to cost of goods sold when a technician installs the part on a job.

Is QuickBooks good for plumbers?

Yes. QuickBooks handles a plumbing company's books, job costing, expense tracking, and 1099s, and it connects to field service tools like ServiceTitan, Housecall Pro, and Jobber. It is not dispatch or scheduling software, so most plumbers pair it with a field service platform that pushes invoices and payments into QuickBooks for the accounting side.

How do I record the purchase of a service agreement?

Record the up-front payment as unearned revenue, a liability, rather than income all at once. Set up a maintenance plan service item mapped to that liability account, then recognize the revenue in pieces as each seasonal visit is performed. This keeps a prepaid annual plan from inflating one month and shows your recurring revenue accurately over the year.

How do I record credit card processing fees in QuickBooks?

Book the full sale amount as income, then enter the processor's fee as a negative line or a separate expense so the deposit matches your bank. On a bank deposit, add a line under Add funds to this deposit, pick a merchant fees expense account, and enter the fee as a negative amount so the net matches what actually hit checking.

How do I categorize fuel expenses in QuickBooks?

Categorize fuel under a vehicle or Car and Truck expense account and mark it as business. Shops running several trucks often add a fuel sub-account or use classes to track spend per truck, which shows which van costs the most to run. Convert your fuel card statements first so every charge imports with its date and amount.