AR Invoices calculated measures and KPIs
This table shows the AR Invoices measures that are calculated and defined as saved expressions. The saved expressions use the Accounting Date and Sum aggregation.
Operational Metrics
| Measure | Description |
|---|---|
| Invc and Pmt Var | The number of invoice variance between invoice and payment transactions |
| Receivables 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 |
| Invc Avg Days – Invc and Due Pmt | The number of days between the invoice date and the due date divided by the number of invoices |
| Invc Avg Days – Invc and Pmt | The number of days between the invoice date and the final payment date divided by the number of invoices |
| Invc Avg Days – Invc and Recon | The number of days between the invoice date and the internal reconciliation date divided by the number of invoices |
| Invc Avg Days – Due and Pmt | The number of days between the due date and the final payment date divided by the number of invoices |
Credit Management
| Measure | Description |
|---|---|
| No. of Fully Paid Invcs | Number of invoices that have been paid in full for the period |
| Pmt Avg Days – Invc and Pmt | The number of days between the invoice date and payment date divided by the number of payments |
| Daily Avg Pmt – Invc and Pmt | The amount paid by day between the invoice and payment dates in the division currency divided by the number of days between the invoice and payment dates |
| Overdue Avg Days – Due and Pmt | The number of days between due date and payment date divided by the number of payments after the due date |
| Overdue Avg Days – Adj Due and Pmt | The number of days between the adjusted due date and payment date divided by the number of payments after the adjusted due date |
| Overdue Avg Days – Follow-up and Pmt | The number of days between follow-up date and payment date divided by the number of payments after the follow-up date |
| Overdue Avg Days – Adj Follow-up and Pmt | The number of days between the adjusted follow-up date and payment date divided by the number of payments after the adjusted follow-up date |
| Overdue Avg Pmt Due Date | The amount paid past the due date in the division currency divided by the number of payments after the due date |
| Overdue Avg Pmt Adj Due Date | The amount paid past the adjusted due date in the division currency divided by the number of payments after the adjusted due date |
| Overdue Avg Pmt Follow-up | The amount paid past the follow-up date in the division currency divided by the number of payments after the follow-up date |
| Overdue Avg Pmt Adj Follow-up | The amount paid past the adjusted follow-up date in the division currency divided by the number of payments after the adjusted follow-up date |
| Overdue Daily Avg Pmt – Due Date | The amount paid by day past due date in the division currency divided by the number of days between due date and payment date |
| Overdue Daily Avg Pmt – Adj Due Date | The amount paid by day past the adjusted due date in the division currency divided by the number of days between the adjusted due date and payment dateThe amount paid by day past due date in the division currency divided by the number of days between due date and payment date |
| Overdue Daily Avg Pmt – Follow-up Date | The amount paid by day past the follow-up date in the division currency divided by the number of days between follow-up date and payment date |
| Overdue Daily Avg Pmt – Adj Follow-up Date | The amount paid by day past the adjusted follow-up date in the division currency divided by the number of days between the adjusted follow-up date and payment date |
Invoice Accuracy
| Measure | Description |
|---|---|
| Manual and Normal Invcs Var | The difference between the number of manual invoices and the number of normal invoices |
| Manual Amt Pct | The amount of manual invoices divided by the invoice amount |
| Manual Invc Pct | The number of manual invoices divided by the number of invoices |
| Norm Order vs Tot Order Amt Pct | The amount of normal order invoices divided by the amount of order invoices |
| Norm Order vs Tot Order Invc Pct | The number of normal order invoices divided by the number of total order invoices |
| Total Var vs Tot Order Amt Pct | The total variance amount divided by the amount of order invoices |
| Corrected Invc Pct | The number of corrected invoices divided by the number of invoices |
| Corrected Invc Amt Pct | The amount of corrected invoices divided by the invoice amount |
| Corrective Invc Pct | The number of corrective invoices divided by the number of invoices |
| Corrective Invc Amt Pct | The amount of corrective invoices divided by the invoice amount |
| Write-Off vs Tot Order Amt Pct | The amount of write-off invoices divided by the amount of order invoices |
| Write-Off vs Tot Order Invc Pct | The number of write-off invoices divided by the number of order invoices |
| Billback vs Tot Order Amt Pct | The amount of billback invoices divided by the amount of order invoices |
| Billback vs Tot Order Invc Pct | The number of billback invoices divided by the number of order invoices |
| Debit Note vs Tot Order Amt Pct | The amount of debit note invoices divided by the amount of order invoices |
| Debit Note vs Tot Order Invc Pct | The number of debit note invoices divided by the number of order invoices |
| Invcs w/ Var Pct | The number of invoices with variances divided by the number of invoices |
| Invcs w/o Var Pct | The number of invoices without variances divided by the number of invoices |
| Invcs w/ Ded Pct | The number of invoices with deductions divided by the number of invoices |
| Invcs w/o Ded Pct | The number of invoices without deductions divided by the number of invoices |
| Pmts w/ Ded Pct | The number of payments with deductions divided by the number of payments |
| Pmts w/o Ded Pct | The number of payments without deductions divided by the number of payments |