Basic Rent Roll in Excel
Click here for Top Ten Discussions. CLICK HERE for Q & A Homepage
Receive Free Rental Owner Updates Email:  
MrLandlord Q & A
     
     
Basic Rent Roll in Excel (by Lois [CA]) Feb 2, 2010 7:26 PM
       Basic Rent Roll in Excel (by Curious The George [NC]) Feb 3, 2010 5:41 AM
       Basic Rent Roll in Excel (by Tex [TX]) Feb 3, 2010 6:52 AM
       Basic Rent Roll in Excel (by Steve [FL]) Feb 3, 2010 7:36 AM
       Basic Rent Roll in Excel (by Curious The George [NC]) Feb 3, 2010 12:45 PM
       Basic Rent Roll in Excel (by Jeff S [MI]) Feb 3, 2010 3:55 PM
       Basic Rent Roll in Excel (by matt [WV]) Feb 3, 2010 5:10 PM
       Basic Rent Roll in Excel (by RonD [CA]) Feb 4, 2010 7:10 AM
       Basic Rent Roll in Excel (by Ernest Salinas [CA]) Jul 13, 2010 11:37 PM


Basic Rent Roll in Excel (by Lois [CA]) Posted on: Feb 2, 2010 7:26 PM
Message:

What information do you keep track of in a 'rent roll'?

I was thinking of creating one in Excel, but don't reall know the program all that well. Does anyone know of a template available?

thanks

--75.36.xxx.xx




Basic Rent Roll in Excel (by Curious The George [NC]) Posted on: Feb 3, 2010 5:41 AM
Message:

I'll tackle this one.

Date

Tenants Name

Date rent due

Amount of rent due

Amount of late fee if required

Amount of rent paid

Date paid

Late fee Paid

Date Paid

Total rents due

Total rents paid

Total late fees paid

Monthly Summary

Yearly Summary --24.136.xxx.x




Basic Rent Roll in Excel (by Tex [TX]) Posted on: Feb 3, 2010 6:52 AM
Message:

Morning Curious, I was wondering if might send me a sample of the spreadsheet. I to I'm having problems putting one together. you can send it to csnad@yahoo.com.

thanx --161.226.xxx.x




Basic Rent Roll in Excel (by Steve [FL]) Posted on: Feb 3, 2010 7:36 AM
Message:

I took a couple of community college classes on Excel a couple of years ago. I can't stress enough the value of doing that as a LL/Business Person. --67.166.xxx.xx




Basic Rent Roll in Excel (by Curious The George [NC]) Posted on: Feb 3, 2010 12:45 PM
Message:

Tex, I don't have an Excel spreadsheet. I just was trying to answer the question. If I did have one I'd be happy to share. I use Quicken Property Manager V2.0.

Perhaps someone who does have Excel setup for a rent roll could help you out. About five years ago I was competent enough on Excel to set up something but I am way to rusty now. --24.136.xxx.x




Basic Rent Roll in Excel (by Jeff S [MI]) Posted on: Feb 3, 2010 3:55 PM
Message:

To George's list - how about address of subject property ?

Also, if annual, anniversary date or beginning date of lease.

Possibly tenant contact info - phone #

Organize info as desired .... --24.192.xxx.xxx




Basic Rent Roll in Excel (by matt [WV]) Posted on: Feb 3, 2010 5:10 PM
Message:

I use Excel but I don't know how to help you out. If anybody does please post. --71.176.xxx.xx




Basic Rent Roll in Excel (by RonD [CA]) Posted on: Feb 4, 2010 7:10 AM
Message:

Tex, I sent you a very basic, user friendly worksheet. --75.84.xx.xxx




Basic Rent Roll in Excel (by Ernest Salinas [CA]) Posted on: Jul 13, 2010 11:37 PM
Message:

Could you send me a rent roll sheet too! I'm having trouble with excell also. Thanks my email is escanyo71@yahoo.com. --76.203.xxx.xxx





Reply:
Subject: RE: Basic Rent Roll in Excel
Your Name:
Your State:

Message:
Basic Rent Roll in Excel
Would you like to be notified via email when somebody replies to this thread?
If so, you must include your valid email address here. By entering your email address here, you agree to receive notification from Mrlandlord.com every time anyone replies to "this" thread. You will receive response notifications for up to one week following the original post. Your email address will not be visible.
Email Address: