PDF Bank Statement to QuickBooks for Used Car Dealers: Convert Auto Dealer Statements to QBO

An independent used car dealer draws on a floor plan line to buy inventory, pays off each unit when it sells, collects down payments and sales tax, and takes funding checks from finance companies. That mix does not feed QuickBooks cleanly from a long PDF, and auction and floor plan portals rarely offer a real bank feed. PDFQBO converts each statement into a QuickBooks QBO file so every draw, curtailment, deposit, and fee reaches your books with the right date and amount, ready to tie to a specific vehicle.

Quick answer

To get an auto dealer bank statement into QuickBooks, convert the PDF to a QBO file first. Upload the operating account or floor plan statement to PDFQBO, review the vehicle purchases, floor plan draws and payoffs, down payments, and sales tax it reads, and download a QBO (Web Connect) file. Then import that file into QuickBooks Online or Desktop and code each line, holding cars as inventory until sold and floor plan advances as a liability. The same works for an auction or BHPH servicer statement that never connects to a bank feed.

Floor plan draws and payoffs Inventory and per-unit cost Review before import

Last updated July 2026

Convert a dealer statement to QBO

Upload an operating or floor plan PDF and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Any account

Operating, floor plan, servicer

QBO + IIF

Online and Desktop

Per-unit

Tie draws to inventory

Auto delete

Files removed after use

How to convert an auto dealer statement to QuickBooks

Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether it came from your operating account, a floor plan line like NextGear or Westlake Flooring, or an auction platform.

Gather the PDFs

Download the monthly statement from the operating account, the floor plan portal statement showing draws and curtailment payments, and any BHPH servicer or auction account you run. Floor plan and auction statements rarely connect to a QuickBooks bank feed with line detail.

Upload to the converter

Drag the statements into the tool above. A busy month with several auction purchases, floor plan draws, unit payoffs, and a stack of down payments converts as easily as a quiet one, and you can upload several months at once.

Review the transactions

PDFQBO reads the date, description, and amount on each line and keeps deposits and payments on the correct side. Check the table, confirm the vehicle purchases, floor plan activity, down payments, and fees, then export a QBO or IIF file.

Import and categorize

Upload the QBO file from the Banking screen in QuickBooks Online, or import the Web Connect or IIF file in Desktop. Then post car purchases to inventory, floor plan draws and payoffs to the flooring liability, and sales tax to what you owe the state.

Why used car dealer books are hard to get into QuickBooks

Floor plan draws and payoffs must tie to a vehicle

A flooring line like NextGear, Westlake Flooring, or a bank line lets you draw to buy a car and pay off that unit's advance when it sells. The statement shows draws going out and curtailment or payoff payments coming through, and each one belongs to a specific vehicle in inventory. Expensing those payments is wrong; a draw increases the flooring liability and buys an asset, and a payoff pays the liability down. Converting the statement gets every draw and curtailment in with its date so you can match it to the right unit instead of guessing at month end.

A car you buy is inventory, not an expense

When you buy a vehicle at auction or from a wholesaler, that purchase is an asset that sits on the balance sheet until the car sells. It only becomes cost of goods sold on the day you deliver it to a buyer. If you expense the auction ACH the month it clears, your profit swings wildly and your inventory value is wrong. Converting the statement gets each purchase and auction fee in accurately so you can add it to the unit's cost and move the whole thing to COGS at sale.

Deposits come from many directions

Your deposits are not one clean stream. You get customer down payments, funding checks or ACHs from finance companies buying your retail installment contracts, and, if you carry your own paper, a flood of small weekly or biweekly BHPH payments with no useful bank feed detail. Each type posts differently. Converting the statement gets every deposit in with its date and amount so you can tell a down payment from lender funding from a note payment instead of lumping it all into sales.

Sales tax and title fees pass through you

Sales tax you collect is money you owe the state, not income, and it should sit as a liability until you remit it. The same goes for DMV, title, registration, temp tags, and doc fees that flow through the deal. Booking any of it as revenue overstates what the lot earned and leaves your tax numbers off. Getting every collected amount into QuickBooks and coded to the right liability is what keeps your profit honest and your remittance easy to reconcile.

Built for used car dealer books

One tool for every account you deal with, so a busy month of auction buys, floor plan activity, and deposits goes into QuickBooks in minutes.

Floor plan draws and payoffs in

Draws and curtailment payments on a NextGear, Westlake, or bank flooring line each belong to a unit. PDFQBO captures every one with its exact date and amount so you can post it to the flooring liability and tie it to the right vehicle instead of retyping the portal.

Auction and floor plan statements

Convert the auction platform or floor plan portal statement to a QBO file so those ACHs and fees are in QuickBooks even when the account offers no bank feed, and you can add each cost to the unit it bought.

Per-vehicle gross profit

Tag purchases, recon, transport, and the sale to the vehicle it belongs to so you can read gross profit per unit, not just a monthly lump that hides which cars actually made money and which sat too long.

