The spreadsheet is updated as of 12/18/2016!
One of the most popular items on our website is this Rental Profit and Loss spreadsheet. Over last few months we’ve received several questions and more than a few reports of problems and bugs. We also received a couple of requests for changes and we’ve tried to accommodate all that we could.
The updated workbook now supports tracking expenses and income for individual units. There is now also a report that summarizes all units on one page.
Lastly, I removed the password from most of the pages so people can modify the workbook to meet their own needs. Good luck and hope you find it useful!
You can find a full description, and simple instructions here….
Hi,,I am excited to use your income and expense spreadsheet. How do I get the individual property report to fill in. I have fill in every other sheet, but the individual report to fill in. Thank you.
Jason Hershey, Designated Broker says
Hi Audy! The individual report will fill in automatically when you select the property name from the drop-down. That is cell A3 (first cell, 3rd row down from the top.
In the blank spreadsheet it will say “123 Main St., Anytown”. You should select the name of your property, of course.
Scott Edwards says
Hi, I too am trying to get the individual property report to fill in and to correct an issue with a field auto-popuating and it asks for a password. Can you tell me what the password is? Thanks.