How do I find and merge duplicate vendor records in my books, and what do I have to repair afterwards?

Find the duplicates: prove two records are the same payee, not just a similar name

If the payee has marked their address “NEW”, the requester should update its records. (jurisdiction: United States — federal tax law (Internal Revenue Code); IRS instructions, entity_scope: Requesters of Form W-9 — persons required to file U.S. information returns (payors/withholding agents), conditions: payee has marked the address “NEW” on Form W-9)

“If the payee has marked their address “NEW,” you should update your records.”

The IRS will send the filer a notice if the payee's name and TIN on the information return filed do not match the IRS's records. (jurisdiction: United States — federal tax law (Internal Revenue Code); IRS instructions, entity_scope: Requesters of Form W-9 — persons required to file U.S. information returns (payors/withholding agents))

“The IRS will send you a notice if the payee's name and TIN on the information return you filed don’t match the IRS's records.”

TIN matching allows a payor or authorized agent required to file information returns to match TIN and name combinations with IRS records before submitting the forms to the IRS. (jurisdiction: United States — federal tax law (Internal Revenue Code); IRS instructions, entity_scope: Requesters of Form W-9 — persons required to file U.S. information returns (payors/withholding agents))

“TIN matching allows a payor or authorized agent who is required to file information returns to match TIN and name combinations with IRS records before submitting the forms to the IRS.”

The documented procedure directs the user to select Expenses by Vendor Summary from the "Find report by name" dropdown; this is the named report the article uses for vendor totals. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13)

“From the Find report by name ▼ dropdown, select Expenses by Vendor Summary .”

The documented procedure directs the user to select Vendors from the "Display columns by" dropdown, so that the report's columns are broken out by vendor. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13)

“From the Display columns by ▼ dropdown, select Vendors .”

The article states that if the user wants to show open invoices and bills as well, they select Accrual. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13, accounting_basis: Accrual, conditions: Only where the user also wants open invoices and bills shown)

“If you want to show open invoices and bills too, select Accrual .”

As one suggested cleaning method, the article says a report showing every field used in the vendor master file should be printed for each supplier on a regular basis and scanned for missing information in the more important fields, giving tax codes and taxpayer identification numbers (TINs) as examples of such fields rather than a closed list. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, conditions: Presented as one of several suggested ways to clean the file)

“On a regular basis, print a report for each supplier that shows every field being used in the vendor master file. Scan the report for missing information in the more important fields, such as tax codes and taxpayer identification numbers (TINs).”

Where a field is missing and the supplier is actively being used, the article suggests contacting that supplier to obtain the missing information. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, conditions: Applies where the supplier is actively being used)

“If the supplier is actively being used, then contact the supplier to obtain the missing information.”

As a suggested method of finding duplicate vendor records, the article says to print a supplier list sorted by name and look for duplicate names, which it treats as an indication that duplicate records are present. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, conditions: Presented as one of several suggested ways to clean the file)

“Print a list of suppliers, sorted by name, and look for duplicate names that indicate the presence of duplicate records.”

As a suggested cleaning method, the article says to compare the taxpayer identification numbers recorded for the newest suppliers against the TIN matching program on the IRS website to verify the recorded numbers are correct, and to update any information found to be incorrect. (jurisdiction: United States, entity_scope: Businesses with suppliers holding US taxpayer identification numbers, conditions: Applies to the newest suppliers; Depends on the IRS TIN matching program)

“Compare the recorded taxpayer identification numbers for the newest suppliers to the TIN matching program on the IRS website to verify that the recorded numbers are correct. Update any information that is incorrect.”

Not established from an authoritative source.

Decide which record survives before you run anything

The instructions direct the requester to show on the information return filed with the IRS, and on the copy furnished to the payee, the full name and address as provided on Form W-9. (jurisdiction: United States — federal tax law (Internal Revenue Code); IRS instructions, entity_scope: Requesters of Form W-9 — persons required to file U.S. information returns (payors/withholding agents))

“Show the full name and address as provided on Form W-9 on the information return filed with the IRS and on the copy furnished to the payee.”

For a sole proprietor the individual's name goes on the first name line and the doing-business-as name may go on the second; the DBA name alone may not be entered; the TIN is either the individual's SSN or the business's EIN, with the IRS expressing a preference for the SSN. (jurisdiction: United States (federal tax administration), entity_scope: Filers reporting payments to sole proprietors, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“You must show the individual's name on the first name line; on the second name line, you may enter the “doing business as (DBA)” name. You may not enter only the DBA name. For the TIN, enter either the individual's social security number (SSN) or the EIN of the business (sole proprietorship). The IRS prefers that you enter the SSN.”

The article directs the user to choose carefully which vendor profile to keep and which to merge. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online company files with duplicate vendor profiles, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus)

“Important : Choose carefully which profile to keep and which to merge.”

The article lists the Company name and Display name of the vendor profile the user wants to keep as something needed before making these changes. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online company files with duplicate vendor profiles, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus, conditions: stated as a prerequisite before making any changes)

“The Company name and Display name of the vendor profile you want to keep.”

In the Merge Vendors tool the user selects the vendors to be merged and then selects one of them as the Primary Vendor before selecting Merge. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of QuickBooks Accountant Edition or QuickBooks Desktop Enterprise, platform: QuickBooks Desktop, platform_edition: QuickBooks Accountant Desktop Plus and QuickBooks Desktop Enterprise (Diamond, Gold, Platinum) editions)

“Select the vendors you want to merge, then select Next . Select a Primary Vendor , then Merge .”

Partly established. Established: the merge direction the platform allows (S19, S38, S39, S40, S44). Missing: correct legal payee identity as a criterion for choosing the surviving record; attached compliance documentation as a criterion for choosing the surviving record; references from open and recurring transactions as a criterion for choosing the surviving record; completeness of history as a criterion for choosing the surviving record.

Capture the before picture and back up the file

Before merging, the article's pre-merge checklist directs the user to back up the QuickBooks Desktop for Windows or Mac company file. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“Before you merge make sure: Backup your QuickBooks Desktop for Windows or Mac company file.”

Before merging, the article's pre-merge checklist directs that the company file be switched to “Single User” mode. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“Before you merge make sure: Backup your QuickBooks Desktop for Windows or Mac company file. Switch your company file to "Single User" mode.”

Before merging, the article's pre-merge checklist directs that any pending accountant changes be cleared. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“Before you merge make sure: Backup your QuickBooks Desktop for Windows or Mac company file. Switch your company file to "Single User" mode. Clear any pending accountant changes.”

A customer/vendor that was marked inactive by a merge can be marked active again, but doing so does not transfer the transactions back to it. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: record was marked inactive by a merge)

“You can mark the customers/vendors active again but this will not transfer the transactions back to the merged customer/vendor.”

The documented procedure directs the user to select a date range from the "Report period" dropdown. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13)

“From the Report period ▼ dropdown, select a date range.”

Selecting Export to Excel or Export to PDF automatically downloads a copy of the report and saves it to the user's computer. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13, conditions: Follows selection of Export to Excel or Export to PDF)

“This automatically downloads a copy of the report and saves it to your computer.”

Partly established. Established: a backup or export of the file taken before the consolidation runs (S27); why the operation must be treated as irreversible (S45). Missing: the pre-merge balances, payee totals and transaction counts captured and preserved before the consolidation runs.

Required authority: official platform documentation, primary regulator or government. Highest achieved: official platform documentation.

What the merge actually does on your platform

In QuickBooks Online, merging vendors moves the duplicate vendor's past transactions onto the vendor profile the user keeps and makes the duplicate vendor inactive. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online company files with duplicate vendor profiles, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus)

