RF Outstanding Check Register Report

Description

Purpose

You should use this report to monitor uncashed checks that were processed through the Accounts Payable (AP) module. The register lists all negotiable (not cashed) checks by operating location. The Research Foundation's (RF) central office runs the report by state for reporting abandoned property (e.g., uncashed checks) to each state as required by the abandoned property laws in that state.

Frequency

You should run this report quarterly.

Setting Report Parameters

The following table describes the required and optional parameters to use to run the report:


Parameter	Description (click in the field to see the List of Values)
Required Parameters
Bank Name		The default is the Key Bank of New York. Do not change this option.
Bank Account		The default is the Supplier Account. Do not change this option.
Type		The default is the Location. Campus users should use the default value. Central office staff uses other values, e.g., All and State, when reporting abandoned property to individual states.
Date Range From		The beginning date of the checks to be reviewed. The earliest date you can enter is 01-JAN-01, the "go live" date for the Research Foundation's Oracle applications. Legacy system check information is not in Oracle.
Date Range To		The ending date of the checks to be reviewed. The earliest date you can enter is 01-JAN-01, the "go live" date for the Research Foundation's Oracle applications. Legacy system check information is not in Oracle.
Optional Parameters
State		The state name on the address of the check. Central office uses this for reporting abandoned property to individual states.
Location		The operating location. Campus users are only allowed to enter their own location in this field. Central office uses this to retrieve lists of checks made out of the General Ledger accounts.

Understanding the Output

The table that follows describes the report output:

Column Heading	Description of Column
Check #	The number of the check that wasn't cashed.
Check Date	The date the check was run from the AP module.
Payee	The person or entity that the check was made out to, e.g., the supplier.
Address, City State Zip Code	The full address of the payee as it is listed in the Supplier File. Note: If a site name changed, the information in this field will state: "Supplier Address May Have Changed. Verify in Supplier File." In this case you will need to review the address information in the Supplier File for that supplier and select the appropriate address.
Amount	The dollar amount of the uncashed check.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request form.

Effective Date: 6/11/2007 10:09:08 AM