Customer Receivables Aging Dashboard

The Customer Receivables Aging dashboard lets a finance manager review accounts receivables and identify current or potential problems. This dashboard provides an overall analysis of a company’s accounts receivables collection efforts and the status of key accounts.

Customer Receivables Aging: Dashboard Structure and Behavior

This dashboard has two sections:

The upper part provides an aging overview and an analysis of either overdue receivables or future remittances.
The lower part displays an analysis of overdue receivables or future remittances for the top five customers or sales employees.

All the amounts in the dashboard are given in the local currency, which is displayed under the title bar on the right side. In the lower part of the dashboard, you can use the dropdown list to switch the analysis from Customers, which is the default, to Sales Employees. By default, details for the top customer or sales employee are displayed on the right side of the lower part. To display the details for another customer or sales employee, in the bar chart, click the bar for the customer or sales employee for which you want to view detailed information. For more information about the data refresh options and settings, see Scheduling Daily Data Refresh for Dashboards.

Customer Receivables Aging: Dashboard Behavior Details

The balance due for a customer, a sales employee, or a specific aging interval should be a positive value. A negative value is not shown correctly in the dashboard. To enable values to be displayed correctly in the dashboard, before displaying the dashboard you must first reconcile credit memos and any other documents that result in a negative value. When you select the Customer Receivables Aging dashboard, it displays the default time interval, which is 90+ Days. If there is no data for this time interval, the display does not default to another time interval. Instead, the dashboard appears as follows:

In the Overdue Analysis line chart, the Overdue Total line appears with data; the 90+ Days line displays a zero value.
In the Overdue Analysis by Customers or Overdue Analysis by Sales Employees, no Top 5 Customers or Top 5 Sales Employees bar chart appears.
In the Aging Versus Revenue line chart, the 90+ Days line displays a zero value. There is no Overdue Total and Revenue.

The default selection of the top-ranked customer or the top-ranked sales employee is realized only at initialization of the dashboard (“at initialization” refers to selecting a new dashboard or clicking a different aging interval for the first time after opening the first dashboard). If you change the selected aging interval to a different interval and then return to the previously selected aging interval, the default display of the top-ranked customer or top-ranked employee in the Aging Versus Revenue line chart does not occur. This also happens when you change the default display of Overdue Analysis by from Customers to Sales Employees. This may result in no data being displayed in the Aging Versus Revenue and Future Remit Versus Sales Opportunities line charts.

Example Example

The dashboard shows the Top 5 Customers (31-60 Days) bar chart and the Aging Versus Revenue line chart. For both charts, data for the top-ranked customer is shown. To display the second-ranked customer, you click the bar chart for the second-ranked customer. Both charts now display data for the second-ranked customer. Now you change the Overdue Analysis by from Customers to Sales Employees. The bar chart displays up to five top sales employees, depending on the data available. The Aging Versus Revenue line chart displays data for the second-ranked sales employee (the expectation is that data for the top-ranked sales employee is displayed). However, if there is only one “top” sales employee (one bar in the Top 5 Sales Employees (31-60 Days) bar chart), no data is displayed in the Aging Versus Revenue line chart because there is no data for the second-ranked sales employee. In this example, the line chart retains the ranking value (second-ranked) from the previously displayed line chart.

End of the example.

Example Example

The dashboard shows the Top 5 Customers (31-60 Days) bar chart and the Aging Versus Revenue line chart. For both charts, data for the top-ranked customer is shown. First you display the second-ranked customer by clicking the bar chart for the second-ranked customer. The line chart displays data for the second-ranked customer. Now you select a different aging interval by clicking the relevant time slice in the Aging Overview pie chart. For the new aging interval, the bar chart displays up to five top customers, depending on the data available. The Aging Versus Revenue line chart displays data for the top-ranked customer. Then you change the aging interval back to 31-60 Days. The dashboard shows the Top 5 Customers (31-60 Days) bar chart. The Aging Versus Revenue line chart displays data for the second-ranked customer (the expectation is that data for the top-ranked customer is displayed). See also the example above.

End of the example.

