Accounts Payable Operational Metrics reports
The measures used in Accounts Payable Operational Metrics reports are sourced from the AP Operational Metrics fact. These measures are analyzed by Int Recon Date and use the Sum aggregation.
Efficiency Index Trend Analysis
Description: This report shows the efficiency index trend and how it is affected by the increase or decrease in average number of invoices, and average invoice amount over time.
Measure: Efficiency Index, Avg No. of Invoices, Avg Invoice Amt. The tooltip also shows No. of AP Employees and Invoice Amt – Third Currency.
Chart type: 3 data series combo, 1 single column chart on Y axis 1, 1 spline chart on Y axis 2, and 1 spline chart on Y axis 3
Processing Time by Period
Description: The charts show the processing time trend over time against a user-defined target for average days between invoice date and reconciliation date.
Measure: Avg Days – Invc and Due, Avg Days – Invc and Recon, Target – Invc and Recon
Chart type: 3 data series combo, 2 grouped column chart and 1 line chart
Top Efficiency Index
Description: This report shows the bottom performing AP Authorizers/AP Users, measured by the Efficiency Index. These AP Authorizers/AP Users have the highest average days difference between invoice date and reconciliation date compared to the days difference between the invoice date and due date.
Measure: Efficiency Index
Chart type: 1 data series bar chart
Column selector: AP Authorizer, AP User
Bottom Efficiency Index
Description: This report shows the top performing AP Authorizers/AP Users, measured by the Efficiency Index. These AP Authorizers/AP Users have the lowest average days difference between invoice date and reconciliation date compared to the days difference between the invoice date and due date.
Measure: Efficiency Index
Chart type: 1 data series bar chart
Column selector: AP Authorizer, AP User
Processing Time by Category
Description: This report shows the average processing time per AP User. It has an option to change the category from AP User to AP Authorizer.
Measure: Avg Days – Invc and Due, Avg Days – Invc and Recon, Avg Invoice Amt, Efficiency Index
Chart type: Table
Column selector: AP User, AP Authorizer
Number of Invoices per FAM Entry - AP
Description: This report show the FAM entries and the number of invoices per period.
Measure: No. of Invoices
Chart type: Cross table