Deposits kept separate

Getting every deposit into QuickBooks is what lets you split down payments, finance-company funding, and BHPH note payments, so your income reflects real sales instead of every dollar that hit the account.

Sales tax held as a liability

Sales tax, title, and DMV fees you collect are pass-through, not revenue. Converting the statement gets each collected amount in with its date so you can code it to what you owe the state and reconcile the remittance later.

Reads any bank's layout

A national bank, a local bank, a floor plan portal, or an auction account each format a statement their own way. PDFQBO finds the transaction rows on each one and leaves out the summary boxes that are not transactions.

Who uses it at a used car dealership

Anyone keeping a dealer's books in QuickBooks from PDF statements.

Independent retail lots

You buy at auction on a flooring line and sell for cash or through a lender. Converting the operating and floor plan PDFs each month gets every purchase, draw, payoff, and down payment into QuickBooks so cars stay inventory until sold and you see profit per unit.

Buy here pay here dealers

You carry your own paper and collect a stream of small weekly note payments with no useful bank feed. Converting the servicer and bank statements gets every BHPH payment in with its date so principal, interest, and down payments post correctly instead of piling into sales.

Wholesale and dealer-to-dealer

You move volume between auctions and other dealers where inventory turns fast and margins are thin. Converting the statements keeps each purchase and sale tied to its unit so cost of goods sold is right and you can tell which flips actually paid.

Bookkeepers for dealer clients

Clients hand you PDFs, a floor plan portal export, and a pile of auction ACHs. One converter for every account gives you a repeatable way to bring any lot's month into QuickBooks with inventory, flooring liability, and pass-through tax split correctly.

Common used car dealer categories once the transactions are in

Once the statements are converted and imported, you code each transaction to an account. These are the accounts a dealer leans on most, and having every line in QuickBooks is what makes per-vehicle profit and your tax numbers trustworthy.

• Vehicle inventory for auction and wholesale purchases held as an asset until each unit sells.
• Floor plan liability for draws, curtailment, and payoffs on a NextGear, Westlake, or bank flooring line.
• Cost of goods sold moved from inventory the day a vehicle is delivered, plus recon and transport.
• Sales tax payable and title, DMV, and doc fees collected as pass-through, not income.
• Vehicle sales income from cash deals, finance-company funding, and BHPH down payments.
• Auction and flooring fees plus interest on the line, tracked so gross profit per unit is accurate.

To keep car purchases as an asset until sold, see recording inventory purchases and COGS in QuickBooks. For the flooring line itself, follow recording a loan or line of credit, and when it is time to pay the state, see recording a sales tax payment. For coding the imported lines, see categorizing bank transactions in QuickBooks.

Frequently asked questions

How do I record floor plan financing in QuickBooks?

Set up the flooring line as a liability account. When you draw to buy a car, increase the liability and add the vehicle to inventory. When the car sells, the payoff or curtailment reduces the liability, and interest and flooring fees post as expense. Converting the statement gets each draw and payoff in with its date so you can tie it to the right unit.

Is a used car purchase an expense or inventory in QuickBooks?

A car you buy to resell is inventory, an asset, not an expense. It sits on the balance sheet until the vehicle sells, then moves to cost of goods sold on the day you deliver it. Expensing the auction payment when it clears distorts profit and inventory value. Converting the statement gets each purchase in accurately so you can add it to the unit's cost.

How do I record a customer down payment at a car dealership in QuickBooks?

Record the down payment against the vehicle sale, not as separate income, so it reduces what the customer or lender still owes on that deal. If the sale has not closed yet, hold it as a customer deposit liability. Converting the statement gets each down payment in with its date so you can apply it to the right deal cleanly.

How do I get an auto dealer bank statement into QuickBooks?

Convert the PDF statement to a QBO file, then import it. Upload the operating or floor plan statement to PDFQBO, review the purchases, draws, payoffs, down payments, and sales tax it reads, and download a QBO (Web Connect) file. In QuickBooks Online you upload it from the Banking screen; in Desktop you import the Web Connect or IIF file. Then categorize each line.

Is QuickBooks good for a used car dealership?

QuickBooks works well for a lot when cars are held as inventory until sold, the floor plan line is a liability, sales tax is pass-through, and each unit is tracked for gross profit. A dealer management system handles deals and titles; QuickBooks is the accounting book of record. Converting your bank and floor plan PDFs to QBO files keeps the two in agreement.

How do I track profit per vehicle in QuickBooks?

Tag each purchase, recon, transport, and the sale to the vehicle it belongs to, then run a report by that tag. Once every cost and the sale price carry the unit, you can read gross profit per car and see which held too long. Converting the statements gets those lines in so you can assign them to the right vehicle.

Get your dealer statements into QuickBooks

Upload an operating, floor plan, or auction PDF, review the purchases, draws, payoffs, down payments, and sales tax, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing