---
title: "Real estate chart of accounts in QuickBooks | Ledgerbrook"
source: https://ledgerbrook.com/blog/chart-of-accounts-for-real-estate/
description: "Property-level Class tracking, tenant security deposit escrow, CapEx vs repairs, and a free QBO chart of accounts."
---

[Blogs](/blog/)

# Real estate chart of accounts in QuickBooks

October 5, 2026 · [Omkar Moraye](/about/)

[](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dlinkedin%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](https://x.com/intent/post?url=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dx%26utm_medium%3Dsocial%26utm_campaign%3Dshare&text=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks)[](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dfacebook%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](mailto:?subject=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks&body=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks%0A%0Ahttps%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Demail%26utm_medium%3Dsocial%26utm_campaign%3Dshare)

## What is the best chart of accounts for real estate in QuickBooks Online?

A real estate chart of accounts needs 2 paired accounts for tenant security deposits: a restricted escrow bank account and an equal liability. It tracks each property with Classes, splits every mortgage payment into principal, interest, and escrow, and keeps capital improvements separate from repairs you can deduct this year.

## Why generic QuickBooks setups fail real estate investors

The standard chart of accounts provided by QuickBooks Online was built for basic retail and consulting businesses. It assumes a company earns revenue by selling products or services from a single operational location.

In real estate investment and property management, that basic layout creates four blind spots:

1. **No visibility into individual property profitability:** Lumping rent and repair costs together hides which rental units generate strong cash-on-cash returns and which properties bleed cash through maintenance.
2. **Commingled tenant security deposits:** Depositing tenant security deposits into operating checking and spending them on repairs breaks the law in states that require deposits to be held separately, and leaves no cash for move-out refunds anywhere.
3. **Distorted mortgage expense reporting:** Coding monthly bank feed mortgage payments to a single “Mortgage Expense” line mixes deductible interest with principal debt paydown, artificially depressing reported net income while leaving balance sheet liability balances unchanged.
4. **Muddled capital asset capitalization:** Writing off $15,000 roof replacements as current-year repairs instead of capitalizing them into fixed asset accounts overstates current-year deductions and leaves the asset off the depreciation schedule.

A real estate chart of accounts fixes all four with property-level tracking, paired escrow accounts, and separate capital asset accounts.

You can download this complete real estate account hierarchy formatted for one-click import into QuickBooks Online:

### Download the Real Estate QBO Chart of Accounts

33-account QuickBooks Online template with security deposit escrow, mortgage splits, and CapEx tracking.

[Download QBO CSV](/downloads/chart-of-accounts/real-estate-chart-of-accounts-quickbooks.csv)

## The three structural rules of real estate bookkeeping

To maintain clean books across single-family rentals, multi-family portfolios, and commercial leases, your file must adhere to three foundational rules:

### Rule 1: Use Class tracking instead of duplicating accounts

The most common failure mode in rental property bookkeeping is creating duplicate accounts for every street address:

> _The wrong approach:_ Account 5100 (Repairs - 104 Main St), Account 5101 (Repairs - 208 Elm St), Account 5102 (Repairs - 412 Oak Ave)…

This practice inflates the chart of accounts to hundreds of entries, rendering balance sheets unreadable and cluttering the register.

Instead, create **one master expense account** (e.g. Account 5010: Property Maintenance & Repairs). In QuickBooks Online Plus or Advanced, enable **Classes** under **Account and Settings > Advanced > Categories > Track classes**. Set up each property as a Class. If each property sits in its own LLC, each LLC normally needs its own QuickBooks file; Classes split properties that belong to one entity. When entering an invoice or matching a bank feed transaction, assign the property Class.

This enables you to generate a **Profit & Loss by Class** report, showing individual property columns side by side on one page.

### Rule 2: Segregate tenant security deposits in escrow

Tenant security deposits do not belong to the landlord or property manager. They remain the tenant’s money until the lease ends, less any lawful deductions. Rules vary by state: some require a separate account (a few require it to earn interest for the tenant), others only set a deadline for returning the deposit. A separate escrow account is the safe default everywhere.

A compliant setup requires two paired accounts:

- **Account 1030: Tenant Security Deposit Escrow (Bank Asset):** The dedicated bank account where deposit checks are lodged.
- **Account 2120: Tenant Security Deposits Held (Other Current Liability):** The mirror balance sheet liability reflecting the total security deposit amount owed back to tenants.

These two accounts must always match. If Account 1030 has $8,000 in cash but Account 2120 shows $12,000, tenant deposit funds were improperly transferred or spent. The entries for receiving, keeping and refunding a deposit through these two accounts are in our post on [security deposit accounting](/blog/security-deposit-accounting/).

### Rule 3: Split mortgage payments into principal, interest, and escrow

When a mortgage payment autodrafts from checking, the bank feed transaction represents three distinct financial elements:

| Component | Destination Account | Accounting Nature |
| --- | --- | --- |
| **Principal Paydown** | Account 2510 (Mortgages Payable) | Reduces balance sheet long-term liability |
| **Mortgage Interest** | Account 6100 (Mortgage Interest Expense) | Current-year tax-deductible expense on P&L |
| **Tax & Insurance Escrow** | Account 1450 (Lender Escrow Asset) | Prepaid current asset held by lender |

Coding the entire draft to an expense line overstates deductions and fails to reduce your mortgage note on the balance sheet.

## CapEx vs repairs: what the IRS lets you expense

Improvements to a building are capitalized and depreciated over 27.5 years (residential rental) or 39 years (nonresidential). Repairs that keep the property in ordinary working condition are deducted in the year you pay them. The IRS tangible property regulations treat a cost as an improvement if it is a **betterment** (makes the property better than it was), a **restoration** (replaces a major component or building system, such as the roof or HVAC), or an **adaptation** (converts the property to a new use).

Three safe harbors let you expense costs without arguing those tests:

| Safe harbor | Limit | How it works |
| --- | --- | --- |
| **De minimis** (Treas. Reg. §1.263(a)-1(f)) | $2,500 per invoice or item, for owners without an audited financial statement | Annual election statement filed with the return; your accounting policy must expense items under the limit |
| **Routine maintenance** (§1.263(a)-3(i)) | Recurring work you expect to do more than once in the building’s first 10 years | No election needed |
| **Small taxpayer** (§1.263(a)-3(h)) | Lesser of $10,000 or 2% of the building’s unadjusted basis per year; building basis $1 million or less; average gross receipts $10 million or less | Annual election, made building by building |

- **Expensed under Account 5010 (Repairs):** Replacing a broken dishwasher ($800), repainting a unit between tenants ($1,800), or fixing a leaking pipe ($650).
- **Capitalized under Account 1600 (Building Improvements):** Installing a new central HVAC system ($9,500), replacing the roof ($18,500), or adding a patio ($12,000).

Account 1600 builds the depreciable basis your CPA reports on Form 4562. Roofs, HVAC, and most other building components follow the building’s 27.5- or 39-year life and do not qualify for bonus depreciation. Land improvements and items a cost segregation study reclassifies to shorter lives can. For the exact debits and accumulated contra-asset mechanics, see our worked guide on the [journal entry for depreciation](/blog/journal-entry-for-depreciation/).

## Complete real estate chart of accounts hierarchy

Below is the full 33-account chart for residential investors, commercial landlords, and property managers:

| Number | Account Name | Account Type | Detail Type |
| --- | --- | --- | --- |
| **1010** | Property Operating Checking | Bank | Checking |
| **1030** | Tenant Security Deposit Escrow | Bank | Rents Held in Trust |
| **1100** | Tenant Accounts Receivable (Rent Arrears) | Accounts Receivable (A/R) | Accounts Receivable (A/R) |
| **1450** | Lender Property Tax & Insurance Escrow | Other Current Assets | Other Current Assets |
| **1500** | Land (Non-Depreciable) | Fixed Assets | Land |
| **1505** | Land Improvements (Paving, Fencing, Landscaping) | Fixed Assets | Other fixed assets |
| **1510** | Rental Property Buildings | Fixed Assets | Buildings |
| **1520** | Accumulated Depreciation - Buildings & Improvements | Fixed Assets | Accumulated Depreciation |
| **1600** | Capitalized Building Improvements (CapEx) | Fixed Assets | Buildings |
| **2010** | Accounts Payable - Contractors & Vendors | Accounts Payable (A/P) | Accounts Payable (A/P) |
| **2020** | Property Operating Credit Card | Credit Card | Credit Card |
| **2120** | Tenant Security Deposits Held | Other Current Liabilities | Rents in trust - Liability |
| **2130** | Prepaid Tenant Rent | Other Current Liabilities | Other Current Liabilities |
| **2510** | Mortgages Payable (Long-Term Notes) | Long Term Liabilities | Notes Payable |
| **3010** | Owner / Investor Capital Contributions | Equity | Owner’s Equity |
| **3020** | Owner Equity Draws & Distributions | Equity | Owner’s Equity |
| **3030** | Retained Earnings | Equity | Retained Earnings |
| **4010** | Residential Rental Income | Income | Other Primary Income |
| **4020** | Commercial Lease Revenue | Income | Other Primary Income |
| **4030** | Late Fees & Tenant Charges | Income | Other Primary Income |
| **4040** | Utility Reimbursement Income (RUBS) | Income | Other Primary Income |
| **5010** | Property Maintenance & Turnover Repairs | Expenses | Repair & Maintenance |
| **5020** | Property Management Commissions | Expenses | Other Business Expenses |
| **5030** | Landscaping & Snow Removal | Expenses | Repair & Maintenance |
| **5040** | Trash, Water & Sewer Utilities | Expenses | Utilities |
| **5050** | Property Real Estate Taxes | Expenses | Taxes Paid |
| **5060** | Landlord Property & Casualty Insurance | Expenses | Insurance |
| **5070** | HOA Dues & Condo Assessments | Expenses | Dues & Subscriptions |
| **6010** | Advertising & Vacancy Marketing | Expenses | Advertising/Promotional |
| **6020** | Legal, Eviction & Professional Fees | Expenses | Legal & Professional Fees |
| **6030** | Pest Control & Extermination | Expenses | Other Business Expenses |
| **6100** | Mortgage Interest Expense | Expenses | Interest Paid |
| **7010** | Gain or Loss on Sale of Real Estate | Other Income | Other Miscellaneous Income |

You can explore and filter this structure in our interactive [Real Estate Chart of Accounts directory](/tools/chart-of-accounts/real-estate/). Setting up a different kind of client? See the [construction](/blog/chart-of-accounts-for-contractors/), [restaurant](/blog/restaurant-chart-of-accounts/), [law firm](/blog/chart-of-accounts-for-law-firms/), [trucking](/blog/chart-of-accounts-for-trucking/), and [nonprofit](/blog/chart-of-accounts-for-nonprofits/) versions.

## Worked entries: mortgage payments and security deposits

### Transaction 1: The monthly $2,450 mortgage split

Your bank feed displays a recurring $2,450.00 withdrawal for your rental property loan. Based on the lender’s monthly statement, split the transaction across three accounts:

| Date | Account | Debit | Credit |
| --- | --- | --- | --- |
| Oct 1 | 2510 Mortgages Payable (Principal Reduction) | 650.00 | |
| Oct 1 | 6100 Mortgage Interest Expense | 1,300.00 | |
| Oct 1 | 1450 Lender Property Tax & Insurance Escrow | 500.00 | |
| Oct 1 | 1010 Property Operating Checking | | 2,450.00 |

When the lender pays the property tax or insurance bill out of escrow, record a journal entry debiting Account 5050 (Property Taxes) or 5060 (Insurance) and crediting Account 1450 (Lender Escrow). Reconcile 1450 to the lender’s annual escrow statement.

### Transaction 2: Tenant deposits a $2,000 security deposit

A new tenant signs a lease and pays a $2,000 security deposit:

| Date | Account | Debit | Credit |
| --- | --- | --- | --- |
| Oct 15 | 1030 Tenant Security Deposit Escrow | 2,000.00 | |
| Oct 15 | 2120 Tenant Security Deposits Held | | 2,000.00 |

Net P&L income impact: $0.00. The funds remain protected on the balance sheet.

### Transaction 3: Capitalizing an $18,500 roof replacement

A general contractor completes a full tear-off roof replacement for $18,500:

| Date | Account | Debit | Credit |
| --- | --- | --- | --- |
| Oct 20 | 1600 Capitalized Building Improvements (CapEx) | 18,500.00 | |
| Oct 20 | 1010 Property Operating Checking | | 18,500.00 |

The asset basis increases on the balance sheet, ready for annual MACRS depreciation schedules.

## The 4 most common real estate bookkeeping errors

1. **Recording gross rent from net property manager distributions:** If your property manager collects $3,000 in rent, deducts $300 in management commissions and $200 for a plumber, and deposits $2,500 into your account, categorizing the $2,500 as “Rental Income” understates gross revenue by $500 and erases your tax deductions for management and repairs.
2. **Failing to separate land from building basis:** Land does not depreciate under IRS tax law. When purchasing a property for $400,000, use the county assessor’s land-to-improvement ratio or an appraisal to allocate the purchase price between Account 1500 (Land, non-depreciable) and Account 1510 (Buildings, depreciable).
3. **Leaving tenant security deposits in operating accounts:** Spending security deposit cash on current operations leaves you unable to refund tenant deposits at move-out and can trigger penalties in states with deposit-handling rules.
4. **Skipping Class tracking across properties:** Running multiple rental properties through one bank account without Class tracking turns tax preparation into an expensive manual reconciliation.

For the month-to-month workflow behind these accounts (rent clearing, deposit move-outs, mortgage splits, and the closing checklist), see our guide to [real estate bookkeeping in QuickBooks](/blog/bookkeeping-for-real-estate/).

## How to import this template into QuickBooks Online

1. Download [`real-estate-chart-of-accounts-quickbooks.csv`](/downloads/chart-of-accounts/real-estate-chart-of-accounts-quickbooks.csv).
2. Turn on account numbers under **Account and Settings > Advanced > Chart of accounts**.
3. Open QuickBooks Online and select the **Gear icon** in the top right header.
4. Choose **Tools > Import data > Chart of Accounts**.
5. Upload the downloaded CSV file, then click **Next**.
6. Verify column mappings for `Account Number`, `Account Name`, `Type`, and `Detail Type`.
7. Confirm the accounts and select **Import**.

## When real estate books require a historical cleanup

If past bookkeepers added net rental deposits, expensed mortgage principal payments, or left security deposit escrow accounts unreconciled, importing a new chart of accounts cannot resolve historical balance sheet errors.

Restoring accurate property records requires a specialized [QuickBooks cleanup](/quickbooks-cleanup/):

$99per month of backlog20% off 6+ months

We reconstruct historical property basis, reconcile security deposit liabilities, and split past mortgage autodrafts into principal and interest. If your rental portfolio needs balance sheet verification, submit your file for review on our [contact page](/contact/?from=blog%2Fchart-of-accounts-for-real-estate). Once clean, our [monthly bookkeeping service](/monthly-bookkeeping/) keeps rent rolls, escrow balances, and property Class reports reconciled by the 5th business day of every month.

Ledgerbrook

Behind on your QuickBooks books?

Cleanup or catch-up

$99 per month of backlog, 20% off 6+ months

Turnaround

5 business days for a typical year

Monthly close

From $99 a client file a month

[Get a free file review](/contact/?from=blog%2Fchart-of-accounts-for-real-estate)

Free, no card. A written answer within about 48 hours.

[See every price](/pricing/)

Certified

- [![Intuit QuickBooks Certification Level 1](/_astro/level-1.BokmyvzE_Z2cyGo6.webp)](https://www.credly.com/badges/7ceaf1c4-83da-4a1b-b19f-7e15cb5c0ac7/public_url "Intuit QuickBooks Certification Level 1. Verify on Credly.")
- [![Intuit QuickBooks Certification Level 2](/_astro/level-2.D-GWLUNI_Z1Sh5RD.webp)](https://www.credly.com/badges/02426568-00bb-46e1-a939-9063497c54d6/public_url "Intuit QuickBooks Certification Level 2. Verify on Credly.")
- [![Intuit Bookkeeping Certification](/_astro/bookkeeping.C82JE0Dn_Z1YzPBj.webp)](https://www.credly.com/badges/30b70ae2-e369-4a8b-9fee-d6db3a47b70c/public_url "Intuit Bookkeeping Certification. Verify on Credly.")
- [![QuickBooks Online Payroll Certification](/_astro/payroll.r5Yo2XnL_VxspM.webp)](https://www.credly.com/badges/2fc8fb7d-90d1-43ba-961b-aff161fe8491/public_url "QuickBooks Online Payroll Certification. Verify on Credly.")

Issued by Intuit, verified by Credly.

Published October 5, 2026

Share this post[](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dlinkedin%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](https://x.com/intent/post?url=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dx%26utm_medium%3Dsocial%26utm_campaign%3Dshare&text=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks)[](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Dfacebook%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](mailto:?subject=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks&body=Real%20estate%20chart%20of%20accounts%20in%20QuickBooks%0A%0Ahttps%3A%2F%2Fledgerbrook.com%2Fblog%2Fchart-of-accounts-for-real-estate%2F%3Futm_source%3Demail%26utm_medium%3Dsocial%26utm_campaign%3Dshare)

Continue Reading[All blogs →](/blog/)

[

 Previous BlogOctober 5, 2026

### Law firm chart of accounts in QuickBooks

IOLTA trust accounting, three-way reconciliation, client retainer clearing, and an import-ready QuickBooks Online template.

Read previous post →

](/blog/chart-of-accounts-for-law-firms/)[

Next Blog October 6, 2026

### Bookkeeping for law firms in QuickBooks

Law firm bookkeeping in QuickBooks Online: IOLTA trust entries, three-way reconciliation, advanced costs, billing sync.

Read next post →

](/blog/bookkeeping-for-law-firms/)