Icon

Duplicate Invoice Detection

Duplicate Invoice Detection - Accounts Payable / Audit

This workflow helps to score invoices which may be duplicates based on the same amount but differing invoice numbers. The scoring helps the business focus on the highest likelihood duplicate pairs to minimize time spent on reviewing false positives (i.e. not real duplicates). It also helps focus on the highest value invoices which may have been double-paid.

Using a set of core business rules, several sets of potential duplicates are first found. In order to optimize time spent on investigating true duplicates, the list is scored/sorted so the most likely pairs are addressed first. This presents one example of a sorting application.

This use case was presented at the KNIME Spring Data Talks 2021 by Day5 Analytics Inc.

URL: KNIME Spring Data Talks 2021 https://www.knime.com/data-talks-spring-21-presentations
URL: Day5 Analytics Inc. https://www.day5analytics.com/
URL: Slide Deck (PDF Download) https://www.knime.com/sites/default/files/2021-03/finance-automation-knime-server.pdf

Duplicate Invoice Detection

This simple workflow demonstrates a method to flexibly assess invoices based on how likely they are to be duplicates. It presents a ranked output based on the invoices' overall risk assessment.
This is one of several solutions for scoring duplicate pairs for review. When deploying the workflow as a Data App, duplicate pairs can be quickly reviewed in a web-based browser and this workflow can be integrated into enterprise tools. Workflows can be scheduled to ensure ongoing monitoring, with intelligence passed on to recovery departments.

For more information see the workflow metadata (View -> Description)

Data Access

Data Preprocessing

Fuzzy Matching

To identify pairs of invoice numbers

Output: Send report to PDF

Creates visualized table representation of the output data and saves as PDF report

Rank Duplicates, based on

  • invoice number

  • invoice amounts

Loop through potential duplicate pairs and calculate distances
Identify Duplicates by calculating invoice number similarity
A4 Page
Report Template Creator
Set table colors
Color Manager
Display and Heatmap Ranked Potential DuplicatesEach potential match is scored
View Ranked Duplicates
Rank Invoice Amounts
Rule Engine
output a PDF report
Report PDF Writer
Cleanup for reporting
Month 1 invoices
Excel Reader
Sample Data for Scoringmatch_id identifies pairs ofpotential duplicate invoicesidentified using business rules
Consolidate Data for Duplicate Check
Rank Potential Duplicates
Rule Engine
Month 2 Invoices
Excel Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: conno
Created at: 2021-06-16
On NodePit since: 2024-09-05
Last update: 2026-11-10
Created with KNIME version: v5.3.0
Tags: auditaccounts payableduplicateinvoicepaymentfinanceriskday5 analytics

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!