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.
The report calculations rely heavily on the types of
transactions included. Refer to Transaction
Types for more information.
When using the report information to tie out other
reports, pay attention to the Balance Due calculations. These could be
especially prone to differences, if trying to balance them with the Rent
Summary and Aged Delinquency Reports.
The Rent Summary Report uses the Transaction tables,
the Reconciliation Report uses the LeaseRecLNotice tables and the Aged
Delinquency Report uses the Open Items tables to calculate the following:
Other Income
- Transaction Types 1,2, 6 or 9 (billings and
balance transfers except SDI adjustments)
- Posted to current G/L period
- Potential flag set to N
- Receivable flag set to Y
Concessions (included in Other Income)
- Based on transactions to income code type C
- Transaction types 1, 2, 6 or 9 (billings and
balance transfers except to SDI adjustments)
- Potential flag is set to N
- Receivable flag is set to Y
Write-Offs
- Transaction type 8
- Posted to current G/L period or due date in
current G/L period
Adjustments to Prior Periods
- Transaction types 1, 2, 6 or 9 (billings and
balance transfers except SDI adjustments)
- Posted to earlier G/L period but due date in
current G/L period
- Potential flag is set to Y
Prior Accounting Period Adjustments
- Transaction types 1, 2, 6 or 9 (billings and
balance transfers except SDI adjustments)
- Posted to current G/L period but due date is
in earlier G/L period
- Potential flag is set to Y
- Receivable flag is set to N
Current Balance Due
Sum of ending balance field from LeaseRecLNotice
table where ending balance > 0. Note, billings and payments where the
date of record > current accounting period go to the Future
Billing Payment field instead.
Current Prepaid
Sum of ending balance field from LeaseRecLNotice
table where ending balance < 0. Note, billings and payments where the
date of record > current accounting period will go to the Future
Billing Payment field instead.
Forfeits
- Transaction type 4
- Posted to current GL period