If you are running a rental property, hosting on AirBnb or Vrbo, then this excel template is perfect for you.

To see a detailed walkthrough of this template on YouTube, check out this link: https://youtu.be/xHxNGPqSTpc (please note, this walkthrough is of the full featured rental income statement, all features in this walk through may not be included in this listing).

The landlords spreadsheet is designed initially for five properties, however you can easily add as many properties as you need.

In this landlords spreadsheet, you can customize all property, income, and expense account names (the spreadsheet comes pre-built with commonly used income and expense names, but you can change them as you need). Once you update your property names, simply type in transactions and the entire spreadsheet updates automatically. The rental profit and loss statement summarizes data for month end, year to date, and the prior year.

It also includes a month-by-month profit and loss statement, as well as an automated summary analysis page to see your results from multiple views, helping you to see better your results and what areas you can improve.

The income statement template includes an automated bank reconciliation tool to allow you to easily reconcile your checking accounts. Pre-built to reconcile up to three bank accounts.

Includes an automated customer/payor tracker to track all income and expenses by customers, tenants, vendors, and employees.

The income statement template includes an automated bank reconciliation tool to allow you to easily reconcile your checking accounts. Pre-built to reconcile up to three bank accounts.

Includes easy dropdowns throughout the template to assist you in entering transactions correctly and step-by-step instruction.

To view other rental property listings, click: https://www.etsy.com/shop/simpleexcelsolutions/?section_id=40843219

To view Multi-Building Profit and Loss listings, click: https://www.etsy.com/shop/simpleexcelsolutions/?section_id=40241925

To view other general Profit and Loss Listings, click: https://www.etsy.com/shop/simpleexcelsolutions/?section_id=34983659

As with all my products, please contact me anytime for simple modifications/customizations at no additional charge.

Thank you for viewing my spreadsheet!
Andrew