I’ve created this profit and loss statement spreadsheet template to help you simplify tracking your rental property finances, so you can focus on growing your rental income and boosting your property’s financial performance. We set it up so the total section automatically calculates the final number. It even has a operating expense ratio calculation tool.
This customizable tool allows you to calculate gross income, net operating income, and even your net income after accounting for operating expenses like property management fees, mortgage interest, and more. Real estate investors and property owners alike can rely on this rental property income statement to evaluate property profit and loss in detail.
Download it today, make it your own, and be sure to check back for updated versions designed to streamline your income statement needs even further. Go get some of that sweet rental property profit waiting for you out there.
Download Spreadsheet
Sample Topics in the Spreadsheet Template
| Category | Details |
| Revenue Streams | Gross Rental Income |
| Late Fees | |
| Security Deposits | |
| Other Income (Specify) | |
| Total Rental Income | |
| Operating Expenses | Property Taxes |
| Property Management Fees | |
| Maintenance Costs | |
| Repairs | |
| Insurance | |
| Depreciation Expense | |
| Utilities | |
| Cleaning/Turnover Costs | |
| Legal Fees | |
| Marketing/Advertising | |
| Mortgage Interest | |
| Mortgage Payments | |
| Total Operating Expenses | |
| Profitability Metrics | Gross Income (Total Rental Income) |
| Subtracting Operating Expenses | |
| Net Operating Income (NOI) | |
| Pre-Tax Net Income | |
| Net Income (After Tax Obligations) | |
| Cash Flow | |
| Debt Service Coverage Ratio | |
| Year-to-Date Profit/Loss Summary |
Disclaimer – This worksheet is provided for informational purposes only and is based on a framework I personally use and find helpful. It is not intended to serve as financial advice, tax advice, investment guidance, or a substitute for professional services.The calculation of the Operating Expense Ratio (OER) and the interpretation of its ranges are general guidelines and may not apply to every situation. Your specific circumstances, local market conditions, and property type could lead to different outcomes. Please double check your work to ensure quality. Before making any financial decisions or acting on the information provided, consult with a qualified local professional, such as a financial advisor, certified tax professional, real estate expert, or accountant, for personalized advice tailored to your situation. Reliance on this worksheet without proper consultation is solely at your own risk, and the author assumes no liability for its use or interpretation. Always perform due diligence and consider expert input when evaluating property performance or investment opportunities.
Best Practices for Managing Rental Property Finances
(+other free templates)
Make the most of other free tools like the following.
- Rental property analysis spreadsheet
- Rental property chart of accounts template
- Rental property expense worksheet
- How to analyze a short-term rental
I’ve designed this spreadsheet template to make it simple for you to stay on top of your rental business finances, helping you track monthly rental income, calculate the property’s net operating income, and manage your real estate income statement with ease.
This tool includes dedicated sections for income expense statements, maintenance expenses, and other vital expense categories, ensuring your financial document is comprehensive yet easy to use. Tailor it to meet your specific needs, even if you’re managing a residential property or analyzing an investment property.
This customizable Microsoft Excel document also allows you to track income flows, monitor total income, and evaluate the financial health of your rental property. Plus, there’s a section that automatically calculates totals and metrics like P&L and the property’s financial health, saving you time during tax reporting or when you’re analyzing your purchase price over a specified period.
Download my template today to bring clarity to your income generated, rental property turns, and P&L management while streamlining tax purposes and expense tracking.
Don’t forget to check back often, I’ll be updating these tools to help you stay fully equipped to tackle your rental property’s financial performance.
How to Use a Rental Property P&L Statement
Here is how to make the most of this rental property profit loss statement template.
Download and Open the Template
Get started by downloading the template and opening it in your preferred program. It’s designed for easy use and customization.
Enter Your Monthly Income
Begin filling in your monthly income figures. This covers all revenue streams associated with your properties, letting you get a clear picture of cash flow.
Track Expenses with Precision
Add details for all your expenses, including property management fees and maintenance costs. The template is structured so you can create organized rental property statements.
Review the Automatically Calculated Totals
Make use of the section that automatically calculates key metrics, which saves you time and ensures accuracy. This includes totals for income, expenses, and net figures.
Assess Property Value and Performance
Use the template to analyze your property value over time and measure factors like free rental property profit, giving you an edge in financial planning.
Generate Comprehensive Reports
With the entered data, the template helps you produce detailed financial statements and even loss statement templates, making your records thorough and clear.
Adjust for Your Needs
Property managers and owners can tailor the template to meet specific financial tracking goals, making it a versatile tool for managing rental finances.
Follow these ste.s, and you’ll have a powerful resource to organize, analyze, and optimize your property’s financial performance efficiently.
Check Back for Updates
I’m always working to ensure these tools evolve to meet the needs of property owners and real estate investors. If you’re managing a rental property or refining your profit and loss statement, then you’ll find enhanced features to track rental income, net operating income, and gross rental income.
Updates will offer added functionality for calculating total operating expenses, property taxes, and even mortgage interest, making it easier to stay on top of your property’s financial performance. I’m also focused on improving the ability to analyze rental property income statements, track pre tax net income, and break down property profit and loss for both clarity and strategy.
Property owners and managers will appreciate streamlined insights into monthly rental income, property management fees, operating expenses, and net income. Don’t miss new additions designed to simplify reporting on income statements, debt service coverage ratios, and profit and loss reports.
Check back often to discover exciting new updates that can make managing your rental property even more effective.
Join Our Property Management Network
Thank you for taking the time to explore our content, we truly appreciate that you made your way all the way to the bottom of the blog post. You must be enjoying what you are seeing. We hope you find the free rental property profit and loss statement helpful in managing your rental property finances.
We’re excited to share that we are growing a professional network that connects real estate agents and property managers, creating a community that thrives on collaboration and shared expertise. We’d love for you to be part of this growing network.
Sign up today or join our newsletter to stay updated and engage with fellow professionals in the rental property industry.
![www.[website].com](https://ksrealtyagent.com/wp-content/uploads/2025/02/www.website.com_-768x593.webp)
