QueueFortressBookkeeping

Rental Property Chart of Accounts: A Complete Template for Real Estate Investors

Jay Fortner, QuickBooks ProAdvisor

A rental property chart of accounts is the master list of categories every transaction in your portfolio gets recorded to, organized into income, expense, asset, liability, and equity accounts. The most effective design mirrors the expense categories on IRS Schedule E, uses one shared account list across all properties, and tracks each property with QuickBooks Online Classes instead of duplicate accounts. This guide includes a complete numbered template you can copy, with the QuickBooks account type for every line.

A rental property chart of accounts is the master list of categories that every transaction in your rental business gets recorded to — organized into five sections: income, expenses, assets, liabilities, and equity. The best design for a U.S. rental investor mirrors the expense categories on IRS Schedule E, uses one shared account list for the whole portfolio, and tracks each property with QuickBooks Online Classes rather than a duplicate set of accounts per property. Below is a complete, numbered template you can copy into QuickBooks Online today, including the account type for every line and a worked example showing how a mortgage payment splits across it.

Who this template is for

QuestionAnswer
Best forLong-term rental investors with 1–50 units, including portfolios spread across multiple LLCs and bank accounts
Not intended forFix-and-flip projects (which need job costing and work-in-progress accounts) or property managers holding client trust funds
Complexity levelBeginner to intermediate — no accounting background assumed
Software assumedQuickBooks Online (Plus or Advanced if you want per-property Class tracking)
When professional help makes senseMultiple entities, mid-year takeovers of messy books, refinances and rehabs, or a CPA who keeps asking for cleaner year-end records

Short-term rental operators can start from this same structure, but Airbnb and VRBO payouts add clearing accounts and platform fees — see our guide to bookkeeping for short-term rentals for that variation.

Why Schedule E should drive your account design

Most rental income and expenses for individually owned residential rentals are ultimately reported on Schedule E (Form 1040), which uses a fixed set of expense lines: advertising; auto and travel; cleaning and maintenance; commissions; insurance; legal and other professional fees; management fees; mortgage interest; other interest; repairs; supplies; taxes; utilities; depreciation; and other expenses (2025 instructions, checked July 2026).

That list is a gift to your bookkeeping. If your expense accounts map cleanly onto those lines, year-end tax preparation becomes a report handoff instead of a re-categorization project. You are not doing your taxes in QuickBooks — your CPA determines final tax treatment — but designing the books so each expense account rolls up to one tax line means your preparer spends billable hours on strategy, not sorting.

Two design rules follow from this:

  • Don't invent creative categories. "Miscellaneous property stuff" helps no one. Every account below maps to a Schedule E line or a balance-sheet purpose.
  • Don't duplicate accounts per property. Ten properties times fifteen expense accounts is 150 expense accounts and an unreadable profit and loss. Use one account list and tag each transaction with a property Class instead.

The complete rental property chart of accounts template

The template uses standard number blocks: 1000s for assets, 2000s for liabilities, 3000s for equity, 4000s for income, 5000s for operating expenses, and 6000s for non-operating items. Gaps are left between numbers on purpose so you can insert accounts later without renumbering. The QuickBooks Online account type shown for each line controls which financial statement the account reports on, so match it exactly when you create the account.

Income accounts (4000s)

No.AccountQBO account typeNotes
4010Rental IncomeIncomeBase rent only; map to property via Class
4020Late Fees & NSF FeesIncomeKeep separate from rent so collections problems are visible
4030Pet Rent & Pet FeesIncomeMap to property via Class
4040Application & Admin FeesIncomeMap to property via Class
4050Utility ReimbursementsIncomeTenant-billed utilities (RUBS); do not net against the utility expense
4060Laundry, Parking & Storage IncomeIncomeMap to property via Class
4090Forfeited Security DepositsIncomeOnly when a deposit is kept for damages or unpaid rent — see the deposit note below
4910Interest IncomeOther IncomeBank interest on operating and reserve accounts; not property operations

Expense accounts (5000s–6000s)

