Order to Cash
Analytics Tests
Order management, credit, fulfillment and invoicing need to be optimized for organizations to realize revenues as efficiently as possible.
Identifying open items and clients with high adjustment rates can be readily detected with an effective data analysis application
Collection
AR Open Item and Sales Price Review - Test 1
Test 1 entails the profiling of unpaid invoice data by invoice date. Aging process by invoice date, and report number of invoices outstanding, and totals, under the following categories:
< 0 days
0 – 30 days
31 – 60 days
61 – 90 days
91 – 120 days
121 – 180 days
>180 days
AR Open Item and Sales Price Review - Test 2
Test 2 entails the profiling of unpaid invoice data by due date. Aging process by due date, and report number of invoices outstanding, and totals, under the following categories:
< 0 days
0 – 30 days
31 – 60 days
61 – 90 days
91 – 120 days
121 – 180 days
>180 days
AR Open Item and Sales Price Review - Test 3
Test 3 entails the examination of sale price data to identify possible unauthorized customer discounts. Profile sales data and identify unit price variances by product code. Segregate transactions where standard deviation exceeds 0 and profile the results by client and product. The test generates two outputs: first table provides detailed transactions tagged with price variances; second table provides a summary of items found with variances by product.
AR Client Master Review
The objective of this analytic is to examine the customer credit master details to identify possible weaknesses in the credit review process and its respective controls. This test entails an examination of AR client master data to identify potential credit vulnerability – credit limits, credit review date. Profile AR client master data by credit limits and credit review dates.
AR Duplicate Clients Review
The objective of this analytic is to identify instances where a customer might be established in the AR system under various business identities. Entails the examination of AR client data to identify credit vulnerability – identify same businesses under different names. Duplicate process under various scenarios – address detail and name. Three tables are generated to present the results of the analysis.
AR Billing Review
The objective of this analytic is to monitor the AR transactions, specifically billing and adjustment type transactions, per customer, to identify clients with a high adjustment ratio. This information can help uncover the manipulation of client records, and ultimately assets such as inventory.
This analytic is designed to examine the AR transactions file (billing and adjustments) with the objective of profiling clients who appear to have a high number of adjustments, write-offs when compared to their charges.
Cancellations
SM Sale Order and Purchase Order Review
The objective of this analytic is to determine if it is apparent from the cancelled sales orders versus cancelled purchase orders that inventories might be accumulating. Entails the examination of cancelled sales orders to cancelled purchase orders with the objective of identifying conditions where inventory levels (materials) continue to accumulate. Profile by month of SO cancellations to PO cancellations.
Adjustments
AR Billing Review
The objective of this analytic is to monitor the AR transactions, specifically billing and adjustment type transactions, per customer, to identify clients with a high adjustment ratio. This information can help uncover the manipulation of client records, and ultimately assets such as inventory. This analytic is designed to examine the AR transactions file (billing and adjustments) with the objective of profiling clients who appear to have a high number of adjustments, write-offs when compared to their charges.
Analytics By Business Process
Learn more about various analytics tests to meet business needs.
Analytics By Business Process
Request Trial