RF Aging 7 Bucket Report

Description

Purpose

Oracle Accounts Receivable (AR) module maintains detailed information on AR invoices that have been paid in full or have an outstanding balance due. The Research Foundation (RF) customized the Aging 7 Bucket Report to provide the total outstanding AR invoices based on a location, customer, and/or balance due for a specified date.

This report is sorted by customer. Customer subtotals are displayed each section.

A summary of parameters selected is provided at the beginning of the report. This report is used to monitor open AR invoices that have amounts past due and to determine appropriate action with the sponsor (e.g., collection call to sponsor, dunning letter, etc.).

Frequency

Run this report monthly and as needed for review by staff responsible for resolving outstanding balances on AR invoices.

Responsibilities with Access

Setting Report Parameters

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

Parameters

Description
(click in the field to see the List of Values)

Required Parameters

Order By

The report's default sort order is by customer.

Summary Type

The type of summary for the report. Select from:

  • Invoice Summary - displays information on all of the customers' debit items.
  • Customer Summary - displays the customers' names and a total debit amount.

Report Format

The format of the report. Select from:

  • Brief - displays the customer name with item information.
  • Detailed - displays the customer name, item information, as well as contact and address information.

As Of Date

Date that the report uses to calculate whether an invoice meets the past due criteria. The default is the current date.

Bucket Name

The Standard Bucket is the only bucket defined.

Show On Account

This parameter is for On Account receipts.

Optional Parameters

Customer Name Low

The customer name that is associated with the award that the AR invoice was generated for, starting with the top of the alphabetical range.

Customer Name High

The customer name that is associated with the award that the AR invoice was generated for, starting with the bottom of the alphabetical range.

Balance Due Low

The outstanding balance, starting with the top of the range.

Note: For all outstanding balances, leave this field blank.

Balance Due High

The outstanding balance, starting with the bottom of the range.

Note: For all outstanding balances, leave this field blank.

Location

Three-digit location code assigned to a campus (operating location). Security will limit location access.

Understanding the Output

The following table describes the report output:

Column Heading

Description of Column

Invoice Number

Accounts Receivable invoice number. The invoice number that Accounts Receivable assigns once an invoice is approved and released or the invoice number that is assigned to an advance invoice created in AR.

Due Date

The date that the payment is due, based on the billing terms of the award and the invoice date.

Award Number

A unique sequential number assigned to an award. An award is the record established from the award notice or contract received from a customer. An award record contains a funding source (customer), award amounts (funds), start and end dates, terms and conditions, and other information. Awards are used to fund one or more projects.

Org Code

The three-digit location number assigned to a campus (operating location).

Days Late

The number of days the invoice is past due based on the billing terms of the award.

% Unpaid

The percentage of the original invoiced amount that remains unpaid.

Outstanding Amount

The total outstanding amount on the invoice.

Current Amount Past Due

The amount remaining outstanding, either above or below the original invoice amount.

1-30 Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

31-60 Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

61-90 Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

91-180 Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

181-360 Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

360+ Days Past Due

The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

Helpful Tips

Effective Date: 3/19/2007 9:35:10 AM