How to Track Rental Property Expenses (Without Losing Your Mind)
Every landlord knows the feeling: tax season arrives and you're staring at 12 months of bank statements, trying to remember what that $347 Home Depot charge was for. Tracking rental property expenses doesn't have to be painful — you just need a system. This guide walks you through building one from scratch.
Step 1: Separate Personal and Rental Finances
The single most impactful thing you can do is open a dedicated bank account for your rental properties. Mixing personal and rental transactions on the same account is the #1 reason expense tracking feels overwhelming. With a dedicated account, every transaction is rental-related by default.
If you have a credit card you use for property purchases, consider getting a separate card or at least keeping a clear record of which charges are rental-related. Basis lets you exclude personal transactions from reports, but separation at the bank level is always easier.
Step 2: Choose Your Tracking Method
There are three common approaches, each with different trade-offs:
Spreadsheets
Free and familiar. Download your bank statement as a CSV, paste it into Google Sheets, and add columns for property and category. This works for 1-2 properties but breaks down quickly at scale. You'll spend hours each month manually tagging transactions.
General Accounting Software (QuickBooks, Xero)
Powerful but not designed for landlords. You'll need to set up a chart of accounts that maps to Schedule E categories, create classes or locations for each property, and understand double-entry bookkeeping. Overkill for most small landlords.
Rental Property Software (Basis, Stessa, REI Hub)
Purpose-built tools that understand how landlords think about money: by property and by IRS category. The best ones connect to your bank, auto-categorize transactions, and generate Schedule E reports. See our comparison of rental tracking tools to find the right fit.
Step 3: Categorize Every Transaction
Every expense needs two things: a property (which rental was this for?) and a category (what type of expense was this?). Categories should map directly to IRS Schedule E lines: repairs, insurance, mortgage interest, property taxes, utilities, management fees, and so on.
Don't wait until year-end to do this. Spend 10 minutes each week reviewing new transactions. If you use a tool like Basis, most transactions are already categorized — you just confirm or correct them.
Step 4: Handle Credit Cards Properly
Credit cards add a layer of complexity. When you pay your credit card bill, your bank statement shows a single lump-sum payment. But that one payment might include $200 at Home Depot (repairs), $50 at the hardware store (supplies), and $150 for a personal dinner.
The solution: keep your credit card statement and use it to break down the lump-sum payment into individual expenses. In Basis, you upload the CC statement as evidence and it automatically splits the bank payment into categorized line items.
Step 5: Save Receipts
The IRS recommends keeping receipts for all business expenses, and requires them for any single expense over $75 (source: IRS Publication 463). Take a photo with your phone immediately after the purchase — don't let receipts pile up in a shoebox.
Digital storage is fine. The IRS accepts electronic records as long as they're legible and you can produce them on request. Keep them organized by property and year.
Step 6: Review Monthly
Set a calendar reminder for the 1st of each month. Spend 15-20 minutes reviewing the previous month's transactions:
- Are all transactions categorized?
- Is every expense assigned to the correct property?
- Are there any personal transactions mixed in?
- Do the totals match your bank statement?
This monthly habit turns tax prep from a weekend ordeal into a 30-minute exercise. By the time January rolls around, your data is already clean.
Step 7: Generate Reports at Tax Time
When tax season arrives, you should be able to generate a per-property income and expense summary that maps directly to Schedule E. If you've been categorizing throughout the year, this is just a button click. Hand the report to your CPA and you're done.
New to rental property accounting? Read our beginner's guide for a broader overview of the entire process.