KPIs

This section describes the KPIs and the formulas used to calculate the KPIs displayed in the dashboard.

AR Invoice Amount

The total invoice amount based on the Invoice Date.

Overdue Amount Aging

The accounts receivable outstanding amount that is overdue. These accounts are further categorized into aging buckets based on the number of days open or overdue.

Overdue

The outstanding accounts receivable amount that is due after the defined aging period.

Estimated Uncollectable Amount

The portion of customer invoices that are unlikely to be collected, based on aging, risk patterns, or predefined rules.

The amount can be calculated using this formula: Estimated Uncollectable Amount = Outstanding Receivable * Uncollectable %

Estimated Uncollectable Ratio

A financial metric that calculates the percentage of accounts receivable that is not expected to be collected.

This KPI identifies the receivables that convert to debt because of customer default, insolvency, disputes, or nonpayment risk.

Open Amount Ratio

The total accounts receivable outstanding balance.

Balance

The total outstanding accounts receivable amount.