A vendor invoice management system depends on one record per supplier

Updated

Everything a vendor invoice management system can tell you is organised around the supplier, which makes supplier records the foundation and the usual weak point. Duplicate records, wrong legal entities and stale bank details undermine matching, duplicate detection, statement reconciliation and fraud defence simultaneously, and they are created quietly during ordinary work.

How duplicates get created

An invoice arrives under a trading name rather than the legal entity, nobody recognises it, and a new record is created so the invoice can be processed. It happens under time pressure and it looks harmless. Afterwards, payment history is split across two records, duplicate detection cannot see across them, and statements will never reconcile.

How to prevent them

Match new invoices on tax reference and bank details rather than on name, and route anything unrecognised to a person rather than creating a record automatically. Make supplier creation a controlled action by a named small group, and review new and amended records periodically from outside the payables process.

What a clean supplier record enables

Total outstanding for that vendor at a glance, statement reconciliation that actually reconciles, duplicate detection that works across their whole history, and a bank detail change log that makes diverted-payment fraud visible. All four collapse the moment the same supplier exists twice.

Questions people ask about vendor invoice management system

How do we clean up existing duplicates?

Merge carefully, keeping the full history, and start with your highest-volume suppliers where the benefit is greatest. It is tedious and it repays.

Who should create supplier records?

A small named group, separate from whoever releases payments, with changes reviewed periodically from outside the process.

What should be matched on?

Tax reference and bank details primarily. Names vary between trading and legal forms and are the least reliable identifier.

Sources

Related answers

Start Threewayly ProKeep the match, not the spreadsheet