Real Estate Chart of Accounts: Track Tenant Deposits, Depreciation, and Mortgage Debt
A complete guide to setting up your real estate and rental property chart of accounts in QuickBooks. Learn how to track tenant receivables and security deposits, depreciate buildings and equipment separately, and keep property-level mortgage debt out of your operating expenses.
If you own or manage rental property, the default QuickBooks chart of accounts leaves out the accounts that actually matter. One "Rental Income" line and one "Repairs" line can't tell you whether a building is profitable after debt service, whether you're holding enough cash to cover every tenant's deposit, or which asset class is driving your depreciation expense.
This guide walks through the accounts a real estate or rental business needs beyond the generic starting point.
Why Rental Property Needs More Than a Generic Chart of Accounts
Three things make real estate accounting different from a typical small business:
- Tenant money isn't your money yet. Security deposits belong to the tenant until they move out. Under GAAP (Generally Accepted Accounting Principles), that means a deposit is a liability on your books — not income — and the cash backing it should be traceable, not blended into your general operating cash.
- A building isn't one asset. Land doesn't depreciate. Buildings, HVAC equipment, appliances, and vehicles each wear out on their own schedule, so lumping them into a single "Fixed Assets" account makes your depreciation expense impossible to check.
- Property-level costs aren't operating expenses. Repairs, property taxes, and on-site labor are direct costs of running the property — closer to cost of goods sold than to office overhead. Mixing the two hides whether a specific property is actually profitable before you get to corporate overhead.
The Accounts That Do the Work
Here are the accounts from our real estate chart of accounts template that carry the industry-specific logic — not the generic checking, credit card, and owner's equity accounts every business needs, but the ones a rental operation can't run without.
| Account | Number | Purpose |
|---|---|---|
| Tenant Receivables | 1210 | Outstanding rent and fees owed by tenants |
| Security Deposits Held | 1300 | Tenant deposits held separately, backing the deposit liability |
| Tenant Security Deposits | 2200 | Liability for deposits you owe back to tenants |
| Prepaid Rent | 2210 | Rent collected in advance, before it's been earned |
| Investment Properties | 1500 | Rental properties owned, carried at cost |
| Accumulated Depreciation - Buildings | 1590 | Depreciation taken on buildings, tracked apart from equipment |
| Mortgage Payable - Property 1 | 2500 | Mortgage balance tied to a specific property |
| Mortgage Interest Expense | 7010 | The interest portion of the mortgage payment, separate from principal |
| Property Maintenance & Repairs | 5100 | Direct repair costs, booked as a cost of operating the property |
| Property Taxes | 5300 | Real estate property taxes, booked as a direct property cost |
| Forfeited Security Deposits | 4710 | Deposit amounts kept for damages after a tenant moves out |
How This Gets Booked: Rent Roll and a Tenant Move-Out
Say you manage a 12-unit building at $1,500 a month per unit. At the start of the month, you book the full rent roll in one entry: debit Tenant Receivables (1210) for $18,000, credit Rental Income - Residential (4000) for $18,000. As payments land in the bank, each one clears part of that receivable — so at any point, the balance of Tenant Receivables tells you exactly who still owes rent.
Now a tenant moves out. Their $1,500 deposit has been sitting in Security Deposits Held (1300), a restricted asset, offset by the Tenant Security Deposits (2200) liability for the same amount. There's $200 in damage beyond normal wear. You debit Tenant Security Deposits (2200) for the full $1,500 to clear the liability, credit Security Deposits Held (1300) for $1,300 (the refund check), and credit Forfeited Security Deposits (4710) for the $200 you keep. The deposit never touched your income statement until the day you actually earned part of it.
How This Gets Booked: Buying a Property and Depreciating It
You buy a duplex for $340,000 — $60,000 allocated to land, $280,000 to the building — financed with a $270,000 mortgage. You debit Land (1510) for $60,000 and Buildings (1520) for $280,000, credit Mortgage Payable - Property 1 (2500) for $270,000, and credit Checking for the $70,000 down payment. Land never depreciates; it stays on the books at cost until you sell.
Each mortgage payment splits in two: part reduces the Mortgage Payable (2500) principal, part is Mortgage Interest Expense (7010). Pull the split from your amortization schedule rather than booking the whole payment as interest — early payments skew heavily toward interest, and treating the full amount as an expense overstates your costs and understates what you actually owe.
At year-end, depreciation is booked by asset class, not as one number. The building's share is debited to Depreciation Expense (6700) and credited to Accumulated Depreciation - Buildings (1590), spread over the building's long usable life. If the property also has separately purchased HVAC systems or appliances sitting in Equipment & Appliances (1540), those depreciate on a much shorter schedule and post to Accumulated Depreciation - Equipment (1591) instead. Keep them apart — a chart of accounts with a single depreciation bucket can't show you when the equipment is fully written off and the building isn't, or the reverse.
Get Started
Our real estate chart of accounts template includes tenant receivables, security deposit tracking, per-property mortgage accounts, and depreciation split by asset class — pre-configured and ready to import into QuickBooks. It takes 60 seconds to optimize and gives your rental business the reporting structure it needs.