Financials - Collections Delinquencies

Description

This subject area provides the ability to analyze customer delinquency, collection exposure, overdue receivables, promises, disputes, adjustments, receipts, and resolution activity.

Business Questions

This subject area can answer the following business questions:

• How many invoices are in each delinquency status?

• How much total outstanding receivables are currently delinquent?

• What are the top reasons for non-payment across my portfolio?

• What is the average number of days invoices stay in delinquent status before being cured?

• What is the cure rate and what percentage of delinquent invoices returned to current?

• What is the delinquent amount by Business Unit?

• What is the delinquent amount by aging bucket (1-30, 31-60, 61-90, 90+ days)?

• What is the promise-to-pay compliance rate for delinquent invoices?

• What percentage of total outstanding receivables is delinquent?

• Which collector has the highest delinquent portfolio?

• Which customers have the highest delinquent balances?

• Which delinquent invoices have unapplied receipts or on-account cash that has not yet been applied against the invoice? What is the effective delinquent balance after netting out this pending cash?

Job Roles

The following job roles secure access to this subject area:

• Collections Agent

• Collections Manager

Duty Roles

The following duty roles secure access to this subject area:

• Collections Delinquencies Duty

Primary Navigation

Home > Advanced Collections

Time Reporting

This subject area supports analysis of current customer delinquency, aging, promises, and disputes.

Time dimension is linked to Transaction Date for Delinquency Detail Last Update Date for Delinquency Summary Creation Date for Promise to Pay Start Date for Disputes Apply Date for Adjustments Apply Date for Receipts.

Transactional Grain

The grain of Delinquency detail is at Payment Schedule level.

The grain of Delinquency Summary is at Business Unit and Business Level.

The grain of promises is at the Promise detail level.

The grain of disputes is at the dispute level.

Special Considerations

None.