“Merging vendors moves past transactions from the duplicate vendor to the one you want to keep and makes the duplicate inactive.”

The merge operation is invoked from the vendor profile's Edit dropdown menu by selecting Merge contacts. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online company files with duplicate vendor profiles, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus, conditions: step in the documented merge procedure, performed on the vendor profile the user does not want to keep)

“Select the Edit ▼ dropdown menu, then select Merge contacts .”

Before merging, the article's pre-merge checklist directs that Multicurrency be off in QuickBooks Desktop for Windows. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop for Windows (of the products listed by the article), conditions: stated for QuickBooks Desktop for Windows)

“Before you merge make sure: Backup your QuickBooks Desktop for Windows or Mac company file. Switch your company file to "Single User" mode. Clear any pending accountant changes. Multicurrency is off in QuickBooks Desktop for Windows.”

An account that has online information associated with it cannot be merged into another account; the article states that getting that message means one of the accounts has an active bank feed, and links to instructions for turning bank feeds off. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop for Windows (of the products listed by the article), conditions: an account with online information / an active bank feed associated with it)

“Note : If you get the message, “You cannot merge an account that has online information associated with it into another account”, you have an active bank feed on one of the accounts. Here’s how to turn off bank feeds .”

A dedicated Merge Vendors tool is documented for the Accountant and Enterprise editions of QuickBooks Desktop. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of QuickBooks Accountant Edition or QuickBooks Desktop Enterprise, platform: QuickBooks Desktop, platform_edition: QuickBooks Accountant Desktop Plus and QuickBooks Desktop Enterprise (Diamond, Gold, Platinum) editions)

“Use the Merge Vendors tool in Accountant and Enterprise editions”

In QuickBooks Desktop for Mac one documented merge method is renaming: open the relevant list from Lists, copy the name of the entry to be kept, edit the unwanted entry with the pencil icon, paste the copied name and select OK, then select Yes to merge the entries. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop for Mac (QuickBooks Desktop Mac Plus, of the products listed by the article))

“Re-name to merge: Go to Lists , then select the list that has the entries you want to merge. Copy the name of the entry you want to keep. Select the entry you don’t want to use, then select the pencil icon to edit it. Paste the name you copied, then select OK . Select Yes to merge the entries.”

In QuickBooks Desktop for Mac a second documented merge method uses the Merge menu item: open the relevant list from Lists, select the entry to be removed, go to Edit and select Merge (the article notes the entry can also be right-clicked and Merge selected), select the entry to be kept, select Merge, then select Yes to confirm the merge operation. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Users of the QuickBooks Desktop products listed by the article who are merging entries in a company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop for Mac (QuickBooks Desktop Mac Plus, of the products listed by the article))

“Use the Merge menu item: Go to Lists , then select the list that has the entries you want to merge Select the name of the entry you want to remove Go to Edit , then select Merge . Note: You can also right-click the entry and select Merge . Select the name of the entry you want to keep. Select Merge to merge the entries. Select Yes to confirm the merge operation.”

Merging customers/vendors is possible only where the records use the same currency. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: the records to be merged use the same currency)

“You can only merge Customers/Vendors that use the same currency.”

The merge of two records starts from Sales > Customers (customers) or Purchases > Vendors (vendors) by selecting the contact that is to be merged. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: merging two customers or two vendors)

“Go to the Sales > Customers (for customers) or Purchases > Vendors (for vendors), and select the contact you want to merge.”

On a merge, the master customer/vendor retains all the transactions of the merged customers/vendors, and the merged customers/vendors are marked as inactive. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: after the merge has been carried out)

“The master customer/vendor will retain all the transactions of the merged customers/vendors and the merged customers/vendors will be marked as inactive.”

Partly established. Established: what the consolidation operation does to historical transactions and vendor attributes (S19, S44); what the operation carries onto the surviving record (S19, S44). Missing: what the operation silently drops; what permission or eligibility conditions restrict the operation.