No.AccountQBO account typeNotes
5010Advertising & MarketingExpensesListings, signage, photos; aligns with Schedule E "Advertising"
5020Auto & TravelExpensesKeep a mileage log — your CPA needs it to support this line
5030Cleaning & MaintenanceExpensesTurnovers, landscaping, pest control, snow removal; map to property via Class
5040Leasing CommissionsExpensesTenant-placement fees paid to agents or managers
5050InsuranceExpensesLandlord/hazard/umbrella premiums; map to property via Class
5060Legal & Professional FeesExpensesAttorneys, evictions, CPA fees
5065Bookkeeping & AccountingExpensesSub-account of 5060 if you want one roll-up line
5070Property Management FeesExpensesMonthly PM fees; keep separate from leasing commissions
5080Mortgage InterestExpensesInterest portion only — principal is never an expense (see worked example)
5085Other InterestExpensesHELOC, private-loan, or credit-card interest tied to the rental activity
5090RepairsExpensesWork that keeps the property in operating condition; larger renovation-type work goes to 1430 — see the repairs vs. improvements section
5100SuppliesExpensesConsumables: filters, batteries, small hardware
5110Property TaxesExpensesRecord when paid by you or disbursed from escrow, not when escrowed
5115Licenses & Registration FeesExpensesRental licenses, inspections; jurisdiction-specific
5120UtilitiesExpensesOwner-paid electric, gas, water/sewer, trash; map to property via Class
5130HOA DuesExpensesRolls up to Schedule E "Other" — list separately for your CPA
5140Bank & Merchant FeesExpensesAccount fees, rent-collection platform fees
5150Software & SubscriptionsExpensesQuickBooks, listing tools, screening services
6010Depreciation ExpenseOther ExpensePosted at year end from your CPA's depreciation schedule — do not estimate this yourself

Asset accounts (1000s)

No.AccountQBO account typeNotes
1010Operating Checking – [Entity]BankOne per real bank account; never mix personal spending here
1020Security Deposit Bank AccountBankSeveral states require deposits held in a separate or escrow account — check your state's rules
1030Reserve SavingsBankCapital-expenditure and vacancy reserves
1200Tenant ReceivablesAccounts ReceivableOptional — use if you invoice rent and track unpaid balances
1300Mortgage Escrow – Taxes & InsuranceOther Current AssetsMoney the servicer holds for you is your asset until disbursed (see worked example)
1400Land – [Property]Fixed AssetsAllocated at purchase; land is not depreciated
1410Buildings – [Property]Fixed AssetsBuilding portion of purchase price plus closing costs your CPA capitalizes
1430Capital Improvements – [Property]Fixed AssetsRenovations, roofs, HVAC replacements; your CPA determines final capitalization
1440Appliances & EquipmentFixed AssetsSeparately depreciable items per your CPA's schedule
1490Accumulated DepreciationFixed AssetsContra-asset; posted from the CPA's depreciation schedule at year end
1600Loan Costs (Net of Amortization)Other AssetsFinancing costs your CPA amortizes over the loan term

Liability accounts (2000s)

No.AccountQBO account typeNotes
2010Business Credit CardCredit CardOne per real card; connect the bank feed
2100Security Deposits HeldOther Current LiabilitiesRefundable deposits are a liability, not income, while you intend to return them
2300Mortgage Payable – [Property]Long Term LiabilitiesOne account per loan so payoff balances reconcile to lender statements
2400HELOC PayableLong Term LiabilitiesTrack draws and paydowns separately from first mortgages
2500Due To/From Related EntitiesOther Current LiabilitiesIntercompany transfers between your LLCs — reconcile monthly so they net to zero across entities
2600Loan from Owner/MemberLong Term LiabilitiesFormal owner loans only; informal funding belongs in contributions (3010)

Equity accounts (3000s)

No.AccountQBO account typeNotes
3010Owner/Member ContributionsEquityPersonal cash you put into the business; one sub-account per member in a partnership
3020Owner/Member DistributionsEquityCash you take out; never record draws as an expense
3900Retained EarningsEquityQuickBooks creates and rolls this automatically at year end

Setting it up in QuickBooks Online: account types, detail types, and Classes

