Tenant Statement Report
Tenant Statement Report shows all income from the tenants, includes paid and unpaid invoices, displays deposits and credits and shows general income. This report has two tabs: overview and generate. Often used for seeing tenant's income invoices outstanding to date, keeping track of the funds received from your tenant, sharing a detailed statement of charges and payments from a tenant.
The overview shows the information on all tenants. It summarizes the key facts and trends, placing them into infographic charts.
The Tenant Statement Overview consists of four infographic widgets:
•Top 5: longest outstanding and largest balance owed
•Income from tenants
Press on "Download PDF" to download a PDF of the four infographics. The downloaded file also contains more details on the data presented.
"Top 5" widget:
Longest Overdue shows a rating of the top five tenants that have an overdue payment for the longest period of time. This payment is of a single invoice, and the rating is formed based on time overdue. Largest Overdue shows a rating of the top five tenants with the largest balance owed. The information is shown as of today's date. Hovering over or clicking on the info icon shows what information is taken into account in these charts.
Payments which are taken into account:
- income payments from tenants
- only property-related payments
- overdue invoices (past the grace period)
You can also click on a tenant's name or profile picture to see tenant's accounting in their profile.
"Income from Tenants" widget:
This widget shows the totals of paid and partially paid transactions by all your tenants in the following categories:
- Charges and fees
- Late Fees
- Other Income
Hovering over a section of the pie chart shows the total and category name. Hovering over or clicking on the info icon shows what information is taken into account in these charts.
Payments which are taken into account:
- income payments from tenants received during the current month.
A line graph that shows the difference between what tenants were supposed to pay and the actual amount paid. The vertical axis is $. The horizontal axis is the time period previous to today's date.
Hovering over a waypoint shows:
- a certain date range
- the amount due for a certain period
- the amount paid during that period
- the outstanding amount (the difference between the previous amounts)
Hovering over or clicking on the info icon shows what information is taken into account in these charts.
- property-related income payments from tenants
Liabilities Held widget:
This pie chart shows how much is held in liabilities by you as a landlord or property manager in certain categories. The information is shown as of today's date. Hovering over or clicking on the info icon shows what information is taken into account in these charts.
- Security deposits
- Last month's rent
- Other deposits (all other deposit sub-categories)
- And total credits
The Overview tab in reports is available for users with Advanced or Premium subscription plans.
Icons in the top right corner of the page indicate the following:
Info Tip: hover on it to read a brief report description.
Sharing options: hover on it to learn if an owner has access to it.
Help: click on this icon if you want to read the complete article on how to use this report.
The report is not shared with the owner by default. To enable sharing, the property manager needs to change the configuration in the owner's profile.
This might be useful:
When generating the Tenant Statement Report, you can adjust the following criteria:
You can adjust your own “custom range” choosing the needed start and end date to generate the report. Or you can use the pre-set date range options like all, last month, last 90 days, this year, last quarter, last year, and year to date.
The toggle button Active leases only is enabled by default, but you can disable the toggle button to include the leases of all statuses.
Filter by Property / Tenant / Lease
You can filter by property or tenant. If you select the Multi-unit type of the property, then a field for a unit number appears and you can select the unit.
The Preview of the report is available if you have selected the specific tenant in the drop-down. If you select ALL, you will be able to download the report only.
You can tick checkboxes of additional columns you want to add to the report: lease number, lease duration, payment method, and details.
Additionally, you can enable/disable the “Grouping by payment category” option. Enabling “Group by payment category” groups all the transactions within the invoices and payments section and shows totals for the columns amount due, the amount paid, and outstanding balance in each payment category. For example, you can see the totals for Rent, Tenant Charges & Fees, Maintenance Fees, etc. If you disable “Grouping,” the report will be generated showing totals of the columns amount due, amount paid, and outstanding balance for each section of the report.
The default accounting type is Accrual for the Tenant Statement. It sorts the transactions by the due date.
Preview the report
The Preview button gives you an option to preview the complete report in a PDF file in a new tab. You can go through it and download if all correct, go back and adjust other settings or just close the tab. The Preview can be generated for one tenant at a time.
Downloading the report
Click on the "download" button to generate the Tenant Statement Report. The report is generated into one file, and you can download it as .xls or pdf file. If you chose 'All tenants' in the filter, you will be asked whether to generate the Tenant Statement into one file for each tenant separately. The "preview", "download " buttons will be inactive if there is no information on the chosen criteria or you have no properties added.
If the file is very large it would be compressed into a zip file, you will need to unarchive it.
What categories does this report include?
This report includes property-related income and general income transactions, the liability (deposits and other liabilities) and the Tenant Charges & Fees transactions.
Not included categories:
Not included statuses:
Transactions of all lease statuses (active, past, ended, future, signature/insurance pending) except for leases in draft status will be included in the Tenant Statement.
Sept 13, 2021