Duplicate and inactive vendor cleanup
We find duplicates by tax ID, bank details, address and name variants, and list vendors with no payments in a set period. You approve each merge or inactivation, and we document it.
Most vendor masters hold duplicates, suppliers nobody has paid in years and one-time suppliers set up for a single order. LeVasseur Consultants cleans up the vendor master, cuts the supplier list down to the suppliers you need and sets the rules that keep it clean.
Duplicate vendor records make duplicate payments more likely, because most systems only catch a repeated invoice number within the same vendor record. The Washington State Auditor’s Office recommends reviewing the vendor master at least once a year, removing duplicates and inactivating vendors that are no longer used.
Old records are also a route for fraud. A Tennessee Valley Authority inspector general audit of one vendor master found duplicate vendors, vendors not deactivated on time and vendor addresses that matched employee addresses. Business email compromise, where a fraudster poses as a supplier or executive to redirect a payment, accounted for $2.77 billion in reported losses in 2024, according to the FBI’s Internet Crime Report.
We find duplicates by tax ID, bank details, address and name variants, and list vendors with no payments in a set period. You approve each merge or inactivation, and we document it.
One checklist for adding a supplier: who can request it, which documents are required, how bank details are confirmed and who approves. The person who adds suppliers is not the person who pays them.
Required fields, naming rules, who may change bank details, how every change is confirmed with the supplier through contact details already on file, and a yearly review date with a named owner.
We group suppliers by what you buy from them and move repeat categories to fewer suppliers, so you buy more from suppliers you already know.
A supplier you will pay once does not need a vendor record. One-off purchases go through a buyer of record with pass-through purchasing, so the vendor master stays clean after the cleanup.
Organizations moving to a new accounting or purchasing system that do not want to carry old records across.
Vendor lists built request by request, with no one owning the list as a whole.
Teams that found a duplicate payment or a bank-detail change request they could not verify.
We review an export of your vendor master and 12 to 24 months of payments. You get the duplicates, inactive suppliers and one-time suppliers, with a recommendation for each.
We run the cleanup with your team and write the onboarding, change and inactivation rules that keep the list clean.
We handle new-supplier requests against the rules, run the yearly review and route one-time purchases through a buyer of record.
Each engagement is quoted per project.
Reducing your supplier list to the suppliers you need: merging duplicates, inactivating suppliers you no longer use and moving repeat purchases to fewer suppliers. It cuts the number of vendor records, invoices and payments your team handles.
At least once a year, which is what the Washington State Auditor's Office recommends, and before any move to a new accounting or purchasing system. Between reviews, onboarding and change rules stop the list from growing back.
No. We inactivate rather than delete. Inactive records keep their payment history; they can no longer receive new orders or payments.
Give requesters another route. One-off purchases go through a buyer of record, who buys in its own name and invoices you, so the supplier never needs a vendor record.
Not to start. An export of the vendor master and 12 to 24 months of payments is enough for the review. Changes in your system are made by your team or with access you grant.
Send us a note on roughly how many active suppliers you have and when the list was last cleaned. We will tell you what a review would cover.