PDF Bank Statement to QuickBooks for Equipment Rental: Convert Rental Yard Statements to QBO
A rental yard's bank statement is not a list of sales. It is a mix of refundable damage deposits that are not yours yet, damage waiver fees that are, card batches from a hundred small counter rentals, delivery and fuel surcharges, a monthly equipment loan or floor plan payment, and the occasional five-figure deposit from selling a used skid steer off the fleet. PDFQBO converts each PDF statement into a QuickBooks QBO file so every deposit, waiver, and financing payment reaches your books with the right date and amount.
Quick answer
To get an equipment rental company bank statement into QuickBooks, convert the PDF to a QBO file first. Upload the operating account statement to PDFQBO, review the merchant card batches, refundable deposit receipts, damage waiver and delivery fees, and equipment loan payments it reads, and download a QBO (Web Connect) file. Import that file into QuickBooks Online or Desktop, then code the lines: refundable deposits to a liability account, waiver and delivery fees to income, and each loan payment split between principal and interest.
Last updated July 2026
Convert a rental yard statement to QBO
Upload an operating account or fleet card PDF and download a QBO file for QuickBooks.
No credit card required to try your first statement.
How to convert an equipment rental statement to QuickBooks
Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether the money is a counter rental coming in or a fleet payment going out.
Gather the PDFs
Download the monthly statement from the operating account where card batches and deposit checks land, plus any fuel or fleet card you charge diesel, parts, and trailer repairs on.
Upload to the converter
Drag the statements into the tool above. A peak summer month with three hundred lines converts as easily as a quiet January, and you can upload several months at once when you are catching up after season.
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 card batches, deposit refunds, and loan payments, 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 send refundable deposits to their liability account and split each equipment note into principal and interest.
Why equipment rental books are hard to get into QuickBooks
A refundable deposit looks exactly like revenue on the bank line
When a customer puts down $500 to take a mini excavator for the weekend, that money is sitting in your account but it is not yours. It is a refundable damage deposit, and until the machine comes back clean and undamaged it belongs on the balance sheet as an other current liability, not in rental income. The bank statement does not know the difference. It shows a deposit, the same as a paid rental invoice. If you post everything that clears the account to income, you overstate revenue every busy month and then confuse yourself again when the deposit goes back out. Converting the statement gets the deposit receipt and the later refund in as separate dated lines, which is what lets you park one in the liability account and clear it against the other.
The damage waiver is income, and it is not insurance
Most yards add an optional damage waiver, commonly a percentage of the rental rate, that limits what the customer owes if the equipment is damaged. It is not an insurance policy and you are not an insurer; it is a contractual fee you charge and keep, so it is ordinary income and in many states it is taxable the same way the rental is. Because it rides along inside the same card batch as the rental itself, it never shows up separately on the bank line. Getting the batch into QuickBooks with its date is the first step; reconciling that batch back to the rental software's daily report is what splits waiver income out from rental income and from the deposits.
Card batches net out fees, so the deposit never matches the day's rentals
Counter rentals are mostly card transactions, and the processor deposits them in a batch a day or two later with the discount rate already taken out. Friday's $4,180 of rentals lands Monday as $4,061. The gap is merchant fees, and if you record the deposit as your revenue you have quietly understated both income and expense by the same amount all year. Rental yards also tend to run several batches a week plus counter cash and the occasional customer check, which is a lot of small lines to type by hand. Converting the statement brings them all in dated so you can match each batch to the day it covers.
The fleet is a balance sheet, not an expense
A rental business is a capital business. Skid steers, boom lifts, generators, scaffold, and trailers are fixed assets you depreciate, usually bought on equipment notes or a floor plan line with the dealer. Every month a payment leaves the account, and only the interest portion is an expense. The rest reduces the note. On the bank statement it is one number. Split incorrectly, or coded straight to an expense account, and the balance sheet drifts further from reality every month until a lender asks for financials. Then there is the other direction: when you sell a machine off the fleet, the deposit is not income either, it is a disposal that has to be measured against the book value left on that asset.
The rental software and QuickBooks rarely agree on their own
Most yards run a rental platform such as Point of Rental, Texada, Quipli, or integraRental for contracts, availability, and billing, and QuickBooks for the general ledger. Some of these push summary journal entries across and some do not, and none of them know what actually cleared your bank. Reservations, extensions, partial returns, and rerents make the operational numbers and the bank numbers diverge in ways only a reconciliation catches. The bank statement stays the source of truth, which is why getting every line of it into QuickBooks matters more here than in a business that just sells things.
Built for rental yard books
One tool for every line on the statement, so a peak season month goes into QuickBooks in minutes instead of an evening of typing.
Deposits stay separable
Deposit receipts and deposit refunds come through as their own dated lines, so you can route them to a liability account and clear them against each other instead of burying them in rental income.
Every card batch captured
A month of counter rentals can be dozens of processor deposits. Each one arrives with its settlement date and net amount so you can tie it back to the day's contracts and book the merchant fee.
Fleet payments in with dates
Equipment notes and floor plan draws hit on their own schedules. Getting each payment in dated is what lets you split principal from interest and keep the note balances honest.
Fuel and parts cards too
Diesel for the delivery truck, hydraulic hose, tires, and dealer parts usually run on a card. That statement converts the same way a bank statement does, so shop costs land in QuickBooks with the rest.
Catch up a whole season
Books that fell behind during a busy summer can be rebuilt from the PDFs you already have. Convert several months in one pass rather than waiting on a feed that only reaches back so far.
Reads any bank's layout
A national bank, a local commercial lender, or a dealer floor plan account each format a statement their own way. PDFQBO finds the transaction rows on each and leaves out the summary boxes that are not transactions.
Who uses it in the rental business
Anyone keeping a rental operation's books in QuickBooks from PDF statements.
Construction and tool rental yards
Skid steers, lifts, compactors, and trailers out on daily and weekly contracts, financed on equipment notes. Converting the operating statement keeps rental income, deposits, and note payments straight all season.
Party, event, and tent rental companies
Heavy on customer deposits taken months ahead of the event, then delivery, setup, and damage charges after. Dated lines are what let you hold deposits as a liability until the event actually happens.
Trailer, storage container, and portable rental
Recurring monthly billing on long-term units mixed with one-time delivery and relocation fees. Statement lines give you the real cash dates behind a rent roll that bills on paper every month.
Bookkeepers and CPAs with rental clients
Clients hand you a rental software report and a bank PDF that do not tie out. One converter for every account gives you a repeatable way to bring a yard's month into QuickBooks and reconcile it against the contracts.
Common equipment rental 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 rental yard leans on most, and getting the split right between the balance sheet and the income statement is what keeps utilization and fleet return on investment meaningful.
- • Rental income separated by category if you can, since a boom lift and a plate compactor earn very differently against what they cost.
- • Damage waiver and environmental fees as their own income accounts, not folded into the rental line.
- • Delivery, pickup, and fuel surcharges which are service income and often carry different sales tax treatment than the rental.
- • Customer deposits held as an other current liability, cleared when the machine is returned and the deposit is refunded or applied.
- • Rental fleet assets and accumulated depreciation tracked per machine so a disposal can be measured against real book value.
- • Equipment notes and floor plan payable with each payment split into principal and interest expense.
- • Shop, parts, and maintenance kept apart from general repairs so you can see the true cost of keeping the fleet rentable.
- • Rerent expense for machines you sublease from another yard to cover a job, which is a cost of revenue rather than an overhead line.
For holding a deposit correctly, see recording a security deposit in QuickBooks. For the note payments, see recording a loan or line of credit, and for the fleet itself see recording depreciation in QuickBooks. When you trade a machine in on a newer one, see recording an equipment trade in. For the card batches, see recording merchant processor payouts, and for coding the imported lines see categorizing bank transactions in QuickBooks.
Frequently asked questions
How do I record a security deposit in QuickBooks for an equipment rental?
Record a refundable deposit to an other current liability account, not to income. Create an account such as Customer Deposits Held, then use a service item pointed at that liability when you take the deposit, so the money increases cash and increases the liability. When the equipment comes back, refund the deposit against the same account. If you keep part of it for damage or a late return, move only that portion to income or against the repair cost.
Is a damage waiver income or insurance?
A rental damage waiver is income. It is a contractual fee that limits the customer's liability, not an insurance policy, and you are not acting as an insurer when you charge it. Post it to its own income account rather than folding it into rental revenue, so you can see what the waiver actually earns against the damage you absorb. Many states also treat it as taxable the same way the rental is, so check your state's rule.
How do I record an equipment loan payment in QuickBooks?
Split every payment between principal and interest. The principal portion reduces the loan liability account and the interest portion goes to interest expense, using the amortization schedule from the lender to get the split for that month. Coding the whole payment to an expense account overstates expenses and leaves the loan balance frozen, which shows up as soon as a lender or your CPA compares your balance sheet to the payoff statement.
How do I record selling a piece of rental equipment?
Treat it as a disposal, not a sale of inventory. Remove the machine's original cost and its accumulated depreciation from the balance sheet, record the cash you received, and book the difference as a gain or loss on disposal of assets. A used unit sold for more than its remaining book value produces a gain even though it sold below what you paid, because depreciation already ran through the income statement in earlier years.
What accounting software do equipment rental companies use?
Most yards run a rental management platform such as Point of Rental, Texada, Quipli, or integraRental for contracts, availability, and billing, and use QuickBooks as the general ledger for financial statements, payroll, and tax. Some of those platforms push summary entries into QuickBooks and some do not, so the bank statement remains the check on whether the two agree.
Can QuickBooks handle equipment rental?
QuickBooks handles the accounting for an equipment rental business well: rental income, deposits as liabilities, fleet assets with depreciation, equipment notes, and job or class tracking by yard. What it does not do is manage reservations, availability, and returns, which is why most yards pair it with rental software. Keeping the bank side complete by importing every statement is what keeps the accounting book of record trustworthy.
How do I get an equipment rental bank statement into QuickBooks?
Convert the PDF statement to a QBO file, then import it. Upload the operating account or fleet card statement to PDFQBO, review the card batches, deposit receipts and refunds, delivery and waiver income, and equipment note payments 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 code each line to the right account.
Get your rental yard statements into QuickBooks
Upload an operating account or fleet card PDF, review the card batches, deposits, and note payments, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.
Related guides and tools
Convert PDF bank statement to QuickBooks
The flagship converter for any bank's PDF statement.
PDF statements to QuickBooks for contractors
Your customers, and the same equipment note patterns.
PDF statements to QuickBooks for self storage
Recurring monthly billing and deposits held.
Record a security deposit in QuickBooks
Hold refundable deposits as a liability, not income.
Record an equipment trade in
Retire a machine and roll it into the next one.
Batch convert PDF bank statements
Convert a whole season of statements at once for catch-up.