skip to Main Content

Rental Property Income and Expenses Google Sheets Template

4.57 (7 reviews)

A Google Sheets template for landlords. No more stress on the tax time. Simple yet powerful property management tool with access from all devices.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Do you need an online tool to track all your rental properties? Here is our Rental Income Expenses Google Sheets Template for a quick and easy way to manage many assets in one-place.

So, real estate agencies or landlords! You will not need any extra tool other than this simple yet powerful Google Sheets template to manage your income and expense sources.

Landlord Template

Download this tool to keep records of your rental property’s revenue and outgoings.

Rental Income Expenses Google Sheets Template Features

This template essentially assists you in keeping track of properties as well as performing income and expense analysis. The following are the main components of the Google Sheets template:

  1. Menu
  2. Property Database
  3. Income Section
  4. Expenses Section
  5. Dashboard

Menu:

Firstly, use the top navigation buttons to navigate to the relevant pages in this template. The buttons will also show you the correct order of the template.

settings-options

In addition, there is a settings section in this sheet. So you can fill in the drop-down lists that will be used in other parts of the template. Also, you can change the start year and month in this Menu.

Property Database of Rental Property Income and Expenses Google Sheets Template:

Secondly, you can save your properties as well as other information about them in this section. Also, the filters can be used to provide a more detailed view if desired.

Income and Expense Sections:

Thirdly, this is a database where revenue is recorded in this Google Sheets Template. Thus, you can enter the income for the relevant month by selecting the property and income category from the drop-down lists.

dropwdown-menu

Additionally, this section also has 100 rows for each year. It is also possible to enter data for up to ten years. To get to the correct year, simply use the top navigation buttons.

Note: If the selected income category is not included on the dropdown list, then the calculations will not take this into account. So the template will warn you with a red color.

dropdown-menu

Similarly to the income section, there is also an expenses section in this Google Sheets template. It is a database where expenses are added. To clarify, you can enter the expense for the relevant month by selecting the property and expense category from the drop-down lists.

Dashboard:

dashboard-sheet

Finally, use the Dashboard section to keep track of your income and expense sources.

Moreover, this section includes three filters: property, month, and year. Display the data you want in graphs by combining these elements and making efficient use of the rental income and expense Google Sheets Template.

Meanwhile, all you need is an internet connection and a Google account to start. And everything will be in sync!

Note: If you want this template in Microsoft Excel, you can download our Rental Property Income and Expenses Excel Template.

Rental Income Expenses Google Sheets Template Features Summary:

  • Outstanding visual dashboard
  • Unique online tool to manage properties
  • Filters for a more granular perspective
  • Easy-to-use menu
  • Informational notes included
  • Automated charts and bars
  • No installation needed, ready to use
  • Works on any operating system
  • Suitable for any device including mobile, tablet, desktop

Rental Income Expenses is a ready-to-use Google Sheets Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

7 reviews for Rental Property Income and Expenses Google Sheets Template

  1. D Figueroa

    Have you made a video of how to build this template?

    • Someka

      Hi there! We indeed have a tutorial video for this template. You can watch the video here.

  2. Rufus Holland

    Keep up the good work.

  3. Malik Hasan

    I want to change the payment type!! I don’t how to do it?

    • Someka

      Hi Malik! Thank you for your question. You can change the payment types on the Menu sheet. It is at the right bottom of the page. After you change the settings of the Payment Types, you can select the relevant payment type from the dropdown menu on the Property Database sheet.
      Payment Types

      Hope this helps!

  4. Dave Barley

    Better than Excel. Me and my wife use it both on our phones and love it.

  5. J Hobson

    Excellent and easy to manage

  6. Rafa Foster

    I sent the Share request, pls reply!!

    • Someka

      Hi there, thanks for your comment. You don’t have to ask for permission for editing. The download link for Google Sheets will lead you to the original file in the “View Only” mode. All you have to do is to make a copy for your self as shown below: Go to File > Make a copy and give a new name for your file before clicking on the “Make a copy” button. You can see below:

      make a copy

  7. Robbie

    thanxx

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES