fbtwittergoogle877.413.7325

Free expense tracking spreadsheet for your rentals – we’ve updated it

Spreadsheet is updated as of 12/18/2016!
Are you done putting together your tax paperwork? I just finished mine and my accountant liked the spreadsheet.  In the process of using it I found, and fixed a few bugs, so if you tried it before… try it again.  And, if you haven’t started your taxes yet, its a great time to do so.

Here is the original post with some information about the spreadsheet, and links to full instructions.

We’ve created this simple spreadsheet, that we use ourselves, to track our rental income and expenses, and to report information to our accountant.  With it, you can create reports, including a Profit and Loss Statement (P&L) for each property or unit.  You can also see how much you are spending by category.  The spreadsheet is designed to do a lot of the basic work for you, while being customizable. You can add your own properties, expense categories, and income categories for use in tracking and reporting.

Download the spreadsheet here

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

License and instructions for Rental property P&L spreadsheet

License and Instructions

Property and unit list for Rental property P&L spreadsheet

Property and Unit List

Expense Categories list for Rental property P&L spreadsheet

Expense Categories

Income Categories list for Rental property P&L spreadsheet

Income Categories

Expense Entry tab for Rental property P&L spreadsheet

Expense Entry

Income entry tab for Rental property P&L spreadsheet

Income entry

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

Property report – Details

Property report - Income and Expense by Category report for Rental property P&L spreadsheet

Property report – Income and Expense by Category

Property report - summary for P&L spreadsheet

Property report – summary

Portfolio Summary tab of P&L spreadsheet

Portfolio Summary

Category summary tab of P&L spreadsheet

Category summary

You Might Also Like...

