SFH Rental Spreadsheet

[Brandan Orcutt]

Hello All,

I have a few questions about organizing and allocating rental payments.

Since I am new to this world, I wanted to see how others are keeping track of everything.

1. Is there a standard spreadsheet that everyone uses to keep track of a property, maintenance, and rent payments, etc?

2. How does a rent payment apply to a rental? For example, if I get a check for August 1st , do you put into the spreadsheet that it applies to July interest and taxes or is it for August? I guess I'm just trying to find out if the payment is for last month or the current month.

3. Where is everyone putting the money? Should there be a separate account for each house? Is there a checking and a savings for each house and I put the tax $$ coming in into the savings?

Thanks in advance for every ones advice/tips. I just want to learn what is the norm for keeping up with a rental on a spreadsheet and bank accounts.

Brandan