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 account for tip income and tip reporting requirements at my salon?

Your obligations depend on whether your stylists are W-2 employees or booth renters. Employees must report all tips to you, and tips over $20 per month are subject to FICA. Booth renters handle their own tip reporting on Schedule C.

Read answer

How do I set up job costing in QuickBooks Online for a general contractor?

Use sub-customers for each job, classes for cost categories like labor and materials, and enable the Projects feature for tracking. The chart of accounts needs to be structured for construction or the reports won't tell you anything useful.

Read answer

What payroll records am I legally required to keep and for how long?

Federal law requires you to keep most payroll records for at least 4 years. Arizona requires 4 years for unemployment records. Best practice is to keep everything for 7 years to cover all potential audit windows.

Read answer

What financial reports should a medical practice owner review monthly?

Focus on a P&L by provider, A/R aging by payer, collections vs charges ratio, overhead percentage, and days in A/R. Monthly review catches revenue and cash flow problems before they get out of hand.

Read answer

What are Arizona's requirements for filing state payroll taxes and Form A-4?

Arizona uses a unique flat-percentage withholding system where employees choose their rate on Form A-4. Employers deposit withholding quarterly using Form A1-QRT and file an annual reconciliation on Form A1-R by February 28.

Read answer

Are there any Arizona-specific tax credits or incentives for small businesses I should know about?

Arizona offers several tax credits that many small businesses overlook. The most notable include the Quality Jobs Tax Credit, the R&D tax credit, Military Reuse Zone credits, and the Angel Investment Tax Credit. Work with a tax professional to determine which ones apply to your situation.

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