Duplicate vendors in NetSuite: finding and merging them

Why duplicate vendors happen

Duplicate vendors usually start with a small shortcut. A clerk cannot find the supplier under the name on the invoice and creates a new vendor record. The original record may be under a different legal name, a former name, or a name with punctuation. Once two records exist, bills, credits and payments split between them, and the next clerk has even less reason to trust either record.

Re-keyed invoice numbers make the problem harder to see. A supplier sends INV-1043; one record holds INV-1043 and another holds 1043. In an export from NetSuite, the supplier invoice number sits in the Reference No. field, so the two bills do not sort next to each other. The same supplier can also be set up twice during an import or a rushed onboarding, with one record for the parent company and one for a trading name. Statements paid as well as invoices and re-sent payment runs add chances for the same liability to be recorded or paid twice.

Duplicate vendors are not just a housekeeping issue. When the same supplier exists twice, matching on vendor, amount and date window only catches duplicates inside one record. A payment can post to one record while the bill remains open on the other. A vendor credit can sit unapplied because it was entered against the wrong record. The supplier statement may show an open invoice that your ledger shows as paid, or a credit you never took. Those are recoverable amounts only if AP looks across records, not within one vendor history.

Finding them

Start with the Duplicate Detection & Merge feature in NetSuite. It is enabled under Data Management and finds duplicate customers, vendors, partners and contacts. Use the results as a first pass, then check the vendor list by hand. Duplicate detection depends on existing names and details, so it will not catch every trading name, misspelling or punctuation difference.

Export the vendor list and a list of vendor bills. In NetSuite, the supplier invoice number appears in the Reference No. field in the export. Normalize the invoice numbers before matching: compare INV-1043 with 1043, and check for spaces, dashes and leading zeros. Then match across vendor records on supplier name, amount and a date window. Look for the same invoice number on two vendor records, the same bill entered once on each record, and payments that repeat after a payment run was re-sent. A simple sort on Reference No. will not find INV-1043 against 1043, so compare both the cleaned number and the raw value.

Use supplier statements as a second net. Reconcile the statement line by line against bills, credits and payments in NetSuite. If the statement shows an invoice that your ledger shows as paid, check whether the payment went to a different vendor record. If the statement shows a credit that is not applied in your ledger, check whether it was entered on a duplicate vendor. Ask the supplier for a statement that lists credits as well as open invoices, and ask for the credit back when a duplicate payment or unapplied credit is confirmed. The supplier can usually see both records even when your AP team cannot.

Merging vendors in NetSuite

Before any merge, confirm that the two records are the same supplier and not two legal entities. In NetSuite, a vendor is merged into another from the record's Actions menu. The merge cannot be undone, both vendors must share the same primary subsidiary, and tax agency vendors cannot be merged. If the records sit under different primary subsidiaries, stop and resolve the record structure before you touch the merge. Export the vendor records and the open bills, credits and payments first, and note which record will be the surviving vendor.

Choose the record that should remain, then use the Actions menu on the record that will be merged into it. Do not merge on a name match alone. Check the tax ID, remit-to address, banking details and the open items on each record. If one record holds a vendor credit and the other holds the bill it should apply to, confirm how the credit will be handled before the merge. If a tax agency vendor is involved, the merge is not available; keep the records separate and fix the transaction posting instead.

After the merge, review the surviving vendor record for open bills, credits and payments. Re-run the duplicate check on invoice numbers, especially where INV-1043 and 1043 were both in use. Check that no bill was left open on the merged record and that no payment is now unmatched. The review has to happen immediately. Keep the pre-merge export with the vendor file so the next person can see what was combined and why.

Keeping the vendor list clean

Make new vendor creation a controlled step. Before a clerk adds a supplier, require a search by legal name, trading name, tax ID and bank details. Require a second review for any vendor that will receive payment. Use one naming convention for the vendor master and record the supplier's invoice naming pattern, including whether it uses a prefix such as INV-. When a supplier sends INV-1043, search both INV-1043 and 1043 before creating anything. This check prevents many duplicate records and duplicate bills.

Set the Duplicate Number Warnings accounting preference in NetSuite at Setup > Accounting > Preferences > Accounting Preferences. The preference can be No Warnings, Warn (UI only) or Warn and Block. Warn and Block covers vendor bills and vendor credits, among other transactions, and compares a number with other records of the same type. It will not catch every variation, because INV-1043 and 1043 are different strings, so keep the export review in place. In NetSuite, the supplier invoice number sits in the Reference No. field in the export; use that field for a periodic match across vendor records on number, amount and date window.

Reconcile supplier statements on a regular cadence and ask for credits back when a duplicate payment or unapplied credit is confirmed. Review re-sent payment runs before they go out again. When a duplicate vendor is found, merge only after the pre-merge checks, then update the vendor master notes with the old names and invoice patterns so the next clerk finds the surviving record. A clean vendor list depends on search-before-create, duplicate number warnings and statement reconciliation.

Questions