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