End of Period [U04]: Non-Updating Reports

This is part of the End of Period [U04] group. For an introduction to End of Period and links to all the End of Period documents, refer to End of Period [U04]: Overview.

Introduction
End of Day Reports
End of Month Reports
End of Year Reports

Introduction

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.

End Of Day Reports

These reports may be generated as part of the End of Day process.

Application Activity [R0501]
This report is also available in the Application report menu [R05] of the LeasePak client. 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.

Daily Transaction Journal [R0405]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. 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.

General Ledger Entries Listing [R0406]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. 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.

Notes Transaction Journal [R1205]
This report is also available in the Notes Payable report menu [R12] of the LeasePak client. 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.

Rental Income [R0409]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. The Rental Income report lists income earned and/or initial direct costs amortized for each lease.

Turnaround Timing [R0503]
This report is also available in the Application report menu [R05] of the LeasePak client. 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.

End Of Month Reports

These reports may be generated as part of the End of Month process.

Account Balances [R0103]
This report is also available in the Strategic Management report menu [R01] of the LeasePak client. 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].

Assessments Receivable Aging [R0607]
This report is also available in the Collection/Tracking report menu [R06] of the LeasePak client. 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.

Energy Tax Credit Listing [R0307]
This report is also available in the Controller's Tax report menu [R03] of the LeasePak client. 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.

Energy Tax Credit Review [R0308]
This report is also available in the Controller's Tax report menu [R03] of the LeasePak client. 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.

General Ledger Reconciliation [R0403]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. 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.

Historical General Ledger [R0410]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. 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.

Income Receivable Balancing [R0407]
This report is also available in the Audit Control report menu [R04] of the LeasePak client. 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].

Insurance Follow-up [R0904]
This report is also available in the Operational report menu [R09] of the LeasePak client. 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].

Investment Tax Credit Listing [R0302]
This report is also available in the Controller's Tax report menu [R03] of the LeasePak client. 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.

Investment Tax Credit Review [R0303]
This report is also available in the Controller's Tax report menu [R03] of the LeasePak client. 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.

Lease Inventory [R0902]
This report is also available in the Operational report menu [R09] of the LeasePak client. 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].

Monthly Application Summary [R0507]
This report is also available in the Application report menu [R05] of the LeasePak client. 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).

Monthly Notes Transaction Journal [R1205]
This report is available only through End of Period. It is a month end version of the Notes Transaction Journal report [R1205]. 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.

Monthly Transaction Journal [U0456]
This report is available only through End of Period. It is a month end version of the Daily Transaction Journal report [R0405]. 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.

New Lease Earnings [R0101]
This report is also available in the Strategic Management report menu [R01] of the LeasePak client. 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).

Off-Lease Inventory [R1001]
This report is also available in the Asset report menu [R10] of the LeasePak client. 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).

Operator's Status Review [R0202]
This report is also available in the Operational Management report menu [R02] of the LeasePak client. 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.

Salesperson Commission [R0204]
This report is also available in the Operational Management report menu [R02] of the LeasePak client. 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.

Tax Depreciation [R0304]
This report is also available in the Controller's Tax report menu [R03] of the LeasePak client. 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.

Trial Balance [R0901]
This report is also available in the Operational report menu [R09] of the LeasePak client. 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].

Vendor Delinquency [R0603 ]
This report is also available in the Collection/Tracking report menu [R06] of the LeasePak client. 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.

End Of Year Reports

These reports may be generated as part of the End of Year process.

Book Gain/Loss (EOY)
This report is available only through End of Period. It is a year end version of the Book Gain/Loss report [R0108]. 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]).

Energy Tax Credit Listing (EOY)
This report is available only through End of Period. It is a year end version of the Energy Tax Credit Listing report [R0307]. 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.

Energy Tax Credit Review (EOY)
This report is available only through End of Period. It is a year end version of the Energy Tax Credit Review report [R0308]. 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.

Investment Tax Credit Listing (EOY)
This report is available only through End of Period. It is a year end version of the Investment Tax Credit Listing report [R0302]. 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.

Investment Tax Credit Review (EOY)
This report is available only through End of Period. It is a year end version of the Investment Tax Credit Review report [R0303]. 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.

Tax Depreciation (EOY)
This report is available only through End of Period. It is a year end version of the Tax Depreciation report [R0304]. 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 (EOY)
This report is available only through End of Period. It is a year end version of the Taxable Income report [R0301]. 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 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.