This phrase perfectly fits the topic of finances. Meanwhile, all you need is an internet connection and a Google account to start.Action with a plan is a disaster. Display the data you want in graphs by combining these elements and making efficient use of the rental income and expense Google Sheets Template. Moreover, this section includes three filters: property, month, and year. Dashboard:įinally, use the Dashboard section to keep track of your income and expense sources. To clarify, you can enter the expense for the relevant month by selecting the property and expense category from the drop-down lists. It is a database where expenses are added. Similarly to the income section, there is also an expenses section in this Google Sheets template. So the template will warn you with a red color. Note: If the selected income category is not included on the dropdown list, then the calculations will not take this into account. To get to the correct year, simply use the top navigation buttons. It is also possible to enter data for up to ten years. Thus, you can enter the income for the relevant month by selecting the property and income category from the drop-down lists.Īdditionally, this section also has 100 rows for each year. Thirdly, this is a database where revenue is recorded in this Google Sheets Template. So, in this section, you can fill in the following fields: Property Name, Tenant Name, Contact Information, Initial Rent and Last Rent Price, Contract Starting Date and End Date, Bank Account, and so on. Tenant records mean all information, including financial, maintenance, and other records about a tenant or prospective tenant. Also, the filters can be used to provide a more detailed view if desired. Secondly, you can save your properties as well as other information about them in this section. Property Database of Rental Property Income and Expenses Google Sheets Template: Also, you can change the start year and month in this Menu. So you can fill in the drop-down lists that will be used in other parts of the template. In addition, there is a settings section in this sheet. The buttons will also show you the correct order of the template. The following are the main components of the Google Sheets template:įirstly, use the top navigation buttons to navigate to the relevant pages in this template. This template essentially assists you in keeping track of properties as well as performing income and expense analysis. Rental Income Expenses Google Sheets Template Features 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.ĭownload this tool to keep records of your rental property’s revenue and outgoings. 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.
0 kommentar(er)