Customer Receivables Aging: Company Overview

In the Customer Receivables Aging dashboard, the Aging Overview chart provides the percentage of overdue customer receivables for specific time intervals. It controls the time interval for the other charts in the dashboard and lets you switch between the Overdue Analysis and Future Remit Analysis.

Type and Display	Behavior	KPI
Chart showing aging total and percentage distribution of customer receivables by time interval and future remittances	90+ Days is the default time interval for the other charts in the dashboard. (Overdue Analysis, Top 5 Customers <time period>,Top 5 Sales Employees <time period> and Aging Versus Revenue). To change the time interval, click one of the <n> Days segments in the chart.	The KPI is the percentage of the amount due for each time interval. Data comes from the Customer Receivables Aging report.

Overdue Analysis: Company Overview

This chart provides a historical analysis of customer receivables for the time interval you selected in the Aging Overview chart.

Type and Display	Behavior	KPI
Two-line chart showing the trend of a company’s overdue accounts receivables total and overdue accounts for the time interval selected in the Aging Overview chart. The Overdue Total line is always displayed.	Changing the time period in the X axis refreshes the Overdue Total and <n> Days lines. To change the time period displayed in the X axis, from the View by dropdown list select one of the following options: Last 6 Months: 6 months from current month (default) Last 12 Months: 12 months from current month The default time interval is 90+ Days. To change the time interval for the Overdue Total and <n> Days lines, in the Aging Overview chart click one of the <n> Days segments. To view the future remittances analysis, in the Aging Overview chart, click the Future Remit segment.	Amount for the current month is from the Customer Receivables Aging report with the Aging Date and Posting Date set to the current date. Amount for previous months is from the same report when the Aging Date is set to the ending date of the previous month.

Type and Display

Behavior

KPI

Two-line chart showing the trend of a company’s overdue accounts receivables total and overdue accounts for the time interval selected in the Aging Overview chart. The Overdue Total line is always displayed.

Changing the time period in the X axis refreshes the Overdue Total and <n> Days lines. To change the time period displayed in the X axis, from the View by dropdown list select one of the following options:

Last 6 Months: 6 months from current month (default)
Last 12 Months: 12 months from current month The default time interval is 90+ Days.

To change the time interval for the Overdue Total and <n> Days lines, in the Aging Overview chart click one of the <n> Days segments. To view the future remittances analysis, in the Aging Overview chart, click the Future Remit segment.

Amount for the current month is from the Customer Receivables Aging report with the Aging Date and Posting Date set to the current date. Amount for previous months is from the same report when the Aging Date is set to the ending date of the previous month.

Overdue Analysis: Customer and Employee Details

Overdue Analysis by Customers and Overdue Analysis by Sales Employees list the top five accounts and provide a historical analysis of aging receivables versus revenue.

From the dropdown list, you select Customers or Sales Employees.

Chart	Type and Display	Behavior	KPI
Top 5 Customers Top 5 Sales Employees	Bar chart with overdue receivables for each of the top five customers or sales employees for the selected time interval in the Aging Overview chart	To display the KPIs on the right side of the chart for a different customer or employee, click the bar for the desired customer or employee. To change the time interval, in the Aging Overview chart click one of the <n> Days segments. To view the future remittances analysis, in the Aging Overview chart, click the Future Remit segment.	The overdue amount for each customer or sales employee is from the Customer Receivables Aging report.
Aging Versus. Revenue	Two-line chart (Overdue Total ,<n> Days) overlaying the Revenue area	For information about the behavior in this chart, see Overdue Analysis: Company Overview.	Overdue Total is Balance Due minus Future Remit in the Customer Receivables Aging report. The selection criteria are: Currency: Local Aging Date: Current Date Age By: Due Date Revenue is derived from the selection criteria for the Sales Analysis report. The document should be Invoices. Posting Date is from the beginning of the selected horizon to the current date. Invoice-related documents and localization A/R documents that impact the revenue account, such as credit memo, A/R invoice exempt, A/R debit memo, A/R bill, A/R exempt bill, A/R export invoice, A/R correction invoice, A/R correction invoice reversal, and A/R reserve invoice, are also considered.

