Track Rental Expenses and Income With This Super Easy Worksheet

You’re too busy right now to track every last penny, so you’ll get it done in April before your taxes are due.

Then April rolls around and you can’t remember what that $23 was for. What about this receipt for $125?…

…and you swear you have a receipt laying around somewhere for the $500 tool you bought.

Does this sound familiar?

You are leaving money on the table when you aren’t tracking your expenses properly. Stop overpaying the taxman!

I’ve grown to the point where I use actual accounting software that syncs with my accounting software, which is pretty expensive. I know that not everyone is at that level, so in order to help you stay on top of your bookkeeping, I am releasing the actual excel spreadsheet I used to track my properties for the first 3-4 years of my business.

This excel spreadsheet allows you to track all of your income and expenses. It is super easy to alter and make it your own.

Rental Property Expenses and Income worksheet Rental Property Expenses and Income worksheet

It is essential that you track every single dollar that flows in or out of your business through your rental properties. Honestly, you have no idea if you are making or losing money until you start tracking it properly.

For the data to be calculated properly, you will need to use the tabs on the bottom of the sheet and fill out the monthly income and expense worksheets. There is also a tab for mileage.

Rental Property Expenses Worksheet

Within the monthly sheets you will find the rental expenses spreadsheet to help you track all your different sources of costs.

These can range from simple repairs or maintenance to major improvements. You also need to be tracking vacancy costs, all of your mileage, and even tools you purchase to do repairs.

All of these things may be deductions (consult with your CPA) and tracking your rental property expenses can save you money at tax time.

The rental property expenses spreadsheet is customizable  and will help you track all of your expenses. The rental property expenses spreadsheet is customizable  and will help you track all of your expenses.

It’s really essential that you track every dollar of expenses. Remember, every dollar you forget about is one more dollar that Uncle Sam gets to tax.

Don’t leave money on the table by not having a rental expense worksheet!

Rental Income Spreadsheet

Within the monthly sheets, there is an income worksheet to help you track all your different sources of income.

This is what the rental income worksheet looks like This is what the rental income worksheet looks like

As you can see, you can choose from several options and record what the income is for.

By recording the dates and category of every income source, you will be able to identify areas where you can improve your business, determine who are good and bad tenants or help you think of creative ways to increase your income.

Just like you want to track every expense, you also don’t want to forget the record your income. Remember, if you forget to claim all of your income, the government could come knocking and they won’t be happy!