Blog

How to set up a chart of accounts for a property management company

Zrico team ·
In short

A good property management chart of accounts is one shared, numbered list for every property, with properties tracked as a separate field rather than as separate accounts. It keeps trust cash, deposits and prepaid rent apart from income, separates repairs from capital improvements, and stays small enough that two people would code the same bill the same way.

A chart of accounts decides what every report you send can say. If utilities and utility reimbursements share one account, no owner statement can show net utility cost. If every property has its own repairs account, nobody can compare repair spend across the portfolio without a spreadsheet. Most messy books trace back to a chart that grew one account at a time. This guide shows how to build one on purpose.

Start with two sets of books

A property management company keeps two kinds of books, and the chart has to serve both.

  • The property books: the income, expenses, cash and liabilities of each property you manage. These belong to the owners. Owner statements, budgets and 1099s for owners come from here.
  • The company books: your management company's own business. Management fees you earn, payroll, office rent, software and your own bank accounts live here.

The same account can mean opposite things in the two sets. Management fees are an expense in the property books and income in the company books. Keep both in one chart with clear names, such as Management fee expense and Management fee income, so nobody posts a fee to the wrong side.

Use properties as a field, not as accounts

The most common mistake is creating accounts like Repairs, 12 Oak St and Repairs, 40 Grove St. Within a year the chart has thousands of accounts and every new property means a dozen new ones. Instead, every entry carries the account and the property, and reports filter or group by property. One Repairs account, used by every property, lets you compare repair costs per property in one report and keeps the chart stable as the portfolio grows.

Pick a numbering scheme and keep gaps

A four-digit scheme with ranges is enough for almost any portfolio:

  • 1000 to 1999: Assets
  • 2000 to 2999: Liabilities
  • 3000 to 3999: Equity
  • 4000 to 4999: Income
  • 5000 to 6999: Operating expenses
  • 7000 to 7999: Capital and non-operating items
  • 8000 to 8999: Company-only accounts, if you keep company and property accounts in one chart

Number in steps of 10 or more, for example 5110, 5120, 5130, so you can add a related account later without renumbering. Group related accounts together: all utilities in one block, all repairs in another.

The accounts trust accounting depends on

These are the accounts that make or break a clean three-way reconciliation. Set them up first.

  • Trust cash, one account for each trust bank account
  • Security deposit cash, if deposits are held in their own bank account
  • Operating cash for the company's own bank accounts, never mixed with trust cash
  • Accounts receivable, tenants
  • Security deposit liability
  • Prepaid rent, a liability for rent paid before it is due
  • Accounts payable
  • Owner contributions and owner distributions, as equity in the property books
  • Due to and due from accounts between entities, if you keep separate books for each LLC

Prepaid rent is the one most often missing. Without it, a tenant who pays December rent on November 28 shows up as November income, and both months are wrong on the owner statement.

A sample property management chart of accounts

Here is a starting chart for a residential portfolio. Rename and trim it to fit, but keep the structure.

  • 1010 Trust cash, operating
  • 1020 Trust cash, security deposits
  • 1050 Company operating cash
  • 1100 Accounts receivable, tenants
  • 1150 Undeposited funds
  • 1200 Prepaid expenses
  • 1500 Buildings
  • 1510 Building improvements
  • 1600 Accumulated depreciation
  • 2010 Accounts payable
  • 2100 Security deposit liability
  • 2150 Prepaid rent
  • 2200 Accrued expenses
  • 2500 Mortgage payable
  • 3010 Owner contributions
  • 3020 Owner distributions
  • 3900 Retained earnings
  • 4010 Rental income
  • 4020 Vacancy loss
  • 4030 Concessions
  • 4100 Late fee income
  • 4110 Returned payment fee income
  • 4200 Utility reimbursement income
  • 4300 Other tenant charges
  • 4400 Laundry and vending income
  • 5010 Advertising and marketing
  • 5110 Repairs, general
  • 5120 Repairs, plumbing
  • 5130 Repairs, HVAC
  • 5140 Repairs, electrical
  • 5150 Appliance repair
  • 5210 Turnover cleaning
  • 5220 Turnover painting
  • 5310 Landscaping
  • 5320 Snow removal
  • 5330 Pest control
  • 5410 Electricity
  • 5420 Gas
  • 5430 Water and sewer
  • 5440 Trash
  • 5510 Insurance
  • 5520 Property taxes
  • 5610 Management fee expense
  • 5620 Leasing fee expense
  • 5710 Legal and professional fees
  • 5810 Bank fees
  • 6010 Payroll, on-site
  • 7010 Capital improvements
  • 7110 Mortgage interest
  • 7120 Mortgage principal

