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 set up QuickBooks Online correctly for a new business from scratch?
Choose the right plan, set your fiscal year and accounting method, then customize the chart of accounts for your specific industry. The defaults QuickBooks gives you are generic and won't produce useful financial reports without modification.
Read answerHow do I separate bookkeeping for multiple rental properties owned in different LLCs?
Each LLC needs its own bank account, its own set of books, and its own tax return. In QuickBooks Online, use separate company files per LLC rather than trying to combine everything into one file.
Read answerHow do I track retainage in QuickBooks for construction projects?
QuickBooks Online doesn't have a built-in retainage feature. You need to create a Retainage Receivable account and a Retainage Payable account, then use line items and journal entries at each billing cycle to track what's being withheld.
Read answerHow 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 answerWhat home office deduction rules apply to real estate agents who work from home?
Real estate agents who work from home can claim the home office deduction if they meet the exclusive-use and regular-use tests. Most agents qualify because their home office serves as their principal place of business for administrative work.
Read answerHow do I account for service agreements and maintenance contracts in my HVAC business?
Record the payment as deferred revenue when collected, then recognize it as earned revenue when each service visit is performed. This prevents your P&L from overstating income in the months you collect and understating it in the months you do the work.
Read answer