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.