30 Comments

  1. Jason Hershey, Designated Broker on September 8, 2013 at 10:40 pm

    The link to the article is fixed.

    • Wendy Burdick on August 10, 2017 at 9:03 am

      I would like to alphabetize the expenses in the Expense Categories worksheet before I start using it. However, it is locked.

      • Tellus Real Estate on August 17, 2017 at 2:42 pm

        Hi Wendy, the password for the expense spreadsheet is “tellusre”. Just use the “REview” tab and unlock the expense sheet with that password and you should be able to sort the values

  2. Bob Bihler on October 10, 2013 at 9:59 am

    Hey guys, thanks for the great expense tracking spreadsheet. I’ve tried several times to get the ‘Invdividual Property Report’ to generate a report, but all I’m seeing is error codes and blanks.
    Before putting in more time entering data wondered if anyone else had this problem, and if you
    have a ready solution, or if you can point me to a similar SW package.

    BTW; the other reports are working fine.

    Thanks in advance, Bob Bihler

    Copy paste of what I’m seeing on the Individual Property Report sheet:

    Income Category Income Amount Expense Category Expense Amount
    #NAME? #NAME? #NAME? #NAME?
    #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    #DIV/0! #DIV/0! #DIV/0! #DIV/0!

    Rental income Accounting
    Late fees Advertising
    Utility billbacks Attorney and legal fees
    CAM charges Bank charges

  3. Jason Hershey, Designated Broker on October 10, 2013 at 12:39 pm

    Hi Bob, I’ll check it out and let you know what I find out shortly.

  4. Jason Hershey, Designated Broker on October 10, 2013 at 12:51 pm

    Hi Bob, I’m not able to reproduce the problem you are seeing right off. The kinds of errors you are seeing are typical in Excel if the references to cells are messed up for some reason. this can happen if sheets get renamed or something similar.
    For example, if you select the first cell in that report that has an error you should see something like this in the formula box:
    =IF(‘Income Categories’!A1=””,””,’Income Categories’!A1)

    If you want, send me your spreadsheet in email and I’ll take a look. I can probably figure out what happened plus it would give me a chance to see if there is a way I can prevent it from happening in the future. 🙂

    Another free option for doing this sort of thing is a web application called “TrexGlobal” that will let you track income and expenses for free, up to a certain number of properties. I used to use it myself. Here is a link: http://www.trexglobal.com/partner/jason_hershey (if you sign up with this link, you simply see my smiling face at the bottom of your page when you sign in)

  5. Bashir on March 1, 2015 at 6:59 pm

    a quick question in reference to this spreadsheet, is there to modify so that you can use a negative dollar value when entering in the expense sheet. In other words say I have paid a utility bill of $150 and I ended getting a refund from the utility company of $50 after 2 months. So I would need to enter -50 and reduce the utility expense by $50. Thanks

  6. a light on March 6, 2015 at 8:01 am

    I’m having trouble entering the name of my property in the “Property/Unit” column. It displays a drop-down menu, asking me to add the name of my property to that before I add it to the column. I’ve tried to figure out how to do this via just general Googling for using excel spreadsheets, but haven’t had any luck. Can you give any help here?

    • Jason Hershey, Designated Broker on March 10, 2015 at 6:42 pm

      There is actually a separate sheet for entering property names. It is the last sheet in the workbook, named PropertyUnit_list

  7. julie on March 11, 2015 at 11:33 am

    I’ve entered property names on the unit list and did a test income and expense entry just to see what it would look like on the various reports but I was unable to see anything but error messages on the report. Before I get too into filling this whole thing out, could you show me what I might be missing here?
    Thanks!
    https://drive.google.com/file/d/0B1a0f90CZjyXdHNjR3ROdGFrSWs/view?usp=sharing

  8. Tim on March 27, 2015 at 10:17 pm

    When I enter an expense on line 100 on the expense tab all is fine , when I enter an expense on line 101 I get an error on the individual property report tab . Any thoughts ? Same goes for Income entry .

    Thanks Tim

    • Jason Hershey, Designated Broker on April 10, 2015 at 10:54 pm

      Hi Tim! Thanks for catching this. The formula is only looking at the values through row 100, so I need to update it. I’m getting ready to post an update to the spreadsheet and will include this change with the update. Thanks!

      • Wayne Blackwood on March 20, 2016 at 2:31 pm

        First, let me say thank you for this wonderful Free tool. Its just what I’ve been looking for; having said that, I was wondering if you posted an update to the worksheet to address the issue that Tim (Tim on March 27, 2015 at 10:17 pm) was having; not being able to get pass the errors after line 100. I have about 300 individual entries. Thanks in advance.

      • John Nixon on December 18, 2016 at 12:14 pm

        Have you ever updated the Line 100 Problem?
        I can not get the individual reports to show anything after line 100.

  9. LG on June 13, 2015 at 12:29 pm

    Thank you for the profit and loss spreadsheet. I am experiencing the same error that Bob Bihler posted above in 2013. I have entered expenses for a unit, but they don’t show up on the individual unit report. The dollar amounts there are blank.

    Anything I can check for on my end?

    • Jason Hershey, Designated Broker on June 15, 2015 at 7:05 pm

      Are you using the standard version of Excel? It may not work with Excel online, or with excel compatible applications like Numbers or Google’s version. If you want, you can email me a copy and I can see if it will open on my end.

  10. Eric on July 17, 2015 at 11:07 am

    Is therre a way to produce a balance sheet by linking to your spereassheet. Sorry i am illiterae when it comes to accounting.

    • Jason Hershey, Designated Broker on July 21, 2015 at 9:58 pm

      Not really. If you assign the purchase of any assets to their own expense category (or categories), it would help you in maintaining your balance sheet. You could simply use that total to update the balance sheet category (adding to the balance). The cash account in the balance sheet might be updatable by subtracting all the expenses from that… assuming you are running everything on a cash basis.

      Hope that helps.

  11. Jim Hueske on November 9, 2015 at 1:07 pm

    Jason,
    Started using your spreadsheet a couple of days ago.
    It is just what I have been looking for. We have owned an ocean front vacation rental property in Yachts, OR since 1999.
    I used Quickin 2004 till it crashed. Intuit does not support the Mac very well.
    I have run into a small problem, with your spreadsheet. For some reason, A26 is trying to look like a cell in row 4, of the expense tab.
    When I try to run a Portfolio Cat Summary, it is giving me incorrect totals. My totals for garbage should be 466.50/ it is only finding $400.
    It is also giving me several #REF! in the summary.
    I do know a bit about Excel, but not enough to figure this one out.
    I there anyway to sort the column A, the date column, after I have entered data?
    I am attaching a copy of my data.

    Hoping to sell the property this Spring. Retirement time!

    Regards and thanks for your help.

    Jim Hueske
    5415540891

    Sent an email the other day. Can’t attach here.

  12. hmoud khresheh on August 13, 2016 at 4:41 am

    Mr Jason hi
    first of all I would to thank for this very good job:
    after i download the sheet,it is not open in excel

    could you help me if you don’t mind

    • Tellus Real Estate on December 18, 2016 at 9:35 pm

      Hello Hmoud, I’m not sure why it would not open in Excel. It should be fine. I’m not sure about Excel online or Excel for Mac, though. I’d suggest trying the version I just posted that has some fixes.

  13. Wayne Mahoney on January 10, 2017 at 11:14 pm

    Hi. I started using this for rentals from Sept 2016 and on. I just entered the expenses as I found them in my records thinking I could sort them when I was done. I figured out that the sheet is protected with a password so I can’t sort. I looked at your instructions and it said most were removed. Can I have the password or should I not be able to sort? I could share it on a google doc and let you remove the protection if that would be easier.

    Nice sheets, thanks for your help.

  14. Justin Yung on January 19, 2017 at 4:08 am

    There is a free online site for tracking income and expenses and easily generating reports. Check out http://www.rentalincomeexpense.com

  15. Linda on February 2, 2017 at 7:00 am

    I love your worksheet! Thanks so much! I need to add many more rows (not sure how many yet). How do I add extra rows? The workbook is protected and I can’t “add” them the normal way. Am I missing something?

    • Tellus Real Estate on April 2, 2017 at 9:18 pm

      Hi Linda,
      Sorry, missed your question when it came in. You should be able to simply add rows as long as you do it before the row that says “Enter additional rows above this row”. In either case, the password for the workbook is simply “tellusre”. The password protection is there only to help prevent folks from accidentally breaking the formulas. Cheers!

Leave a Comment





This blog is kept spam free by WP-SpamFree.