How to Track your Monthly Rental Expenses


How To Track Your rental property expenses


Accounting! Ugh! So boring and nasty! But it must be done. Bookkeeping is vital to keeping track of all your expenses, income and general notes on all your rental properties. It’s funny because I know of a few real estate investors who don’t really track it. They just collect the income, it goes into their bank accounts and they are happy. They pay for repairs from their personal accounts and don’t log and record all the repairs they do. This my friends is the WRONG way of keeping track of your rental properties.


How To Track Your Rental Property Income and Expenses using This FREE Spreadsheet

The correct way involves tracking every little repair, every single mile you drive to get to and from your properties and recording when your rent payments are coming. Everyone loves collecting rent checks and everyone one loves making life easier during tax time. Plus its super awesome to see them on my awesome rental expense spreadsheet which you’ll see below. Also by doing this, your CPA is going to love you. If you are not deducting all your expenses you can get from owning rental properties then you are missing out on additional income and should start doing this properly immediately.   I do it once a month and it only takes a few minutes.

Check out the Top 13 Rental Property Tax Deductions if you are not sure what you can write off.


The spreadsheet I use keeps track of all expenses monthly for the year and provides a nice little summary of all the months.

Check out this cool summary page:


For the data to be calculated properly on that page you need to use the additional tabs at the bottom of the spreadsheet labeled by month. As you insert numbers in these columns, it will auto populate the summary page. But you absolutely have to use the drop down in the expense category. If you don’t, it will mess up the formulas on the summary page.

Here is a screenshot of one of the monthly tabs where you will input the data, notice the drop down being chosen. Dont mess with these!!

Grow your net worth today with your FREE Personal Capital account.





Start keeping track of your monthly rental expenses now. Here is the rental And income expense template for you to download and use at your own pleasure.

What do you think of the spreadsheet?

Please show some love by sharing this article.

Cash Flow Diaries


    • Jen! You are my first comment on this post! Ive had a few people email me thanking me for the spreadsheet but I always wondered why no one left a comment 🙁

      Thanks for doing so and Im really glad you like the spreadsheet!. Its definitely pretty cool and handy.

  1. This is a great spreadsheet! Exactly what we needed. Thanks for sharing.

    • Hi Melanie, It really is a cool spreadsheet. Glad you like it. 🙂

  2. Just bought my first rental properties and this is perfect for me!! Thank you

    • Hi Cheri,

      Awesome! Congrats on your first rental property. You are now one step closer to financial freedom! 😉

  3. The spreadsheet is awesome. I was wondering if I can add categories to the drop down box-for example postage, phone, HOA, Principal. Not sure how to do this. Also I need to separate my regular rent income from my Section 8 income.

    • Hi Debra, Sure you can add categories to it, you can do anything you want to it but you will have to figure out how to do all of that. Just make a copy of the original file to have as a backup in case you need to start over but I would just start messing around with it and see if you can figure it out.

  4. Love this spreadsheet, just what I was looking for. Trying to figure out how to get the Excel spreadsheet to work on my MAC!

    • That spreadsheet really is awesome! Glad you like it. Oooh, i have always been a windows guy but good luck on the Mac!! 😉

  5. Thanks Alexander for the spreadsheet! Saves me a lot of time and has everything I need. Love your blog also and your journey. We are closing on our first this week and second within a month and having fun doing it!

    • Thanks Tom!! The spreadsheet is awesome indeed! Congrats on your first investment property. That is huge!! And the 2nd within a month! Thats my kind of speed!

  6. Thank you so much, I have been using your spreadsheet for a few months now and just love it, what a time saver and perfect at a glance view 🙂

  7. Thank you so much for this wonderful (and free!) spreadsheet. For those who are not enlisting the help of a professional property management company to keep their records in order, something like this can be very useful. I would love to add that all property owners performing their own accounting should keep a hold of important documents regarding each tenant, anything related to your property, and your financial statements. In addition, you should keep a running list of all important contacts as they relate to your rental property business so that you can get in touch with anyone that may have an affect on your bookkeeping. Thanks again for sharing this helpful resource!

  8. looks awesome! just started here are a couple quick questions 1) where do I insert my mortgage. 2) is this for one calendar year only? start a blank one for next year?

  9. Just curious as to why you chose to include mortgage interest as an expense? While it’s a deductible expense, it does not factor into your NOI for purposes of evaluating returns.

    • Hi Greg,

      I dont personally deduce mortgage interest like that. Those items are just generic items from when I originally got that spreadsheet. You can modify it as needed.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge