Home >> Paper and Books >> Notebooks >> Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking

Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking

Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking

Product Details:

This template is designed specifically for rental properties that have multi-units, such as apartment complexes or duplexes, etc.   The template has an extra focus on tracking variable expenses per apartment/ unit and will also help keep track of standard expenses and rental income.  There are 5 sections within this template:

Standard Monthly Information – This is where you can enter the monthly rental income and expenses that are the same each month, such as maintenance fees, etc.   You will enter the rent or expense and the amount will populate for all 12 month automatically.  You’ll be able to enter a new rate and an effective date for increases (just 1 per year).  You will be able to over-write any amounts if there are more than 2 changes within 1 year.

Variable Expenses Detail – There will be 2 separate worksheets to enter variable expenses for 2 different apartment/duplex complexes.  In each you can enter the specific apartment #, expense description, category and the date and cost.   You will be able to enter as many apartment/unit numbers within each of the 2 complexes.

Variable Expenses Summary – There will be 2 separate summaries for each apartment/duplex complex, which will show 3 different tables that will summarize the information entered in the detail worksheets:
• Expenses by Apartment – This will list all the apartment numbers and beneath will show the specific expense description that you enter (not the category) and beneath will list the date and total cost to the right.

• Expenses by Apartment & Expense Category – This is similar, except you can filter by the expense category at the top. In the screen shot, I have it filtered by Depreciation Expense. You will be able to filter it by clicking on the little icon I have circled.

•  Expenses by Month, Filtered by Apartment - When all apartments are selected, this table will show the month and then the expense description and total costs. In this example, I have it filtered by Apt #5.

Monthly Variable Expense Summary – This will show the month and total expenses per total apartment/duplex complex.

Main Summary – This page will link together both the variable expenses and the standard monthly expenses and rental income, to give you the overall big picture view as well as assisting in tax preparation.  The expenses categories that you select and that are shown in the summary are the same as those needed for schedule E. 

This template is set up to handle as many apartment #’s as you need it to, but only 2 different apartment/duplex complexes. Different versions of the file can be saved if you need more or customizations can be made for an additional charge.  Feel free to contact me with any questions. 

You will receive an Excel Spreadsheet version is MS Office 2007, but should work fine with other versions of excel. This file is not meant to provide any type of tax advice.

You will receive this by email. You won't receive a physical copy in the mail.

*You do not have permission to distribute or re-sell the template, so please don't do it.


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: $ 20.00



Product Information
Product name - Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Price: USD 20.00
In Stock: 0
Stats

Listed On 2013-08-07

4039 views

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

Follow Us

Close
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking
Multi Unit Rental Property Expense and Income Tracking Apartment Rental Variable Expense Tracking