![Document: End of Period [U04] Overview (main document)](nav_u04_nonupdrpt_lnk01.gif){kind=small}
The following is a list of reports that may be set to run during End of Period and are not part of any updates to the LeasePak database. Many of these reports may also be run interactively through the LeasePak client. Differences in output between interactive and EOP versions are noted. Report groupings below are for ease of reference, and do not reflect the order in which they run during EOP. Refer to the EOP Module List for execution order of End of Period modules.
For reports that are also available interactively, use the link to access the full description of the report.
These reports may be generated as part of the End of Day process.
The Application Activity report provides a register of applications whose statuses have changed on a selected date or between a range of dates. Booked applications may be excluded from the list. The report may also provide a list of applications whose statuses have changed to a specific status or status category.
The Daily Transaction Journal provides an audit trail which can be used to prove the debit and credit entries to the General Ledger accounts each day. It may also be used to review the transactions processed for a specific lease and the resulting General Ledger debit and credit entries. Two reports are produced, a listing and a consolidation report.
When executed through End of Day, the Daily Transaction Journal reports transactions starting with the date and time the previous End of Day completed, up to the current date and time.
The General Ledger Entries Listing provides the information necessary to pass entries to a General Ledger system separate from LeasePak. Also, used in conjunction with the Trial Balance report [R0901], the Accounts Receivable Balancing report [R0404], the Income Receivable Balancing report [R0407], the Accounts Payable Balancing report [R0408], the Suspense Review report [R0203] and the Off Lease Inventory report [R1001], it is an essential tool in the General Ledger reconciliation process.
The Notes Transaction Journal report provides an audit trail which can be used to prove the debit and credit entries to General Ledger accounts each day. It may also be used to review the transactions processed for a specific note payable and the resulting General Ledger debit and credit entries. Two reports are produced, a listing and a summary report.
The Turnaround Timing report provides a summary of the amount of time applications remain in one status before moving to another status. The report may be used as a tool in measuring productivity or analyzing workflow and workload.
These reports may be generated as part of the End of Month process.
The Account Balances report provides miscellaneous information on leases, including user defined calculations for gross receivable, net outstanding, and gross outstanding balances.
Accounts
Payable Balancing [R0408]
This
report is also available in the Audit Control report menu [R04] of the LeasePak
client.
The Accounts Payable Balancing report provides lease and asset information detailing the payable LeasePak General Ledger accounts. This report may be used to reconcile the corresponding General Ledger accounts on the General Ledger Entries Listing report [R0406].
Accounts
Receivable Balancing [R0404]
This
report is also available in the Audit Control report menu [R04] of the LeasePak
client.
The Accounts Receivable Balancing report provides a register of all outstanding accounts receivable items. It may be used to reference payments/charges accrued but not yet paid and to reconcile the Lease Payments Receivable General Ledger account balance on the General Ledger Entries Listing report [R0406]. The Accounts Receivable Balancing report may also be used when reversing partial payments and pre-payments via the Payment Reversal option of the Payment update [U0102].
The Assessments Receivable Aging report lists all leases and shows aging of outstanding assessment charges. All assessments, including use tax and recurring charges, may appear on the report. The user selects all or a subset of assessments to be included. The assessment charges are organized into customizable categories (e.g., current; 1-30 days; 31-60 days; 61- 90 days; and 91+ days). This report may be used to reference assessment charges accrued but not yet paid and to reconcile each Assessment Receivable general ledger account balance on the General Ledger Entries Listing report [R0406].
Book
Gain/Loss [R0108]
This
report is also available in the Strategic Management report menu [R01] of the
LeasePak client.
The Book Gain/Loss report provides book gain or loss information and/or use of the allowance for bad debt reserve for assets sold during the fiscal year. Included in this report are assets sold either through a lease or asset payoff or through the sale of off-lease inventory (using the Payoff update [U0103]).
Cash
Receipts Journal [R0411]
This
report is also available in the Audit Control report menu [R04] of the LeasePak
client.
The Cash Receipts Journal reports on cash received (e.g., payments, payoffs, advance monies received for new leases) and payment reversals against cash. The report only shows transactions currently on file. Transaction information is normally stored back one month prior to the most recent month end. For example, on 5/10, if the preceding month end was run on 4/30, the oldest reportable date would be 4/1. Transaction information may be stored indefinitely if the Transaction File Clean-up update [U0451] is not executed at the end of month.
Certificate
of Ownership [R0903]
This
report is also available in the Operational report menu [R09] of the LeasePak
client.
The Certificate Of Ownership report lists all assets with a missing or incorrect ownership certificate or title (UCC or Security Interest) filing. Therefore, this report may be used as an exception report, identifying assets whose ownership status is not correctly filed. Changes to the status of the ownership certificates and title filings may be entered through the Asset Maintenance update [U0210].
Delinquency
[R0601]
This
report is also available in the Collection/Tracking report menu [R06] of the LeasePak
client.
The Delinquency report lists past due leases, showing number of times delinquent, number of days delinquent, last and next payment dates, and amounts outstanding. This report supports the collection process even if LeasePak’s Collection module is not purchased. Two reports are produced: the Delinquency report [R0601A] and the Net Delinquent Outstanding Review [R0601B]. An alternate form of the Delinquency report may be produced, depending on the setting of the ALTERNATE DELINQUENCY REPORT switch on the third screen of the Miscellaneous Customizations option of the Portfolio update [U0212]. The alternate report may be produced for some portfolios, the standard report for others, if desired, by setting the switch on [U0212MI] to Y or to N by portfolio.
The Energy Tax Credit Listing report provides a year-to-date detailed accounting of the Energy Tax Credit for each applicable asset.
Only assets with an ETC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The Energy Tax Credit Review report provides a year-to-date summary of the Energy Tax Credit to be taken. It is formatted to assist in the preparation of the Internal Revenue Service forms.
Only assets with an ETC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The General Ledger Reconciliation report provides a quick means to verify that the system is in balance by comparing General Ledger account balances to the total of the dollar amounts for each lease. This report should be set to run monthly through End of Period, as well as run interactively on a weekly basis.
The Historical General Ledger report provides past General Ledger account balance information. The months that comprise the current fiscal quarter and up to 5 previous quarter totals are displayed on the report. The number of previous quarter totals displayed depends on space available on the report after the current fiscal quarter information is displayed.
The Income Receivable Balancing report provides a detailed accounting of income accrued but not yet due for leases with non-monthly payment schedules. This report may also be used to reconcile the Lease Income Receivable General Ledger account balance on the General Ledger Entries Listing report [R0406].
The Insurance Follow-up report provides a follow-up for receipt of required insurance coverage documents. Changes to the status of insurance coverage may be entered through the Demographic update [U0204].
The Investment Tax Credit Listing report provides a current detailed accounting of the Investment Tax Credit status for each asset. This report may be used for tax information and book ITC accrual purposes if ITC is recognized on a flow-through basis. If ITC is recognized for book purposes using the deferral method, the accrual register and/or transaction journal reports book ITC accrual information.
Only assets with an ITC method other than BYPS or with an in-service date before January 1, 1986 are reported on.
The Investment Tax Credit Review report provides a year-to-date summary at the office level of the investment tax credit to be taken and reversed. It is formatted to assist in the preparation of the Internal Revenue Service forms for ITC.
Only assets with an ITC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The Lease Inventory report lists all leases that have not been paid off nor charged off. Paid off leases have a lease activity status starting with NP; charged off leases, a lease activity status starting with NC. Refer to the Status Codes document for a list of lease activity statuses and their meanings. To obtain a listing of assets not currently tied to a lease, use the Off Lease Inventory report [R1001].
The Monthly Application Summary provides a review by vendor of the current month’s application activity. This report assists in determining the quality of the vendor relationship by analyzing the volume of applications and the decisions made (approvals, rejections).
The Notes Transaction Journal report provides an audit trail which can be used to prove the debit and credit entries to General Ledger accounts each day. It may also be used to review the transactions processed for a specific note payable and the resulting General Ledger debit and credit entries. Two reports are produced, a listing and a summary report.
The Transaction Journal provides an audit trail which can be used to prove the debit and credit entries to the General Ledger accounts each day. It may also be used to review the transactions processed for a specific lease and the resulting General Ledger debit and credit entries. Two reports are produced, a listing and a consolidation report.
When executed through End of Month, the Transaction Journal reports transactions starting with the date and time the previous End of Month completed up to the current date and time.
The New Lease Earnings report provides information on leases with a system booking date of the current month (i.e., all leases booked onto the system since the actual date of the last month end).
The Off Lease Inventory report lists assets on file which are not currently attached to a lease (i.e., in inventory or sold). This report is used to reconcile the balance in the Inventory General Ledger account as shown on the General Ledger Entries Listing report [R0406]. The report may be accessed through the Asset report menu [R10]. All assets with a pre-inventory status (assets which have never been on lease) are shown first for each office. Following this, all other assets are listed. It may appear that the report, when viewed as a whole, is not sorted by asset number. In actuality, it is sorted by asset number, but within each sub-group of assets (pre-inventory and all others).
The Operator’s Status Review report summarizes each operator’s activity since the last End of Month. The report may be used as a tool in measuring productivity or analyzing workload.
Paid
Off Leases [R0912]
This
report is also available in the Operational report menu [R09] of the LeasePak
client.
The Paid Off Lease report lists leases paid off or terminated during the current month. It may be used for audit purposes and/or to ensure that all appropriate documents have been returned to the lessee or investor.
Portfolio
Status [R0104]
This
report is also available in the Strategic Management report menu [R01] of the
LeasePak client.
The Portfolio Status report provides a historical perspective of the lease portfolio for the current month and the preceding twelve (12) months. The statistics are displayed for each month and year-to-date for the current and previous years. The report may be used for trend analysis and miscellaneous MIS reporting.
The Rental Income report lists income earned and/or initial direct costs amortized for each lease.
The Salesperson Commission report provides a listing of the leases booked for each salesperson, sorted and totaled by vendor. It may be used to determine the commission amounts due to each salesperson. The report shows lease booking information for each salesperson as well as total information of leases booked by vendor for each salesperson.
The Tax Depreciation report provides year-to-date information on federal, alternative minimum tax (AMT), and state depreciation for the lease portfolio, to assist in the preparation of the lessor’s federal and state tax returns. Life-to-date depreciation is also shown for informational purposes. Two depreciation reports are produced, one for federal and AMT, and one for state.
Taxable
Income [R0301]
This
report is also available in the Controller's Tax report menu [R03] of the LeasePak
client.
The Taxable Income report provides year-to-date information on taxable income generated by the lease portfolio, to assist in the preparation of the lessor’s federal and state tax returns. The report is sorted and totaled by state. The sum of all the state totals (found on the grand totals page) may be used for the federal return.
The Trial Balance report shows the financial values of all current leases on file. Paid off and terminated leases are not included. It may be used just to inventory leases on file or to reconcile corresponding General Ledger accounts on the General Ledger Entries Listing report [R0406].
The Vendor Delinquency report lists past due leases, showing guarantor information, number of days delinquent, last and next payment dates, gross balance, amounts outstanding, and percentage of outstanding per delinquency category. This report supports the collection process even if LeasePak’s Collection module is not purchased.
These reports may be generated as part of the End of Year process.
The Book Gain/Loss report provides book gain or loss information and/or use of the allowance for bad debt reserve for assets sold during the fiscal year. Included in this report are assets sold either through a lease or asset payoff or through the sale of off-lease inventory (using the Payoff update [U0103]).
The Energy Tax Credit Listing report provides a year-to-date detailed accounting of the Energy Tax Credit for each applicable asset.
Only assets with an ETC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The Energy Tax Credit Review report provides a year-to-date summary of the Energy Tax Credit to be taken. It is formatted to assist in the preparation of the Internal Revenue Service forms.
Only assets with an ETC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The Investment Tax Credit Listing report provides a current detailed accounting of the Investment Tax Credit status for each asset. This report may be used for tax information and book ITC accrual purposes if ITC is recognized on a flow-through basis. If ITC is recognized for book purposes using the deferral method, the accrual register and/or transaction journal reports book ITC accrual information.
Only assets with an ITC method other than BYPS or with an in-service date before January 1, 1986 are reported on.
The Investment Tax Credit Review report provides a year-to-date summary at the office level of the investment tax credit to be taken and reversed. It is formatted to assist in the preparation of the Internal Revenue Service forms for ITC.
Only assets with an ITC method other than BYPS or an in-service date before January 1, 1986 are reported on.
The Tax Depreciation report provides year-to-date information on federal, alternative minimum tax (AMT), and state depreciation for the lease portfolio, to assist in the preparation of the lessor’s federal and state tax returns. Life-to-date depreciation is also shown for informational purposes. Two depreciation reports are produced, one for federal and AMT, and one for state.
The Taxable Income report provides year-to-date information on taxable income generated by the lease portfolio, to assist in the preparation of the lessor’s federal and state tax returns. The report is sorted and totaled by state. The sum of all the state totals (found on the grand totals page) may be used for the federal return.
©
2001 by McCue Systems Incorporated.
All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, Inc. is prohibited.