Rent Roll by Building Report

The Rent Roll by Building Report lists residents for a selected property along with their name, resident status, unit square footage, market rent and actual rent amounts, move-in dates, move-out dates, lease terms, lease expiration dates, notice dates, security deposit amounts and current account receivable balances.

Note

An asterisk (*) indicates a required field or selection.

Select Properties

Click to select properties from the Select Properties tab. The report runs for all selected properties.

From Building

Printing the report calls for a building range to print from. Enter the first number of the building range. Or use the drop-down to display a lookup list.

To Building *

Printing the report calls for a building range to print from. Enter the last number of the building range. Or use the drop-down to display a lookup list.

Page Break between Buildings

Accept the checked default to insert a page break in between building information. Or, uncheck to exclude page breaks and print as one long report.

Include Inactive Units

Accept the unchecked default to exclude units with an Inactive status or check to include them when the report is displayed.

Include Current Residents

Accept the checked default to include residents with a Current status or uncheck to exclude them when the report is displayed.

Include Applicants

Accept the checked default to include potential residents with an Applicant status or uncheck to exclude them when the report is displayed.

Include Waiting List Applicants

Accept the unchecked default to exclude potential residents with a Wait List status or check to include them when the report is displayed.

Include Canceled Applicants

Use the drop-down to select if and when to include applicants with a Canceled status when the report is displayed.

Always—always include canceled applicants regardless of their balance.

Sometimes—only include canceled applicants if they have a balance due.

Never—(default) never include canceled applicants.

Include Previous Resident

Use the drop-down to select if and when to include residents with a Previous status when the report is displayed.

Always—always include previous residents regardless of their balance.

Sometimes—only include previous residents if they have a balance due.

Never—(default) never include previous residents.

The following report details assume all defaults are selected.

Note

If a resident does not have a Current lease status such as Current, Transfer or Notice then the lease charges for that resident are followed with an asterisk and are not included in the property totals. For instance, Rent $500.00*.

Apt

The unit number. For instance, A101.

Bldg ID

The building ID or number. For instance, 01 used to separate the report data by building.

Type

The unit type + sub-type. For instance, 1B/1B Den.

Apt Status

The unit status. For instance, VA for vacant available.

Names

If the unit is leased or occupied, the primary resident name is listed on line 1 and any additional occupants on the subsequent lines. If the unit is vacant, then this is the description of the lost rent income code for the unit. For instance, VACANCY.

The resident status. For instance, A for Applicant.

Sq. Ft.

The total square per unit.

Market Rent

Market Rent is the unit market or street value, which may differ from the rent amount actually billed to the resident leasing the unit. This number ties to the Market Rent field on the Rent Roll Recap Report and to the Market Rent field on the Reconciliation Report.

Code

The income code used to identify each active recurring charge. For instance, PET for Pet Deposit.

Lease Charges

The recurring charges for each income code, along with the totals. Note, there is one line listed for each active recurring charge.

Gross Possible

If the unit is occupied, this is the sum of the active recurring charges for which the income code's Potential flag is set to Y. If the unit is vacant, then this is the unit Market Rent.

Actual Potential Charge

The actual amounts charged for this period, that are due in the current accounting period. Potential Rent is the total income that could be received if all vacant unit were leased at full market value + current potential charges for occupied units. Note, if the unit is vacant then this field is blank.

MI/MO Date

If the unit is occupied, this field lists the actual Move-In date. If the unit is vacant, then this field lists the actual Move-Out date.

Lease Expires/Term

If the unit is occupied, then this field lists the date the current lease expires + the term of the lease. If the unit is vacant, then this field is blank.

Sec/Other Deposits

If the unit is occupied, then Line 1 provides the resident's On Hand Security (subject to minimum) amount and Line 2 provides the resident's On Hand Other Deposit amounts. If the unit is vacant, then these fields are blank.

Ending Balance

If the unit is occupied, then this field lists any unpaid recurring charges and/or unpaid security deposit amounts. This number ties to the Current Month Balance Due less Prepaid field on the Reconciliation Report and to the Ending Past Due & PPD (prepaid) field on the Rent Roll Recap Report. If the unit is vacant, then this field is blank.

Total

Totals of LEASE CHARGES and SECURITY/OTHER DEPOSITS for each lease are listed. Property totals are listed for each selected property. This number ties to the Ending Balance field in the Security Deposits section of the Rent Roll Recap Report. It is calculated as Security Deposits Total + Other Deposits Total = Total Deposits.

Property Totals

Market Rent

Sum of Unit Market Rent (for each unit) = Property Total.

Lease Rent

Sum of Lease Rent for each Current, Notice or Transfer status lease listed = Property Total.

Gross Possible

Sum of Lease Rent for each Current, Notice or Transfer status lease listed = Property Total.

Actual Potential Charges

Sum or Actual Potential Charges (for each lease listed) = Property Total.

Security Deposits

Sum of Security Deposit (for each lease listed) = Property Total.

Other Deposits

Sum of Other Deposit (for each lease listed) = Property Total.

Total Deposits

Security Deposit (property total) + Other Deposit (property total) = Total Deposits collected for the property.

Unit Analysis

Occupied

The number of units for the property with an occupancy status of Occupied or Notice, not including Down, Wait List or Construction. It is calculated as the Number of Occupied Units/Total Units = Total Percentage of Occupied Units.

Vacant

The number of units for the property with an occupancy status of Vacant, not including Down, Wait List or Construction. It is calculated as the Number of Vacant Units/Total Units = Total Percentage of Vacant Units.

Down

The number of units for the property with an occupancy status of Down. It is calculated as the Number of Down Units/Total Units = Total Percentage of Down Units.

Total Units

A count of the number of units in the property, excluding Wait List and Construction.

Construction

The number of units for the property with a unit status of Construction.

Waiting List

The number of units for a property with a unit status of Wait List.

Employee

The number of units for a property with a unit status of Employee.

Model

The number of units for a property with a unit status of Model.

Other Use

The number of units for a property with a unit status of Other.

Total Special Use

The percentage of Employee, Model and Other. It is calculated as the Number of Special Units/Total Units = Total Percentage of Special Units.

Grand Totals

Grand Total

Grand Totals are the sum of Property Totals and are only listed if more than one property is selected when the report is run.