Bookkeeping, payroll, and tax services for small businesses across the Valley of the Sun.

Call or Text: (602) 730-4560

How do I track depreciation schedules for multiple rental properties in QuickBooks?

Start with your chart of accounts. Create a parent fixed asset account for each property, named something identifiable like the property address or a nickname you use consistently. Under each parent account, create sub-accounts for Building, Land, Improvements, and Accumulated Depreciation. This structure lets you see the total asset value for any single property while keeping the depreciable and non-depreciable portions separate.

The building sub-account is where your depreciable basis lives. For residential rental property, you depreciate the building over 27.5 years using the straight-line method. That means you divide the building’s cost basis by 27.5 to get your annual depreciation amount, then record that as a journal entry each year (or monthly if you want more accurate interim financials). The debit goes to depreciation expense and the credit goes to accumulated depreciation under that property.

Getting the cost basis right matters more than anything else in this process. Your depreciable basis for the building is the purchase price plus qualifying closing costs plus any capital improvements, minus the land value. Closing costs that get added to basis include title insurance, recording fees, transfer taxes, and legal fees directly tied to the acquisition. Loan origination fees and prepaid interest don’t count.

Land is never depreciated. You need to separate the land value from the building value for every property you own. Real estate investors commonly use the county tax assessor’s ratio between land and improvements as a starting point. If the assessor values land at 20% and improvements at 80%, you apply that same ratio to your purchase price. Land typically falls between 15% and 25% of total value in most Phoenix-area markets, though it varies by location and property type.

When you make capital improvements like a new roof, HVAC replacement, or kitchen remodel, those get added to the Improvements sub-account for that property. Each improvement starts its own 27.5 year depreciation schedule from the date it was placed in service. Repairs and maintenance get expensed immediately, so knowing the difference between an improvement and a repair is important for both your books and your tax return.

For investors with higher-value properties, a cost segregation study can identify components of the building that qualify for shorter depreciation periods. Things like appliances, carpeting, cabinetry, and certain fixtures can be depreciated over 5, 7, or 15 years instead of 27.5. This accelerates your deductions significantly in the early years of ownership. The study costs money, so it usually only makes sense on properties worth $500,000 or more, but the tax savings often dwarf the cost.

Keep a separate depreciation schedule outside of QuickBooks, even if it’s just a spreadsheet. Track the date acquired, original cost basis, land allocation, depreciable basis, annual depreciation amount, and accumulated depreciation to date for each property and each improvement. QuickBooks records the journal entries, but a standalone schedule gives you the backup documentation and makes it much easier when you sell a property and need to calculate gain.

If you have several properties and this is getting unwieldy, that’s a sign you need bookkeeping services from someone who understands real estate accounting. Getting depreciation wrong doesn’t just affect your current year taxes. It follows you through the life of the property and impacts your gain calculation when you eventually sell or exchange.

Your Valley of the Sun Bookkeeper

The Next Step:
A Quick Conversation

Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.

More Questions

How do I track commission splits and brokerage fees as a real estate agent on Schedule C?

Report the full gross commission on Schedule C line 1, then deduct the brokerage split as a commission expense. Never net them. Your 1099 shows the gross amount, and your return must match.

Read answer

How do I separate personal and business expenses as an owner-operator leased to a carrier?

Open a dedicated business bank account and route all carrier settlements there. Pay yourself through owner's distributions, use a business credit card for expenses, and track every deductible category separately. This keeps your books clean and prevents missed deductions at tax time.

Read answer

How should a pest control company handle recurring billing and revenue recognition?

Bill recurring contracts in advance or at time of service depending on your terms. If customers prepay, record the payment as deferred revenue and recognize it as each treatment is completed. Track recurring revenue separately from one-time jobs.

Read answer

How do I know if my bookkeeping is behind and what does a catch-up engagement involve?

Common signs include unreconciled bank accounts, missing financial statements, and unfiled tax returns. A catch-up engagement works through the backlog month by month, reconciling accounts and categorizing transactions until your books are current and accurate.

Read answer

How do I set up QuickBooks for a medical practice with multiple revenue streams?

Create classes for each revenue stream and use sub-accounts under income for every payer category. Then reconcile QuickBooks to your practice management system monthly so the two always agree.

Read answer

What IFTA reporting requirements do I need to track for my trucking company?

IFTA requires tracking miles and fuel purchases by jurisdiction, vehicle unit numbers, and trip dates for every qualified vehicle. Returns are filed quarterly, and non-compliance penalties range from $1,000 to $16,000 with possible out-of-service orders.

Read answer

Phoenix-based bookkeeping firm serving small businesses across the Valley of the Sun. We provide bookkeeping, payroll, tax preparation, and fractional CFO support with transparent pricing and no upselling. Owned and operated by David Morrow, a former COO with 20+ years of business experience.

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • QuickBooks Online Payroll Certification badge

© 2026 2Morrow Bookkeeping LLC