Multi-Unit Rental Tracker

Multi-Unit Rental Tracker

Multi-Unit Rental Tracker

$4.00

Simplify managing multiple rental properties with our Multi-Unit Rental Tracker, a downloadable Excel file. This tool tracks each unit’s rental income, expenses, and profit. Just enter your numbers, and it does all the calculations for you. Purchase and download now and keep your rental finances organized and easily managed!

Description

Multi-Unit Rental Tracker Manual

This guide will help you set and achieve your goals for the year. A Yearly Goal Planner is a tool that helps you plan and track your goals throughout the year. It keeps you focused and motivated to achieve what you want. 

Why Use Multi-Unit Rental Tracker?

  • 💡 Stay Organized: Keep all your goals in one place.
  • 💡 Track Progress: See how far you’ve come and what you still need to do.
  • 💡 Achieve More: Break down big goals into smaller, manageable steps.

Freebies 🤩

  • ✅ Rental Income & Expense Tracker
  • ✅ Easy Bookkeeping
  • ✅ 50-30-20 Budget Tracker
  • ✅ Goal Planner
  • ✅ Holiday Gift Tracker

Steps on how to use the Yearly Goal Planner:

Step 1: Setup

📌 To set up your multi-property rental tracker, go to the Start tab.

📌 Changes made here will auto-populate throughout the spreadsheet.

Step 1.1: Starting month & year (required)

📌 The Overview tabs and charts built into this template are designed to include data for 12 months.

📌 To make sure that the reports show the correct 12-month period, you have to choose the starting month and year.

📌 To select the starting month & year, simply double-click on cell G3 in the Start tab.

📌 Select year and month from the pop-up calendar (select the day of your first income/expense transaction, 1 January 2023, for example).

📌 Or, you can enter the starting date manually in the cell G3 (use the format MM/DD/YYYY).

📌 For example, 01/01/2024.

Multi-Unit Rental Tracker Manual-1

Step 1.2: Property names, rental channels & expense categories (required)

📌 All the Overview tabs group your income and expenses by property, rental channel and expense category.

📌 You can add up to 20 properties, rental channels & expense categories.

📌 Enter your properties in the Property Name table (cells B7 to B26).

📌 Purchase Price column is optional, fill it in only if you’d like to calculate the cap rate for each property.

📌 Enter your rental channels in the Rental Channels table (cells E7 to E26).

📌 Then enter your expense categories in the Expense Categories table (cells G7 to G26).

Multi-Unit Rental Tracker Manual-2

Step 1.3: Profit goals (optional)

📌 Monthly profit goals will be shown in the Monthly Overview & Profit Overview tabs.

📌 This could be helpful if you’d like to compare your profit goals to the actual profit.

📌 Enter your monthly profit goals in the Profit Goals table (cells J7 to J18).

📌 The annual profit goal is calculated automatically. Please do not type over this cell.

Multi-Unit Rental Tracker Manual-3

Step 2: Income tab

📌 Now you can start entering your transactions into the Income tab.

📌 All the monthly and annual totals will be calculated for you and can be found in the Monthly and Annual Overview tabs.

📌 Required columns are:

– Property: Select one of the properties from the dropdown menu.

Channel: Based on the rental channels you set up in the Start tab, you must select one channel from the dropdown menu.

– Check-in: double-click on the cell to select the check-in date from the pop-up calendar.

– Rental Income: Enter the total rental amount.

💡 Note: Charts and tables in the Overview tabs won’t update if at least one of the 4 required columns is not filled in.

Required columns for each transaction are highlighted in red.

Multi-Unit Rental Tracker Manual-2

Step 3: Expenses tab

📌 Now you can start entering your transactions into the Income tab.

📌 All the monthly and annual totals will be calculated for you and can be found in the Monthly and Annual Overview tabs.

📌 Required columns are:

Date: double-click on cell to select a transaction date from the pop up calendar. Or, enter the date manually using the format: MM/DD/YYYY.

Property: Select one of the properties from the dropdown menu. 

Amount: Enter the total transaction amount.

