Schedule E Categories: How to Map Bank Transactions (Rental Property)
Your bank sorts spending into budgeting buckets. Schedule E wants specific line numbers. This guide maps the transactions a landlord sees most often to the Part I line they usually belong on.
General information, not tax advice. Always check the IRS Instructions for Schedule E and Publication 527 for your situation.
Why bank categories do not match Schedule E
A bank sees "Home Improvement" and "Utilities". Schedule E Part I has its own lines: 3 rents received, 4 royalties, 5 advertising, 6 auto and travel, 7 cleaning and maintenance, 8 commissions, 9 insurance, 10 legal and other professional fees, 11 management fees, 12 mortgage interest paid to banks, 13 other interest, 14 repairs, 15 supplies, 16 taxes, 17 utilities, 18 depreciation expense or depletion, and 19 other expenses.
The mismatch causes three common problems. One bank category can land on several lines (a hardware store receipt may be repairs, supplies or an improvement). One payment can cover several lines (a mortgage payment). And some money movements are not income or expenses at all (transfers, principal, deposits). So you tag by line number yourself, not by the bank's label.
The mapping table
Read each row as "what the transaction looks like in your bank export" to "where it usually goes". The notes matter, because many rows depend on the facts.
| Bank or card description | Schedule E line | Notes |
|---|---|---|
| Home Depot, Lowe's, hardware store | 14 Repairs or 15 Supplies | Fixing something (patch, replace a faucet) is repairs; small consumables are supplies. A new roof, new water heater or remodel is an improvement; see repairs vs improvements. |
| Plumber, electrician, handyman | 14 Repairs | Labor to fix existing things. If it is part of an improvement, capitalize it with the project. |
| Cleaning service, lawn care, pest control | 7 Cleaning and maintenance | Pest control and landscaping are sometimes put on line 19; pick one approach and use it every year. |
| Property tax payment to county | 16 Taxes | Real estate taxes on the rental. Not income taxes. |
| Mortgage payment | 12 Mortgage interest (interest part only) | Split it: interest to line 12, principal is not deductible, escrow parts go to 9 and 16. See below. |
| Landlord / dwelling fire policy premium | 9 Insurance | Escrowed premiums count when the lender pays them from your payments. |
| HOA dues | 19 Other | Assessments for a capital item may need to be capitalized. |
| Zillow, Apartments.com, listing fees, yard sign | 5 Advertising | Tenant screening reports are often put on line 19. |
| Property manager monthly fee | 11 Management fees | Leasing or placement commissions paid to an agent may belong on line 8. |
| Leasing agent finder's fee | 8 Commissions | Only if it relates to finding a tenant. |
| Water, sewer, trash, gas, electric (landlord pays) | 17 Utilities | If the tenant pays and you do not, there is nothing to record. |
| CPA, tax prep, attorney, eviction filing | 10 Legal and other professional fees | Only the rental-related part of a tax preparer's fee. |
| Mileage or gas to the property | 6 Auto and travel | Use the standard mileage rate or actual costs, not both for the same vehicle. Keep a mileage log. |
| Interest on a HELOC, personal loan or credit card used for the rental | 13 Other interest | Mortgage interest from a bank is line 12; other interest is line 13. Interest on a loan used for personal spending is not deductible here. |
| Bank fees on the rental account, software subscriptions | 19 Other | Business-only accounts keep this clean. |
| Refrigerator, stove, new roof, new HVAC, remodel | Capitalize, then 18 via depreciation | Not deducted in one year. Build a depreciation schedule instead. |
| Tenant rent deposit (ACH, Zelle, check) | 3 Rents received | Count rent when you receive it (cash method). Prepaid rent counts when received. |
| Security deposit received | Not income, unless kept | Track it as a liability. Part you keep becomes income. |
| Tenant reimburses you for a repair or utility | 3 Rents received, or net against the expense | Be consistent. Many landlords simply report it as income and deduct the full expense. |
| Transfer between your own accounts | Ignore | Not income or expense. |
| Groceries, personal Amazon, your own home | Exclude | Not rental. If a purchase is mixed, split it. |
The tricky ones
Mortgage payment: split it
One payment usually has up to four parts: principal, interest, escrowed property tax and escrowed insurance. Only the interest goes on line 12 (the lender reports it on Form 1098). Principal builds your equity and is not deductible. Escrowed tax goes to line 16 and escrowed insurance to line 9. Your lender's annual statement gives the amounts paid out of escrow. Log the payment in your records as one row split into its parts.
Escrow
The amount paid into escrow is not the deduction. The amount the lender actually pays out for tax and insurance in the year is the figure to use, so you may need the year-end escrow statement rather than your monthly payments.
Deposits
A security deposit you plan to return is not rental income when you receive it. If you keep some of it, such as for unpaid rent, that amount is generally income in the year you keep it. Last month's rent paid in advance is rent and is income when received.
Mixed-use purchases
If a card charge covers rental and personal items, split the receipt. If you use a property part of the year yourself, Publication 527 explains how to divide expenses between rental and personal use. A dedicated rental account and card keep this much simpler.
Capital improvements
Appliances, a new roof, new HVAC and remodels generally add value or extend life, so they are capitalized and recovered through depreciation (line 18), not deducted in one go. Tag these rows "capitalize" in your records and set them up on a depreciation schedule. The test for repair versus improvement is covered in this guide.
A simple monthly workflow
- Use a separate bank account (and ideally a separate card) for each rental, or at least for all rentals together.
- Once a month, export the transactions as a CSV.
- Add a column and tag every row with a Schedule E line number, or "transfer", "capitalize" or "personal".
- For rows that need a split (mortgage, mixed-use), add one row per part.
- Save the receipt or invoice for anything that is not obvious, and name it by date and vendor.
- At year end, total each line per property and compare with your lender's and bank's year-end statements.
FAQ
Can I just use my bank's category tags for Schedule E?
Not directly. Bank categories like Home Improvement or Utilities are built for budgeting, not tax lines. Use them as a starting point, then tag each row with a Schedule E line number yourself.
Do I deduct my whole mortgage payment?
No. Only the interest portion goes on line 12 (or line 13 if the lender is not a bank or similar institution). Principal is not an expense. The lender's year-end statement shows the interest total.
Is a security deposit rental income?
Generally not when you receive it, if you expect to return it. If you keep part of it, for example to cover unpaid rent, that part is generally income when you keep it. Check the Schedule E instructions and Publication 527.
What do I do with a transfer between my own accounts?
Ignore it for Schedule E. Moving money from your checking to your rental account is not income or an expense. Mark it as a transfer so it does not get counted twice.
Related
- Schedule E Line 19 Other Expenses: What Goes There and How to Track It
- Rental Property Repairs vs Improvements: How to Log Each Cost
- Rental Property Depreciation Schedule: 27.5-Year Table with a Worked Example
- Rental Property Tracker (Schedule E ready spreadsheet)
Disclaimer
General information, not tax advice. For record-keeping only. See the IRS Instructions for Schedule E and Publication 527, or ask a tax professional. Kitebyte is not affiliated with the IRS.