Three mechanics matter when you build this list in QuickBooks Online:

  • Account type controls the report. The account type (Income, Expenses, Bank, Fixed Assets, Long Term Liabilities, Equity, and so on) determines whether an account appears on the profit and loss or the balance sheet. Get the type wrong and the account shows up on the wrong statement — the most common reason investor books show mortgage principal as an "expense."
  • Detail type is just a sub-label. QuickBooks also asks for a detail type. It helps organize the list but does not change where the data reports, so pick the closest match and move on.
  • Classes give you property-level reporting. Create one Class per property (and sub-classes per unit if needed), tag every income and expense line with its Class, and you can run a profit and loss by property from one company file. Class tracking is available on the QuickBooks Online Plus and Advanced plans — not Simple Start or Essentials — and is turned on under Settings, Account and settings, Advanced, Categories.

This structure — one company file per legal entity, one shared chart of accounts, one Class per property — is the setup we use for nearly every rental client. The step-by-step build, including bank feeds and recurring transactions, is covered in our guide to setting up QuickBooks Online for landlords. If you operate several LLCs, the entity-level file question gets its own treatment in bookkeeping for multiple LLCs.

Worked example: splitting one mortgage payment correctly

The numbers below are illustrative, not from a client. Suppose your servicer drafts $1,850 on the 1st for the Maple Street duplex. The statement shows principal $410, interest $1,010, and escrow $430. One bank-feed line, three very different destinations:

Split lineAmountAccountQBO account typeWhat it does
Principal$4102300 Mortgage Payable – Maple StLong Term LiabilitiesReduces the loan balance; not an expense
Interest$1,0105080 Mortgage InterestExpensesHits the P&L; Class = Maple St
Escrow$4301300 Mortgage Escrow – Taxes & InsuranceOther Current AssetsMoves your cash into an asset the servicer holds; not yet an expense

Later, when the servicer pays the county $2,580 in property taxes out of escrow, you record that disbursement as $2,580 to 5110 Property Taxes and reduce the 1300 escrow balance by the same amount. Tag every line with the property Class. Done this way, your P&L shows only true operating costs, your balance sheet ties to the lender's payoff statement, and your escrow account reconciles to the annual escrow analysis. Investors who record the entire $1,850 as "mortgage expense" overstate operating costs by the principal amount every single month — one of the most common errors we find in cleanup work.

Repairs vs. improvements: bookkeeping, tax, and management views

This is where a chart of accounts quietly earns its keep, because the same invoice can mean three different things:

  • Bookkeeping: Record work that keeps the property in ordinary operating condition — fixing a lock, patching drywall, servicing a furnace — to 5090 Repairs. Record work that arguably betters the property, restores a major component, or adapts it to a new use — a roof replacement, a full kitchen renovation, converting a garage to a unit — to 1430 Capital Improvements, with the invoice and scope of work attached. The point of the two accounts is to keep the fact pattern clean and documented.
  • Tax: IRS guidance (Publication 527 and the Schedule E instructions, 2025) treats repairs and improvements differently: repair costs may be reported as current expenses, while improvements generally must be capitalized and depreciated — residential rental buildings over 27.5 years. Where a specific cost falls depends on the facts, dollar thresholds, and safe-harbor elections that your CPA, EA, or tax attorney applies. Your job in the books is not to decide the tax answer; it is to record the cost in the right bucket with documentation so your preparer can.
  • Management: For operating decisions, repairs are a recurring cost of running the property, while improvements are capital invested in it. Mixing them makes a stabilized property look unprofitable in renovation months and hides your true cost basis.

When in doubt, book larger or scope-changing work to 1430 and flag it for your CPA at year end. It is far easier for a preparer to move a capitalized item into expenses than to reconstruct an improvement that was buried in twelve months of repair transactions.

A note on security deposits

A refundable security deposit is not rental income when you receive it — IRS Publication 527 (2025) is explicit that a deposit you plan to return is not included in income on receipt. In the books, deposits land in 2100 Security Deposits Held as a liability (ideally in a separate bank account, which some states require). If you later keep part of a deposit for damages or unpaid rent, move that portion to 4090 Forfeited Security Deposits in the year you keep it. Recording deposits as rent is one of the fastest ways to overstate income and understate what you owe tenants.

