Rent Roll with Variance

Modified on Tue, 3 Mar at 12:53 AM

Application: Tango Lease

Report Group: Lease Financials

Report Name: Rent Roll with Variance

Summary: The Rent Roll with Variance Report displays previous period amount and is used to compare the current month payment amount verses previous amount and the variance percentage.

Report Example:

Parameters:

*Tenancy Type
Location Number
Lease Number
Lease Type
Lease Status
Term Status
Brand/Org:
Lease Financials Group
*Month
*Year
Payment Category
Frequency
System Generated Flag

Version/Change History	Last Revised
Updated report column headers to reflect customer-defined labels (as applicable) and Updated 'On Hold' logic to pull payment/billing status (not the flag trigger) - so it captures both system-generated payments and one-time payments on hold.	6/9/2023
Updated the Rent Roll Variance Report to add logic to sum by Payment Type AND System Generated Flag. If both are not the same, then show them in separate rows in the report.	10/13/2023
Updated the Standard Rent Roll with Variance Report to use Lease Payment status for On Hold payments and remove any logic that looked to the On Hold Flag trigger in Recurring Costs.	12/8/23
Updated Rent Roll with Variance Report to add a column 'Current Period Payment Status' and add a new multi-select filter parameter 'Current Payment / Charge Status'.	3/8/2024