What still points at the retired record

Wave states that a contractor or regular vendor that is attached to a bill cannot be deleted. (jurisdiction: Not stated for this statement; document is the en-us Wave Help Center edition of the Wave product and elsewhere addresses US businesses specifically, entity_scope: Wave contractor and regular vendor records attached to a bill, platform: Wave, platform_edition: Wave Help Center article, current at 2026-09-09 (edition not retrievable - host returns 403), conditions: record is attached to a bill)

“You cannot delete a contractor or regular vendor that is attached to a bill.”

Once Recurring Transactions, Custom Form Styles, Currencies, and Attachments have been deleted in QuickBooks Online, they can no longer be restored. (jurisdiction: United States (Intuit's en-US QuickBooks Support site; US country selection), entity_scope: QuickBooks Online company users maintaining lists (accounts, terms, classes, products/services, customers, vendors), platform: QuickBooks Online, platform_edition: QuickBooks Online, US (en-US) help article, Updated 8/24/2026 05:16, conditions: applies after deletion of these four kinds of list element)

“Warning :    Keep in mind that once you have deleted Recurring Transactions, Custom Form Styles, Currencies, and Attachments, they can no longer be restored.”

Not established from an authoritative source.

Required authority: official platform documentation. Highest achieved: official platform documentation.

Repair what the split had already broken

Where a payer realises that duplicate reporting or a large percentage of incorrect information has been filed, it should contact the IRS information reporting customer service site for further instructions. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“If a payer realizes duplicate reporting or a large percentage of incorrect information has been filed, contact the information reporting customer service site at 866-455-7438 for further instructions.”

Duplicate filing is a common error: the same information is not to be sent to the IRS more than once. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“Duplicate filing. Do not send the same information to the IRS more than once. Also see Multiple filings , earlier.”

Where an account number was on the original return, the same account number must appear on both the original and the corrected return so the correction can be identified and processed; where it was not on the original, it is not added to the correction. (jurisdiction: United States (federal tax administration), entity_scope: Filers preparing corrected paper information returns, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“If the account number was provided on the original return, the same account number must be included on both the original and corrected returns to properly identify and process the correction. If the account number was not provided on the original return, do not include it on the corrected return.”

An account number must be shown where the filer has multiple accounts for one recipient and is filing more than one information return of the same type for that recipient. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: filer holds multiple accounts for the same recipient and files more than one return of the same type; applies to information returns for calendar/tax year 2025, filed in 2026)

“The account number is required if you have multiple accounts for a recipient for whom you are filing more than one information return of the same type.”

Not established from an authoritative source.

Required authority: primary regulator or government. Highest achieved: primary regulator or government.

Verify the surviving record adds up

See The documented procedure directs the user to select Expenses by Vendor Summary from the "Find report by name" dropdown; this is the named report the article uses for vendor totals.

The article states that if the user wants to show only the payments they made to their vendors, they select Cash. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13, accounting_basis: Cash, conditions: Only where the user wants to show only payments made to vendors)

“If you want to only show the payments you made to your vendors, select Cash .”

The documented procedure directs the user to select Run report to produce the report. (jurisdiction: United States (en-US QuickBooks Online help article; United States product/support site), entity_scope: Businesses and users of the QuickBooks Online products listed in the article's applicability list, platform: QuickBooks Online, platform_edition: QuickBooks Online Advanced, Plus, Essentials, Simple Start, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus; article updated 8/4/2026 03:13)

“Select Run report .”

See Selecting Export to Excel or Export to PDF automatically downloads a copy of the report and saves it to the user's computer.

Not established from an authoritative source.

Records you must not merge, and what to do instead

Where an individual debtor is in chapter 11 bankruptcy and has notified the filer of the bankruptcy estate's EIN, post-petition gross income, gross proceeds or other reportable payments are reported using the estate's name and EIN rather than the individual's. (jurisdiction: United States (federal tax administration), entity_scope: Filers reporting payments to an individual debtor in chapter 11 bankruptcy who has notified the estate's EIN, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“If an individual (the debtor) for whom you are required to file an information return is in chapter 11 bankruptcy, and the debtor notified you of the bankruptcy estate's EIN, report post-petition gross income, gross proceeds, or other reportable payments on the applicable information return using the estate's name and EIN.”

An information return can carry only one recipient TIN. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“Only one recipient TIN can be entered on the form.”

The pre-merge checklist directs that the vendors to be merged are not tax authorities. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Vendor records in a QuickBooks Desktop company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“The vendors you want to merge aren’t: Tax authorities”

The pre-merge checklist directs that the vendors to be merged are not tax exempt. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Vendor records in a QuickBooks Desktop company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“The vendors you want to merge aren’t: Tax authorities Tax exempt”

The pre-merge checklist directs that the vendors to be merged are not vendors paid through online banking. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Vendor records in a QuickBooks Desktop company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“The vendors you want to merge aren’t: Tax authorities Tax exempt Paid through online banking”

The pre-merge checklist directs that the vendors to be merged are not direct deposit vendors. (jurisdiction: United States — QuickBooks US (en-US) support site; US product line-up, US sales numbers and country selector, entity_scope: Vendor records in a QuickBooks Desktop company file, platform: QuickBooks Desktop, platform_edition: QuickBooks Desktop Mac Plus, Premier Plus, Pro Plus, Accountant Desktop Plus, Enterprise Diamond, Enterprise Gold, Enterprise Platinum (products listed by the article))

“The vendors you want to merge aren’t: Tax authorities Tax exempt Paid through online banking Direct deposit vendors”

See An account that has online information associated with it cannot be merged into another account; the article states that getting that message means one of the accounts has an active bank feed, and links to instructions for turning bank feeds off.

A customer cannot be merged to a vendor. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown)

“You cannot merge a customer to a vendor.”

Where a person is both a customer and a vendor, the two records can be linked instead. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: the same person is both a customer and a vendor)

