There are a lot of moving parts to owning and managing your own rental property business. This may leave you wondering, “How do you make the time to track your rental property income and expenses?”. Lucky for you, you can grab our rental property Excel spreadsheet template below.
If you have landed here, I’m guessing you already know the importance of tracking your business expenses and income. Accurate record keeping is the only way to know if your business is profitable. It can also reveal which properties make you the most money or alternatively are losing money. This information is super valuable as it can help you make business decisions moving forward.
If you are new to investing or property management it can be overwhelming as to how much there is to learn. There are a lot of great tools and property management software worth exploring. But if you are brand new to investing and just have a property or two you might choose to start with a simple Excel spreadsheet.
What Does the Spreadsheet Include?
Our template spreadsheet includes space to record information on up to five properties. It also has four primary tracking areas that include:
- Tenant Information
- Security Deposit Information
- Rental Income
- Expenses
The tenant information area includes space to record the tenant’s name, contact information, rent amount and lease renewal date.
The spreadsheet also has an area to record the date the security deposit is collected and how much was collected.
In the rental income area, you can track the date you collect rent each month, how much you collect, and if you charge a late fee.
The last section is for rental expenses. There is an area to record common rental expenses like your mortgage, utilities, and insurance by month. Also included is an area for miscellaneous expenses per property.
All of the spreadsheet columns are formatted so that the expenses total automatically. So you can easily view where you’re at financially at any given point in the year. This also makes it easy to view your gross income, expenses and net income. And finally since it’s in an Excel spreadsheet you can easily reformat any sections you wish.
Grab the Rental Property Excel Spreadsheet Template
You can grab a copy of the Rental Property Financial Spreadsheet by subscribing below. Not only will you receive the printable spreadsheet but you’ll have unlimited access to our entire Investment Property Resource Library. Subscribe for a limited time for just $2.99 per month to this growing digital collection of printable templates and tools for buying and managing investment properties.
It’s the perfect low-cost toolkit for anyone looking for a little more guidance to kick-start their passive income potential. No obligation – opt-out of the Investment Property Library at any time.
Subscribe below for the Rental Property Financial Excel Spreadsheet and access to our full Investment Property Resource Library
Some of the other printable resources in the Investment Property Resource Library include:
- Sample Inspection and Inventory Record
- Sample Rental Applications
- Rental Business Financial Spreadsheet – Excel Spreadsheet
- Rental Property Cash Flow Worksheet
- Newsletter Updates
Additional resources are added all the time so check back often.
If you want more information about how to use the sample inspection and inventory record or rental application you can follow these links. They are also included in the library as mentioned above.
I hope our spreadsheet is helpful as you start tracking your rental property income and expenses. It can be hard to make time but we try to sit down at least once a month to enter our rental checks and receipts. We usually try to do this each month when rent is due and keep that process every month.