Chart

Type and Display

Behavior

KPI

Top 5 Customers

Top 5 Sales Employees

Bar chart with overdue receivables for each of the top five customers or sales employees for the selected time interval in the Aging Overview chart

To display the KPIs on the right side of the chart for a different customer or employee, click the bar for the desired customer or employee. To change the time interval, in the Aging Overview chart click one of the <n> Days segments. To view the future remittances analysis, in the Aging Overview chart, click the Future Remit segment.

The overdue amount for each customer or sales employee is from the Customer Receivables Aging report.

Aging Versus. Revenue

Two-line chart (Overdue Total ,<n> Days) overlaying the Revenue area

For information about the behavior in this chart, see Overdue Analysis: Company Overview.

Overdue Total is Balance Due minus Future Remit in the Customer Receivables Aging report. The selection criteria are:

Currency: Local
Aging Date: Current Date
Age By: Due Date

Revenue is derived from the selection criteria for the Sales Analysis report. The document should be Invoices. Posting Date is from the beginning of the selected horizon to the current date.

Invoice-related documents and localization A/R documents that impact the revenue account, such as credit memo, A/R invoice exempt, A/R debit memo, A/R bill, A/R exempt bill, A/R export invoice, A/R correction invoice, A/R correction invoice reversal, and A/R reserve invoice, are also considered.

Future Remit Analysis: Company Overview

Type and Display	Behavior	KPI
Bar chart showing future remittances for a selected time period	To change the time period displayed in the X axis, from the View by dropdown list, select one of the following options: Next 4 Weeks: 4 weeks from next week (default) Next 12 Weeks:12 weeks from next week Next 6 Months:6 months from next month The number of the week is taken from the SAP Business One 8.81 calendar. To view the overdue analysis, in the Aging Overview chart, click one of the <n> Days segments.	The future remittance amount for each time period comes from the Customer Receivable Aging report, where Aging Date is set to the end of each week or month.

Type and Display

Behavior

KPI

Bar chart showing future remittances for a selected time period

To change the time period displayed in the X axis, from the View by dropdown list, select one of the following options:

Next 4 Weeks: 4 weeks from next week (default)
Next 12 Weeks:12 weeks from next week
Next 6 Months:6 months from next month

The number of the week is taken from the SAP Business One 8.81 calendar.

To view the overdue analysis, in the Aging Overview chart, click one of the <n> Days segments.

The future remittance amount for each time period comes from the Customer Receivable Aging report, where Aging Date is set to the end of each week or month.

Future Remit Analysis: Customer and Employee Details

Chart	Type and Display	Behavior	KPI
Top 5 Customers (Future Remit) Top 5 Sales Employees (Future Remit)	Bar chart and future remittance amount for each of the top five customers or sales employees	To display the KPIs on the right side of the chart for a different customer or employee, click the bar for the desired customer or employee.	The future remittance amount for each time period comes from the Customer Receivables Aging report; Aging Date is set to the end of each week or month.
Future Remit Versus Sales Opportunities	Clustered bar chart comparing future remittances versus sales opportunities	For information about the behavior in this chart, see Future Remit Analysis: Company Overview.	The query for sales opportunities is based on the selection criteria for the Opportunities Forecast Over Time report.

Chart

Type and Display

Behavior

KPI

Top 5 Customers (Future Remit)

Top 5 Sales Employees (Future Remit)

Bar chart and future remittance amount for each of the top five customers or sales employees

To display the KPIs on the right side of the chart for a different customer or employee, click the bar for the desired customer or employee.

The future remittance amount for each time period comes from the Customer Receivables Aging report; Aging Date is set to the end of each week or month.

Future Remit Versus Sales Opportunities

Clustered bar chart comparing future remittances versus sales opportunities

For information about the behavior in this chart, see Future Remit Analysis: Company Overview.

The query for sales opportunities is based on the selection criteria for the Opportunities Forecast Over Time report.

More Information

Design, Behavior, and KPIs for SAP Predefined Dashboards