AR Operational Metrics calculated measures and KPIs

This table shows the AR Operational Metrics measures that are calculated and defined as saved expressions.

The saved expressions use the payment date and sum aggregation.

Measure Description
Avg Days – Due and Pmt The number of days between the due date and the final payment date divided by the number of invoices
Avg Days – Invc and Due The number of days between the invoice date and the due date divided by the number of invoices
Avg Days – Invc and Pmt The number of days between the invoice date and the final payment date divided by the number of invoices
Avg Days – Invc and Recon The number of days between the invoice date and the internal reconciliation date divided by the number of invoices
Receivable Index A way to rate a customer's payment history, computed as the weighted overdue amount divided by the weighted invoice amount by the due date