AP Operational Metrics
The Accounts Payable Operational Metrics model is designed to provide insights into the performance of a company’s accounts payable process. By providing key measurements to tracking and monitoring, the model can assist you in improving operational efficiency. The model shows counts of transactions, elapsed time and dates, and trends over time. It also provides an index to monitor the efficiency of the accounts payable process.
The model supports analysis of:
- Processing time
- Late payments
- Number of invoices vs number of payments
- Average number of invoice per employee
- Payment methods to ensure efficient transaction
M3 Analytics provides a configurable target value for the average days between invoicing and reconciliation. The facts in this model can be analyzed by these dates:
- Int Recon Date
- Invoice Date
- Due Date
- Int Accounting Date
Source information
The main source for the Accounts Payable Operational Metrics model is the M3 BE table FPLEDG. The table is filtered by internal reconciliation code 9 to retrieve only fully paid invoices. The transactions are captured in the invoice currency. Some additional data is retrieved from the M3 BE table FGLEDG, such as invoice and payment amount in local and third currencies, and other general ledger information.
The model is composed of two grains, one at transaction (FPLEDG) level and the other is aggregated up to the supplier invoice level. Analysis is made available only on the aggregated table.