AFM General Ledger Entries Listing [R1007]
LeasePak menu:
Reports, Asset [R10]
Corresponding End of Period process: None
Related to:
Asset Focus Leases
Related to:
Reports income amount differences in general ledger account entries for asset focus leases.
Report Selection Criteria
On the LeasePak main menu, click Reports, point to Asset [R10] and then click Location Listing [R1007].
Field Description
All- (Optional)
Select this check box to report on all portfolios, or clear it to report on a specific portfolio, company, region, or office.
AllSelect this check box to report on all portfolios, or clear it to report on a specific portfolio, company, region, or office.
- Port
- (Optional)
Type the portfolio number to report on, or click 
to select from the list. Leave blank if reporting across portfolios.
PortType the portfolio number to report on, or click to select from the list. Leave blank if reporting across portfolios.
- Comp
- (Optional)
Type the company number to report on, or click to select from the list. Leave blank if reporting across portfolios.
CompType the company number to report on, or click to select from the list. Leave blank if reporting across portfolios.
- Regn
- (Optional)
Type the region number to report on, or click to select from the list. Leave blank if reporting across portfolios.
RegnType the region number to report on, or click to select from the list. Leave blank if reporting across portfolios.
- Offce
- (Optional)
Type the office number to report on, or click to select from the list. Lease blank if reporting across portfolios.
OffceType the office number to report on, or click to select from the list. Lease blank if reporting across portfolios.
Click OK to generate the report, or Cancel to exit the screen.
AFM General Ledger Entries Listing
The purpose of this report is to report the differences of income transactions in the general ledger accounts at lease and asset level. This report is only asset focus leases and will not work for normal leases or IBLs.
For asset focus leases, the total amount payable is split across the assets that are attached to that lease. At database level, LeasePak maintains the entries for income transactions of the lease separately in the RTX table while for its assets the income transactions entries are split and then entered against the attached assets.
When generating the report, LeasePak compares the income transactions for general ledger accounts at both lease and asset level (the transaction amounts for the assets attached to the asset focus lease are summed up for the comparison). The difference calculated is shown in the report.
A difference of zero indicates that the general ledger account is balanced. A value other than zero indicates an imbalance and a problem in the transaction entries.
Field Description
- Lease No
-
(Display)
Shows the identifier of an asset focus lease.
Lease NoShows the identifier of an asset focus lease.
- General Ledger Account - Number
-
(Display)
Shows the general ledger account number.
General Ledger Account - NumberShows the general ledger account number.
- General Ledger Account - Name
-
(Display)
Shows the general ledger account name.
Following are the general ledger accounts that LeasePak tracks for asset focus leases:
- 80 - CR Lessor Income (Pre computed)
- 81 - CR Lessor Income (Simple)
- 82 - CR Operating Lease Income
- 118 - DR IDC Amortization
- 178 - CR Insurance Fee Income (IDR1)
- 182 - CR Registration Fee Income (IDR2)
- 186 - CR Dealer Subsidy Income (IDR3)
- 190 - CR Opening Comm Income (IDR4)
- 102 - DR IDC Offset
- 171 - DR Ins Prem Amortization (IDC1)
- 174 - DR Notary Fee Amortization (IDC2)
General Ledger Account - NameShows the general ledger account name.
Following are the general ledger accounts that LeasePak tracks for asset focus leases:
- 80 - CR Lessor Income (Pre computed)
- 81 - CR Lessor Income (Simple)
- 82 - CR Operating Lease Income
- 118 - DR IDC Amortization
- 178 - CR Insurance Fee Income (IDR1)
- 182 - CR Registration Fee Income (IDR2)
- 186 - CR Dealer Subsidy Income (IDR3)
- 190 - CR Opening Comm Income (IDR4)
- 102 - DR IDC Offset
- 171 - DR Ins Prem Amortization (IDC1)
- 174 - DR Notary Fee Amortization (IDC2)
- Transactions - Lease
-
(Display)
Shows the lease level income amount.
Transactions - Lease Shows the lease level income amount.
- Transactions - Total Assets
-
(Display)
Shows the asset level income amount. This amount is the sum of incomes of all assets attached to this lease.
Transactions - Total Assets Shows the asset level income amount. This amount is the sum of incomes of all assets attached to this lease.
- Difference
-
(Display)
Shows the difference between the lease and asset level income calculation for this general ledger account. A difference of zero indicates that the account is balanced and the transaction entries at both lease and asset level are correct. A value other than zero is an indication of an imbalance and requires verification.
DifferenceShows the difference between the lease and asset level income calculation for this general ledger account. A difference of zero indicates that the account is balanced and the transaction entries at both lease and asset level are correct. A value other than zero is an indication of an imbalance and requires verification.
LeasePak Documentation Suite
© by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.