Bank Statement to QuickBooks for Property Management: Convert PDF Statements to QBO

A property-management company rarely runs on one account. You usually have an operating account for your own fee income and expenses, a trust or escrow account that holds owner and tenant funds, a separate security-deposit account, and one or more credit cards for repairs and supplies. Keeping those balances clean in QuickBooks is the whole job, and it depends on getting every statement in without gaps.

Bank feeds work against you here. They typically pull only about 90 days of history, and they often skip trust accounts, escrow accounts, and closed accounts entirely, which are exactly the accounts you most need reconciled. Manual .qbo upload has no date limit, so you can bring in a full prior year or an account the feed never touched. You can convert a bank statement to QuickBooks from the PDF your bank already gives you.

A tenant security deposit is not your income and it is not the owner's income. It is money you are holding, so it belongs on the books as a liability. Set up an other current liability account, often named Security Deposits Held, and record deposits against it. When a tenant moves out and you return the money, you draw it back down from that liability. If you keep part of it for damage, move only that portion from the liability to income and record the repair as an expense.

Where the money sits matters as much as how you book it. Many states require managers to hold owner funds and tenant deposits in a separate trust or escrow bank account, kept apart from the company's operating account. Commingling, meaning mixing client money with your own, is the most common and most serious trust-accounting violation, and using deposits to cover operating costs is a classic example. QuickBooks is not purpose-built property-management software, but it handles this fine when you keep a dedicated trust bank account and matching liability accounts. Always confirm your own state's rules.

Once the statement is imported, each line needs the right account and the right property tag. Using a class or location per property lets a single QuickBooks company track many buildings and many owners at once. Here is how common property-management transactions line up.

The nuance most people miss is the difference between your money and the owner's money. Rent you collect and bills you pay on an owner's behalf flow through a liability like Due to Owner, not through your own profit and loss. Only your management fee is real income to your company. Booking owner expenses as your own expenses inflates your books and blurs the trust balance.

Turn on class or location tracking and create one class per property, or per unit if you manage buildings with several doors. Tag every transaction to its property as you review the imported statement. With that in place, each owner statement is simply a Profit and Loss by Class filtered to that property, showing rent collected, expenses paid, your fee, and the net owed to the owner.

Consistent tagging at import time is what makes those reports trustworthy, so set the class on each line rather than fixing it later. If you manage a large portfolio and need to bring in many accounts or a full year at once, bulk bank statement to QuickBooks conversion lets you process the whole stack, then sort each .qbo file to the right property and company.

The trust or escrow account has to be reconciled every month, and not just for tidiness. The bank balance in that account should equal the sum of every liability it backs: each owner's Due to Owner balance plus every tenant's Security Deposits Held. If those numbers do not tie out, money has slipped between owners or between trust and operating, which is exactly the problem trust accounting exists to prevent.

Because bank feeds so often skip trust and escrow accounts, converting the PDF trust statement and importing it cleanly is frequently the only practical way to reconcile that account in QuickBooks. Bring in the trust statement, match every line to its owner or deposit liability, and confirm the balance agrees before you send out owner statements for the month.

1. Upload your PDF bank or credit card statements to the converter at the top of this page. You can add several at once, including the operating, trust, and security-deposit accounts.
2. The tool OCRs and parses each statement and reconciles the running balance, keeping the date, description, and amount for every line.
3. Download a .qbo file per statement, plus Excel and CSV copies for your own owner tracking sheets.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 lines per file and 350 KB or less, so split a long statement if it runs past those limits. For a step-by-step walkthrough, see how to import into QuickBooks Online.

How do I do bookkeeping for property management in QuickBooks?

Keep the company's operating account separate from a trust account that holds owner and tenant funds, use a class per property, and book rent and owner bills through a Due to Owner liability so only your management fee is income. Convert PDF statements to .qbo, import them, tag each line, and reconcile monthly.

How do I record security deposits in QuickBooks?

Record a tenant security deposit as an other current liability, often called Security Deposits Held, not as income. Deposit the money into your trust or deposit account and offset it to that liability. When you refund it, pay from the same account against the liability. If you keep part for damage, move only that part to income.

Can QuickBooks be used for property management?

Yes, though it is not purpose-built property-management software. It will not screen tenants or collect rent, but for the books it works well when you set up a trust account, use classes or locations per property, and track owner and deposit funds as liabilities. Many managers pair it with a converter to import trust statements.

How do I track income by property in QuickBooks?

Turn on class or location tracking and assign one class to each property or unit, then tag every transaction as you review it. Run a Profit and Loss by Class to see rent, expenses, and your fee for each property. That report doubles as the basis for each owner's monthly statement.

How do I record owner draws in QuickBooks?

An owner disbursement is not your expense, so record it against the Due to Owner liability rather than an expense account. When you pay an owner their net proceeds from the trust account, the payment reduces that liability. This keeps the trust balance equal to what you still owe each owner and keeps your own books accurate.

Can I import old bank statements into QuickBooks for taxes?

Yes. Manual uploads have no date limit, unlike bank feeds that only reach back about 90 days. Convert your older PDF statements into .qbo files and upload them to backfill a prior tax year or a trust account the feed never connected to. Import each account separately and reconcile month by month.