One of the most important accounting practices in any business is setting up and keeping a property management chart of accounts. As a property manager, your chart of accounts will help you keep tabs on all the transactions for each of your properties in your portfolio.
In this article, we’ll walk through setting up a chart of accounts for your properties and discuss some best practices with the help of Taylor Brugna, Partner, The Real Estate CPA. In addition, check out the on-demand video below for an idea of how property managers can use technology to help.
“Having a clear, concise chart of accounts is crucial for your clients to understand how their rental properties are performing,” says Brugna. “It can guide future investments and help both you and your clients make important financial decisions.”
Check out the video session featuring Taylor Brugna and Jeana Pondelli from Buildium’s product team as they walk through the best practices of what’s possible with property management software.
What Is a Property Management Chart of Accounts?
Brugna describes a chart of accounts as a record that organizes each transaction made for your properties into accounting categories. These categories offer a clear understanding of data relevant to each property. Transactions fall under one of five overarching categories: assets, liabilities, expenses, income, or equity. Each property gets its own coding system within your chart of accounts. Put together, all of those accounts become your chart of accounts.
The codes can get pretty granular. But that’s a good thing. By giving each transaction for each property a specific code, it’s easy to keep track of where every penny is going and which of your properties are making or losing money.
Assets include checking accounts, savings accounts and accumulated depreciation of each property, while your liabilities could include refundable security deposits, credit card balances, and taxes/insurance owed on properties.
Equity entries typically include net income, retained earnings, and any contributions or distributions made for your properties.
Why Do You Need a Chart of Accounts?
In the days before computers, each transaction had its own page in a ledger book, recording income, expenses, assets, liabilities, and equity. Each transaction was recorded and, at the bottom of the page, the numbers were tallied. To get a total picture of profits and losses, an accountant simply had to add up income, assets, and equity, and then subtract expenses and liabilities.
A chart of accounts is the backbone of all the financial reports and forecasting you do for both your company and your properties. It allows you to:
- Report the financial health of rental properties to owners
- Determine rent and fee increases
- Forecast marketing, staffing, and other budgets
- Report accurate financials for taxes
How to Set Up a Chart of Accounts for Your Property Management Portfolio
A chart of accounts is set up in a hierarchy of entries. You might even think of it in terms of a parent-child organization. The highest-level entries would be the five we discussed above. Then, each of your transactions would be grouped as “children” underneath.
Many experts recommend numbering line items using ranges of 1,000. For example, assets would be assigned the high-level number 1000, and all assets would be coded between 1000 and 1999. According to Brugna, a typical numbering system would be organized as follows:
- Assets: 1000-1999
- Liabilities: 2000-2999
- Shareholder’s Equity: 3000-3999
- Revenue: 4000-4999
- Expenses: 5000-5999
Under that, you can assign different types of income their own numbers. For example, 1100 might be rent, while 1200 could be HVAC maintenance fees.
Finally, you’ll need a way to identify which income comes from which property, while leaving room to add future properties.
To do that, assign each property a number in the 1s place of your accounts. So, your property at 123 Elm St. would be assigned 1101 for rent and 1201 for HVAC fees. For other accounts, it would still be assigned a one in the 1s place.
To keep line items straight, make sure each has a clear and brief summary.
Property Management Chart of Accounts Examples
Let’s take a look at how the above example would look on a spreadsheet.
At the highest level, you chart of accounts will look something like this:
Under those high-level categories, you would then fill in each line item description:
Finally, transactions for each property would be recorded using codes based on the descriptions you already set up.
If done using a simple spreadsheet, a chart of accounts can take some time to set up. You’ll have to track down every transaction that goes through your property management firm, create a coding system that works best for your company, and then set up the sheets. Putting in the time to create a consistent accounting method that makes adding new transactions easy, however, is well worth it.
If the idea of updating a spreadsheet is unappealing, there are, of course, software solutions that automate accounting processes and keep your books much more secure than a spreadsheet ever would.
Quickbooks probably comes to mind for your own business’ financials. This flexible software includes templates that work for most businesses, and it can be integrated with other tools. If you’re using a property management software solution with an open API, you can integrate Quickbooks directly into that tool.
It’s important to keep in mind, however, that Quickbooks auto-populates their charts of accounts and is best suited for your internal company financials vs. accounting for the properties you manage. You may have to spend some time tweaking it to meet the needs of a property management company.
When it comes to handling the accounting for your owners’ properties, a solid property management solution, however, will have accounting tools built right in, with templates that are already configured for those needs. Buildium comes with a standard chart of accounts along with the option to edit an existing general ledger account.
Chart of Accounts Best Practices
Once you get your chart of accounts up and running, set up a training session with stakeholders, explaining the coding system. Teach them to adhere to the following best practices as well.
#1: Designate One Person to Update the Chart of Accounts
A chart of accounts is definitely a cooks-in-the-kitchen situation. Too many people accessing the file will only cause mistakes and chaos — and by too many, we mean more than one.
#2: Update Frequently and Consistently
Get your team on a regular schedule of reporting transactions to you or the person responsible for the chart of accounts. Give them a deadline to get all of their transactions in. That way, there’s time to update and reconcile by the end of the month.
#3: Stick to Your Coding System
Of course, you will have to add new line items for new transactions, but each new item should be sorted into existing categories that follow the coding system you set up.
“Consistency in categorizing will help your property owners identify trends, areas of success, and where to improve,” says Brugna. “For example, monitoring repairs and maintenance costs month over month will give you a clear breakdown of expenses and show you how renovation budgets are tracking.”
#4: Record Absolutely Everything
Don’t keep anything off the books, or even in a separate chart of accounts. Record every single transaction in the same place. Taxes, compliance, property forecasting, and investment decisions all depend on a complete picture of your properties’ finances.
#5: Keep the Miscellaneous Items to a Minimum
If you’ve ever moved, you know you always end up with that one box of miscellaneous stuff you don’t know what to do with. When you unpack it, you’re left with a mess of random things to deal with.
The same goes for your chart of accounts. While you may have some miscellaneous income or expenses, you shouldn’t use that category as a catch-all for transactions you just don’t want to deal with at the moment. You’ll end up with a mess that will be tough to reconcile at the end of the month, quarter, or year.
A chart of accounts is a must-have tool for any successful property management business. Whether you keep a spreadsheet, use a one-size-fits-all program such as Quickbooks, or opt for specialized accounting tools from a property management software solution, choose the method and the system that works best for you and stick to it.
Want more insights to deepen your understand of the Chart of Accounts? Check out our step-by-step guide, Setting Up an Effective Chart of Accounts.Read more on Accounting & Taxes