For landlords with a small number of rental properties, a spreadsheet can work if it is well-structured and consistently maintained. As portfolios grow, especially with multiple properties and increasing transaction volume, spreadsheets often become inefficient and harder to keep accurate at scale. The real challenge is not the tool itself, but maintaining clear, property-level tracking of income and expenses.
Good rental property bookkeeping goes beyond recording transactions, it organizes financial activity by property so you can see exactly what each asset earns, what it costs to operate, and how it performs over time. In our experience, investors who understand their numbers at the property level are better equipped to make informed decisions about holding, improving, or expanding their portfolio.
Why Per-Property Tracking Is Non-Negotiable
The IRS requires you to report rental income and expenses on Schedule E of your personal tax return and Schedule E is organized by individual property. If your bookkeeping lumps all properties together, your CPA must manually separate everything before filing, costing you time and money.
More importantly, per-property tracking reveals the truth. A property generating $18,000 in annual rent but costing $16,500 to operate is barely profitable. Without per-property books, that number is buried in the overall total and never seen.
What to Track for Each Rental Property
Income
• Monthly rent received by unit
• Late fees and pet fees collected
• Security deposits, recorded as a liability, NOT income, until forfeited by the tenant
Deductible Operating Expenses (Schedule E)
• Mortgage interest, only the interest portion, not principal
• Property taxes and insurance premiums
• Repairs and maintenance (distinguish from capital improvements, which are depreciated)
• Property management fees
• Advertising and tenant placement costs
• Legal and professional fees including bookkeeping
Non-Cash Deduction to Track Separately
Depreciation: Residential rental property is depreciated over 27.5 years under the IRS Modified Accelerated Cost Recovery System (MACRS). This is one of the most valuable deductions available to landlords and must be calculated by your CPA or bookkeeper.
How to Set Up QuickBooks for Multiple Rental Properties
QuickBooks Online works well for landlords when configured with the Classes or Locations feature to separate every transaction by property. Every income and expense transaction is tagged to a specific property class so you can run a profit and loss report per property or roll up across your entire portfolio for a combined view.
For 1 to 2 properties, this setup can be managed independently. For 3 or more properties, a bookkeeper who understands real estate accounting will configure this correctly from day one and maintain it monthly, saving hours of year-end reconciliation.
Commonly Missed Deductions Landlords Leave on the Table
• Mileage to the property for every drive to inspect, meet a contractor, or show a vacancy
• Home office deduction if you manage your portfolio from a dedicated home workspace
• Property management software subscriptions and landlord association memberships
• Legal fees for lease preparation, eviction proceedings, and tenant disputes
• Bookkeeping and accounting fees, the cost of professional bookkeeping is itself fully deductible
Frequently Asked Questions
How should I track income and expenses for multiple rental properties?
Use QuickBooks Online configured with separate Classes or Locations for each property. Every transaction is tagged to a specific property so you can generate individual profit and loss reports per unit or roll up across your entire portfolio for year-end reporting.
What expenses can landlords deduct on their taxes?
Landlords can generally deduct mortgage interest, property taxes, insurance, property management fees, advertising, and ordinary legal fees related to rental operations. Repairs and maintenance are deductible in the year incurred, while capital improvements must be depreciated over time. Mileage driven for rental property activities may be deducted using the IRS standard mileage rate (70 cents per mile in 2025), provided proper records are maintained. Bookkeeping and accounting fees related to managing rental activity are also deductible. Additionally, residential rental property is depreciated over 27.5 years based on the building value, not the land.
What is the difference between a repair and a capital improvement for rental properties?
A repair restores a property to its original condition and is fully deductible in the year it is paid. A capital improvement adds value or extends the useful life of the property and must be capitalized and depreciated over time. Examples include a new roof, kitchen remodel, or HVAC replacement.
How do I handle security deposits in my rental property books?
Security deposits are not income when received. They are a liability because you may need to return them. Record them as a liability in your bookkeeping until they are forfeited for unpaid rent or damages, at which point they become income.
Do I need a separate bank account for each rental property?
You do not legally need a separate account per property, but you do need at least one dedicated business bank account used exclusively for rental income and expenses. Using a personal account for rental transactions makes accurate bookkeeping nearly impossible.
Written by the UpKeep Books Team | Bookkeeping specialists serving small and medium-sized businesses across the United States | upkeepbooks.com
⚠ Disclaimer: This article is for informational purposes only and does not constitute tax, legal, or financial advice. Consult a licensed CPA or qualified tax advisor for guidance specific to your situation.