Spreadsheet Overview
Track your rental property income and expenses with this easy to use property management spreadsheet.
Landlord Rental Property Spreadsheet Features
- Track rental income and expenses
- Create your own income and expense categories
- Customizable income statement reports
- Track business bank accounts such as checking and credit card accounts
- Reconcile bank accounts
- Track tenant deposits
The landlord rental property template has a total of 14 registers. Use each Excel register to track your financial accounts, such as your checking and credit card accounts. You can track the running balances of those accounts and reconcile those accounts. As you enter transactions into the accounts, assign each transaction to the appropriate categories, such as income or expense categories.
Create custom income and expense reports so you can see how your property is performing and whether it is profitable. You can create category reports, reports by vendor, reports by property location, reports by accounts, and reports by time periods.
Split transactions in the checkbook app for rental property to better reflect your rental income and rental expenses.
You can also chart and track the value of your asset and liability accounts over time so you have a visual picture the trending value of your cash and debt accounts.
The landlord property tracker is a great checkbook app with beautiful dashboards, reports and charts to help you analyze your rental properties business income and expenses.
The landlord income and expense tracker spreadsheet is designed for small businesses self-employed individuals who are managing one or small number of rental properties.
Whether you are a property owner looking to rent out your home for the first time or a seasoned landlord with several properties, this rental property spreadsheet can help simply your real estate bookkeeping, monitor rental expenses, analyze potential opportunities (such as whether to increase or decrease rents), and maximize your properties return on investment.
System Requirements
-
Windows PC Computer: Compatible with Microsoft Excel 2021, 2024, or Excel for Microsoft 365.
-
Mac Computer: Works perfectly with Microsoft Excel 2021, 2024, or Excel for Microsoft 365.
-
Flexible Set Up: Save to and use solely on your local computer for maximum data privacy or use with OneDrive or Dropbox for anywhere access.
-
Formatting Note: Formatted with standard US Dollar signs ($) and traditional MM/DD/YYYY date entry fields.
-
Automation: This spreadsheet utilizes built-in Excel macros to automate and simplify your money management. After downloading the spreadsheet, see simple video instructions for how to enable macros in less than 60 seconds.
-
Software Note: Requires a full desktop version of Microsoft Excel installed on your computer. This spreadsheet is not compatible with Google Sheets, free browser-based Excel Online, Apple iPad, or mobile phone apps.
