Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm Treasurer for an HOA and just purchased QB Desktop. I want to have the properties stay static, and the owners be customers. So, I was thinking about this structure:
Owners - Customers
Billable rates - items
Properties - ?
I don't know what to do with the properties. I thought about setting them up as jobs, but I'm not sure that will work. I also thought about setting them up as items with the billable rate defined for each. We are in a lake community, and some lots have a water connection and some don't. We have a few different rates charged depending on the lot characteristics.
Need advice on how to set up properly in QB. I want to maintain the properties universally, as they won't change, and see the owners "assigned" to each property change over time. I want to be able to pull each separately - the owner and the property to see the history. Sometimes owners sell and buy different properties.
Thanks in advance.
Solved! Go to Solution.
Customer Name = use this for Property.
Add Job = the Owner.
Add Job = the Next owner.
Each of these has their Start Date = they Own it. There is End date = they Sold it. And now you have different Customer:Job names, which means you can be tracking what one person owes, or one person prepaid and is owed back.
When the house sells, you do not Change anything. That is New Job, under Customer (which is that Property).
Hi there, @TBTreas.
Thanks for joining the Community today. I'm here to share some information regarding setting up your properties in QuickBooks Desktop.
To help decide how to correctly set up your properties in QuickBooks Desktop, I'd suggest reaching out to your accountant. This is to make sure that your bookkeeping is accurate. Once you've confirmed the appropriate setup, I can walk you through entering jobs and items in QuickBooks.
To create a Job:
To add an Item:
For more information about performing this process, please refer to the following article:
This should guide you on the right path, @TBTreas. Feel free to reach back out to me if you have further questions. Have a great day!
It's the other way around:
Customer:Job = Property and Owner
Now you have Current owner, previous owner, Job Start, End and Projected End Dates. That's how Property stays Static = upper level name.
So the property is the job with essentially no end date. when a house sells, I change the job customer?
Thx.
Customer Name = use this for Property.
Add Job = the Owner.
Add Job = the Next owner.
Each of these has their Start Date = they Own it. There is End date = they Sold it. And now you have different Customer:Job names, which means you can be tracking what one person owes, or one person prepaid and is owed back.
When the house sells, you do not Change anything. That is New Job, under Customer (which is that Property).
I just tried this and created an invoice - I think this is going to work!!!!
Thank you!!!!
Julie
Glad to help.
I inherited a Water District where the customer names are the people, and it has an integrated handheld meter reader. I wish I could start over with Addresses, not Names, but the reader works off of Serial Number attached to Names, so that is too much reprogramming to bother with.
This solution makes sense. We are using QB online, though. So I can use customer as property address, but QB online doesn't have "jobs". They have "sub-customer". I can use that, but there is no start/end date field. Not ideal, but I can use the notes field to record this info. The bigger trouble is what happens if one person owns multiple properties within the community? For example, if Joe Smith owns 2 properties, "Joe Smith" would be a job (or sub-customer) under 2 different "customers". That means Joe Smith would receive 2 separate invoices.
So my questions are: If using QB Online, is there a better way to do an HOA or is using "sub-customer" the only way to go? And second, how do we handle one person owning multiple properties? Thanks! - Dave
Explore the trial period of this membership management app. You may find something useful to setup on your QBO account. It only supports QBD for now.
https:// wildapricot.grsm.io/quickbooks
Hi,
Did you ever receive a response to "And second, how do we handle one person owning multiple properties?"
Thanks,
Each time I enter the job now I have 2 customers in the customers List any idea how I can avoid this see picture
Hello, farrellpe.
In QuickBooks, a simple way to make sure you don’t enter duplicate customers or job is to have a simple naming standard that you use whenever you enter new customers. You can follow QBteach suggestions to manage the customers. To modify the job name or the customer name. Here's how:
For more details, please see this article: Change vendor, customer or employee name type.
I've also added this how to track job costs in QuickBooks Desktop for your reference.
Reach out to me if you have clarification. I'm more than happy to explain further. Take care and have a good day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here