Auditor: Detection Reports

Auditor: Detection Reports

Detection Report Requirements

If Auditor Advanced Edition is enabled, the tab Detection Reports is available. PROCESSIT version 7.1 R4 is the minimum required version for accessing detection reports.

Detection Reports

Detection Reports shows a list of reports belonging to the user currently logged in. You can create new reports, delete a report or view report data. Some reports include graphs to aid in interpreting results and provide additional reference data to assist you in identifying patterns which might require further investigation.

Available Detection Reports

• Duplicate Invoice Payment Detection
• Benford's Law
• Supplier Data Audit
• Rounded Invoice Amount Frequency
• Above Average Payment Per Supplier

Create Report

1. Select a report
2. Specify report criteria
3. Click Run Report
4. The report is created and shown first in the report list with status RUNNING
5. Click Refresh.
6. When the report is ready, it has status COMPLETED and View Report is available.

Report Management

1. View Report: Double-click a report line or click View Report.
2. Delete Report: Select a report line and click Delete Report.
3. Show Criteria: Select a report line and click Show Criteria. A dialog displays criteria used for the report.

Report Criteria

This table shows the required criteria for the reports and which parts of the report are affected by the criteria. An asterisk * means the criteria is required for the report, a pie chart means the criteria affects the graph, and a document chart means the criteria affects the report table data.

Report Criteria Table

Report	Organization	Supplier	Search Dates
Duplicate Invoice Payment Detection	*	*	*
Benford's Law	*	*
Supplier Data Audit	*	*	*
Rounded Invoice Amount Frequency	*	*
Above Average Payment per Supplier	*	*	*

Duplicate Invoice Payment Detection

The Duplicate Invoice Payment Detection report consists of 6 separate audits across all organizations during the search date period. The report is based solely on paid invoices.

1. Duplicate Supplier, Invoice Number, Invoice Amount
2. Duplicate Supplier, Invoice Date, Invoice Amount
3. Duplicate Supplier, Invoice Number, Different Invoice Amount
4. Duplicate Invoice Date, Invoice Number, Invoice Amount
5. Duplicate PO Number, Invoice Amount, Invoice Number, Different Supplier
6. Duplicate Invoice Amount, Supplier, Different Payment Date

Total Paid Invoices

The top 5 total paid invoices by supplier to this organization during the search date period. Includes selected supplier information if applicable. If the selected supplier is not within the top 5 but have paid invoices, it is displayed with the number of paid invoices. If a supplier have no paid invoices it is not displayed, and the top 5 suppliers are shown.

Benford’s Law

Benford’s Law defines the expected frequency that a number will appear in a given position. The report audits the frequency of first digit numbers in invoice amount paid against those expected by Benford’s Law to detect potential fraud patterns.

The main graph represents the top 5 suppliers to this organization by total invoices paid. This report includes selected supplier information if applicable. The graph is based solely on paid invoices and shows the paid invoices over time.

Benford’s Law Selected Supplier Site

Benford’s Law broken down for selected supplier by supplier site if applicable.

Total Paid Invoices

The top 5 total paid invoices by supplier to this organization. Includes selected supplier information if applicable.

Supplier Data Audit

This report examines duplicate supplier setup to detect and display similar name and address information associated with different supplier numbers. The report runs an employee address versus supplier address cross-check to ensure that employee address information is not the same nor similar to that of a supplier address.

The Supplier Data Audit report consists of two audits by organization.

• Duplicate Supplier: Similar name, address, city, state and zip code.
• Employee Supplier Cross Check: Similar name, address, city, state and zip

Top Supplier Total Invoices Received

The top 5 total invoices received by supplier to this organization during the search date period. Includes selected supplier information if applicable.

Rounded Invoice Amount Frequency

The Total Rounded Invoice Frequency report displays the numnber of invoices with rounded invoice amounts (i.e. invoice amounts with no additional decimals). The report displays the top 5 suppliers for all organizations with a minimum of 30 paid invoices and includes selected supplier information if applicable. The graph is based solely on paid invoices and shows the paid invoices over time.

Top Selected Supplier Site Rounded Frequencies

The top 5 selected supplier sites with rounded invoices to this organization with a minimum of 30 paid invoices.

Top Suppliers Invoice Date Equal Payment Date

The top 5 suppliers for all organizations with the total number of invoices with payment date equal to invoice date. This indentifies quick turn around trends.

Above Average Payment Per Supplier

The Above Average Payment reports audits invoices by selected supplier to this organization during the search date period. The average invoice amount is calculated for this supplier for the last year (365 days).

The report is solely based on paid invoices where the payment amount is larger than the average payment amount per supplier.

Average Invoice Amount Top Suppliers

This graph displays top 5 average invoice amounts of any supplier to this organization for the last year (365 days). Includes selected supplier information if applicable. If the selected supplier is not within the top 5 but have paid invoices, it is displayed with the number of paid invoices. If a supplier have no paid invoices it is not displayed, and the top 5 suppliers are shown.