Bank Statement Converter for Property Managers: Convert PDF Statements to Excel and CSV for Owner Statements and Schedule E

How do property managers do bookkeeping from bank statements?

Property management bookkeeping means taking every line on the operating and trust account statements and coding it to a property, an owner, and a category, then rolling those lines up into a monthly statement for each owner and a per-property total for taxes. The buckets are consistent: rent income, management and leasing fees, repairs and maintenance, mortgage and property tax, insurance, utilities, and owner draws. Starting from a bank statement, the work is to decide which property and owner each transaction belongs to and tag it, which is fast when the statement is already a clean spreadsheet and slow when it is a printed PDF. That conversion is the step the tool removes.

How is a security deposit recorded, and why does it matter?

A refundable security deposit is not income when you receive it, because the money still belongs to the tenant and you are holding it in trust until the lease ends. On the books it is recorded as a liability, not revenue, and returning it later is not an expense: you simply reduce the liability. It only becomes income in the year you keep part or all of it for unpaid rent or damage, and any repair you then pay for is deducted as an expense. Getting this right on the statement matters because a deposit miscoded as rent inflates the owner's taxable income and can misstate the trust balance. The table below shows how the common property transactions are treated.

What does a property manager report on Schedule E?

Schedule E is where rental real estate income and expenses are reported, one column per property, up to three properties per form and more on additional copies. Rent received goes in as income, and the deductible expenses each get their own line: advertising, cleaning and maintenance, insurance, management fees, mortgage interest, repairs, supplies, property taxes, utilities, and depreciation. Security deposits you expect to return are not entered on Schedule E at all, because they are not income. Because the form is per property, the whole point of coding the bank statement by unit is that the totals drop straight onto the right column instead of being untangled at tax time.

Do property managers have to reconcile a trust account?

Yes. A property manager who collects rent and holds deposits for owners is handling money that is not theirs, and in most states that money sits in a dedicated trust or escrow account that has to be reconciled to the bank statement every month. A clean three-way reconciliation ties the bank balance, the book balance, and the sum of what is owed to each owner and tenant, and they all have to agree. The bank statement is the anchor of that reconciliation, so converting it to rows with the running balance intact is what lets you match every deposit and disbursement against your ledger and catch a commingling error before an auditor does.

When does a property manager issue a 1099?

A property manager operating as a trade or business issues a Form 1099-MISC to each owner for the rent remitted to them during the year, and a Form 1099-NEC to unincorporated vendors and contractors paid for services. For tax year 2026 the reporting threshold rose from $600 to $2,000 after the One Big Beautiful Bill Act, so both forms are generally required once payments to a given owner or vendor cross $2,000 in the year. Recipient copies are due January 31. The totals behind each form are simply the sum of the payments to that owner or vendor on the bank statements, which is exactly what a converted, filterable spreadsheet gives you.

Where BankXLSX fits, and where it does not

BankXLSX converts the statement into a spreadsheet. It is not accounting software and it is not a property management platform: it does not build the owner statement, reconcile the trust account, or file Schedule E. What it does is remove the retyping by reading each operating or trust account PDF into dated rows with amounts and the running balance already in columns. From there you or your bookkeeper add the property and category columns, total by owner, and reconcile against your ledger. Managers who keep the books in QuickBooks convert the statement straight to a QuickBooks import with a bank statement to QuickBooks converter. To subtotal spend by property in a spreadsheet, pair the converter with our transaction categorization guide, and to keep the receipts behind every repair and vendor payment, an expense and receipt tracker holds the paper trail through the year.

Should each property or owner have its own account?

Separating owner and tenant money from your own operating cash is not optional in most states, so a dedicated trust account is the baseline. Beyond that, whether each owner gets a sub-account or you track them within one trust account by ledger is a business choice, but the cleaner the separation, the simpler every reconciliation and owner statement becomes. When all activity for a property runs through a clearly tracked account, the converted statement is already close to that property's income and expense report, and the monthly owner statement almost writes itself. Commingling funds across owners or with your own money is the fastest way to a trust-accounting violation, and the bank statement is where that mixing shows up first.