income and expense tracker google sheets

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.

Income and expense tracker google sheets