Tracking your income and expenses is an essential part of managing your rental property. To help you stay on top of your bookkeeping, we've created an easy-to-use Excel worksheet that you can personalize to meet the needs of your rental business. The worksheet, made for property owners with one to five properties, is broken down by month and will auto-calculate totals from each spending category to provide you with your gross income, net income and total expenses for a calendar year.
Track your rental finances by entering the relevant amounts into each itemized category, such as rents and late fees in the "rental income" category, or HOA dues, gardening service and utilities in the "monthly expense" category. The amounts you enter will automatically total down and across, giving an at-a-glance view of your monthly and yearly expenditures.
Use our free worksheet template to manage your rental finances quickly and painlessly, or use it as a starting point to help you create your own.Download Worksheet
Note: This is a Microsoft Excel document. For this document to work correctly, you must have Microsoft Office 1997 or higher installed on your machine.