AR Operational Metrics
The Accounts Receivable Operational Metrics model is designed to provide insights into the performance of a company’s invoicing process. By providing key measurements to tracking and monitoring, the model can assist you in improving operational efficiency. The model shows counts and values of transactions, elapsed time and dates, and trends over time.
The model supports analysis of:
- Due date vs payment date
- Due date changes
- Average credit time – weighted by invoice value
- Usage of payment method to ensure efficient transaction
M3 Analytics provides a Receivable Index to rate customer payment history. The facts in this model can be analyzed by these dates: follow-up date, invoice date, payment date, due date, and internal reconciliation date.
Source information
The main source for the Accounts Receivable Operational Metrics model is the M3 BE table FSLEDG. The table is filtered by internal reconciliation code 9 to retrieve only fully paid invoices. The transactions are captured in the invoice currency. The term division currency is used in M3 Analytics. Some additional data is retrieved from the M3 BE table FGLEDG, such as invoice and payment amounts in local currency, accounting information, FAM entry ID, and FAM function. The model supports analysis at invoice level.
The number of customer invoices with changes to the due date is captured by updates of the follow-up field.