cancel
Showing results for 
Search instead for 
Did you mean: 
Bumprt
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Greeting:

I am the bookkeeper for a property management co.  We handle over 75 properties for over 50 different owners.  We have two separate bank accounts; one for the property management co. and the other a trust account holding the funds for the property owners.  The trust fund account receives income from each rental property and pays the expenses related to each property.  Each month, each property owner is paid the net income for their property(ies).

In addition to tracking the income and expenses for each property separately, I also need to track the balance in the security deposit and repair fund for each property.  I also track the separate income and expenses of the property management co.

Each month, I need to provide each owner with a report of the income and expenses for their property(ies).  I also need to prepare a report showing the balances in the security deposit and repair fund for each property.  I also prepare reports for the property management co.

I was told at the time that I obtained Quickbooks Online, that it was able to track the above information and prepare the reports described above.  I was also told that there a module (or package?) specifically designed for companies such as mine was included with Quickbooks Online.  

Despite searching online, I have been unable to locate any modules or packages designed for property management companies that are a part of Quickbooks (or even integratable into Quickbooks).  I have also been unable to find any information on how to set-up Quickbooks to perform these actions.  And while I can set up Quickbooks to track and report on properties for a single owner, I have not figured out how to track and report on multiple properties for multiple owners.

Any suggestions or information would be greatly appreciated.

Thanks

 

14 Comments 14
AlexV
QuickBooks Team

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Good day, Bumprt.

 

Thanks for posting here. Let me share an idea on how we can track multiple properties in QuickBooks Online.

 

We can turn on and use the class tracking feature. Then, let's add all the properties to your class list. That way, we can assign them when we record any transaction.

 

You can follow these steps:

  1. Go to the Gear icon and select Account and Settings.
  2. Select Advanced, then select the Categories section to edit.
  3. Check Track classes and the Warn me when a transaction isn’t assigned a class.
  4. Under Assign classes, select One to entire transaction or One to each row in transaction.
  5. Click Save, then Done.

Once done, you can create and manage classes in QuickBooks Online. You'll see the Class field when you create a transaction that you can use it to tag a class to a transaction.

 

In addition to that, we have available reports by the class that you can pull. You can use it to reports the properties' sales, costs, or profitability.

 

Here are the additional reports for more details:

Leave a comment below if you need anything else. Stay safe and healthy!

Bumprt
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Hi Alex

Thanks for the reply.  Unfortunately that's only half the answer.  I have been using classes for the books of a single company that owns a number of rental units for itself.

The problem I am having is tracking multiple properties for multiple owners.

Any suggestions for the handling of multiple properties for multiple owners.  Opening a separate Quickbooks account  for each owner is not an option as there is one bank account used on behalf of multiple and multiple properties.

Thanks

AlexV
QuickBooks Team

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Thanks for the reply, Bumprt.

 

You don't have to open separate accounts. QuickBooks Online has a new feature called tags. We can use it instead to track multiple properties.

 

Here are some of the articles for more details:

Please reply again if you need anything else. I'll be here!

DVF2016
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

I am a Real Estate Agent and currently only manage my own rental buildings.  I have 11 units in one building and 4 in a second building and we are growing.  Our books are in QuickBooks Online.  We have the class tracking set up for each building.  Now we are looking to automate billing for rents.  I want to be able to send a bill for their rent automatically, use their checking account with minimum fees to us for the service rather than more costly options with debit or credit cards.  How does QuickBooks recommend we do this?  Is it an emailed invoice to them once a month?  Is it an ACH?  And if it does not get funded by a certain date, can it rebill with a late charge?

 

 

Fiat Lux - ASIA
Level 15

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

@DVF2016 

Utilize this app to manage your properties, accepting ACH payments for free, and integrate it with your QBO.

https://home.tenantcloud.com/signup?affiliate=3jqxsies8ncnqqwj

 

Lynn48
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

I have been using QuickBooks for Mac desktop for 10+ years and I want to move online.  I have 5 properties that have their own bank accounts. The features I use are the check register, and reports. Each property has about 5-10 entries per month. I DO NOT pay bills through quickbooks nor do I use most of the functions. I have been told that only the Plus program will work. After the introductory discount, the price is $80 per month!!!  I suppose I can continue with my 2019 program as it is $0 per month. Can you suggest a “reasonable” alternative?

Rose-A
Moderator

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

It's nice to see you here in the Community, Lynn48.

 

While we're unable to suggest an alternative program for property management, you'll want to continue using QuickBooks Online Plus or search for a third-party application as suggested by Fiat Lux - ASIA.

 

You can follow the steps below on how to search for an app within your QuickBooks Online account:

 

  1. Log in to your QuickBooks Online account.
  2. From the left pane, click on Apps.
  3. Search for apps in the search box.

 

QuickBooks displays the list of applications available that match the description you entered. Once you find the right app, click on it to open.

 

You can also visit this link for a better view: https://apps.intuit.com/. From there, you can find different apps that are compatible and designed to work with QuickBooks Online.

 

You can take a look at the following pointers below to know more about this feature. The links will provide you steps from setting up to pulling up reports to review your transactions with locations:

 

Get started with class tracking in QuickBooks Online.

Set up and use location tracking.

 

If I can be of help while working in QuickBooks, please let me know. I'm always here to keep helping. Have a good one!

Fiat Lux - ASIA
Level 15

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners


@Lynn48 wrote:

I have been using QuickBooks for Mac desktop for 10+ years and I want to move online.  


 

@Lynn48 

Why do you need to move online?

Yoelf
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners



Have you ever gotten a solution to your question? The tags doesn’t help at all to get a PL report for the different property owners. 

Yoelf
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

I’ve found a solution to this!

setup customers and classes. The major problem is having one bank account for all. Create a equity account OwnerB. The solution, make a GJE debit from rental income credit to OwnerB, debit ownerB Credit account receivables customer ownerB. Then go to customer center report payment from owner B apply the credits. Whatever remains open, OwnerB owes you. If you received rents more than the expenses you would create a credit memo and issue a refund to this OwnerB customer. 

Murage
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Hello,i think you should activate class accounting and create a class for each of your customers.When you are recording rental income or expense ,assign it to the specific class and that way you will be able to generate reports for each

Yoelf
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

I need to change it a little. the last sentence should be replaced by following.  If you received rents more than the expenses you would create a check and issue a refund to this OwnerB customer. You will write check to Owner B, Account is accounts receivable customer name is ownerB and class it. once its done you go back to customers, OwnerB will now show a reduced amount because the check you just wrote. go to receive payments and apply the GJE credit to this check to zero out the open balances 

apowell90
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

You may consider creating sub-classes.  e.g. Owner 1: Property 1: Apt 1. That's how we do it.  I have heard adding tenants as Customers but I haven't tried that yet.  When we do our P&L by Class, it is all separated by columns. 

Vikki2
Level 1

Setting up Quickbooks Online for property management co. handling multiple properties for multiple property owners

Hi Bumprt, I have a client with the same issue (multi owners - different percentage ownership per property).  Were you able to figure out how to track this in QBO?  Thanks

 

Vikki

Need to get in touch?

Contact us