Selection Criteria
Make the following menu selections to display this page:
Reports—Accounting Reports—Reconciliation
The Reconciliation Report reconciles the total market rent and potential rent to be collected with the actual amount collected for the month. The purpose of this report is to show accrued income and reconcile it to the amount of cash deposited for the month.
Fields
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.
Report Details
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.
Rent Collections for the Period
The sum of payments (transaction type 3) to all income codes (except types Security, Other and Miscellaneous/Vending) with a G/L period equal to the current accounting period.
Security Deposits
The sum of payments (transaction type 3) to income codes of type Security with a G/L period equal to the current accounting period.
Other Deposits
The sum of payments (transaction type 3) to income code of type Other with a G/L period equal to the current accounting period.
Total Collected
The sum of payments (transaction type 3) to income codes of type Miscellaneous/Vending income with a G/L period equal to the current accounting period.
Miscellaneous Income
The sum of payments to income codes of type Miscellaneous/Vending income with a G/L period equal to the current accounting period.
Total Actual Collections
This number is calculated as the Sum of Rent Collections for the Period + Security 1 Deposits + Security 2 Deposits + Miscellaneous Income Deposits.
Column Descriptions
Amount
The amount of Potential Rent or Collections (as described above).
Percent %
The percentage of the corresponding amount to Market Rent. It is calculated as Amount/Market Rent X 100.
Collected
The sum of payments (transaction type 3) to income codes (except types Security, Other, and Miscellaneous/Vending) with a G/L period (transaction table) equal to the current accounting period (property table), listed by income code.
Percent %
The percentage of the corresponding Collected amount to the Potential amount. It is calculated as (Collected Amount/Potential Amount) X 100.
Deposits
The sum of payments (transaction type 3) to all income codes (listed by types Security, Other and Miscellaneous/Vending) with a G/L period (transaction table equal to the current accounting period (property table) – Returns.
Returns
The sum or Return Checks (listed by types Security,Other, and Miscellaneous/Vending). Note, Deposits + Returns = Collections Amount (by type).
Apt
The building + unit number. For instance, 01-A101.
Market Rent
The Market Rent amount, listed by unit.
Loss to Lease
The difference between the unit's market rent and the potential amount actually charged to the resident leasing the unit.
Income Code
The income code for the items on this line.
Current Period
The current period adjustments.
Column Totals
From Prior Period
Adjustments from prior period.
From Future Period
Adjustments from future period.
Other Rents
Other income.
Prior Period Adjustments
Prior accounting period adjustments.
Future Period Adjustments
Future accounting period adjustments.
Prior Balance Due
Balance due from prior month.
Prior Prepaid
Prepaid balance from prior month.
Write-Off
Write-offs; listed by code.
Rent Refunds
Rent Refunds; listed by code.
Forfeits
Forfeits; listed by code.
Lost Rent
Lost Rent; listed by code.
Current Balance Due
The current balance due.
Current Prepaid
The current prepaid balance.
Apt
The building + unit number. For instance, 01-A101.
Net to Collect
The total amount of rent to collect.
Net Rent Collected
The rent collected for the period.
Rent Collected
The rent collected for the period less deposits.
Rent NSF's
The rent collected for the period less returns.
Net Security Collected
The security deposit amount collected.
Security Deposits
The amount of security deposits collected less deposits.
Security NSF's
The amount of security deposits collected less returns.
Other Deposits Collected
The amount of other security deposits collected.
Other Deposits
The amount of other security deposits collected less deposits.
Other Deposit NSF's
The amount of other security deposits collected less returns.
Total Collected
The total amount collected.
Total Deposits
The total amount collected less deposits.
Total NSF's
The total amount collected less returns.
Note
If the Net to Collect <> (Net Rent Collected + Net Security Collected + Net Deposits Collected) then an * is printed.
Historical Reconciliation Report
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.
Procedures
To Display the
Reconciliation Report
See Also
Reconciliation Report Overview
Copyright © 2018 Infor. All rights reserved. www.infor.com.