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