Commercial portfolios add recovery income accounts, such as 4500 CAM recovery income, 4510 Real estate tax recovery and 4520 Insurance recovery, so reconciliations can compare what was billed with what was spent. Association books add 4600 Assessment income and separate reserve accounts.

Design rules that keep the chart clean

  1. One idea per account. Utility expense and utility reimbursement are separate accounts, so you can show net cost.
  2. No miscellaneous. If Other expense grows past a small share of total expenses, it is hiding something. Read it monthly and move recurring items to real accounts.
  3. Repairs and capital apart. Decide with your accountant where a repair ends and an improvement begins, write the rule down with an example, and code to it every time. A water heater replacement and a faucet washer should never land in the same account.
  4. Contra accounts for income reductions. Vacancy loss and concessions as their own accounts let you show gross potential rent and what you actually earned.
  5. Name accounts the way people speak. Turnover painting beats Paint, make-ready, int. Owners read these names on statements.
  6. Lock who can add accounts. One person, usually the controller or lead accountant, approves new accounts. Everyone else uses what exists.

Map accounts to tax lines

Many individual owners report rental income on Schedule E, and their accountants will ask for totals that match its lines: advertising, cleaning and maintenance, insurance, legal and professional fees, management fees, mortgage interest, repairs, supplies, taxes, utilities and others. Keep a tax line column next to every expense account so a year-end report can total by tax line. Entities that file other returns need their own mapping. Confirm the mapping with your accountant; this is not tax advice.

How many accounts is right?

Fewer than most people expect. A residential portfolio usually works well with 80 to 150 accounts across property and company books. Past about 200, coding gets inconsistent: two accountants put the same bill in two places, and the reports stop being comparable. A simple test: give five recent bills to two people separately. If they code all five the same, the chart is clear enough.

Changing an existing chart

  1. Export the current chart with the balance and the number of entries in each account for the last 12 months.
  2. Mark accounts with no entries for deactivation, and accounts that mean the same thing for merging.
  3. Write a mapping table: old account, new account, reason.
  4. Make the change at a period boundary, ideally the start of a fiscal year, so year-over-year reports compare cleanly.
  5. Reclassify history only if you need comparable reports; otherwise start fresh from the boundary and keep the mapping on file.
  6. Update bank rules, recurring bills and recurring charges that point to old accounts before the first new month.

The same mapping table is the core of a software switch, because the chart of accounts is confirmed before any balance is imported.

A setup checklist

  1. Property books and company books both covered
  2. Properties tracked as a field on every entry
  3. Numbering by range, with gaps
  4. Trust cash, deposit liability and prepaid rent in place
  5. Repairs and capital improvements separated by a written rule
  6. Contra income accounts for vacancy loss and concessions
  7. Tax line mapping on every expense account
  8. One person approves new accounts

How Zrico helps

Zrico keeps the general ledger, bank reconciliation, bills, budgets, owner statements and 1099s in one set of books, with each LLC in its own books, bank accounts and 1099s. Every report can run for one property, several, an owner's properties or an entity, and reports that offer a basis run on cash or accrual. When you switch, the chart of accounts is confirmed before any balance goes in. Read more at /product/accounting, and see the definition and examples at /glossary/chart-of-accounts.

See Zrico run your portfolio.

Bring a property. We will show you, on your own data, what Zrico would have handled last month.