Category: Based on the categories that you set up in the ‘Start’ tab, you have to select one of the income streams from the dropdown menu.

📌 Note: Charts and tables in the Overview tabs won’t update if at least one of the 3 required columns is not filled in.

Required columns for each transaction are highlighted in red

Multi-Unit Rental Tracker Manual-5

Step 4: Income Overview tab

📌 The Income Overview tab is completely automated, it will take all the data you filled in the Start & Income tabs.

📌 Note:  Please do not type in this tab.

📌 In the Income Overview tab you’ll find the following information:

    • – Total annual income
    • – Monthly income
    • – Average monthly income
    • – Income by rental channel
    • – Income by property

Multi-Unit Rental Tracker Manual-6

Step 5: Expenses Overview tab

📌 The Expenses Overview tab is completely automated. It will take all the data you filled in the Start & Expenses tabs.

📌 Note:  Please do not type in this tab.

📌 In the Expenses Overview tab, you’ll find the following information:

    • – Total annual expenses
    • – Monthly expenses
    • – Average monthly expenses
    • – Expenses by category
    • – Expenses by property

Multi-Unit Rental Tracker Manual-8

Step 6: Profit Overview tab

📌  The Profit Overview tab is completely automated. It will take all the data you filled in the Start, Income & Expenses tabs.

📌 Note:  Please do not type in this tab.

📌 In the Profit Overview tab, you’ll find the following information:

    • – Monthly & annual income
    • – Monthly & annual expenses
    • – Monthly & annual profit
    • – Average monthly profit
    • – Profit margin
    • – Profit goals

Multi-Unit Rental Tracker Manual-7

Step 7: Monthly Overview tab

📌 The Monthly Overview tab is completely automated, it will take all the data you filled in the Start, Income and Expenses tabs.

📌 Note: Please do not type in this tab.

📌 To select the month, click the small arrow on the right side of cell B8.

📌 Then select one of the months from the dropdown (they’ll update depending on the year & month chosen in the Start tab).

📌 Here you’ll find the following information for a selected month:

    • – Income
    • – Expenses
    • – Profit goal
    • – Actual profit
    • – Profit margin
    • – Income by rental channel
    • – Income by property
    • – Expenses by category

Multi-Unit Rental Tracker Manual-9

Step 8: Property Overview tab

📌 The Property Overview tab is completely automated. It will take all the data you filled in the Start, Income, and Expenses tabs.

📌 Note:  Please do not type in this tab.

📌 To select one of the properties, click on the small arrow on the right side of cell B6.

📌 Select one of the properties from the dropdown menu.

📌 Here you’ll find the following information for a selected property:

    • – Total income
    • – Total expenses
    • – Actual profit
    • – Profit margin
    • – Average monthly profit
    • – Purchase price
    • – Cap rate
    • – Income by rental channel
    • – Expenses by category

Multi-Unit Rental Tracker Manual-10

Step 9: Protected cells

📌 Some of the cells have been protected in this spreadsheet.

📌 This is to make sure that the formulas that make the overview tabs work correctly cannot be accidentally deleted or overwritten.

📌 If you accidentally type over the cell that is protected, you’ll see a warning. Simply click Cancel.

Multi-Unit Rental Tracker Manual-11


Fatal error: Uncaught wfWAFStorageFileException: Unable to verify temporary file contents for atomic writing. in /home/u769886334/domains/investmentsph.com/public_html/wp-content/plugins/wordfence/vendor/wordfence/wf-waf/src/lib/storage/file.php:51 Stack trace: #0 /home/u769886334/domains/investmentsph.com/public_html/wp-content/plugins/wordfence/vendor/wordfence/wf-waf/src/lib/storage/file.php(658): wfWAFStorageFile::atomicFilePutContents() #1 [internal function]: wfWAFStorageFile->saveConfig() #2 {main} thrown in /home/u769886334/domains/investmentsph.com/public_html/wp-content/plugins/wordfence/vendor/wordfence/wf-waf/src/lib/storage/file.php on line 51