Common chart of accounts mistakes

  • Booking the full mortgage payment as an expense. Overstates costs by the principal portion and leaves loan balances unreconciled.
  • Creating a copy of every account for every property. Use Classes for property tracking; keep one clean account list.
  • Dumping deposits into income. Refundable deposits are liabilities until forfeited.
  • Netting reimbursements against expenses. Record tenant utility reimbursements as income (4050) and the utility bill as expense (5120) so both sides stay visible and documented.
  • A bloated "Miscellaneous" account. If more than a sliver of spending lands in a catch-all account, your reports and your tax preparer are both flying blind.
  • Guessing at depreciation. Depreciation entries should come from your CPA's schedule, not an estimate — the books and the tax return need to tell the same story.
  • Letting intercompany transfers pile up. Due To/From balances between LLCs should reconcile monthly; unreconciled transfers are a leading cause of the cleanup projects described in our guide to catching up on rental property bookkeeping.

What to do next

  1. Copy the template above into QuickBooks Online, matching each account type exactly. Delete or make inactive the default accounts you will not use.
  2. Create one Class per property (Plus or Advanced plan) and turn on Class tracking.
  3. Set up a bank-feed rule or recurring split for each mortgage payment using the principal/interest/escrow breakdown from the current statement, and update it when the amortization shifts.
  4. Recategorize the current year to date into the new structure, then reconcile every bank, credit card, and loan account.
  5. Run a profit and loss by Class and confirm each property's numbers pass the smell test before you trust the reports.

If you are doing this on top of a year of uncategorized bank feeds, or across several entities, the setup is usually a weekend project — the catch-up behind it is not. QueueFortress is a 100% US-based bookkeeping firm that works exclusively with real estate investors on QuickBooks Online, and chart-of-accounts design like this is the first step of every engagement. See what is included in monthly real estate bookkeeping from QueueFortress, or browse more guides on the QueueFortress real estate bookkeeping blog.

Frequently asked questions

Should each rental property have its own QuickBooks file?

No — use one company file per legal entity, not per property, and track properties with Classes. Separate files per property multiply subscription costs and make portfolio reporting nearly impossible. Separate legal entities generally do warrant separate files so each LLC's books stand on their own.

How many accounts is too many?

If your profit and loss no longer fits on one screen, you have too many. Most rental portfolios run well on 20–30 expense accounts or fewer. Add detail with Classes and sub-accounts, not by inventing new top-level categories.

Do I record mortgage principal as an expense?

No. Principal reduces the Mortgage Payable liability on the balance sheet. Only the interest portion is an expense, and escrow amounts sit in an asset account until the servicer disburses them. See the worked example above for the full split.

Can I just use the default QuickBooks chart of accounts?

You can start there, but the defaults are generic small-business accounts — they include categories you will never use and miss rental-specific ones like escrow, security deposit liabilities, and per-loan mortgage accounts. Replacing the defaults with a structure like the one above takes under an hour and pays off every month afterward.

Does this chart of accounts work for short-term rentals?

The balance-sheet structure carries over, but STR operations add platform payout clearing accounts, channel fees, and lodging-tax liabilities. Start from this template, then layer on the additions covered in our short-term rental bookkeeping guide.

Sources checked

  • IRS, Instructions for Schedule E (Form 1040), 2025 tax year — expense line categories (lines 5–19) and the repairs vs. improvements distinction. irs.gov/instructions/i1040se. Checked July 20, 2026.
  • IRS, Publication 527, Residential Rental Property (2025) — improvement framing (betterment, restoration, adaptation), security deposit treatment, 27.5-year residential depreciation, and land/building allocation. irs.gov/publications/p527. Checked July 20, 2026.
  • Intuit, "Account type and detail types in QuickBooks Online" — account types determine financial-statement placement; detail types are organizational. quickbooks.intuit.com. Checked July 20, 2026.
  • Intuit, "Get started with class tracking in QuickBooks Online" — Class tracking availability on Plus and Advanced plans and setup path. quickbooks.intuit.com. Checked July 20, 2026.

This article explains bookkeeping structure and recordkeeping, not tax advice. Whether any specific cost is a repair or a capital improvement, and how items are reported on your return, depends on your facts and current law — confirm final tax treatment with your CPA, EA, or tax attorney. Reviewed status: pending human review per the QueueFortress editorial policy.

Want clean, CPA-ready real estate books?

Book a free 15-minute call. We'll review where your books stand and recommend the right plan for your portfolio. No pitch.

Book a Free 15-Min Call

QueueFortress provides bookkeeping services and prepares CPA-ready financials. QueueFortress is not a CPA firm and does not provide tax, audit, or attest services.