Code

The identifying income code. For instance, Rent.

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.

To run the Historical Monthly Income Summary report, check the Print Historical Version check box. The Historical Monthly Income Summary report prints based on the 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 is noted in the report.

1. From the eSite menu, select Reports—Accounting Reports—Monthly Income Summary.
2. Click Select Properties. Select the properties for which you want to print the report and click Done.
3. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
4. 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.