Data quality

How to avoid duplicate contacts and companies between Holded and HubSpot

Holded by Vexco, an app by Vexco Solutions, avoids duplicates by matching records in a fixed order: an existing link first, then the tax ID (NIF/CIF), then the email. When a match is doubtful, it creates nothing and sends the case to a review inbox. Before activating, the setup wizard analyses both systems and lets you start with a “Link only” load.

Key points

  • Matching order: existing link, then tax ID (NIF/CIF), then email; doubtful cases go to the review inbox instead of being guessed.
  • HubSpot doesn't deduplicate companies created through the API by domain name, and that includes installed third-party sync apps, so the integration needs its own matching.
  • Wizard step 5, “Analyze duplicates”, only reads and uses roughly one Holded API call per 100 records.
  • “Link only” links what already exists on both sides and creates or changes nothing; “Link and fill gaps” fills empty fields without overwriting.
  • By default the app never deletes a customer in the other system (it only marks it), so a wrong match can be corrected without losing data.

Why duplicates appear between Holded and HubSpot

Holded and HubSpot identify customers differently. Holded is built around invoicing, so the tax ID (NIF or CIF in Spain, a VAT number abroad) is what really identifies a company. HubSpot is built around marketing and sales, so it identifies contacts by email and companies by domain. Connect the two without a matching strategy and the same customer ends up twice.

The usual causes are:

  • Different names for the same company. Finance records the legal name (“Distribuciones Pérez, S.L.”), while sales types the trade name (“Pérez Distribución”).
  • Records created by integrations. HubSpot's documentation says companies created through the API are not deduplicated by the company domain name, and that this includes installed third-party sync apps. Every sync tool has to bring its own matching.
  • “Create” steps without a lookup. Holded's own FAQ notes that, through Zapier, a contact that doesn't match an existing one in Holded is created as new. Our guide to connecting Holded and HubSpot with Zapier or Make explains how to add a lookup step.
  • Shared generic emails. Several customers use an accountant's address or an info@ mailbox, so email alone links the wrong companies.
  • Manual imports. A CSV loaded into one system months ago, with no shared ID, leaves two versions of each customer.

For companies with international teams there is an extra layer: Spanish customers carry a NIF or CIF, while customers in other EU countries carry a VAT number in their own format. If those numbers live in different fields, or are typed with and without the country prefix, matching by tax ID becomes unreliable.

How Holded by Vexco matches records

The app follows the same order for every customer, from the safest signal to the weakest:

  1. Existing link. If the two records were linked before, that link wins. Links are stored by the app and survive renames.
  2. Tax ID. If there is no link, the app looks for the same NIF/CIF on the other side.
  3. Email. If there is no tax ID, it looks for the same email.

When the result is clear, the records are linked. When it isn't, for example the same email with a different tax ID, or several candidates for one record, the app does nothing and sends the case to the review inbox. A wrong automatic match does more damage than a short wait for a human decision.

Each flow can be adjusted in the flow editor: the matching keys, conditions such as “only customers with tax ID”, who wins on a conflict and who rules on the first link. “Test with a record” runs a dry run for one record and writes nothing.

The review inbox: cases and buttons

The review inbox collects everything the app chose not to decide alone. Each case shows both records side by side, with the reason and the matching used.

CaseExampleButtons
Possible duplicateSame email, different tax ID; or two HubSpot companies with the same NIF“Merge”, “Create new”, “Ignore”
Data conflictThe billing address changed in both systems since the last sync“Keep Holded”, “Keep HubSpot”
ErrorHolded rejected a record because a required field was empty“Retry”

The Status tab shows how many items are waiting for review. Clear the inbox before you turn on both directions, so nothing doubtful is written to Holded.

Before activating: “Analyze duplicates”

Step 5 of the setup wizard, “Analyze duplicates”, compares both systems before anything is written. It reports, per flow, how many records will be linked, how many will be created in HubSpot, how many in Holded and how many need a human decision, plus how many were linked by each key.

The analysis only reads and uses roughly one Holded API call per 100 records, so even a large customer base costs little quota. If it takes too long on a big account, you can continue without waiting: the same matching runs during the initial load and doubtful cases still go to the review inbox. See step 5 of how it works for screenshots.

Choosing the initial load mode

Step 6 decides what happens to the data you already have. The mode is the most important decision for avoiding duplicates on day one.

ModeLinks existing recordsFills empty fieldsOverwrites valuesCreates missing records
“Link only”YesNoNoNo
“Link and fill gaps”YesYesNoNo
“Full load”YesYesPer the first-link ruleYes

