Good Spreadsheet for Tracking Rental Properties?

Question

I'm looking for a good Excel spreadsheet for tracking income and expenses on Excel for my rental propeties, but I'm striking out and I don't have the patience to create one myself! Does anyone have a good template they could email me, that I preferably don't have to sell my arm, leg and first born for? I've seen some templates for sale online, but lets be honest, who really wants to PAY for a freaking spreadsheet!?

I would certainly appreciate the help! This past tax season, my accountant was NOT pleased with the sorry excuse for a workbook that I had!

Thanks in advance!

I would certainly appreciate the help! This past tax season, my accountant was NOT pleased with the sorry excuse for a workbook that I had!

Thanks in advance!

Joe Martella · Answer

This is from an earlier post I made. I hope this helps. I have used TurboTenant successfully 4 times now.

I currently manage 4 SFH rentals in addition to having a very demanding full time job. There are many free resources out there for smaller investors. I am going to list them:

• TurboTenantIt is completely free to advertise your rental, screen your tenants.You upload your pictures, write a description and it posts to 20+ websites for freeTakes about 24-48 hours for leads to come in.Once you select a tenant, they pay for the background check, upload documents (paystubs, ID, W2) and it is all set to you.It even helps you build a lease after you select a tenant (there is a $30+ fee for the lease)My referral code .disclosure. I do not get any money from TurboTenant, nor am I an owner or investor in the company.They have a referral program where they will send me a $25 home depot gift card for a referral - you don't have to use the referral codeI also use them for rent collection now since they do free credit reporting for tenants
• It is completely free to advertise your rental, screen your tenants.
• You upload your pictures, write a description and it posts to 20+ websites for free
• Takes about 24-48 hours for leads to come in.
• Once you select a tenant, they pay for the background check, upload documents (paystubs, ID, W2) and it is all set to you.
• It even helps you build a lease after you select a tenant (there is a $30+ fee for the lease)
• My referral code .disclosure. I do not get any money from TurboTenant, nor am I an owner or investor in the company.
• They have a referral program where they will send me a $25 home depot gift card for a referral - you don't have to use the referral code
• I also use them for rent collection now since they do free credit reporting for tenants

• It is completely free to advertise your rental, screen your tenants.
• You upload your pictures, write a description and it posts to 20+ websites for free
• Takes about 24-48 hours for leads to come in.
• Once you select a tenant, they pay for the background check, upload documents (paystubs, ID, W2) and it is all set to you.
• It even helps you build a lease after you select a tenant (there is a $30+ fee for the lease)
• My referral code .disclosure. I do not get any money from TurboTenant, nor am I an owner or investor in the company.
• They have a referral program where they will send me a $25 home depot gift card for a referral - you don't have to use the referral code
• I also use them for rent collection now since they do free credit reporting for tenants

• StessaStessa is a website that I use to track all my expenses.It is another free site and you can pull reportsYou even can upload receipts.Roofstock recently purchased StessaCompletely free
• Stessa is a website that I use to track all my expenses.
• It is another free site and you can pull reports
• You even can upload receipts.
• Roofstock recently purchased Stessa
• Completely free

• Stessa is a website that I use to track all my expenses.
• It is another free site and you can pull reports
• You even can upload receipts.
• Roofstock recently purchased Stessa
• Completely free

• Zillow Rental ManagerI use this to collect rent.Free for the landlordTenant only pays a fee if they use a credit card to pay rent. ACH is freeTakes about 5-7 days for the funds to hit your bank account
• I use this to collect rent.
• Free for the landlord
• Tenant only pays a fee if they use a credit card to pay rent. ACH is free
• Takes about 5-7 days for the funds to hit your bank account
• ExcelI use an excel spreadsheet to track my check register. You can download a free template online
• I use an excel spreadsheet to track my check register. You can download a free template online

• I use this to collect rent.
• Free for the landlord
• Tenant only pays a fee if they use a credit card to pay rent. ACH is free
• Takes about 5-7 days for the funds to hit your bank account

• I use an excel spreadsheet to track my check register. You can download a free template online

Other free websites I haven't used.

• Avail.co
• This is another free website that I learned about this week listening to a podcast (may have been a BP podcast). I haven't used it and cannot speak to it.
• This is another free website that I learned about this week listening to a podcast (may have been a BP podcast). I haven't used it and cannot speak to it.

• This is another free website that I learned about this week listening to a podcast (may have been a BP podcast). I haven't used it and cannot speak to it.

• Zibo.comThis is another free website where you can collect rent electronically and have an interest checking account.I am still looking at this, because not all my tenants pay electronically. 2 like to mail checks. I haven't looked at how to deposit those - I don't like mobile deposits.
• This is another free website where you can collect rent electronically and have an interest checking account.
• I am still looking at this, because not all my tenants pay electronically. 2 like to mail checks. I haven't looked at how to deposit those - I don't like mobile deposits.

• This is another free website where you can collect rent electronically and have an interest checking account.
• I am still looking at this, because not all my tenants pay electronically. 2 like to mail checks. I haven't looked at how to deposit those - I don't like mobile deposits.

There are many free resources to use before you start paying for services. Out of my 4 rentals, I have placed 2 tenants with TurboTenant - one tenant is on year 3 and the other tenant is on year 2. I listed the properties, took some pictures (they weren't the greatest pictures) and had it rented in a week. I was able to recycle the leases upon renewal and didn't pay any commissions for the rental, which is a savings of over $4,000 if you consider the rental commission to be 1 month rent. I highly recommend it.

Here are some threads you may want to take a read of:

https://www.biggerpockets.com/...

Luka Milicevic · Answer

On bigger pockets go to Tools- calculators and see if there's anythign there that could work for you.

If not, I personally use my own. It shouldn't be complicated. Just something really basic.

Bill B. · Answer

If you can swing $50. Quicken is overkill for 20 properties. But it’s easy to learn and will auto download all your bank and credit card transactions. It will also give you reports by category or property. It also tracks loan pay down and categorizes the payment, gives you net worth and income. (Which can include or exclude your personal income.)

Nathan Gesner · Answer

I don't know where you are looking, but there are amazing spreadsheets for sale on Etsy for less than $10. They can handle 10 - 20 rentals, are color coded and formatted, and even come with instructions on how to use them.

Example: https://www.etsy.com/listing/1841053667/rental-property-book...

Jessica Sudyn · Answer

This is some great information! thank you!!!

Good Spreadsheet for Tracking Rental Properties?

Good Spreadsheet for Tracking Rental Properties?

Most Popular Reply

7 Replies