Receivables Management dashboards and reports

Applied vs Unapplied Amounts

The Applied vs Unapplied Amounts dashboard displays the summary of outstanding amount, applied amount based on customer, and unapplied payments based on operator.

This list shows the reports on the dashboard:

• The Outstanding Invoice Amount by Customer report shows the outstanding invoice amount based on the customer.
• The Unapplied Amount by Customer report shows the unapplied amount based on the customer.
• The Applied vs Unapplied Amount report compares the applied amount and unapplied amount based on the period.
• The Unapplied Payments by Operator detail report which shows the unapplied amount of a payment number which includes customer, company, and receivable operator name details

This list shows the filters you can use to slice data:

• Company
• Customer
• Ranking
• Year
• Year/month

Customer Analysis

The Customer Analysis dashboard displays summarized information about customers.

This list shows the reports on the dashboard:

• The Top 10 Customers by Credit Limit Used report shows the top customers based on credit limit used.
• The Overdue Invoice Count report shows the overdue invoices count based on the customer.
• The Unapplied Amount by Customer report displays the unapplied payments based on the customer.
• The Dunning Letters by Customers report shows the last dunning letters based on the customer.
• The Outstanding Invoice Amount by Territory report shows the outstanding invoice amount based on the territory.
• The Outstanding Invoice Amount by Customer report shows the outstanding invoice amount based on the customer.

This list shows the filters you can use to slice data:

• Company
• Customer
• Ranking
• Territory
• Year
• Year/month

Customer Invoice Aging

The Customer Invoice Aging dashboard displays customer invoice aging details.

This list shows the reports on the dashboard:

• The Customer Aging Report report compares the outstanding invoice amount and total outstanding invoice amount per customer based on the different aging buckets.
• The Aging by Class report compares the outstanding invoice amount of different aging buckets with total outstanding invoice amount based on customer major class.
• The Customer Aging Details detailed report shows outstanding invoice amount per aging bucket which includes customer details, transaction ID, and transaction type columns.

This list shows the filters you can use to slice data:

• Company
• Customer
• Ranking
• Process Level
• Year
• Year/month

Invoice Aging Analysis

The Invoice Aging Analysis dashboard contains these reports:

• The Customer Aging report compares the outstanding amount and total outstanding amount for a customer per aging bucket.
• The Aging by Credit Analyst report shows an outstanding amount based on credit analyst for each aging bucket.
• The Aging by Class report shows an outstanding amount based on major class for each aging bucket.

This list shows the filters you can use to slice data:

• Company
• Customer
• Ranking
• Process Level
• Year
• Year/month

Invoice Detail

The Invoice Detail dashboard displays the detail of invoices which includes invoice, invoice type, batch number, status, terms code, transaction date, general ledger date, payment due date, origin, open amount, invoice amount currency amount, original currency, days to pay, transaction category, payment code, discount date, and sales representative name for company and customer.

This list shows the filters you can use to slice data:

• Company
• Customer
• Process Level
• Receivable Invoice Detail Type
• Receivable Invoice Status
• Sales Representative Name
• Year
• Year/month

Invoice Overview

The Invoice Detail dashboard displays the summary of invoice details.

This list shows the reports on the dashboard:

• The Top Customers by Invoices report compares invoice count and invoice amount based on the customers.
• The Invoice Amount report shows invoice amount per period.
• The Invoice Amount by Origin or Status report shows invoice amount based on both origin and status. Click the status in the chart to redirect you to the Invoice Detail report.
• The Invoice Amount by Sales Representative report shows invoice amounts based on sales representative. Click a Sales Rep in the report to redirect you to the Invoice Detail report.

This list shows the filters you can use to slice data:

• Company
• Customer
• Process Level
• Ranking
• Year
• Year/month

Overdue Invoices

The Overdue Invoices dashboard displays detailed information of overdue invoices that includes invoice, transaction date, payment due date, overdue days, invoice amount currency amount, open amount and currency for company and customer.

This list shows the filters you can use to slice data:

• Company
• Customer
• Customer Company
• Process Level
• Year
• Year/month

Payment Analysis

The Payment Analysis dashboard shows the summary of payment information.

This list shows the reports on the dashboard:

• The Payments by Customer report shows payments made by individual customers. Click a customer to redirect you to the Payment Detail dashboard.
• The Type of Payment report shows payments based on the type of payment. Click a payment type to redirect you to the Payment Detail report.
• The Customer Advances report shows advance payments made by the customer.
• The Payments by Status shows payments based on status. Click a status in the chart to redirect you to the Payment Detail report.

This list shows the filters you can use to slice data:

• Company
• Customer
• Receivable Process Level
• Ranking
• Year
• Year/month

Payment Detail

The Payment Detail report displays detailed information of payments that include receivable payment header, process level, receivable payment, status, deposit bank code, payment number, type of payment, deposit date, general ledger date, cash code, transaction amount, and original currency for the company and customer.

This list shows the filters you can use to slice data:

• Company
• Customer
• Receivable Payment Status
• Receivable Process Level
• Type of Payment
• Year
• Year/month

Revenue Overview

The Revenue Overview dashboard displays the summary of overall revenue generated.

This list shows the reports on the dashboard:

• The Top Customers by Revenue report shows the top customers based on the revenue.
• The Revenue by Year Month report shows revenue based on the period.
• The Revenue by Origin report shows revenue based on the origin.
• The Revenue by Sales Representative report shows revenue based on the sales representative.

This list shows the filters you can use to slice data:

• Company
• Customer
• Process Level
• Ranking
• Year
• Year/month