125 Multi-Unit Properties Rental Income Expense Tracker Landlords Rental Property Spreadsheet Ledger Multi-family Profit NOI ROI Cap Rate

Extremely easy to use Spreadsheet with very powerful Property Management features. Available in Google Sheets and Excel

Ideal for landlords and property managers with a mix of properties like Multi-Family Homes (Duplex, Triplex etc), Multi-Unit Properties, Apartment Buildings, Single Family Homes, Commercial Properties.
You can easily record and track rental income and expenses, taxes, insurance, vendors and property maintenance of all your properties through this spreadsheet.
Both long-term and short-term rentals can be tracked.
Rental Income bookkeeping and property management becomes very easy with this Spreadsheet

This Spreadsheet includes

20 Multi-Unit Properties with 2, 3, 4, 5, 7, 10 and 15 Units / apartments in each Property
10 Single Family Properties
Total number of Properties is 125.

I will customize this for FREE for you if you need different configurations like more or less units in the Multi-Unit Properties up to a total of 125 properties. If you need more properties, I will request a nominal customization fee.

I will also be happy to include minor tweaks/ customizations for free

FEATURES

1. A very convenient single Income Tab and a single Expense Tab to record transactions for all your properties

There is a drop down list of all your properties in the Income and Expense tabs. When entering a transaction such as rent, you would go to the Income tab, simply pick the property you want from the automatic drop down list, enter the date, enter the amount, and any other optional details like Tenant name, start date, end date etc. That's it! The Dashboard will automatically update for that property.

2. Main Dashboard which summarizes and compares Income, Expenses and Profit
- For all properties by month
- For each property
- Summarization by Income Categories & Expense Categories
- Drill down of all Income and Expense Categories

2. A Unit Dashboard similar to the Main Dashboard summarizing and comparing across all units of each property.

3. Rent Due Date Tracking

4. A fixed HOA Expenses Tab so that you just need to enter the HOA expenses once and it gets populated for all 12 months for any property you like

5. Profit Margin, NOI, ROI, Cap Rate, Occupancy Rate

6. A Property Tab where you can record all pertinent information for each of your properties including Tenant Info, Start Date, Renewal Date, Deposit, Property Purchase Price, Invested amount, Current Property Value, Unit Occupied, Rent Due Date etc.

7. A Vendor List which becomes an automatic drop down menu in the Expenses Tab.
You can also record all vendor details like contact information etc.

8. A Taxes Due tab which shows with automatic color grading how soon taxes are due for each property. Colors get more intense when the tax due
date gets close

9. A Insurance Due Tab which shows when Insurance payments are due with automatic color grading.

10. A Maintenance Schedule checklist for all properties

11. Multiple useful graphs like Profit from each property, Income Contribution, Expense share by Property and Expense Category distribution

12. Record each tenant's name, deposit, rental start date and end date.

----------------------------------------------------------------------------------------------------------
DETAILED VIDEO
Please paste the link below in your browser to see a detailed video of the 125 Multi-Unit Property Spreadsheet.
----------------------------------------------------------------------------------------------------------

https://www.canva.com/design/DAFPbGfhMzY/IHTm8ngJ0ZxfwT8oqzkwIw/watch?utm_content=DAFPbGfhMzY&utm_campaign=designshare&utm_medium=link&utm_source=publishsharelink

----------------------------------------------------------------------------------------------------------------

I will be happy to provide support and answer any questions.

You will get both the Google Sheets and Excel version

For Google Sheets, you will only need a free Google account to use it.

Download Instantly and use
This is copyrighted to MoneyUsageTools and is for your own personal use. It cannot be sold, shared or otherwise redistributed.