Home >> Pattern Tutorials and Kits  >> Accessories >> Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties

Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties

Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties

Product Details:

If you manage multiple rental properties for another owner of that property, this template will help you with tracking the rental income and expenses and will break down the rent due to you and the owner, as well as summarize expenses paid by you and the owner.  The template will track up to 20 properties.

How it works ~
•Set up - See last slide where you would enter the property names and the percentage splits that have been agreed to between you and the owner.  The file will come populated with some general payment and expense categories; however you can add or change the current categories to fit your situation.
 

After you have that information set up, you will enter most of the details in the below 2 pages –
 

Revenue – Here you can enter the details related to your rental income for all properties-
o When you select the property name and total amount paid, the file will split the amount due to manager and owner, based on the percentages you entered in the first page.
o If you charge fees that the renters pay to you but are not split with the owner, you will be able to enter these as well.
o The top of the page will give a YTD totals for Owner and Manager revenue.
o Another total at the top will calculate the amount of ‘Rent Being Held’.  This is for when rent is paid prior to the move in date.  The rent will not appear as income in the summaries until the move in month.

Expenses – Here you will enter all expenses related to your properties-
o Simply select the property name, if the expense is an owner or manager responsibility, description, category, date paid and amount.
o The total expenses for manager and owner will sum up at the top of the page.
 

Owner Summary (see 2nd picture)
The owner’s summary will pull information from both the revenue and expenses pages to give a nice snapshot of each month/property that you have selected.  All that you will have to do is click a ‘Refresh All’ button anytime new data is added into the revenue or expenses pages.  You will then be able to select the month and property name by using the filters in the table (directions are included).
The top of the summary will show the total revenue due to the owner, total expenses and total revenue minus expenses (total due) for the month selected.
 

*The summary tables can be copied and pasted into an email or printed out to be mailed.  It's not advised to email the spreadsheet to an owner, as they would also have access to your other properties.

Manager’s Summary (see 1st picture) – This page consists of 2 charts that will show the total revenue, expenses and net profit by Month and per Property.
 

*You will receive an Excel Spreadsheet and directions in PDF.  Version used is MS 2007 but works fine with other versions of excel. 
 

*You do not have permission to distribute or re-sell the template, so please don't do it.
*All templates come personalized with your name or company name.  Please let me know if you have a preferred name to use at checkout.

Thanks for visiting!
 


Shipping :
Items ships from : United_States.

Payment Method:

We accept the following forms of payment:
 
Ship To Single Cost With another Item
United_States $ 0 $ 0
Everywhere Else $ 0 $ 0


More Creations from this Artist!

Vacation Rentals by Owner Expenses Spreadsheet Rental Income Tracking Template   Property Management Spreadsheet Excel Template for Tracking Rental Income and Expenses   Printable Wedding Venue and Reception Budget Planner   Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals   Sales Log Multi Venue Monthly Sales Organizer   Project Tracking Program Custom Made Project Plan Template   Business Financial Printables  Shop Sales and Expenses Spreadsheet   Annual Inventory Template Beginning and Ending Year Inventory Tracking  



Price: $ 10.00



Product Information
Product name - Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Price: USD 10.00
In Stock: 0
Stats

Listed On 2014-01-24

4878 views

Shop Owner
Shop Section
Shop Info
12 items for sale
Action
Bookmark and Share    Share
Report this Item - Report this Product

Follow Us

Close
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties
Property Managers Template Rent Income and Expense Tracking Spreadsheet For Managers with Multi Owner Properties