144 Multi-Unit Single Family Properties Rental Income Expense Landlords Property Management Spreadsheet Excel Google Sheets

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

Perfect 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 choose whatever mix you want.
You can easily record and track rental income and expenses, taxes, insurance, vendors and property maintenance of all your properties through this spreadsheet. You can also calculate Mortgage Payments and HELOC payments
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

144 Properties (inclusive of units in Multi-Unit Properties and Single Family Properties)

After your purchase I will customize this for FREE for your property configuration.
You can choose whatever mix you want - some multi-family, some single-family, all single-family.
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

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

4. Rent Due Date Tracking

5. Three Fixed Expenses Tabs where you just need to enter the expenses once and it gets populated for all 12 months for any property you like. There is a Debt Service Tab, Taxes Tab and Insurance Tab. These can be changed to any Fixed Expense of your choice.

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

7. 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.

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

9. A Taxes Due Tracker 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

10. A Insurance Due Tracker which shows when Insurance payments are due with automatic color grading.

11. A Maintenance Schedule checklist for all properties

12. A Mortgage Payments Calculator with monthly Principal and Interest Payments shown. You can also see how payments change if you make any extra payments. It will also show how much interest and time you save with any extra payments.

13. A HELOC calculator which shows monthly payments and also shows payment changes when any additional payments are made or rate changes are done

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

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


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

VIDEO of 144 Multi-Unit & Single Family Properties Landlords & Property Manager's Spreadsheet

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

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

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 MoneyUsage.com and is for your own personal use. It cannot be sold, shared or otherwise redistributed.