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:
|
|