• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Industries   Real Estate  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
108
bJQQy_l9Gr4kAbacfA8pyY
Subscribe RSS
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
New Member
02/03/11 1:01pm PST
Viewed by asker 02/09/11 11:07am PST

Record rent paid to a Property Manager

US QuickBooks Pro for Windows : 2011

How do I record rent as a Property Manager?  I have the owners of the property setup as the Customer, and their properties setup as a job.  I also have the tenants setup as Customers.  Not sure this is the best way, but back to my question.  I invoice the tenant for their rent.  How do I record receiving their rent, take out 10% fee for myself, and then give this money as a credit to the owner of the property on their monthly invoice that they receive from me?

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
13 Replies
PMinCO
PMinCO
Questions asked: 1
Questions answered: 23
Points earned: 35
PMinCO
PMinCO
Questions asked: 1
Questions answered: 23
Points earned: 35
Contributor
02/04/11 8:18am PST

The easiest way I've found is to just receive the payment of rent as you normally would and apply that payment to the open rent invoice for that tenant. 

Then just write the owner of the property a check without a sum in the amount field.

In the first Item field (not under the Expense Tab) use whatever Item you have set up to show that the rent was received and the amount.  On the next line down add an Item for your Management Fee but show that as a negative amount, because you are deducting your Fee from the owner's proceeds.

The check to the owner will have filled in the the proceeds they will receive for the month. (Rent received minus the Management Fee) Then just hit print and mail it off.

You can also record expenses you may have paid for out-of-pocket by listing those Items as negative amounts.

QB will automatically adjust the amount of the check as long as you didn't initially pre-fill the amount.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
New Member
02/04/11 8:48am PST

Instead of writing the owner of the property a check, I would like to add the rent as a credit to their invoice with me.  I pay all of their properties utility bills and loan payments, and then the owner of the property gets billed at the end of the month.  How am I able to do this?  I tried to put it in as a Credit Memo and then apply to invoice, but when I print the invoice it still shows the original dollar amount before the credit memo, even though on the screen it shows Credits Applied.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
PMinCO
PMinCO
Questions asked: 1
Questions answered: 23
Points earned: 35
Contributor
02/04/11 10:45am PST

Sorry, I'm of no help.  It'll take one of the guru's that track this thread to help you out with that one.  Good luck.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/04/11 10:51am PST

Property:tenant or Property:unit:tenant is Customer:job.

Owners are Class. Open Help and read about class tracking.

If you want to use Owner:Property:unit:Tenant, for Customer:job:subjob, etc, you can do this, too.

Don't have Owner names as Customer because when you pay them, they are Vendor names.

You run reports such as P&L by Class and Job reports, to see the activities.

You record everything in separate steps and in full. You record Rent due from tenant using Items, use Invoice (no one said you have to print and send an invoice, use it to track due dates by tenant). You pay vendors in full, gross, and then use a negative for your own holdback, linking that to your income account for commissions. The check to the Owner as vendor name is Net but you have captured the full rent out to them for 1099 reporting.

You use items to track security deposits, too. Use Sales Receipt to receive it, Credit memo to return it.

Property owners won't receive an invoice from you, typically, because these are people you pay. Vendors, not customer.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
New Member
02/07/11 7:15am PST

I DO invoice the property owners because I pay all of their utility bills upfront, and then I invoice them for that amount.  I would like to credit them the (rent minus my fee) on their invoice from me.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Nancy178
Nancy178
Questions asked: 10
Questions answered: 550
Points earned: 1087
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
Nancy178
Nancy178
Questions asked: 10
Questions answered: 550
Points earned: 1087
Allstar
02/07/11 7:56am PST

Setup two company files.  One for your PM Company and one for your Owners.

Bill your Owners for your commission from your own PM Company File. That bill is now a bill that needs to be entered into the Owners Company file, just like any other bill. 

Write a check to you for the bill you sent them from their company file because it's an expense.

Running a Profit and Loss Report  will show how much money your owners made less expenses.

To send your owner their bottom line, write a check to them using "Rent Due to Owner" that you setup in their Chart of Account as an expense account. (If they have money coming to them and their bottom line is a profit)

If it's a negative, Invoice the Owner for the amount that is due to cover the negative amount.

The simpler you make QuickBooks the better it is.  Don't try cramming everything into one company file. 

Nancy Neville, Certified QuickBooks Pro Advisor, Landlord Consultant

Author of:  Property Management in QuickBooks

Author of The Landlord's Guide to QuickBooks

Author of How to be a winner for Landlords

http://www.nancyneville.homestead.com

 

 

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
New Member
02/09/11 11:06am PST

When you say "Setup two company files. One for your PM Company and one for your Owners.".  Do mean setup another company file for each owner?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Nancy178
Nancy178
Questions asked: 10
Questions answered: 550
Points earned: 1087
Allstar
02/09/11 12:18pm PST

No.  As a PM you own your own business, therefore you have a different tax schedule you belong to.  You are a company.  Your owners company file is just to keep track of data.  So you can combine all owners into one company file, but not into yours.

I prefer each owner to have their own company file, but that's just me.  Most people prefer to have them jammed into one company file.  It's okay, but I'm a stickler for detail and keeping everything separate.  I hate co-mingling funds.  This is a suing society.  I'd rather be safe than sorry, but that's just me.

Nancy Neville

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/07/11 11:34am PST

Gelham, you can't credit customer names for Rent you owe to them, as customer names. Because this is not documenting Rent owed and "paid" to Vendor names. Well, you can do this as long as you don't expect the data in QB to be useful for 1099 purposes. You can't report what you don't track.

You can read Help system on how to track "when customer is vendor, too" using a Barter Bank-type of account. You need to track activity to the appropriate name type, for accurate reporting.

Or, as Nancy points out, keep two data files.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
gelham01
gelham01
Questions asked: 10
Questions answered: 8
Points earned: 8
New Member
02/08/11 6:48am PST

What if I do this:

Make the Customer a Vendor also.

I record rent like normal (Create invoice to tenant, Receive Payment, Record Deposit)

Create a Bill to the Customer-Vendor for my fees

Create a Credit Memo for the rent amount

Create an invoice to the Customer showing on each line the amounts he owes me, and then apply the credit memo to this invoice.  If there is more in the credit memo than he owes me, it will just show paid with a balance left on the credit memo.  If the invoice is more than the credit memo it will show the adjusted balance due.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/11/11 12:38pm PST

You can't use Credit memo and Invoice for Owners as Vendor Names. This isn't going to track what you owe and pay them.

Invoice for rent.

Create Bill to Owner as vendor name, for what you owe them.

On the bill, use a negative for what they owe you: repairs, fees.

Pay them the Net.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
iflyhigh
iflyhigh
Questions asked: 0
Questions answered: 1
Points earned: 1
iflyhigh
iflyhigh
Questions asked: 0
Questions answered: 1
Points earned: 1
New Member
02/01/12 2:24pm PST

 GREETINGS,

Don't know if you still are looking but this is how I have set up my sysyem for the same situation:

1) I created a "other current liability" account giving it the name "property funds owned by..."

2) The tenants in the builbing are normal customers AND I have also made the property owners a normal customer. 

3) When I set up the "items" for the rental rates, utilities, etc.., and charge them to the tenants each of these are recorded, not as a "sale" but under the "other liability account". After all, my company is not selling to the tenent but actually...selling.... management services to the property owner. 

Here - under my items I have a "property management service fee". This is what I charge to the property owner when I create an invoice to charge him. 

4) when the rent is paid into the actual bank account  (which my company owns) it covers the tenent invoice and increases the liability owed to the property owner. 

5) I then invoice the property owner for management services and any other expenses for that month and inform the owner that the invoice balance will be deducted form the bank account

(note) I open an actual bank account for each property under my control.

6) To pay myself for the services - we simply make a journal entry, debit- other liability and credit - accounts receivable marked to the property owner. Then I can transfer the funds from that account to my main operating account (recorded by general journal entry)

7) to transfer the rest of the rent to the owner of the property, I write a check from the management account for the required transfer paying the owner. Then to record this I debit - other liability and predit accounts payable (i.e. to record the "expense")

 

In general, I treat this like a "trust fund" on my company books and can keep my company expenses and income seperate from the rental income which is in essence belongs to the property owner - it is only entrusted to be under my control. For my accounts this is a, you guessed it ..... liability. The rent only flows through my account.

Might not be the perfect solution but does offer transparency. Hope it helps.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Gita_Faust
Gita_Faust
Questions asked: 51
Questions answered: 2244
Points earned: 3653
Allstar
02/07/12 12:32pm PST
Latest post

Thanks for posting your check list and process.

 

Author of books "Manage Properties with QuickBooks" series
www.FastTracConsulting.com resources, links and more - NEW BLOG

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Ampli899
20 mins ago
Ampli899
replied to
Why does quick books shut d...
QNE19638
20 mins ago
QNE19638
posted
error
Ampli899
26 mins ago
Ampli899
replied to
Wifi or 3G
Heidi4538
31 mins ago
Heidi4538
posted
Why does quick books shut d...
snap_solutionsllc
36 mins ago
snap_solutionsllc
posted
Online Banking
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business