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.

Thru 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.

Code

The identifying income code. For instance, Rent.

Bldg ID

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

Debit Acct

The income code entity and debit account. If multiple entities are set up, then only the first displays.

Credit Acct

The income code entity and credit account. If multiple entities are set up, then only the first displays.

Description

A brief description of the income code. For instance, Base Rent.

Bank Deposits

The sum of the transaction detail amount for income codes where the transaction type is 3 (payment) or the 7 (miscellaneous income).

Returns

The sum of the transaction detail amount for income codes where the transaction type is 3 (payment) or 7 (miscellaneous income) and the Return flag is not null in the transaction header.

Net Deposits

This number is calculated as the Sum of Bank Deposits – Returns.

Adjustments

The sum of transaction detail amount for income codes where the transaction type is 1, 2, 6 or 9 (billing or adjustment).

Forfeits

The sum of transaction detail amount for income codes where the transaction  type is 4 (forfeit).

Refunds

The sum of transaction detail amount for income codes where the transaction  type is 5 (refund).

Rent/Other

Bank Deposits

The sum of transaction detail amount where the income code type is not Security, Other or Other Income, and the transaction type is 3 (payment).

Returns

The sum of transaction detail amount where the income code type is not Security, Other or Other Income, the transaction type is 3 (payment) and the Return flag in the transaction header is not null.

Net Deposits

This number is calculated as Bank Deposits – Returns.

Adjustment

The sum of the transaction detail amount where the income code type is not Security, Other or Other Income, and the transaction type is 1, 2, 6 or 9 (billing or adjustment).

Write-Offs

The sum of the transaction detail amount where the income code type is not Security, Other or Other Income , and the transaction type is 8 (write-off).

Forfeits

The sum of the transaction detail amount where the income code type is not Security, Other or Other Income , and the transaction type is 4 (forfeit).

Refunds

The sum of the transaction detail amount where the income code type is not Security, Other or Other Income , and the transaction type is 5 (refund).

Security Deposit

Bank Deposits

The sum of transaction detail amount where the income code type is Security and the transaction type is 3 (payment).

Returns

The sum of transaction detail amount where the income code type is Security and the Return flag in the transaction header is not null.

Net Deposits

This number is calculated as Bank Deposits – Returns.

Adjustment

The sum of the transaction detail amount where the income code type is Security and the transaction type is 1, 2, 6 or 9 (billing or adjustment).

Write-Offs

The sum of the transaction detail amount where the income code type is Security and the transaction type is 8 (write-off).

Forfeits

The sum of the transaction detail amount where the income code type is Security and the transaction type is 4 (forfeit).

Refunds

The sum of the transaction detail amount where the income code type is Security and the transaction type is 5 (refund).

Other Deposit

Bank Deposits

The sum of transaction detail amount where the income code type is Other Security and the transaction type is 3 (payment).

Returns

The sum of transaction detail amount where the income code type is Other Security and the Return flag in the transaction header is not null.

Net Deposits

This number is calculated as Bank Deposits – Returns.

Adjustment

The sum of the transaction detail amount where the income code type is Other Security and the transaction type is 1, 2, 6 or 9 (billing or adjustment).

Write-Offs

The sum of the transaction detail amount where the income code type is Other Security and the transaction type is 8 (write-off).

Forfeits

The sum of the transaction detail amount where the income code type is Other Security and the transaction type is 4 (forfeit).

Refunds

The sum of the transaction detail amount where the income code type is Other Security and the transaction type is 5 (refund).

Vend/Misc

Bank Deposits

The sum of transaction detail amount where the income code type is Other Misc Income and the transaction type is 7 (miscellaneous income).

Returns

The sum of transaction detail amount where the income code type is Other Misc Income, the transaction type is 7 (miscellaneous income) and the Return flag in the transaction header is not null.

Net Deposits

This number is calculated as Bank Deposits – Returns.

Lost Rent

Loss due to (code description)

Lost rent listed by income code. This amount is excluded from the Property Total amount.

The Loss due to Employee/Model column ties to the Reconciliation Report, Lost Rent by Code section.

Property Totals

Bank Deposits

The sum of cash collected for income code types Rent, Non-Rent, Security, Other Deposit, and Misc Income. Sum of payments with a transaction type of 3 (payment) for the current accounting period.

This number ties to the Reconciliation Report, Total Actual Collections section, Collected Deposits field.

This number also ties to the Rent Roll Recap Report, Cash Deposited section, Total field.

Returns

The sum of returned payments for income codes types Rent, Non-Rent, Security, Other Deposit, and Misc Income. Sum of payments with a transaction type of 3 (payment) where the Return flag is not null.

This number ties to the Reconciliation Report, Total Actual Collections section, Returns field.

This number also ties to the Rent Roll Recap Report, Security Deposits section, Returned Checks field and Checks Returned section, Rent + Misc fields.

Net Deposit

This number is calculated as Bank Deposits – Returns.

This number ties to the Reconciliation Report, Total Actual Collections section, Amount field.

This number also ties to the Rent Roll Recap Report, Cash Deposited section, Total – (Checks Returned section, Rent + Misc) + (Security Deposits section, Returned Checks).

Adjustment

The sum of transaction detail amount where the transaction type is 1, 2, 6 or 9 (billing or adjustments).

This number ties to the Rent Roll Recap Report, Resident Billings section, Total Billed field.

Write-Offs

The sum of transaction detail amounts where the transaction type is 8 (write-off).

This number ties to the Reconciliation Report, Write-Offs by Code section, Total Write-Offs field.

Forfeits

The sum of the transaction detail amounts where the transaction type is 4 (forfeit).

This number ties to the Reconciliation Report, Forfeits by Code section, Total Forfeits field.

This number also ties the Rent Roll Recap Report, Security Deposits section, Security Forfeits.

Refunds

The sum of the transaction detail amounts where the transaction type is 5 (refund).

This number ties to the Reconciliation Report, Rent Refunds by Code section, Total Rent Refunds field.

This number also ties to the Rent Roll Recap Report, Security Deposits section, Security Refunded field.

1. From the eSite menu, select Reports—Building Reports—Monthly Income Summary.
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.