Calculates total rental income from properties and tracks monthly rent payments.
Rental Income Calculator | ||||
Purpose: | This document calculates the total rental income from multiple properties and tracks monthly rent payments. | |||
Landlord Name: | {landlordName} | |||
Period Start: | {periodStart} | |||
Period End: | {periodEnd} | |||
Properties and Rental Income | ||||
Property Name | Monthly Rent | Occupied (Yes/No) | Tenant Name | |
{#properties.propertyName} | {#properties.monthlyRent} | {#properties.occupied} | {#properties.tenantName} | |
Monthly Rental Payments | ||||
Month | Property Name | Tenant Name | Amount Paid | Paid On Time (Yes/No) |
{#payments.month} | {#payments.propertyName} | {#payments.tenantName} | {#payments.amountPaid} | {#payments.paidOnTime} |
Total Monthly Rent Expected | =SUM(properties[Monthly Rent]) | |||
Total Rent Received | =SUM(payments[Amount Paid]) | |||
Difference | =SUM(payments[Amount Paid]) - SUM(properties[Monthly Rent]) |
This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download
Download Excel Template (.XLSX)Download the Rental Income Calculator template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).
Upload the template to Documentero - Document Generation Service, then map and configure template fields for your automated workflow.
Populate templates with your data and generate Excel (XLSX) documents using data collected from shareable web Forms, APIs, or Integrations.
Property Showing Feedback Form
DocumentDOCX
DocumentDOCX
DocumentDOCX
Property Maintenance Request Form
DocumentDOCX