Rental Income and Expense Worksheet
Between maintaining your properties, communicating with tenants, and bookkeeping, there's no question that being a landlord keeps you busy. With so many competing priorities, it's always a relief to find tools that can save you time, effort, and money.
Key Point Module
- 1 Income and expenses are an essential part of effectively managing your rental.
- 2 Personalize your expenses with this worksheet.
- 3 Totals are automatically calculated as you enter data.
- 4 This sheet will also track late fees and any maintenance costs.
To help you stay on top of your bookkeeping and generate the most value from your investment, we’ve created a free Google Sheet / Excel worksheet that you can use to track monthly rental income, expenses, fees, insurance policies, and more. You can view, make a copy, download, and then use the worksheet here.
Convenient and easy to use, this worksheet is designed for property owners with one to five properties. It features sections for each category of income and spending that are associated with rental property finances.
You’ll start by entering the stats on your properties, and then enter the appropriate dollar amounts into each itemized category. For example, under “rental income”, you’ll find areas for rent plus late fees. There’s also a section for security deposits, so you can easily keep track what needs to be returned when your tenants move out. Plus, most of the major expenses, such as maintenance and utilities, are already listed for you. Once entered, the worksheet will calculate the totals for you, so you can see your gross income, net income, and total yearly expenses refresh every time you make a change.
The best part? It’s all customizable – create and delete categories and otherwise adjust as needed to fit your unique situation. You can use it to create a single hub for your rental finances, or you can as a baseline to create your own.
To download the free rental income and expense worksheet template, click below to view the google sheet.
Note: You can also download the sheet as an excel file to use on your home machine offline. Or you can click here to make a google sheets copy.