Bank Statement to QuickBooks for Real Estate: Convert PDF Statements to QBO

Convert PDF bank and credit card statements into .qbo files for QuickBooks so real estate rent, mortgage, escrow, and repairs post cleanly per property.

Totals reconcile to the original QuickBooks Online and Desktop
Loved by bookkeepers and accountants 50K+ pages converted

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Real estate investors, landlords, property managers, and agents can turn PDF bank and credit card statements into .qbo Web Connect files for QuickBooks Online and Desktop. Upload a statement to the converter at the top of this page, and it parses every transaction so rental income, mortgage and escrow payments, repairs, and management fees post cleanly per property. You also get Excel and CSV copies of the same data for your own tracking sheets.

Last updated July 2026.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

Why PDF statements matter for real estate books

Real estate books rarely fit inside a single checking account. You might have an operating account, a security deposit trust account, a mortgage servicer, an escrow sub-account, and a credit card for materials. Bank feeds usually pull only about 90 days of history, and they often skip closed accounts, loan accounts, and escrow accounts entirely. That leaves gaps right where you need clean records for taxes and reconciliation.

QuickBooks does not read a PDF directly. So if your lender or bank only gives you PDF statements, you need a way to convert them into a format QuickBooks accepts. Manual uploads have no date limit, which means you can bring in a full prior year (or an account the feed never touched) and get it reconciled. You can convert a bank statement to QuickBooks in a few minutes using the tool above.

Per-property categorization that survives an audit

The whole point of real estate bookkeeping is knowing which property made or lost money. Once transactions are in QuickBooks, tag each one to a property using classes, locations, or customer records, then map it to the right account. Here is how common real estate transactions line up with QuickBooks categories.

Real estate transactionQuickBooks categoryNote
Tenant rent receivedRental incomeTag to the property class or location
Security deposit receivedSecurity deposit liabilityA liability, not income, until forfeited or returned
Plumbing or HVAC fixRepairs and maintenanceDeductible in the year paid
HOA duesHOA feesSeparate from repairs for clean reporting
Mortgage paymentSplit: interest expense and loan principalPrincipal reduces the loan liability, not an expense
Escrow portion of paymentEscrow asset (then taxes and insurance)Reclass when the servicer pays taxes or insurance
Property manager cutManagement feesDeductible operating expense

The mortgage split trips up most first-time landlords. A single payment is part interest expense, part principal reduction, and often part escrow. Your servicer's year-end statement shows the breakdown, and you can enter it as a split transaction so your books match Schedule E.

Reconciling a trust or security-deposit account

Many states require landlords to hold security deposits in a separate account, sometimes an interest-bearing one. Because that account is a liability you are holding for tenants, it needs its own reconciliation. Convert the deposit account's PDF statements, import them, and reconcile monthly so the balance in QuickBooks matches the bank to the penny. If a tenant moves out and you keep part of a deposit for damage, move that amount from the liability to income and record the repair as an expense.

Handling multiple property LLCs and entities

If you hold each property in its own LLC, keep a separate QuickBooks company (or at minimum a separate class) per entity. Convert each entity's statements on their own so the .qbo files stay clean and import to the right company file. Landlords with a stack of accounts and statements can save time with bulk bank statement to QuickBooks conversion, then sort each file to its entity. Bookkeepers running several client portfolios may prefer the workflow built for bank statement conversion for accountants.

Mapping to Schedule E

Schedule E is where rental income and expenses land on a personal return. If you categorize consistently in QuickBooks, your year-end profit and loss by property maps straight to the Schedule E lines: rents received, cleaning and maintenance, insurance, management fees, mortgage interest, repairs, supplies, taxes, and utilities. Getting old statements in before tax time is the difference between a smooth filing and a scramble.

How to convert your statements
  1. Upload your PDF bank or credit card statements to the converter at the top of this page. You can add several at once.
  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 property tracking.
  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. Each file must be in English and 350 KB or less, so split a long statement if it runs past those limits. For more detail, see how to import a bank statement into QuickBooks Online or use the PDF to QBO converter directly.

Frequently asked questions

Can I use QuickBooks for real estate accounting?

Yes. QuickBooks handles rental income, expenses, and reconciliation well when you use classes or locations to separate properties. It is not a full property management platform, so it will not screen tenants or collect rent, but for the books and tax reporting it works for most landlords and investors.

How do I record rental income in QuickBooks?

Record rent as income tagged to the property, usually through a sales receipt or a deposit categorized to a rental income account. If your statement is a PDF, convert it with the tool above so each rent deposit imports with its date and amount, then confirm the category and property tag before you reconcile.

How do I track expenses by property in QuickBooks?

Use classes or locations to tag every transaction to a specific property, then run a profit and loss report filtered by class. This gives you per-property income and expense totals. Consistent tagging at import time is what makes those reports accurate, so set the property on each line as you review the converted statement.

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, which is how most people backfill a prior tax year or an account the feed never connected to. Import them account by account and reconcile each month.

Does QuickBooks work for landlords with multiple properties?

Yes. One QuickBooks company can track many properties using classes or locations, and separate LLCs can each have their own company file. Convert each account's statements separately so the files stay organized, then import them to the matching entity. Reporting by class keeps each property's numbers distinct.

Why won't QuickBooks accept my PDF statement directly?

QuickBooks cannot read a PDF. It only imports .csv, .txt, .qbo, .qfx, and .ofx files. That is why you convert the PDF first: the tool at the top of this page turns the statement into a .qbo Web Connect file that QuickBooks recognizes, along with Excel and CSV versions for your records.

Convert your first statement free.

Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.

More bank statements we convert to QuickBooks

Same converter, tuned for the layout each bank uses. Find yours: