Vendor Accounts Receivable Aging [R0604]

The Vendor Accounts Receivable Aging report [R0604] lists all leases, sorted and totaled by vendor, and shows the present status of their respective accounts receivable records. The accounts receivable records are organized into 5 customizable delinquency categories (e.g., current; 1-30 days; 31-60 days; 61-90 days; and 91+ days). The only difference between this report and the Accounts Receivable Aging report [R0606] is that this report is sorted and totaled by vendor, not portfolio, company, region and office. The report may be accessed through the Collection/Tracking report menu [R06]. The report is organized by vendor.

Placement of the lease in delinquency category 1, 2, 3, or 4 (e.g., 1-30, 31- 60, 61-90, 91+) is based on the number of days between the payment due date and the current date. Consequently, a lease may be placed in a more delinquent category than expected. For example, assume a lease is delinquent for the July 1 and August 1 payments. On August 31, the lessee is delinquent 61 days and is placed in category 3 (61-90 days), even though only two months are actually delinquent. A switch on the New Lease screen of the Portfolio update [U0212] allows an alternative delinquency calculation which presumes that all months are 30 days. Setting this switch to Y solves the problem described above.

The report may be selected interactively for:

• All vendors
• A dealer
• A lease

Vendor Accounts Receivable Aging Selection

• ALL
  Enter X to report on all leases. Leave blank to report on a specific vendor or lease.
  
  
• VENDR
  Enter the number of a vendor on which to report. Leave blank if reporting across vendors.
  
  
• LEASE
  Enter the number of a specific lease on which to report.
  
  
  

Vendor Accounts Receivable Aging Report

The Vendor Accounts Receivable Aging report [R0604] reports at the lease level and provides the following information for each vendor:

• LEASE

• LESSEE NAME
  
  
• DESCRIPTION
  The lease description, as entered through the Book Lease option of the New Lease update [U0101], is displayed.
  
  
• MATURITY DATE
  
  
• LAST PMT DATE
  The date a lease payment was last processed on the system is displayed.
  
  
• CURRENT AMOUNT OUTSTANDING
  The current lease payment due is displayed. Pre-payments and advanced invoices (i.e., invoices produced up to 120 days before their accrual date) appear in this category.
  
  
• 1-30 AMOUNT OUTSTANDING
  Lease payments past due from 1 to 30 days are displayed.
  
  
• 31-60 AMOUNT OUTSTANDING
  Lease payments past due from 31 to 60 days are displayed.
  
  
• 61-90 AMOUNT OUTSTANDING
  Lease payments past due from 61 to 90 days are displayed.
  
  

• 91 + AMOUNT OUTSTANDING
  Lease payments past due over 90 days are displayed.
  
  Note: The delinquency period is a customized value. In these examples they are 30, 60, 90 and 90+ days, but other periods may be set, there are a total of 6 delinquency categories. Refer to the DELINQUENCY CATEGORY BOUNDARIES parameters on the third screen of the Miscellaneous Customizations option of the Portfolio update [U0212]

• TOTAL OUTSTANDING
  The total of all lease payments due for the lease is displayed. Page totals for number of leases and all dollar amounts are shown by vendor. Grand totals are shown for the number of leases and all dollar amounts.

© 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.