Real Estate Investor Bookkeeping: How to Track Rental Income and Expenses

Real estate investing can generate significant tax advantages — depreciation, mortgage interest deductions, operating expense deductions, and more. But capturing those advantages requires accurate, property-level bookkeeping. Without it, you're leaving deductions on the table and handing your CPA a mess at tax time.

Here's how to set up your books as a real estate investor and what to track for each property.

The most important thing you can do as a real estate investor is track income and expenses at the property level — not just in aggregate. Your CPA needs a Schedule E for each rental property, and your lender (if you're refinancing or buying more properties) wants to see property-level performance.

In QuickBooks, you can accomplish this using classes or locations — one per property. Every transaction gets tagged to a property, so you can run a P&L for each one.

• Rent received (by month and tenant)
• Late fees
• Pet fees or other tenant charges
• Security deposits (these are liabilities, not income, until applied)

• Property management fees
• Repairs and maintenance
• Landscaping and snow removal
• Utilities (if landlord-paid)
• Insurance
• Property taxes
• HOA fees
• Advertising and leasing costs
• Professional services (legal, accounting)

• Mortgage principal payments (not deductible — this is a balance sheet item)
• Mortgage interest (deductible — tracked separately)
• Loan origination fees (amortized over the life of the loan)

This distinction matters enormously for taxes. A repair restores the property to its original condition and is fully deductible in the year it's paid. A capital improvement adds value or extends the useful life of the property and must be depreciated over time.

Examples:

• Fixing a broken window = repair (deductible now)
• Replacing all windows with new energy-efficient ones = capital improvement (depreciated)
• Patching a roof leak = repair
• Full roof replacement = capital improvement

Your bookkeeper needs to flag capital improvements so your CPA can set up the correct depreciation schedule.

Depreciation is the annual deduction you take for the wear and tear on your rental property. Residential rental property is depreciated over 27.5 years; commercial property over 39 years.

For a $300,000 residential rental property (excluding land value), that's roughly $10,900 per year in depreciation deductions — even if the property is appreciating in value.

To calculate depreciation correctly, you need:

• The purchase price of the property
• The value of the land (not depreciable)
• The date placed in service
• Any capital improvements (each depreciated separately)

Your CPA handles the depreciation calculation on your tax return, but your bookkeeper needs to maintain the records that make it possible.

Security deposits are not income when you receive them — they're a liability, because you may have to return them. Recording a security deposit as rental income overstates your income and creates a tax problem.

In QuickBooks, security deposits should be recorded as a liability (Security Deposits Held). When you apply a deposit to unpaid rent or damages, you move it from the liability account to income at that point.

A proper QuickBooks setup for a real estate investor includes:

• Classes or locations for each property
• Separate income and expense accounts for rental activity
• A liability account for security deposits
• Fixed asset accounts for each property (for depreciation tracking)
• Mortgage liability accounts for each loan

If you have multiple properties and they're all lumped together in one QuickBooks file without property-level tracking, you're missing the most valuable reporting your books can give you.

If you have more than two or three properties, the bookkeeping complexity grows quickly — especially if you have a mix of long-term rentals, short-term rentals (Airbnb/VRBO), and commercial properties. Each has different income patterns, expense categories, and tax treatment.

A bookkeeper who understands real estate can set up your books correctly, maintain property-level records, and make sure your CPA has everything they need at tax time.

The Gap ProAdvisors works with real estate investors to set up and maintain accurate books in QuickBooks Online. Contact us for a free consultation.