Rental Income Expense Tracker Landlord Rental Property Spreadsheet 20 Properties Long-term Short-term Property Management

Rental Property Spreadsheet for 1 to 20 Properties. Keep track of Rental Income & Expenses for up to 20 properties.
Extremely easy to use Rental Income & Expense tracking and bookkeeping spreadsheet for Landlords.
Record details for both long-term and short-term rentals.

Available in Excel as well as Google Sheets

This spreadsheet comes with...

FREE SUPPORT for 1 YEAR

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

FEATURES
--------------------

- 20 Properties

- Cool blue buttons to easily navigate to each property and back to Dashboard.

- 9 Income Categories like Rent, Late Fees, Laundry, Parking etc.

- 41 Expense Categories like Maintenance, Management Fees, HOA dues, Mortage Interest, Property Taxes etc.

- No Set up required. The Income and Expense Categories are pre-filled. You can change the category names if you would like to.

- Summary of Income, Expenses and Profit
a) By Month
b) By Properties

- Easily compare performance of all properties.

- Summarization by Income Categories & Expense Categories

- All figures on Dashboard are automatically calculated.

- Drill down of all Income and Expense Categories

- Separate Tab for each property

- Automatic and dynamic summarization of Income, Expenses and Profits for each Property.

- Record each tenant's name, deposit, rental start date, end date and next rent due date - great for long term and short term rentals

- Income and Expenses that tend to get repeated every month can simply be copied and pasted - saving time.

- Ample space for notes

- Use any 12 month period as your accounting / fiscal period

-------------------
VIDEO of 20 Properties Rental Income & Expense Tracker
------------------

-------------------
DESIGN
--------------------

- Eye soothing pastel colors

- Graph to give a quick visual overview of all properties

- Intuitive flowing design

- Easy to navigate with buttons

- Has an "Intro" sheet, a "Dashboard" and 20 "Property Worksheets"

-------------------
SUPPORT
------------------

- 100% support to get you set up and running. I will be happy to provide support, answer questions and provide any minor customizations you may need.

This spreadsheet works best on Excel 2007 and later versions. You will also get the Google Sheets Version

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

-------------------
FAQs
------------------

Who would benefit from this spreadsheet?

This is ideal for Landlords and Property Managers who own or manage between 1 to 20 properties

How is this spreadsheet different from the 10 Property Spreadsheet?

-It has 20 properties. Each property is tracked in its own tab

-There are navigation buttons that allow you to quickly access a property

-You can sort and filter the Income section of each Property tab

-The Categories section is separated from the Dashboard

What does the mini-dashboard do in each property tab?

The mini-dashboard is great for giving a quick overview of all your income and expenses for a particular property by each month and the whole year.

It is on the top of each property tab so that each property has its own mini-dashboard

Do you need to set up accounts in this spreadsheet?

One of the best features of this spreadsheet is that there is no set up required.

The Income and Expense categories come pre-filled with all the standard Rental Income and Expense categories. You can change them if you like but otherwise there is no need for any set up.

Start recording your transactions right away.

Is this spreadsheet easy to use?

Yes it is very easy to use. There is absolutely no learning curve. Simply enter the date, choose an Income or Expense category from a drop-down list and enter the amount. 

The spreadsheet does all the calculations and organizes everything on the Dashboard by month and category so you get a bird's eye view of how each of your properties is performing

Can this be used for short-term properties?

Absolutely. In each property tab you can record when any new tenant comes in. You can record the deposit received from each tenant along with all the transactions like rent etc.