“But in case, a person is both a customer and a vendor, you can link them.”

Linking a customer to a vendor keeps them as two different customers/vendors and does not merge their transactions. (jurisdiction: United States (Zoho Books US edition help site, US-EN), entity_scope: Zoho Books organizations and users, platform: Zoho Books, platform_edition: US edition (US-EN) help/FAQ, as retrieved 2026-09-09; no version or revision date shown, conditions: customer and vendor records have been linked rather than merged)

“Linking customers to vendors will treat them as two different customers/vendors and will not merge their transactions.”

Not established from an authoritative source.

Required authority: official platform documentation, primary regulator or government. Highest achieved: high quality professional secondary reference, official platform documentation, primary regulator or government.

Stop the duplicates coming back

See As a suggested method of finding duplicate vendor records, the article says to print a supplier list sorted by name and look for duplicate names, which it treats as an indication that duplicate records are present.

Once duplicate records are identified, the article suggests deciding which of them to archive and flagging those records as not to be used again. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, conditions: Applies to records identified as duplicates)

“Determine which of these records to archive and flag them as not to be used again.”

The article states the vendor master file should be cleaned at least once a year, for accuracy and compliance. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses that maintain a vendor master file)

“The vendor master file should be cleaned at least once a year to ensure accuracy and compliance.”

For larger organizations, or organizations with frequent vendor transactions, the article recommends quarterly reviews so that duplicates and outdated records are caught sooner. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Larger organizations, or organizations with frequent vendor transactions, conditions: Recommendation is conditioned on organization size or transaction frequency)

“For larger organizations or those with frequent vendor transactions, quarterly reviews are recommended to catch duplicates and outdated records sooner.”

Partly established. Established: a periodic vendor-list review (S68). Missing: a naming convention; a duplicate check at the point of vendor creation; restriction of who may create a vendor.

