--- title: How to Handle Duplicates in HubSpot When NetSuite Is Integrated description: Learn how to safely deduplicate HubSpot companies when NetSuite is connected without breaking the NetSuite integration, finance workflows, or your sync. image: https://koalify.io/hubfs/How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg --- [Skip to content](https://koalify.io/blog/how-to-handle-duplicates-in-hubspot-when-netsuite-is-integrated#main-content) [![rectangle\_long\_koala\_with\_name\_bold\_200\_125\_white](https://koalify.io/hubfs/rectangle_long_koala_with_name_bold_200_125_white.png)](https://koalify.io) - Products Show submenu for Products - [Deduplication](https://koalify.io) - [Email Validation](https://koalify.io/hubspot-email-validation) - Pricing Show submenu for Pricing - [Deduplication](https://koalify.io/pricing) - [Email Validation](https://koalify.io/hubspot-email-validation-pricing-koalify) - [Partners](https://koalify.io/partners) - [Blog](https://koalify.io/blog) - Knowledge base Show submenu for Knowledge base - [Deduplication](https://koalify.io/knowledge-base) - [Email Validation](https://koalify.io/email-validation-knowledge-base) - Products Show submenu for Products - [Deduplication](https://koalify.io) - [Email Validation](https://koalify.io/hubspot-email-validation) - Pricing Show submenu for Pricing - [Deduplication](https://koalify.io/pricing) - [Email Validation](https://koalify.io/hubspot-email-validation-pricing-koalify) - [Partners](https://koalify.io/partners) - [Blog](https://koalify.io/blog) - Knowledge base Show submenu for Knowledge base - [Deduplication](https://koalify.io/knowledge-base) - [Email Validation](https://koalify.io/email-validation-knowledge-base) ![menu-toggle](https://21645388.fs1.hubspotusercontent-na1.net/hubfs/21645388/menu-toggle.svg) ![menu-close](https://21645388.fs1.hubspotusercontent-na1.net/hubfs/21645388/menu-close.svg) [Get Started Free](https://api.koalify.io/hubspot/install?utm_source=koalify&utm_medium=website&utm_campaign=navigation) [HubSpot Data Quality](https://koalify.io/blog/tag/hubspot-data-quality), [HubSpot Integration Duplicates](https://koalify.io/blog/tag/hubspot-integration-duplicates) # How to Handle Duplicates in HubSpot When NetSuite Is Integrated [By \- Jonas,](https://koalify.io/blog/author/jonas) May 18, 2026 ![ Featured Image](https://koalify.io/hs-fs/hubfs/How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg?width=1217&height=723&name=How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg) When NetSuite is your finance system of record, a careless HubSpot merge can do real damage. Billing history disappears. A company gets collapsed into the wrong record, and your finance team loses the NetSuite ID they rely on to process orders, invoices, or renewals. The tricky part is knowing which duplicates are safe to merge automatically and which ones need a human eye. This is especially common when integrations like [Apollo](https://koalify.io/blog/how-to-avoid-apollo-duplicates-in-hubspot), [ZoomInfo](https://koalify.io/blog/merge-zoominfo-duplicates-hubspot), or HubSpot forms keep creating new company records without checking what's already in your database. Over time, you end up with duplicates everywhere and with NetSuite in the mix, the cost of a bad merge is much higher than usual. Koalify lets you handle this precisely. You can protect NetSuite-linked records from unsafe merges, automate the safe ones, and flag the sensitive ones for manual review. Here's how.   ### The core principle: your NetSuite ID is the safety rail Before touching anything, establish one ground rule: **any company with a NetSuite ID (or Customer ID) is a finance-critical record.** That record should never be merged into a duplicate that doesn't share the same ID, or worse, merged with a completely different company that happens to have a similar name or domain. In Koalify, this is handled through two settings: your **duplicate rules** (which control what gets flagged) and your **primary rules** (which control which record survives the merge). Both need to account for your NetSuite ID field.   ### Scenario 1: Both Duplicate Companies Have a Different NetSuite ID **✅ Action: DO NOT MERGE** If two records both have a NetSuite ID and those IDs are different, they are two distinct finance entities, regardless of how similar the company name or domain looks. Merging them would collapse two separate records into one, potentially deleting billing history, breaking the NetSuite sync, and misrepresenting the customer relationship in your reports. 💡 **Edit your duplicate rules** Add a filter to every company duplicate rule: - `NetSuite ID matches (or is unknown) NetSuite ID` This tells Koalify to only flag companies as duplicates when: - Neither record has a NetSuite ID, or - One record has a NetSuite ID and the other doesn't, or - Both records share the **same** NetSuite ID It will never flag two records with **different** NetSuite IDs as duplicates, no matter how similar they look. Apply this filter to every rule in your company duplicate rules list. Each rule runs independently, so the filter needs to be present on all of them. ![How to Handle Duplicates in HubSpot When NetSuite Is Integrated](https://koalify.io/hs-fs/hubfs/How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg?width=1200&height=713&name=How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg)   ### Scenario 2: Only One Company Has a NetSuite ID **✅ Action: Merge — but keep the NetSuite record as primary** This is the most common scenario when integrations or HubSpot users create a new company record that partially overlaps with a customer already in your system. The new record has no NetSuite ID; the original does. These are safe to merge — but only in the right direction. The company with the NetSuite ID must be the primary record. If the non-customer record becomes primary, you lose the NetSuite ID and everything connected to it. 💡 **Edit your primary rules** Set your first priority in the company primary rule to: - `NetSuite ID is known` This ensures that whenever Koalify runs a merge, the record carrying the NetSuite ID is automatically designated as primary. The non-customer duplicate gets merged into it, and your finance sync stays intact. You can then add secondary criteria for cases where neither record has an ID (see Scenario 3 below): - Number of associated contacts (largest first) - Last activity date (most recent first) ### Scenario 3: Neither Company Has a NetSuite ID **✅ Action: Merge — automate it** When neither duplicate has a NetSuite ID, there's no finance record at risk. These are typically duplicates created by enrichment tools, web forms, or manual data entry and they're safe to merge automatically via a HubSpot workflow. 💡 **Set secondary primary rules** Since there's no NetSuite ID to guide the merge, use a combination of: - **Number of associated contacts** (keep the record with the most relationships) - **Last activity date** (keep the most recently active record) This handles the practical reality that historical company records sometimes have the wrong owner assigned, or were created before your current team took over. Prioritising the most active record with the most contacts gives you the best approximation of the "real" company. For these records, you can safely enrol them in a Koalify workflow and let the merges run automatically in the background. ![Only One Company Has a NetSuite ID](https://koalify.io/hs-fs/hubfs/Only%20One%20Company%20Has%20a%20NetSuite%20ID.jpg?width=1227&height=688&name=Only%20One%20Company%20Has%20a%20NetSuite%20ID.jpg)   ### Setting up the workflow to bulk merge duplicates without NetSuite ID Once your rules are in place, here's the recommended approach: 1. **Review flagged duplicates first.** Create a dedicated company view in HubSpot filtered by Koalify duplicate properties. Sort by the Koalify Primary Duplicate ID column so pairs appear next to each other. 2. **Check for edge cases.** Sort by the Koalify number of duplicates column to find any records flagged against an unusually high number of matches these may be candidates for deletion rather than merging, particularly if they have no associated contacts and no activity. 3. **Automate the merges.** For duplicates with no NetSuite ID, enrol them in the Koalify workflow to merge automatically. The workflow always enrolls the non-primary record and merges it into the primary so your primary rules do the work of keeping the right record. ![Setting up the workflow to bulk merge duplicates without NetSuite ID](https://koalify.io/hs-fs/hubfs/Setting%20up%20the%20workflow%20to%20bulk%20merge%20duplicates%20without%20NetSuite%20ID.jpg?width=1197&height=847&name=Setting%20up%20the%20workflow%20to%20bulk%20merge%20duplicates%20without%20NetSuite%20ID.jpg)   ### FAQ #### **Will merging companies in HubSpot affect the NetSuite sync?** It depends on which record becomes primary. If the record with the NetSuite ID survives the merge as the primary, the sync should remain intact. If you accidentally merge the NetSuite-linked record into a secondary, the ID may be lost. That's why setting the primary rule to prioritise `NetSuite ID is known` is essential before running any merges. #### **What if the same company has multiple NetSuite IDs across different records?** This usually means two genuinely separate billing entities have ended up sharing a name or domain in your CRM. Don't merge them — flag them for manual review and verify with your finance team before taking any action. Koalify's duplicate rules will prevent these from being flagged automatically once you've added the `matches (or is unknown)` filter. #### **Can I see a log of which companies were merged and when?** Yes. Every merge run through a Koalify workflow is recorded in the workflow's enrolment history, and the merge is logged in the company record's activity timeline. You can also view the Merged Company IDs property on any primary record to see which records were consolidated into it. #### **What happens to contacts associated with the duplicate company after a merge?** All contacts associated with the non-primary record are re-associated with the primary record after the merge. You won't lose those relationships — they move over automatically.   ### Further reading - [How to merge companies in HubSpot (safely, manually or in bulk)](https://koalify.io/blog/how-to-merge-companies-in-hubspot-manual-or-in-bulk) - [HubSpot deduplication: the ultimate guide to zero duplicates](https://koalify.io/blog/hubspot-deduplication-the-ultimate-guide-to-zero-duplicates-in-hubspot) - [How to handle duplicates in HubSpot when Chargebee is integrated](https://koalify.io/blog/how-to-handle-duplicates-in-hubspot-when-chargebee-is-integrated)   If you're running HubSpot alongside NetSuite and want to get your duplicate rules set up correctly before running any merges, [install Koalify free](https://api.koalify.io/hubspot/install) and book an onboarding call — we'll walk through your specific setup together. ###### Category - [HubSpot Data Quality](https://koalify.io/blog/tag/hubspot-data-quality) - [HubSpot Email Validation](https://koalify.io/blog/tag/hubspot-email-validation) - [HubSpot Revenue Operations](https://koalify.io/blog/tag/hubspot-revenue-operations) - [HubSpot Integration Duplicates](https://koalify.io/blog/tag/hubspot-integration-duplicates) - [HubSpot Associations](https://koalify.io/blog/tag/hubspot-associations) - [HubSpot Deduplication](https://koalify.io/blog/tag/hubspot-deduplication) ###### Popular Post - [HubSpot best practices for contacts that leave a company](https://koalify.io/blog/hubspot-best-practices-for-contacts-that-leave-a-company) - [How to Bulk Merge HubSpot Duplicates: Contacts, Companies, Deals and More](https://koalify.io/blog/how-to-bulk-merge-hubspot-duplicates-contacts-companies-more) - [How to Merge Companies in HubSpot (Safely, Manually or in Bulk)](https://koalify.io/blog/how-to-merge-companies-in-hubspot-manual-or-in-bulk) - [HubSpot Deduplication: How to Find, Manage, and Remove Duplicates in HubSpot](https://koalify.io/blog/hubspot-deduplication-the-ultimate-guide-to-zero-duplicates-in-hubspot) - [How to Merge Duplicate Contacts in HubSpot Without Losing Data](https://koalify.io/blog/how-to-merge-contacts-in-hubspot-manual-or-in-bulk) ### Similar Blogs ![Why Aircall Creates Duplicate Contacts in HubSpot and How to Fix It](https://koalify.io/hs-fs/hubfs/Aircall%20new%20contact.png?width=352&name=Aircall%20new%20contact.png) #### [Why Aircall Creates Duplicate Contacts in HubSpot and How to Fix It](https://koalify.io/blog/how-to-detect-and-merge-aircall-duplicates-in-hubspot) By [Jonas](https://koalify.io/blog/author/jonas) 10 April 2025 If you use Aircall with HubSpot, you may have seen duplicate contacts appear when calls are logged.... [READ MORE](https://koalify.io/blog/how-to-detect-and-merge-aircall-duplicates-in-hubspot) ![How to Clean Invalid Contact Data in HubSpot](https://koalify.io/hs-fs/hubfs/image-png-May-02-2024-07-12-01-1523-PM.png?width=352&name=image-png-May-02-2024-07-12-01-1523-PM.png) #### [How to Clean Invalid Contact Data in HubSpot](https://koalify.io/blog/how-to-clean-invalid-contact-data-in-hubspot) By [Jonas](https://koalify.io/blog/author/jonas) 10 February 2024 [Koalify](https://koalify.io/) doesn't just identify duplicates; it also pinpoints inaccurate data. Cleansing this bad... [READ MORE](https://koalify.io/blog/how-to-clean-invalid-contact-data-in-hubspot) ![Are duplicates inflating your HubSpot Marketing Contacts bill?](https://koalify.io/hs-fs/hubfs/Are%20duplicates%20inflating%20your%20HubSpot%20Marketing%20Contacts%20bill%20Yearly.png?width=352&name=Are%20duplicates%20inflating%20your%20HubSpot%20Marketing%20Contacts%20bill%20Yearly.png) #### [Are duplicates inflating your HubSpot Marketing Contacts bill?](https://koalify.io/blog/duplicate-contacts-hubspot-marketing-contacts-cost) By [Jonas](https://koalify.io/blog/author/jonas) 17 April 2026 HubSpot charges based on the number of Marketing Contacts in your portal. Not unique people.... [READ MORE](https://koalify.io/blog/duplicate-contacts-hubspot-marketing-contacts-cost) ## Koalify HubSpot deduplication & email validation - - [Review Koalify in the HubSpot Marketplace](https://app-eu1.hubspot.com/l/marketplace/listing/koalify-io/write-review?eco_review_source=external-button) [![SOC 2 Logo](https://koalify.io/hs-fs/hubfs/SOC%202%20Logo.webp?width=70&height=70&name=SOC%202%20Logo.webp "SOC 2 Logo")](https://trust.koalify.io/) [![gdpr](https://koalify.io/hs-fs/hubfs/gdpr.png?width=70&height=70&name=gdpr.png "gdpr")](https://trust.koalify.io/) ## Deduplication [Deduplication for HubSpot](https://koalify.io) [Pricing](https://koalify.io/pricing) [Knowledge Base](https://koalify.io/knowledge-base) [Terms of Service](https://koalify.io/terms-of-service) [Data Processing Addendum](https://koalify.io/data-processing-addendum) [HubSpot Deduplication Tools](https://koalify.io/best-hubspot-deduplication-apps) [vs. HubSpot Native](https://koalify.io/compare/koalify-vs-hubspot-native-deduplication) [vs. Insycle](https://koalify.io/compare/koalify-vs-insycle-hubspot-deduplication) [vs. Dedupely](https://koalify.io/compare/koalify-vs-dedupely) [HubSpot Deduplication Guide](https://koalify.io/blog/hubspot-deduplication-the-ultimate-guide-to-zero-duplicates-in-hubspot) [Merge HubSpot Contacts](https://koalify.io/blog/how-to-merge-contacts-in-hubspot-manual-or-in-bulk) [Merge HubSpot Companies](https://koalify.io/blog/how-to-merge-companies-in-hubspot-manual-or-in-bulk) [Merge HubSpot Deals](https://koalify.io/blog/how-to-merge-deals-in-hubspot-manual-or-in-bulk) [Bulk Merge HubSpot](https://koalify.io/blog/how-to-bulk-merge-hubspot-duplicates-contacts-companies-more) ## Email Validation [Email Validation for HubSpot](https://koalify.io/hubspot-email-validation) [Pricing](https://koalify.io/hubspot-email-validation-pricing-koalify) [Knowledge Base](https://koalify.io/email-validation-knowledge-base) [Terms of Service](https://koalify.io/terms-of-service-email-validation) [Data Processing Addendum](https://koalify.io/data-processing-addendum-email-validation) [HubSpot Email Validation Tools](https://koalify.io/best-email-validation-tools-for-hubspot) [vs. NeverBounce](https://koalify.io/compare/koalify-vs-neverbounce) [vs. ZeroBounce](https://koalify.io/compare/koalify-vs-zerobounce) [vs. Kickbox](https://koalify.io/compare/koalify-vs-kickbox) [HubSpot Email Validation Guide](https://koalify.io/hubspot-email-validation-guide) [HubSpot Email Deliverability](https://koalify.io/hubspot-email-deliverability) [HubSpot Bounce Rate](https://koalify.io/hubspot-bounce-rate) ## Company [Partners](https://koalify.io/partners) [Blog](https://koalify.io/blog) [Trust Center](https://trust.koalify.io/) [Security](https://koalify.io/security) © 2026 Koalify. All rights reserved. ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Jonas", "url" : "https://koalify.io/blog/author/jonas" }, "dateModified" : "2026-05-28T11:44:58.001Z", "datePublished" : "2026-05-18T14:51:29.000Z", "headline" : "How to Handle Duplicates in HubSpot When NetSuite Is Integrated", "image" : [ "https://koalify.io/hubfs/How%20to%20Handle%20Duplicates%20in%20HubSpot%20When%20NetSuite%20Is%20Integrated.jpg" ], "mainEntityOfPage" : { "@id" : "https://koalify.io/blog/how-to-handle-duplicates-in-hubspot-when-netsuite-is-integrated", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://koalify.io/hubfs/koalify_rectangle_100px.png" }, "name" : "Koalify" } } ```