How to Use QuickBooks Online for Property Management

How to Use QuickBooks Online for Property Mangement

QuickBooks Online: A solution for property management?

Having a number of clients in real estate, we know that property management companies have their own set of special needs when it comes to accounting software. But what if your enterprise is not quite big enough to merit a specialized accounting system which comes with a big HR investment and an even heftier price tag? We’ve found that QuickBooks Online (QBO) works well for small to mid-size property management companies.

The key piece you want to accomplish by using QBO for property management is to keep the P&L for the actual property management company separate from the properties you manage while still being able to run all necessary reports for the owners of the properties as needed. With QBO it is possible to do both in one file if you map certain fields in certain ways.

How to use QBO for Property Management

1). Set up each property or unit you manage as a customer.

 

By doing this, you’re able to set expenses as billable and charge them back to the property owner. You can easily pull a P&L report by property or unit on a monthly, seasonal or YTD basis as needed.

QBO for Property Management - Example Customer

2). Use location to note the different property, um, locations. (No one said this was rocket science).

By setting this up from the start when creating your QBO file, you can run reports by unit and location which becomes pretty essential to the property owners if they have more than one unit or property.

3). Use class to highlight different types of service offerings.

How to Use QBO for Property Management - Class Example

Whatever operational services are necessary for each property can be categorized
in QBO using the class field. This is helpful if you ever need to run a P&L to know which service is generating the most income for your company or if you’re experiencing losses somewhere and want to hone in on the COGS related to that service.  You can examine your margins even further by both class and by customer in order to see specifically the costs involved for each property you’re managing.

4). Use category to code your expenses and income to accounts.

Categories can be set up by account name to classify the different expenses and property management services you offer. Simply select them from the drop-down menu when you record a transaction in QBO. The account categories are set up within the Chart of Accounts section under Your Company by clicking on the NEW button.

How to Use QBO for Property Management - Category Example

5). Record income and expenses either manually, syncing with a cloud accounting app or a combination of both.

When you’re using QBO for property management, generally you record transactions using the same method you would for any business with a couple of additional helpful steps. Select the class to indicate which service it relates to. Additionally, if it’s an expense for any of the properties or units you manage (as opposed to your own business expense), mark it as billable and select the appropriate property or unit from the customer drop-down menu.

6). Use the split function for multi-service vendors.

When entering expenses, use the split function to record an invoice that includes two different types of services (eg. cleaning and waste removal).

How to Use QBO for Property Management - Split Transaction Example

7). Run reports as needed.

Now that you’ve set up your QBO file for property management you can run reports (P&L, balance sheets etc.) by class, customer and location as needed. This will help greatly with any reporting you are required to provide to the property owners.

While QBO can’t always meet all the accounting needs for property management, if you sync it with other cloud accounting apps like Bill.com for invoices and Gusto for payroll, it can operate as a fairly robust system for small to mid-size property management companies.

Still don’t quite understand how to use QBO for property management? We’d be happy to help. Contact us to learn how our team of cloud CFO professionals can look after your property management company’s books.

Now that we’re part of one of Chicago’s most prestigious CPA firms, Ostrow Reisin Berk & Abrams, Ltd, you’ll also find us online at www.orba.com.  With our ORBA colleagues, we’re positioned to offer you an expanded array of state-of-the-art services. 

Get the Granite Scoop

Subscribe to have all the icy cool details delivered directly to your inbox.

Read more of our blog posts…