Free download
Rental property chart of accounts
A chart of accounts built around the form the books have to land on: every expense account maps to its Schedule E line, deposits and improvements are fenced off where they cannot inflate deductions, and the companion CSV imports straight into QuickBooks Online. No email, no signup.
- 38 accounts: assets, liabilities, equity, income, and the 15 Schedule E expense lines
- Every account carries its QuickBooks type, detail type, and Schedule E line
- The not-an-expense traps table: principal, deposits, improvements, escrow
Educational template, not tax or accounting advice. Account types use QuickBooks Online's names; the same structure works in any ledger.
Mirror Schedule E, do not invent categories
Every rental dollar eventually has to land on one line of Schedule E. A chart of accounts that mirrors those lines makes tax season a copy job; a chart of custom names ("House stuff", "Maintenance misc") makes it a translation project someone bills hours for. So the expense section here is the fifteen Schedule E lines, nothing cleverer:
| Account | Schedule E line |
|---|---|
| Advertising | Line 5 |
| Auto and travel | Line 6 |
| Cleaning and maintenance | Line 7 |
| Commissions | Line 8 |
| Insurance | Line 9 |
| Legal and professional fees | Line 10 |
| Management fees | Line 11 |
| Mortgage interest | Line 12 |
| Other interest | Line 13 |
| Repairs | Line 14 |
| Supplies | Line 15 |
| Property taxes | Line 16 |
| Utilities | Line 17 |
| Depreciation | Line 18 |
| Other (HOA, bank fees, pest control) | Line 19 |
Not sure which line a given expense belongs to? The Schedule E categorizer maps any expense to its line, and the categorization guide covers the judgment calls, repairs versus improvements above all.
The accounts that are not expenses
The expensive mistakes in rental books are almost never miscategorized expenses. They are non-expenses booked as expenses. Four kinds of money move through a rental account and never belong on Schedule E, and the chart gives each a fenced-off home:
| What happened | Where it goes | Booked as an expense it would |
|---|---|---|
| Mortgage principal | 2510 Mortgage payable | Overstate deductions by the principal, thousands a year |
| Security deposit received | 2100 Security deposits held | Inflate income now, double-count at move-out. Deposits are a liability until kept |
| New roof, HVAC, remodel | 1530 Capital improvements | Deduct in one year what the IRS spreads over 27.5 |
| Escrow slice of the payment | 1100 Escrow held by lender | Deduct the contribution and then the disbursement, twice |
The balance-sheet side of the chart exists for exactly these accounts. If you want to see them working together, the balance sheet template is the same structure with the numbers filled in.
One chart, one class per property
The scaling mistake is duplicating accounts per building: "Repairs, Oak St", "Repairs, Maple Ave", and eighteen months later a chart nobody can read. Keep one chart of accounts and put the per-property split in a different dimension: a QuickBooks class or location per property, one tag on every transaction. Every report can then split by building, which is what a per-property Schedule E actually needs, and adding a property adds one class, not thirty accounts.
Importing into QuickBooks
The CSV is shaped for QuickBooks Online's importer: Settings, then Chart of accounts, then the arrow next to New, then Import. Map the four columns (account number, name, type, detail type), turn account numbers on under Advanced settings if they are off, and the whole chart lands in one upload. Starting from a messy existing file instead of a fresh one? Run the QuickBooks cleanup checklist first; phase 3 of that checklist is making the chart look like this one.
The wider system this chart plugs into, the accounts, the workflow, and the habits that keep it current, is written up in the rental property accounting guide and the bookkeeping-from-scratch guide.
Frequently asked questions
What is a chart of accounts for a rental property?
The list of every account the books post to: bank accounts, the property and its loan, deposits held, rent income, and the expense categories. For a rental the design question has one right answer, because everything ends up on Schedule E. The expense accounts should be the fifteen Schedule E lines, the balance-sheet accounts should fence off the money that is not income or expense (deposits, principal, improvements), and nothing else is needed.
What accounts does a landlord actually need?
Fewer than most templates include. A dedicated checking account, a fixed-asset account for the building with land carved out, accumulated depreciation, the mortgage as a liability, a security-deposit liability, rent income, and the fifteen Schedule E expense lines. That is roughly 38 accounts in this template. Charts with hundreds of accounts do not produce better returns; they produce miscategorized transactions.
How do I set up a chart of accounts in QuickBooks for rental properties?
Import it rather than typing it. In QuickBooks Online: Settings, Chart of accounts, the arrow next to New, Import, then upload this template's CSV and map the four columns. Turn on account numbers under Advanced settings first. After the import, add one class or location per property so reports can split by building. The XLSX version carries the same list with a what-goes-here note per account.
Should each property have its own set of accounts?
No. Duplicating the expense accounts per building ('Repairs, Oak St', 'Repairs, Maple Ave') is the classic scaling mistake; the chart becomes unreadable and every report needs hand-assembly. Keep one chart of accounts and tag transactions with a class or location per property instead. One tag per transaction gives you a per-property P&L and a per-property Schedule E without a per-property chart.
What type of account is a security deposit?
A liability, because the money is owed back. This template holds deposits in 2100 Security deposits held (QuickBooks detail type Trust Accounts - Liabilities), ideally matched by a separate bank account. It touches income only at move-out, and only for the portion you keep: that slice moves to kept-deposit income on Schedule E line 3, and the refunded remainder just clears the liability.
Is a mortgage payment an expense?
Only one slice of it. A typical payment is three things at once: interest, which is the Schedule E line 12 deduction; principal, which reduces the loan liability and is never deductible; and an escrow contribution, which is an asset transfer until the lender pays the tax or insurance bill. Booked as one lump expense, the payment overstates deductions by the principal every single month. The chart gives each slice its own account.