Select Properties

Click to select properties from the Select Properties pop-up. The report runs for all selected properties.

Print Backup

Accept the unchecked default to exclude detailed information sorted by unit. Or, check to include it.

Print Historical Version

Mark the check box to print the historical version of the report. The historical version is not the same as the saved report, which is just a copy of the report from when it was run. A historical report is a version of the report that uses current data but is back-dated to the selected period.

Period

This field appears when the box for Print Historical Version is checked. Enter the period in mm/yyyy format to be used for the Historical Reconciliation report. The report will be back-dated to a prior period as defined by the period you enter.

Select Print Style

Accept the marked Standard default to print the report in a portrait-style layout. Or, mark the Compressed option to print the report in a compressed layout.

Market Rent

The total market rent for all units, excluding Wait List and Construction units.

Market Rent %

This percentage is calculated as 100%.

Less Loss to Lease

This number is calculated as Total Market Rent – Total Gross Potential.

Less Loss to Lease %

This percentage is calculated as (Loss to Lease/Market Rent) X 100.

Gross Potential Rent by Code: Adjustments from Prior Periods

The sum of billings and adjustments (transaction types 1, 2, 6 and 9) for income codes set to Potential = Y with a G/L period (transaction table) < the current accounting period (property table) and a due date (transaction table) = current accounting period; listed by income code. Note, this section only prints if there is data to include.

Gross Potential Rent by Code: Adjustments from Future Periods

The sum of billings and adjustments (transaction types 1,2, 6 and 9) for income codes set to Potential = Y with a G/L period (transaction table) > the current accounting period (property table) and a due date (transaction table) = current accounting period; listed by income code. Note, this section only prints if there is data to include. Since this requires that future period transactions be recorded with due dates in the current period, this will seldom occur.

Gross Potential Rent by Code: Current Period Adjustments

The sum of billings and adjustments (transaction type 1, 2, 6 and 9) for income codes set to Potential = Y and Receivable = Y with a G/L period (transaction table) is equal to the current accounting period (property file) and a due date (transaction table) is equal to the current accounting period plus Lost Rent; listed by income code.

Total Gross Potential Rent

This number is calculated as the Sum of Adjustments from Prior Periods, Adjustments from Future Periods and Current Period Adjustments.

Total Gross Potential Rent %

This percentage is calculated as (Total Gross Potential Rent/Market Rent) X 100.

+ Other Income by Code

The sum of billings and adjustments (transaction types 1, 2, 6 and 9) for income codes set to Potential = N and Receivable = Y with a G/L period (transaction table) equal to the current account period (property table) regardless of the due date.

Total Other Income

This number is calculated as the Sum of Other Income by Code.

+ Prior Accounting Period Adjustments

The sum of billings and adjustments (transaction types 1, 2, 6 and 9) for income code set to Potential = Y and Receivable = Y with a G/L period (transaction table) equal to the current accounting period (property table) and a due date (transaction table) < current accounting period (property table) listed by code. Note, this section only prints if there is data to include.

+ Future Accounting Period Adjustments

The sum of billings and adjustments (transaction types 1, 2, 6 and 9) for income code set to Potential = Y and Receivable = Y with a G/L period (transaction table) equal to the current accounting period (property table) and a due date (transaction table) > current accounting period (property table) listed by code. Note, this section only prints if there is data to include.

– Adjustments from Prior Period Due

Previously calculated Gross Potential Rent by Code: Adjustments from Prior Periods. Note, this section only prints if there is data to include.

– Adjustments from Future Period Due

Previously calculated Gross Potential Rent by Code: Adjustments from Future Periods. Note, this section only prints if there is data to include.

+ Balance Due from Prior Month

This number is calculated as the Sum of Resident Beginning Balances > 0.

– Prepaid from Prior Month

This number is calculated as the Sum of Resident Beginning Balances < 0.

Prior Month Bal Due less Prepaid

This number is calculated as the Balance Due from Prior Month – Prepaid from Prior Month.

– Write-Offs by Code

The sum of write-offs (transaction type 8) with a G/L period (transaction table) equal to the current accounting period (property table); listed by income code being written off.

Total Write-Offs

This number is calculated as the Sum of Write-Offs by Code.

+ Rent Refunds by Code

The sum of refund transactions (transaction type 5) with a G/L period (transaction table) equal to the current accounting period (property table) for non-security income codes, listed by income code.

Total Rent Refunds

This number is calculated as the Sum or Rent Refunds by Code.

+ Forfeits by Code

The sum of forfeit transactions (transaction type 4) with a G/L period (transaction table) equal to the current accounting period (property table), listed by income code.

Total Forfeits

This number is calculated as the Sum of Forfeits by Code.

– Lost Rent by Code

Lost Rent, listed by income code.

Total Lost Rent

This number is calculated as the Sum of Lost Rent by Code.

– Current Balance Due

This number is calculated as the Sum of Resident Ending Balances > 0.

+ Current Prepaid

This number is calculated as the Sum or Resident Ending Balances < 0.

Current Month Bal Due less Prepaid

This number is calculated as the Current Balance Due – Current Prepaid.

= Total to Collect

This number is calculated as the sum of the following:

Gross Potential (Current, Prior and Future) + Other Income by Code – Prior Accounting Period Adjustments + Future Accounting Period Adjustments – Adjustments from Prior Period Due – Adjustments from Future Periods Due + Balance Due from Prior Months – Prepaid form Prior Months – Write-Offs + Rent Refunds – Forfeits – Lost Rent – Current Balance Due + Current Prepaid.

Actual Collections

Breakout by Apt—Part 1

Breakout by Apt—Part 2

To run the Historical Reconciliation report, check the Print Historical Version check box and then enter a period using the mm/yyyy format; the Historical Reconciliation report prints for that period. All amounts print based on that period matching the general ledger period of the transaction.

For Lost Rent based on the Days vacant @ and Floating options, the standard calculations are used; the Unit Market Rent for the end of the period is looked up in the Market Rent History table. Lost rent based on Fixed is not able to be recalculated, so for this report the Floating method is used, which the report notes. Resident balances are figured based on the ending date of the selected period.

1. From the eSite menu, select Reports—Accounting Reports—Reconciliation.
2. Click Select Properties. Select the properties for which you want to print the report and click Done.
3. Select the information you want to see on the report (refer to the Selection Criteria for this report).
4. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
5. Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.