Assessments Receivable Aging [R0607]

The Assessments Receivable Aging report [R0607] 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]. The report may be accessed through the Collection/Tracking report menu [R06].

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, not on the number of months delinquent. Conse quently, 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 [U0212NL] allows an alternative calculation for number of days delinquent which presumes all months have 30 days. Setting this switch to Y solves the problem described above.

Balancing Procedures: The TOTAL DUE for each type of assessment for each accounting unit (portfolio, company, region, and office) should balance to the appropriate assessment receivable general ledger account on the General Ledger Entries Listing report [R0406]. When balancing, both the Assessments Receivable Aging report [R0607] and the General Ledger Entries Listing report [R0406] should be generated at the same time.

The report is organized by Portfolio, Company, Region, Office and may be selected interactively for:

All leases
A portfolio
A company
A region
An office
A lease

Assessments Receivable Aging Selection

ALL
Enter X to report on all leases. Leave blank to report on a specific portfolio, company, region, office, or lease.
PORT
Enter the number of the portfolio on which to report. Leave blank if reporting across portfolios.
COMP
Enter the number of the company on which to report. Leave blank if reporting across companies.
REGN
Enter the number of the region on which to report. Leave blank if reporting across regions.
OFFIC
Enter the number of the office on which to report. Leave blank if reporting across offices.
LEASE
Enter the number of the specific lease on which to report.

ALL
Enter X to report on all assessment types. Leave blank to report on specific assessment types.
ENTER ASSESSMENTS TO BE INCLUDED (scrolled area)
If ALL is not selected, enter X next to each assessment type to be included on the report. Multiple assessments may be selected.

Assessments Receivable Aging Report

The Assessments Receivable Aging report [R0607] reports at the lease level and provides the following information:

LEASE
LESSEE NAME
TYPE
The type of assessment (e.g., use tax, late charges, collection fee, etc.) is displayed. Each different assessment type outstanding is displayed for the lease on separate lines of the report.

If the Name Assessment by Portfolio module is purchased, the customized assessment names will be displayed.
LAST PMT
The date a lease payment was last processed on the system is displayed.
CURRENT AMOUNT OUTSTANDING
The current assessment amount due for the TYPE of assessment is displayed. Assessments (use tax and recurring charges) which appear on advanced invoices but have not yet accrued are included in this amount.
1-30 AMOUNT OUTSTANDING
The assessment amount past due from 1 to 30 days for the TYPE of assessment is displayed.
31-60 AMOUNT OUTSTANDING
The assessment amount past due from 31 to 60 days for the TYPE of assessment is displayed.
61-90 AMOUNT OUTSTANDING
The assessment amount past due from 61 to 90 days for the TYPE of assessment is displayed.
91 + AMOUNT OUTSTANDING
The assessment amount past due over 90 days for the TYPE of assessment is 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 that can be entered. 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 assessment amounts due for the TYPE of assessment is displayed.
TOTALS
Page totals for each type of assessment and all dollar amounts in each category are shown by office.

Region, company, portfolio and grand totals are shown for each type of assessment and all dollar amounts. On the grand totals page, column headings appear as CATEGORY 1 DUE, CATEGORY 2 DUE, etc., instead of 1-30 DUE, 31-60 DUE, etc. This accommodates multiple portfolios with different category boundaries. Also, assessment types for recurring charges are described generically (e.g., RECUR CHARGE 1) instead of by actual name (e.g., MAINTENANCE), also to accommodate multi-portfolios. The Multi-portfolio module is a separately purchased module of LeasePak.

If multiple portfolios are used and different category boundaries and/or different recurring charge definitions exist between portfolios, the grand totals page may not contain useful information for these items. For example, if portfolio 1 has $100.00 in category boundary 1 (1-30 days) and portfolio 2 has $25.00 in category boundary 1 (1-15 days) and $75.00 in category boundary 2 (16-30 days), the grand totals page shows $125.00 in category boundary 1 and $75.00 in category boundary 2.

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.