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.

  10. My renter is usually behind in paying rent. For the monthly entries, do I list the amount he pays under the month that it is paid or the month that he is paying the rent for? Example: April 15 he pays 600.00 that is paying for March rent that is past due. Do I list that in the March or April monthly section?

    • I would probably enter that for March but I guess it doesn’t really matter as long as it all adds up at the end of the year. I don’t think it would hurt to put it for April either.

    • Renter usually behind? 1 day late and they get a notice and $25 a day late fee. Now it does not happen. Just a suggestion.

  11. This is great, thanks for sharing! Itโ€™s just what I was looking for. Do you keep a separate spreadsheet to keep track of your rental maintenance (not just fix it calls, but routine maintenance on the rental) and contacts? Or do you keep those on the same spreadsheet under a separate tab?

    • Hi Sara,

      I keep the routine maintenance just on the same spreadsheet, i just create another line item for it. I dont keep it in a different tab. Whatever month I do the “maintenance” in, it goes in that section, it doesnt matter if its a repair call or not.

      As for contacts, yes I keep a separate spreadsheet for real estate related contacts. Just a very simple and basic xls though, nothing special.

  12. It is a great spread sheet for small RE investors like me. Can we add more categories like repair with a specific explanation or HOA etc? Do you happen to have this spread sheet for open office? Thanks for sharing

  13. What is your system/process for keeping track of receipts for expenses? Iโ€™ve played around with integrating receipt images in an excel file and itโ€™s just not super convenient and explodes the file size quickly. Iโ€™ve thought of an excel with expenses numbered, then naming the receipt images with the numbers. Anyone have a system they really like?

  14. Just started using this for our first rental property. Perfect template for what we needed and like the summary page to print off for our accountant at the end of the year.

  15. Thank you cash flow diaries. I forgot where I got my spreadsheet template from . Weโ€™ve been using it for 4 years now, starting with a rental property for 2012. This is compatible with LibreOffice which is an open source and free office software for Linux and Windows. BTW it turns out that โ€œauto and travelโ€ is the most used expense type!

  16. Awesome spreadsheet. Wonderful resource. Would you please consider adding Capital Expenditures and Repairs to the dropdown menu?

  17. Since a couple of months looking for something like this, and voila finally got what I needed.
    Great Job!!

Leave a Reply

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

CommentLuv badge