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

When recording a tenants monthly payment, I split it out as base rent, taxes, insurance,

I have 5 rental properties and need to track the income and expenses for each property, and refund any overages for prepaid expenses through the year.
3 Comments 3
SarahannC
Moderator

When recording a tenants monthly payment, I split it out as base rent, taxes, insurance,

Hello there, marcarr69. Welcome to the Community forum!

 

QuickBooks helps you manage multiple rental properties. You can track the income and expenses for each property using the Class feature. 

 

Please know that the class and location tracking is only available in QuickBooks Online Plus and Advanced. To use it, turn this feature in the settings. Here's how:

 

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

 

Once the feature is activated, you can start setting up your classes. I encourage checking this article for complete steps and further instruction on how you can do it: Get started with class tracking in QuickBooks Online.

 

Then, you can generate the Profit & Loss By Class report to review the income and expenses by each property. If you want to modify the report or any QuickBooks reports, just use these articles as your guide:

 

 

Please let me know if you still need help as you go along with QuickBooks. Take care and stay safe!

SarahannC
Moderator

When recording a tenants monthly payment, I split it out as base rent, taxes, insurance,

Hi marcarr69,


Hope you’re doing great. I wanted to see how everything is going about tracking income and expense for properties. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

john-pero
Community Champion

When recording a tenants monthly payment, I split it out as base rent, taxes, insurance,

So you are charging your tenants for taxes and insurance in addition to rent.  That is easy enough to do. Your monthly memorized (recurring) invoices can have the three service items on them. Then it is a simple matter of recording a single payment against the invoice.

 

As far as keeping income and expense separate by the 5 parcels the best way is to use Class Tracking (if you are on Plus or Advanced - if not consider the upgrade to Plus) Reports for P&L By Class will give you the breakdowns needed for Schedule E columns as required

 

Alternately you can just track your properties as jobs, but you will want your customers set up as Property:Building:Unit:Tenant anyway

Need to get in touch?

Contact us