How to Categorize Rental Property Transactions From a Bank Statement

Last updated July 2026.

Categorizing rental property transactions from a bank statement means sorting every deposit and payment into the income and expense lines that Schedule E uses, per property, so your return ties back to the bank. Rent and other tenant money go to income. Repairs, management fees, insurance, mortgage interest, and the rest map to the expense lines on Form 1040 Schedule E. Keep each property in its own column and keep any personal spending out, and the yearly total drops onto the form with nothing to untangle. This guide covers the categories to use, how to split a mortgage payment, and how to handle the transactions landlords get wrong.

How do you categorize rental property transactions from a bank statement?

Start from Schedule E and build categories that match its lines, then tag every transaction on the statement to one of them. Schedule E, Part I lists the expense types the IRS expects for a residential rental: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, and depreciation. Deposits split into rent received and everything else (security deposits you may have to return are a liability, not income). Once your category list mirrors the form, categorizing is just matching each line to a bucket. The work goes fastest when the statement is already in a spreadsheet, so you can filter the description column and total each category in a couple of clicks.

Schedule E categories to map your transactions to

These are the expense lines a single-family or small multifamily rental usually touches. Line numbers follow the current Schedule E, but confirm them against the form you file.

How do you split a mortgage payment for Schedule E?

Only the interest portion of a rental mortgage payment is deductible on Schedule E, so the single bank debit has to be split. A $1,600 payment might be $900 principal, $520 interest, $150 escrowed property tax, and $30 escrowed insurance. Principal is not an expense at all (it pays down the loan, an equity move), interest goes to line 12, and the escrowed tax and insurance land on lines 16 and 9 when the servicer actually pays them. Pull the interest and escrow numbers from your year-end Form 1098 and the servicer's escrow statement, then adjust the category split so the interest you deduct matches the 1098. If you only categorize the lump payment, you overstate the deduction by the principal.

Keep each property separate

Schedule E reports each property in its own column, so your categories need a property tag too. If several rentals run through one checking account, add a column for the property address or a short code and tag every transaction to it before you total. That way a single spreadsheet produces the per-property income and expense figures the form wants, instead of a blended number you have to pull apart at tax time. Landlords who run each property through a dedicated account have it easier, but the tagging step still matters for any month where a transfer or a shared cost crosses accounts.

Transactions landlords get wrong

• Security deposits. A deposit you hold and may return is a liability, not rental income. Only book it as income in the year you keep it to cover damage or unpaid rent.
• Owner transfers. Moving your own money into the rental account to cover a shortfall is a contribution, not income. Tag it to equity so it never inflates rent received.
• Improvements vs repairs. Fixing a leak is a repair you deduct now. Replacing the roof is an improvement you depreciate. Categorize them differently or you misstate both the expense and the basis.
• Personal spending. A grocery run that hit the rental card is not a rental expense. Separating personal and business spending keeps the Schedule E total defensible; see how to separate business and personal expenses on a bank statement.

The fastest workflow: convert, then categorize

The bottleneck is rarely the tagging, it is getting a year of PDF statements into rows you can sort. Convert each statement to a spreadsheet first, then let the tool categorize the transactions into your Schedule E buckets so you review and adjust instead of typing. Landlords running several doors should start from the bank statement converter built for landlords, which keeps the running balance and per-property view intact. Once the year is categorized, you can build a per-property profit and loss in the same sheet. To capture the receipts that back up repairs and supplies, an expense tool that reads and sorts receipts automatically keeps the documentation ready if the deduction is ever questioned.

If you also file a Schedule C for a short-term rental with substantial services, the split between the two schedules matters; the difference is covered in Schedule E vs Schedule C for rental income.

Repairs you deduct now vs improvements you depreciate

The line between a repair and an improvement decides whether a payment is a full deduction this year or a cost you spread over decades, so it deserves its own categorization habit. A repair keeps the property in working order: fixing a leak, patching drywall, servicing the furnace. You deduct it in the year you pay it, on line 14. An improvement betters the property, restores it, or adapts it to a new use: a new roof, a kitchen remodel, an added bathroom. That cost is capitalized and depreciated, usually over 27.5 years for a residential rental, so it never hits the repairs line. When you categorize, split these into two buckets on the spot, because a $9,000 roof miscoded as a repair is an easy way to draw a question. The IRS safe harbors (the de minimis, small-taxpayer, and routine-maintenance rules) can let some smaller items be expensed, so flag the borderline ones for your CPA rather than guessing.

Track mileage and travel separately

Auto and travel is its own Schedule E line, and landlords miss it because the spending rarely runs through the rental account. Trips to the property to inspect, collect rent, meet a contractor, or handle a turnover are deductible, either at the standard mileage rate or actual expenses. Categorize any fuel, tolls, or airfare that does hit the statement to auto and travel, and keep a mileage log for the drives you paid for out of pocket. The log is the documentation that supports the deduction if it is ever reviewed.

This article is general information, not tax advice. Confirm category and line treatment with a CPA or the current IRS instructions for Schedule E.