Two options make it safer still. “Start with a sample” loads 5, 10, 25 or 50 records per flow and pauses so you can check them in HubSpot. “Simulate without writing” runs up to 25 records per flow through the same process and writes nothing anywhere. Loads run one at a time, customers first, then the catalog, then documents, and can be paused, resumed or cancelled.

Safest start: “Link only” for customers, then tick “Start read-only (Holded → HubSpot only)” before you click “Activate sync”. Review what was linked and what went to the review inbox. Once the inbox is clear, run a second load with “Link and fill gaps” or turn on both directions.

Data hygiene tips before you connect

An hour of cleaning before the first load saves days of fixing afterwards. These checks make the biggest difference:

  • One format for tax IDs. Decide whether you store the country prefix and apply it everywhere. Keep the tax ID in one field in each system, not in the name or the notes.
  • Legal name vs trade name. Keep the legal name in the field Holded uses for invoices and the trade name in its own field. The app's company card shows the tax ID and the trade name next to the HubSpot name.
  • Contact persons. In Holded, people often live inside a company contact as contact persons. In HubSpot they are contacts associated with the company. Decide which people should exist in both.
  • Individuals vs companies. Individual customers in Holded sync with HubSpot contacts; companies sync with HubSpot companies. Check that sole traders are recorded consistently.
  • Existing duplicates in HubSpot. Merge them with HubSpot's own tools first. Two HubSpot companies with the same tax ID give the app two candidates, so the case ends up in the review inbox.
  • Generic emails. Replace shared addresses with each customer's billing email where possible.

Keeping it clean after go-live

Once live, new customers are matched the same way, within seconds of being created or changed. The activity log shows, for every sync, which matching was used and the before and after of each field, and “Show only this chain” follows one record through every step. By default, deleting a customer on one side only marks it on the other, and the app never writes GDPR consent data.

If you are planning a larger clean-up or moving from another CRM at the same time, Vexco also offers HubSpot CRM migration services. To set up the app itself, follow the setup guide; to compare with exporting and importing files by hand, read Holded by Vexco vs manual export.

Holded by Vexco

Install it from the HubSpot Marketplace, connect your Holded company and start in read-only mode. Nothing syncs until you switch it on.

Try it free

Frequently asked questions

Does the app merge duplicate records automatically?

No. It links records automatically only when the existing link, the tax ID or the email gives one clear match. Doubtful cases go to the review inbox, where someone chooses “Merge”, “Create new” or “Ignore”.

What if a customer has no tax ID?

Then the app matches by email. If you prefer to sync only customers that have a tax ID, add the condition “only customers with tax ID” to the companies flow in the flow editor.

Will the app delete duplicates for me?

No, not by default. Holded by Vexco links, creates or updates according to your flow settings; a deletion on one side only marks the record on the other unless you choose otherwise in that flow, and you remove duplicates yourself in Holded or HubSpot.

Does HubSpot deduplicate companies created by integrations?

No, not by domain. HubSpot's documentation says companies created through the API are not deduplicated by the company domain name, including those created by installed sync apps. That is why the app matches by tax ID and email itself.

Is the duplicate analysis expensive in API calls?

No. “Analyze duplicates” only reads and uses roughly one Holded API call per 100 records. The wizard shows the estimated calls and the quota left this month before you run it.

Sources

Keep reading

All articles

Guides7 min read

How to connect Holded to HubSpot: three routes and a step-by-step setup

You can connect Holded to HubSpot in three ways: with Zapier or Make, the route Holded itself documents; with a HubSpot Marketplace app such as Holded by Vexco, built by Vexco Solutions; or with a custom integration. This guide compares the three, lists what you need before you start and walks through the app's seven-step setup, starting in read-only mode.

Automation5 min read

Connecting Holded and HubSpot with Zapier or Make: setup, templates and limits

You can connect Holded and HubSpot with Zapier, the route Holded itself documents, or with Make; for more than a couple of simple one-way flows, a Marketplace app such as Holded by Vexco, built by Vexco Solutions, is usually easier to run. This guide covers the templates Holded lists, how to set up a Zap and the limits Holded and Zapier publish.

Invoicing6 min read

How to sync Holded invoices and payments with HubSpot

Holded by Vexco, an app by Vexco Solutions, copies every invoice issued in Holded into HubSpot as an invoice record linked to the company and the deal, with number, total, PDF and payment status. Each payment recorded in Holded updates what is paid and pending on the deal and the balance and overdue amount on the company, so sales sees what finance sees.

Try it free

Holded and HubSpot, finally up to date

Install it from the HubSpot Marketplace, connect your Holded company and start in read-only mode. Nothing syncs until you switch it on.

14-day free trial with everything on · No card needed · Prices exclude VAT