WoluTools
Find a tool

Finance & Accounting

Find duplicate supplier invoices in an AP export

Upload your accounts payable export as CSV. Likely duplicate invoices are grouped using an amount tolerance you choose, and gaps in invoice numbers are listed.

or drop it here

CSV · Up to 100,000 ledger rows
Free account needed for your 3 free jobs a day

No file at hand? See the prepared example

Standard toolIncluded · 3 free jobs a dayFree: 3 jobs a dayPro: up to 200 jobs a day · €12.99/month or €89.99/year
  • CSV
  • Up to 100,000 ledger rows
Prepared result preview · fictional sample dataFictional AP Duplicate & Sequence Worklist fixture
Source
1 prepared source file · 97 bytes
Prioritized findings
  • Rows: 3
  • Duplicate groups: 1
  • Sequence findings: 0

result.csv · findings.csv · review-decisions.csv · manifest.json

BringCSV
GetAP evidence CSV, review-decision CSV, findings and manifest
PrivacyEncrypted source · 24-hour result

One clear job, from source to download

  1. 1

    Add the source

    Supported formats and limits are visible before the upload.

  2. 2

    Confirm the settings

    Review the exact source, options, units and access before processing.

  3. 3

    Inspect and download

    Check the preview and warnings, then unlock the complete package.

A duplicate invoice worklist from your AP export

What you upload

You upload your accounts payable export as a CSV with up to 100,000 ledger rows. The tool groups rows by supplier and invoice number and compares the amounts within the tolerance you pick. Where invoice numbers are numeric, it also lists gaps in each supplier's sequence. A gap can mean an invoice never arrived or was posted somewhere else.

The files you get

The download holds result.csv, findings.csv, review-decisions.csv and manifest.json. Each finding shows every factor behind the match, so you can see why rows were grouped. review-decisions.csv adds a decision column to each finding. A reviewer can mark keep, block or query and hand the sheet back with the evidence attached. The manifest records a fingerprint of your source file for later checks.

Tolerance, and why findings say review

You choose the amount tolerance: exact only, 0.01 or 1.00. You also decide whether invoice sequences are checked. A wider tolerance finds more candidates, and more of them turn out to be different invoices. Every finding is worded as a review item. The tool never calls an invoice fraudulent. What a duplicate group means is a judgment for your finance team, and it does not replace an accountant or auditor where one is required.

Questions before you run it

How does it decide that two invoices are duplicates?

Rows are grouped by supplier and invoice number, with amounts compared under the tolerance you choose: exact only, 0.01 or 1.00. Every factor behind a match is shown on the finding row.

What is the sequence gap check looking for?

Where invoice numbers are numeric, it lists the missing values in a supplier sequence so you can ask whether an invoice was never received or was posted somewhere else.

Does the tool say an invoice is fraudulent?

No. Findings are worded as review items and carry the matching evidence. What a duplicate group means is a judgment for your finance team.

What is review-decisions.csv for?

It gives each finding a decision column, so a reviewer can record keep, block or query and hand the sheet back with the evidence attached.

How large can the AP export be?

Up to 100,000 ledger rows in a single CSV job.