Selection Criteria
Make the following menu selections to display this page:
Reports—Accounting Reports—Monthly Income Summary
The LedgerSummary Report prints a reconciled month-to-date or year-to-date summary listing of all activity entered during the current accounting period and includes an optional recap list sorted by income code.
Note that security is tracked separately and displayed as two lines of resident totals. It is not displayed by income code at the resident level.
Select Properties
Click to select properties from the Select Properties pop-up. The report runs for all selected properties.
Recap By Income Code
Accept the checked default to print a recap section sorted by income code at the end of the report or uncheck to exclude it.
Standard or YTD
Accept Standard (default) to print the standard report, or select YTD to print the Year to Date Ledger Summary.
The report is titled Ledger Summary and shows the current date.
Unit
The building + unit number. For instance, 01-A101.
Beginning Balance
This number is calculated as Ending Balance – New Charges – Adjustments + Received + Forfeits + Refunds. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
New Charges
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 1 or 9 (billing).
Adjustments
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 2 (adjustment), 6 (balance transfer), or 8 (write-off).
Code
The identifying income code. For instance, RENT.
Description
A brief description of the income code. For instance, Base Rent.
Received
The sum of the transaction detail amount for income codes where the transaction type is 3 (payment).
Non-Revenue
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to N, and the transaction type is 1, 2, or 9 (billing or adjustment).
Forfeits/Refunds
The sum of the transaction detail amount for income codes where the transaction type is 4 (forfeit) or 5 (refund).
Ending Balance
The sum of the Open Item Balance Due for the income code. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Total Rent
Totals for income codes of a type other than Security or Other Security are listed.
Deposit
Totals for Security and Other Deposit are listed.
Property Totals
Column totals are listed per property.
Income Code Recap
If this option is selected, this section appears at the end of the report. This is a summary of the detail information for each income code encountered while displaying the report, sorted by those codes.
Beginning Balance
This number is calculated as Ending Balance – New Charges – Adjustments + Received + Forfeits + Refunds. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
New Charges
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y and the transaction type is 1 or 9 (billing or adjustment).
Adjustments
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 2 (adjustment), 6 (balance transfer), or 8 (write-off).
Code
The identifying income code. For instance, RENT.
Description
A brief description of the income code. For instance, Base Rent.
Received
The sum of the transaction detail amount for income codes where the transaction type is 3 (payment).
Non-Revenue
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to N, and the transaction type is 1, 2, or 9 (billing or adjustment).
Forfeits/Refunds
The sum of the transaction detail amount for income codes where the transaction type is 4 (forfeit) or 5 (refund).
Ending Balance
The sum of the Open Item Balance Due for the income code. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Total
Column totals are listed as the sum of the detail.
The report is titled Ledger Summary and shows the start and end dates of the current accounting period.
Tenant/Unit
Shows tenant name, the building + unit number (for instance, 01-A101), Lease Begin/End dates, Renewal Begin/End dates, Move In/Move Out dates, square footage of the unit, and Security Deposit amount.
Code
The identifying income code. For instance, RENT.
Description
A brief description of the income code. For instance, Base Rent.
Beginning Balance
This number is calculated as Ending Balance – New Charges – Adjustments + Received + Forfeits + Refunds. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Current Charges
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 1 or 9 (billing).
Adjustments
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 2 (adjustment), 6 (balance transfer), or 8 (write-off).
Payments
The sum of the transaction detail amount for income codes where the transaction type is 3 (payment).
Non-Revenue
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to N, and the transaction type is 1, 2, or 9 (billing or adjustment).
Forfeits/Refunds
The sum of the transaction detail amount for income codes where the transaction type is 4 (forfeit) or 5 (refund).
Ending Balance
The sum of the Open Item Balance Due for the income code. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Year To Date Charges
Sum of recurring charges, one time billings, or adjustments (transaction types 1, 9, or 2) to the income codes for that unit between January 1 of the current year through the report run date.
Year to Date Payments
Sum of payments to the income codes for that unit between January 1 of the current year through the report run date.
Total for Tenant
Column totals are listed per tenant.
Property Totals
Column totals are listed per property.
Income Code Recap
If this option is selected, this section appears at the end of the report. This is a summary of the detail information for each income code encountered while displaying the report, sorted by those codes.
Code
The identifying income code. For instance, RENT.
Description
A brief description of the income code. For instance, Base Rent.
Beginning Balance
This number is calculated as Ending Balance – New Charges – Adjustments + Received + Forfeits + Refunds. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Current Charges
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y and the transaction type is 1 or 9 (billing or adjustment).
Adjustments
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to Y, and the transaction type is 2 (adjustment), 6 (balance transfer), or 8 (write-off).
Payments
The sum of the transaction detail amount for income codes where the transaction type is 3 (payment).
Non-Revenue
The sum of the transaction detail amount for income codes where the income code Receivable flag is set to N, and the transaction type is 1, 2, or 9 (billing or adjustment).
Forfeits/Refunds
The sum of the transaction detail amount for income codes where the transaction type is 4 (forfeit) or 5 (refund).
Ending Balance
The sum of the Open Item Balance Due for the income code. An * (asterisk) indicates this line is a continuation from the prior line, in other words that the transactions listed for the income code on this line is applied against the income code from the previous line.
Total
Column totals are listed as the sum of the detail.
Year To Date Charges
Sum of recurring charges, one time billings, or adjustments (transaction types 1, 9, or 2) to the income codes for that unit between January 1 of the current year through the report run date.
Year to Date Payments
Sum of payments to the income codes for that unit between January 1 of the current year through the report run date.
To Display the Ledger Summary Report
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.