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

What expense categories should I set up in QuickBooks for a cleaning business?

Start with cleaning supplies as cost of goods sold, then set up operating expense categories for labor, vehicles, insurance, equipment maintenance, marketing, uniforms, licensing, phone, and office costs. You should also separate residential and commercial income if you do both.

Read answer

How should a dental practice track PPO write-offs and fee schedule adjustments?

Record every procedure at your full UCR fee, then post the contractual adjustment as a separate entry. Track those adjustments by insurance company so you can see which PPO plans are actually profitable and which ones are costing you money.

Read answer

What bookkeeping system should I use to track insurance reimbursements by payer for my medical practice?

Use your practice management system for claims and aging, then reconcile monthly into QuickBooks Online. Set up each insurance payer as a customer in QBO so you can track payments, denials, and adjustments by payer.

Read answer

What is a construction labor burden rate and how do I calculate it?

Labor burden is everything you pay on top of base wages to employ someone, including payroll taxes, workers' comp, insurance, PTO, and other benefits. It typically adds 25-50% to the hourly rate, meaning a $25/hr worker actually costs $31-$37/hr.

Read answer

How do I classify my cleaning workers as employees vs independent contractors?

The IRS uses three tests to determine classification: behavioral control, financial control, and relationship type. Most cleaning workers who follow your schedule, use your supplies, and wear your uniform are employees, not independent contractors.

Read answer

How should I account for security deposits received and returned on rental properties?

Security deposits are a liability, not income. Record them to a liability account when received and reverse the entry when returned. If you retain any portion for damages, reclassify that amount to income and record the repair expense separately.

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