Real estate chart of accounts in QuickBooks

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:

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.

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.

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. Setting up a different kind of client? See the construction, restaurant, law firm, trucking, and nonprofit 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.

How to import this template into QuickBooks Online

1. Download 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:

$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. Once clean, our monthly bookkeeping service keeps rent rolls, escrow balances, and property Class reports reconciled by the 5th business day of every month.