Required authority: authoritative professional or accounting standard. Highest achieved: high quality professional secondary reference, primary regulator or government.

Platform reference: merge behaviour, restrictions and the deactivate alternative

See In QuickBooks Online, merging vendors moves the duplicate vendor's past transactions onto the vendor profile the user keeps and makes the duplicate vendor inactive.

The article lists edit access to the user's vendor profiles in QuickBooks Online as something needed before making these changes. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online company files with duplicate vendor profiles, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus, conditions: stated as a prerequisite before making any changes)

“Edit access to your vendor profiles in QuickBooks Online .”

The article is labelled as applying to QuickBooks Online Advanced, QuickBooks Online Plus, QuickBooks Online Simple Start, QuickBooks Online Essentials, QuickBooks Ledger, Intuit Enterprise Suite and QuickBooks Solopreneur Plus. (jurisdiction: United States (QuickBooks Online US edition help site, quickbooks.intuit.com/learn-support/en-us), entity_scope: QuickBooks Online and related Intuit subscriptions listed by the article, platform: QuickBooks Online, platform_edition: US (en-us) help article, updated 8/5/2026 03:06; listed for QuickBooks Online Advanced, Plus, Simple Start, Essentials, QuickBooks Ledger, Intuit Enterprise Suite, QuickBooks Solopreneur Plus, conditions: product labels the article itself carries)

“QuickBooks Online Advanced QuickBooks Online Plus QuickBooks Online Simple Start QuickBooks Online Essentials QuickBooks Ledger Intuit Enterprise Suite QuickBooks Solopreneur Plus”

See A dedicated Merge Vendors tool is documented for the Accountant and Enterprise editions of QuickBooks Desktop.

See On a merge, the master customer/vendor retains all the transactions of the merged customers/vendors, and the merged customers/vendors are marked as inactive.

See A customer/vendor that was marked inactive by a merge can be marked active again, but doing so does not transfer the transactions back to it.

Wave states that deletion of a contractor or regular vendor is permanent and cannot be undone. (jurisdiction: Not stated for this statement; document is the en-us Wave Help Center edition of the Wave product and elsewhere addresses US businesses specifically, entity_scope: Wave contractor and regular vendor records, platform: Wave, platform_edition: Wave Help Center article, current at 2026-09-09 (edition not retrievable - host returns 403), conditions: applies to the delete operation on contractors and regular vendors)

“Deleting a contractor or regular vendor is permanent and cannot be undone.”

See The documented procedure directs the user to select Expenses by Vendor Summary from the "Find report by name" dropdown; this is the named report the article uses for vendor totals.

Not established from an authoritative source.

Who counts as the same payee for annual information reporting

Persons required to file information returns with the IRS use Form W-9, or an acceptable substitute, to get the payee's (or other person's) correct name and TIN; for individuals the TIN is generally a social security number (SSN). (jurisdiction: United States — federal tax law (Internal Revenue Code); IRS instructions, entity_scope: Requesters of Form W-9 — persons required to file U.S. information returns (payors/withholding agents))

“Form W-9 (or an acceptable substitute) is used by persons required to file information returns with the IRS to get the payee's (or other person's) correct name and TIN. For individuals, the TIN is generally a social security number (SSN).”

See The instructions direct the requester to show on the information return filed with the IRS, and on the copy furnished to the payee, the full name and address as provided on Form W-9.

See For a sole proprietor the individual's name goes on the first name line and the doing-business-as name may go on the second; the DBA name alone may not be entered; the TIN is either the individual's SSN or the business's EIN, with the IRS expressing a preference for the SSN.

