Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
General Landlording & Rental Properties
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 6 years ago,

User Stats

58
Posts
65
Votes
Brian R.
  • Burlington, KY
65
Votes |
58
Posts

Free Simple rent payment log (excel)

Brian R.
  • Burlington, KY
Posted

I created a simple log in excel for tracking payments. This is not for accounting purposes. It is just for keeping track of when they pay. It makes it simple to give future landlords a payment history. I let tenants know that paying early looks very good to future landlords. I send them a printout (email) each year so that they know we keep track and will give them a good reference for their next landlord. Only some of the fields are editable by default. You can "unprotect" the sheet if you want to make changes. Only the first date at the top is unlocked but the rest of the dates will fill in automatically. Use the first of the month so that days late is calculated. You can use the 5th of the month if you want the days late calculated from the 5th. Fell free to edit or distribute it if you like.

https://www.dropbox.com/s/33ve8x3tz3vmgyu/RENT%20P...