Accounts Receivable Aging Overview
The Accounts Receivable Aging Overview dashboard has KPIs and charts that show totals for records with these characteristics:
- Main documents
- Not segment-based
KPIs
- Amount
Total invoice amount.
- Balance
Total invoice balance.
- Open Amount Ratio.
Percentage Balance/Amount.
- Overdue Amount
Balance for main documents that are overdue.
Note that this is calculated during processing of the Finance space, and not at report rendering.
- Overdue Amount Ratio
Percentage Overdue Amount / Balance.
- Estimated Uncollectable Amount
The non-payment probability increases with age, the uncollectable amount is estimated by assigning percentages to each age bucket and summing the estimated unpaid amounts for each age bucket.
The default buckets with estimate percentages are: Not yet due (1%), 1-30 days (5%), 31-60 days (10%), 61-90 days (25%), 91-99999 days (50%).
Buckets and estimate percentages can be changed in user variables.
- Estimated Uncollectable Ratio
Estimated Uncollectable Amount / Balance.
Reports
- Active Currencies
- Aged Debt by Country
Stacked column chart by Country.
Stacks for Balance Not Yet Due, Overdue 1-30 Days, Overdue 31-60 Days, Overdue 61-90 Days, Overdue 91-99999 Days.
You can drill through to debt by State/Province, City, and individual Invoice-to Business Partners.
- Aged Debt by Customer Group
Stacked column chart by Financial Customer Group.
Stacks for Balance Not Yet Due, Overdue 1-30 Days, Overdue 31-60 Days, Overdue 61-90 Days, Overdue 91-99999 Days.
You can drill through to debt by individual Invoice-to Business Partners.
- Aged Debt by Company
Stacked column chart by Financial Customer Group.
Stacks for Balance Not Yet Due, Overdue 1-30 Days, Overdue 31-60 Days, Overdue 61-90 Days, Overdue 91-99999 Days.
- Aged Debt by Credit Analyst
Stacked column chart by Credit Analyst.
Stacks for Balance Not Yet Due, Overdue 1-30 Days, Overdue 31-60 Days, Overdue 61-90 Days, Overdue 91-99999 Days.
You can drill through to debt by individual Invoice-to Business Partners.