For a disregarded single-member LLC the owner's name goes on the first name line and the LLC's name on the second, with the owner's SSN (or EIN if applicable) as the TIN; if the LLC is taxed as a corporation, partnership etc., the entity's own EIN is used. (jurisdiction: United States (federal tax administration), entity_scope: Filers reporting payments to limited liability companies, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“For a single-member LLC (including a foreign LLC with a U.S. owner) that is disregarded as an entity separate from its owner under Regulations section 301.7701-3, enter the owner's name only on the first name line and the LLC's name on the second name line. For the TIN, enter the owner's SSN (or EIN, if applicable). If the LLC is taxed as a corporation, partnership, etc., enter the entity's EIN.”

For individual recipients the TIN is the SSN, ITIN or ATIN; for other recipients, including (but not limited to) corporations, partnerships and estates, the TIN is the EIN. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“The TIN for individual recipients of information returns is the SSN, ITIN, or ATIN. See Sole proprietors , earlier. For other recipients, including corporations, partnerships, and estates, the TIN is the EIN.”

Partly established. Established: what the payer is expected to hold to support that identity (S01). Missing: what identity attributes determine that two vendor records are the same payee for annual information-reporting purposes.

What you must keep afterwards, and for how long

Filers should generally keep copies of the information returns filed with the IRS, or be able to reconstruct the data, for at least 3 years from the due date of the returns (4 years for Form 1099-C), and for 4 years where backup withholding was imposed. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“Generally, keep copies of information returns you filed with the IRS, or have the ability to reconstruct the data, for at least 3 years (4 years for Form 1099-C) from the due date of the returns. Keep copies of information returns for 4 years if backup withholding was imposed.”

Identity information obtained on a Form W-9 or W-9S must be kept confidential by the filer and may be used only to comply with the tax laws. (jurisdiction: United States (federal tax administration), entity_scope: Filers of Forms 1096, 1097, 1098, 1099, 3921, 3922, 5498, and W-2G, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“You are required to maintain the confidentiality of information obtained on a Form W-9/W-9S relating to the taxpayer's identity (including SSNs, EINs, ITINs, and ATINs), and you may use such information only to comply with the tax laws.”

Books or records relating to a form or its instructions must be retained for as long as their contents may become material in the administration of any Internal Revenue law. (jurisdiction: United States (federal tax administration), entity_scope: Persons required to file these forms and keep the underlying books and records, conditions: applies to information returns for calendar/tax year 2025, filed in 2026)

“Books or records relating to a form or its instructions must be retained as long as their contents may become material in the administration of any Internal Revenue law.”

Partly established. Established: how long the underlying accounting and payee records must be kept (S18). Missing: what evidence of the pre-consolidation state must be retained after the records are combined; what evidence of the vendor's identity must be retained after the records are combined.

Vendor master file practice

The article asserts that even a business with a relatively small number of suppliers will gradually accumulate a significant number of errors in its vendor master file, and introduces the following items as suggested (not mandatory) ways to clean the file. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, including those with a relatively small number of suppliers, conditions: The cleaning methods that follow are presented as suggestions)

“When a business has even a relatively small number of suppliers, a significant number of errors will gradually creep into the vendor master file. Here are a number of suggested ways to clean the file:”

See As one suggested cleaning method, the article says a report showing every field used in the vendor master file should be printed for each supplier on a regular basis and scanned for missing information in the more important fields, giving tax codes and taxpayer identification numbers (TINs) as examples of such fields rather than a closed list.

As a suggested cleaning method, the article says to print a report of payments to suppliers over the past two years and, where there has been no activity in that period, to flag the related vendor master files as archived. (jurisdiction: United States (US publisher; the document states no jurisdictional limit of its own), entity_scope: Businesses with suppliers, conditions: Applies to suppliers with no payment activity in the past two years)

“Print a report that shows payments to suppliers over the past two years. If there has been no activity during that time period, flag the related vendor master files as archived.”

Partly established. Established: periodic review of the vendor list (S62, S68). Missing: who may create a vendor; duplicate prevention at creation; the naming and standardisation convention applied to vendor master records.

Required authority: authoritative professional or accounting standard. Highest achieved: high quality professional secondary reference, primary regulator or government.