Details section of property report for Rental property P&L spreadsheet

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!

Download the spreadsheet here

You can find a full description, and simple instructions here….


  1. Audy on July 21, 2015 at 6:50 pm

    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 on July 21, 2015 at 9:50 pm

      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.

  2. Scott Edwards on April 15, 2016 at 9:28 am

    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.

Leave a Comment