Property management in Excell

[Mary Jay]

Hi guys,

I am a small landlord, so I dont really want to pay monthly fees to property management company at this point (I will do it later on)

So I was thinking of doing it in Excel (since its free), but not sure on how to organize it (I am not really good with things like that)

So I was thinking of may be doing one excel sheet per property? Then have on top portion income (rents) and then bottom portion would be expenses... Have a column for each month? And do a separate excel sheet on each property every year?

Or may be better to have the same file for one property and just have several excel sheets in that file for 2017, 2018, 2019?

I hope I am making sense with my explanations...

How do you organize in excel? May be someone can post a picture? If you dont mind to share...

Thank you so much! 

[Nathan Gesner]

New excel file for every calendar year.

New tab for each unit.

Top of the sheet will have the unit address, tenant(s) name, contact information, etc. Below that are the headers for each column. Freeze the headers and tenant information so it's always displayed.

After that, it's personal taste but you want to ensure you track every payment, the date it was paid, what the payment was for (rent, late fee, lease renewal fee, security deposit, etc.), the form of payment (check, online, bank deposit, etc.) and then similar details for any expenses.

I also recommend a section to the right where you can keep track of maintenance for that unit. that would include the date reported, description of problem, contractor hired to repair, expense, date repair complete, etc.