Sage Intacct · Duplicate vendors

Duplicate vendors in Sage Intacct: finding and merging them

Duplicate vendors are two or more records for the same supplier. Sage Intacct does not merge them: you resolve the duplicate's transactions, deactivate it and keep one active record.

What Sage Intacct's documentation says

  1. Sage Intacct does not merge duplicate vendor records: its help says to deactivate one and keep the other active, and for 1099 vendors the payments made to the duplicate are added to the record you keep. Source 1 (opens in a new tab)
  2. Sage Intacct's advice is to resolve all transactions on the duplicate vendor, deactivate it and use only the remaining vendor; an inactive vendor cannot be used in new transactions. A vendor can be deleted only if it has no payments or transactions. Source 2 (opens in a new tab)
  3. Accounts Payable configuration has a setting for bills, checks or adjustments assigned duplicate numbers, with the choices Show warning, Do not allow transactions to be created, or Do nothing. Bills and adjustments are checked per vendor. Source 3 (opens in a new tab)

Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.

Why duplicate vendors happen

Most duplicate vendor records start with a small difference in the name or the remittance details. One clerk adds Acme Industrial Ltd, another adds Acme Industrial, and both records collect bills. The same supplier set up twice is the common pattern. It also happens when a supplier changes banks and AP creates a new record instead of changing the existing one, or when a search in Sage Intacct comes back empty on a busy day and the clerk adds a new vendor.

Duplicate payments do not need duplicate vendors. A bill keyed as INV-1043 and another keyed as 1043 can both pass through when the invoice number format differs. A statement that lists invoices already paid can be entered as a new bill if nobody reconciles it to open items. A payment run that is re-sent after a bank file issue can pay the same bills twice. A credit memo posted to the wrong vendor record sits unapplied, and the next statement looks unpaid.

These errors cost money in different ways. You pay twice, or you pay a statement total that includes invoices already settled. You also lose a credit when it sits on the wrong record. The vendor list becomes harder to trust, and the next clerk repeats the mistake because two similar names now exist. Fixing the record early is cheaper than cleaning up payments later.

Finding them

Start with a vendor export from Sage Intacct. Sort by name and look for near matches: punctuation differences, missing words, trading names, and names that differ by a branch or a holding company. Compare addresses, contact details and remittance data, because two records for the same supplier often share a bank account or an email domain. A raw list sorted by name will show most pairs without special tooling.

Then look at bills. When you export bills from Sage Intacct, the supplier invoice number appears as Bill number. Sort by Bill number and compare values after you strip spaces, hyphens and leading zeros. INV-1043 and 1043 should sit close together. Check the vendor on each row. If the same invoice sits under two vendor records, you have a duplicate vendor issue on top of a duplicate bill issue. Bills and adjustments are checked per vendor in Sage Intacct, so the duplicate number setting will not catch that pair when the vendor records are different.

Payments give you another trail. Match payments on vendor, amount and a date window. Two payments to similar vendor names in the same week for the same amount are worth a look. So are payments to the same remittance details under two vendor records. Pull the payment history for each suspect vendor and compare it to the bills. If a payment has no bill behind it, or a bill has two payments, you have found the problem.

Statements close the loop. Reconcile each supplier statement to open bills in Sage Intacct, not just to the vendor total. A statement that shows an invoice you already paid is a signal that the invoice was keyed twice or paid under another vendor record. Ask the supplier for a statement that lists invoice numbers and credits. Then check each line. That is also how you find credits that were never applied.

Merging vendors in Sage Intacct

Sage Intacct does not merge duplicate vendor records. Its help says to deactivate one and keep the other active. For 1099 vendors, the payments made to the duplicate are added to the record you keep. That makes the choice of survivor important. Pick the record you want for future bills, and for 1099 vendors, make sure the kept record is the one that should carry the payments.

Sage Intacct's advice is to resolve all transactions on the duplicate vendor, deactivate it and use only the remaining vendor. An inactive vendor cannot be used in new transactions. A vendor can be deleted only if it has no payments or transactions. So the work is not a single merge step. You clear the duplicate first. Open bills and unapplied credits, plus any adjustments, need a decision before the record goes inactive. For anything the help does not cover, such as what happens to a bill after a void, check Sage Intacct's own help or ask your administrator rather than guessing.

A practical order helps. Decide which record survives. Tell the AP team to stop adding bills to the duplicate, then resolve every open transaction on it. Deactivate the duplicate once it is clear. Keep a note of what was resolved, who approved it and where the support is filed. That note matters when someone asks why a vendor is inactive or why a 1099 total changed. Do not delete a vendor just to tidy the list. Deactivating is the normal end state for a duplicate with history.

Keeping the vendor list clean

Prevention starts at onboarding. Before anyone adds a vendor in Sage Intacct, search by name, by remittance details and by the supplier's own invoice format. Require a second look for names that are close to an existing record. Set a naming standard and stick to it. Decide whether legal suffixes, punctuation and branch names belong in the vendor name. The point is to make the same supplier land on the same record every time.

Use the duplicate number setting in Accounts Payable configuration. It covers bills, checks or adjustments assigned duplicate numbers. The choices are Show warning, Do not allow transactions to be created, or Do nothing. Bills and adjustments are checked per vendor. Show warning is a reasonable minimum because it slows the clerk down without blocking a legitimate correction. Do not allow transactions to be created is stronger, but it will not catch the same supplier invoice entered under two different vendor records. That is a vendor cleanup problem, not a bill number problem.

Put the vendor review on a schedule. Export vendors and bills, sort by name and Bill number, and look for new near matches. Reconcile the largest suppliers' statements on a regular cycle. Ask suppliers for credits or refunds when you find an overpayment. A supplier will often apply a credit to the next invoice if you ask, but you have to catch it first. The same goes for a statement paid as well as the invoices: ask for a refund or a credit, and record the answer.

Feed the finding back to the AP team. When a duplicate is found, tell the clerk who entered it what went wrong: a re-keyed invoice number or a statement entered as a bill. Sometimes it is a new record for a supplier that already existed. If the duplicate number setting is set to Do nothing, change it to Show warning or Do not allow transactions to be created. If the team does not know that bills and adjustments are checked per vendor, they will assume the setting covers more than it does.

To review paid bills outside Sage Intacct, export them: Export paid bills from Sage Intacct. The supplier's invoice number is in the Bill number column.

Questions

Can you merge duplicate vendors in Sage Intacct?

No. Sage Intacct does not merge duplicate vendor records. Its help says to deactivate one and keep the other active, and for 1099 vendors the payments made to the duplicate are added to the record you keep.

How do I find duplicate vendors in Sage Intacct?

Export vendor records and compare names, addresses, contact details and remittance data. Export bills too: the supplier invoice number appears as Bill number, so you can spot pairs like INV-1043 and 1043 under different vendor records. Then match payments on vendor, amount and a date window.

What does the duplicate bill number setting do in Sage Intacct?

In Accounts Payable configuration, the setting covers bills, checks or adjustments assigned duplicate numbers. The choices are Show warning, Do not allow transactions to be created, or Do nothing. Bills and adjustments are checked per vendor, so it will not catch the same invoice entered under two vendor records.

Can I delete a duplicate vendor in Sage Intacct?

A vendor can be deleted only if it has no payments or transactions. Otherwise, resolve all transactions on the duplicate, deactivate it and use only the remaining vendor. An inactive vendor cannot be used in new transactions.

Updated Nov 13, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.