Rivane

Accounting
made smart

ERP Use CasesTier 1Published May 23, 2026

Customer Master Record Creation and Deduplication

Customer Master Record Creation and Deduplication for US and UK finance teams: ERP requirements, controls, audit evidence, data model, APIs, state transitions, and implementation checks.

Customer Master / Account Management is where ERP discipline either begins or breaks.

Customer Master Record Creation and Deduplication looks operational from far away. In a real finance team, it is a chain of assertions: the right actor started the work, the required records existed, the control policy was applied, the state change was preserved, and the outcome can be explained later without rebuilding the transaction from emails and spreadsheets.

The expected business outcome is specific: Duplicate account rate <1% post-deduplication; 100% of customer records carry external_id; enrichment data available within 30 seconds of account creation

The control flow a finance team actually needs.

Workflow map showing control steps, exceptions, and evidence for this ERP process.Duplicate Detect...Start conditionMerge Operation ...Required checksThird-Party Enri...Owner and SLAExternal Id Prop...System updateMandatory Fields...Exception handlingAudit packetEvidence trailException loopCustomer Master / Account Management should preserve every override and rejection.
Workflow map for this ERP process, including exception handling and audit evidence.

Step 1

Duplicate Detection Using Fuzzy Match...

Step 2

Merge Operation Preserves Full History...

Step 3

Third-Party Enrichment Optional With...

Step 4

External Id Propagated To All...

Step 5

Mandatory Fields: Legal Name, Billing...

The ERP surface involved.

Module

Customer Master / Account Management

Actors

Sales Rep, Customer Onboarding Team, MDM (Master Data Management) Engine

Tier

Tier 1

Finance area

Sales, CRM & Customer Management

Region lens

US and UK finance teams

Publication date

May 23, 2026

Duplicate detection using fuzzy match on name, domain, and tax ID with configurable similarity threshold; merge operation preserves full history on surviving record; third-party enrichment optional with manual override; external_id propagated to all downstream systems on creation; mandatory fields: legal name, billing address, primary contact, currency, payment terms; account hierarchy (parent/subsidiary) supported; GDPR/CCPA data residency flag; change history on all fields with actor and timestamp

US and UK teams have different compliance hooks, but the same control problem.

US teams usually care about clean evidence for audit support, vendor records, payment controls, tax reporting, and management review. UK teams usually care about VAT-ready records, approval evidence, digital-record discipline, and traceable postings. The country-specific details differ, but the operating pattern is the same: the ERP needs controlled records, explicit ownership, defensible state changes, and evidence that survives beyond the person who completed the task.

The control matrix.

Control areaRequirementAcceptance proof
Control 1Duplicate detection using fuzzy match on name, domain, and tax ID with configurable similarity thresholdGiven a sales rep creating a new customer post-opportunity-close
Control 2merge operation preserves full history on surviving recordwhen the account is submitted with legal name, billing address, primary contact, currency, and payment terms, then the system runs fuzzy deduplication on name, domain, and tax ID, and if no duplicate, creates the account with external_id propagated to downstream systems
Control 3third-party enrichment optional with manual overridewhen enrichment provider returns data, it is applied within 30 seconds
Control 4external_id propagated to all downstream systems on creationnegative) when a required field (legal name, billing address, primary contact, currency, or payment terms) is missing, then creation is rejected with 400 and error code REQUIRED_FIELD_MISSING.
Control 5mandatory fields: legal name, billing address, primary contact, currency, payment termsDuplicate account rate <1% post-deduplication; 100% of customer records carry external_id; enrichment data available within 30 seconds of account creation
Control 6account hierarchy (parent/subsidiary) supportedDuplicate account rate <1% post-deduplication; 100% of customer records carry external_id; enrichment data available within 30 seconds of account creation

Audit evidence is a chain, not a folder.

Evidence layerWhat should be preserved
Business event
A new customer record is initiated by a sales rep post-opportunity-close or by an onboarding specialist. The system checks for existing accounts by company name, domain, tax ID, and phone to surface potential duplicates for manual review. The rep confirms uniqueness or merges into an existing record. The confirmed account record is enriched with data from a configured third-party enrichment provider (e.g., Clearbit, ZoomInfo) and synced to the billing system. A unique external ID anchors the record across ERP, CRM, and billing systems.
Control rulesDuplicate detection using fuzzy match on name, domain, and tax ID with configurable similarity threshold; merge operation preserves full history on surviving record; third-party enrichment optional with manual override; external_id propagated to all downstream systems on creation; mandatory fields: legal name, billing address, primary contact, currency, payment terms; account hierarchy (parent/subsidiary) supported; GDPR/CCPA data residency flag; change history on all fields with actor and timestamp
Acceptance proofGiven a sales rep creating a new customer post-opportunity-close; when the account is submitted with legal name, billing address, primary contact, currency, and payment terms, then the system runs fuzzy deduplication on name, domain, and tax ID, and if no duplicate, creates the account with external_id propagated to downstream systems; when enrichment provider returns data, it is applied within 30 seconds; (negative) when a required field (legal name, billing address, primary contact, currency, or payment terms) is missing, then creation is rejected with 400 and error code REQUIRED_FIELD_MISSING.
Data record
customer { id: string (cust_*), external_id: string, legal_name: string, domain: string, tax_id: string, billing_address_id: string, primary_contact_id: string, currency_code: char(3), payment_terms: string, parent_account_id: string, gdpr_flag: bool, status: enum(ACTIVE, INACTIVE), created_at: timestamp };
dedup_candidate { id, source_id, match_score, matched_fields: array };
(reference, product may differ).
System event
POST /v1/customers { external_id, legal_name, domain, tax_id, billing_address, primary_contact, currency_code, payment_terms } -> 201 { id, dedup_candidates: [] };
POST /v1/customers/{id}/merge { surviving_id } -> 200;
GET /v1/customers/{id};
emits customer.created, customer.merged, customer.enriched events;
idempotent via external_id.
Lifecycle state
PENDING_DEDUP -> ACTIVE | MERGED;
terminal INACTIVE, MERGED;
guard: ACTIVE requires all mandatory fields populated;
MERGED preserves history on surviving record;
INACTIVE blocks new orders;
external_id immutable after creation.

The useful version of this workflow is not only fast. It is inspectable. A controller, auditor, or operator should be able to move from source event to system record to state transition to final business outcome without guessing.

Implementation contracts.

Reference data model

`customer` { id: string (cust_*), external_id: string, legal_name: string, domain: string, tax_id: string, billing_address_id: string, primary_contact_id: string, currency_code: char(3), payment_terms: string, parent_account_id: string, gdpr_flag: bool, status: enum(ACTIVE, INACTIVE), created_at: timestamp }; `dedup_candidate` { id, source_id, match_score, matched_fields: array }; (reference, product may differ).

API and events

`POST /v1/customers` { external_id, legal_name, domain, tax_id, billing_address, primary_contact, currency_code, payment_terms } -> 201 { id, dedup_candidates: [] }; `POST /v1/customers/{id}/merge` { surviving_id } -> 200; `GET /v1/customers/{id}`; emits `customer.created`, `customer.merged`, `customer.enriched` events; idempotent via `external_id`.

State transitions

`PENDING_DEDUP -> ACTIVE | MERGED`; terminal `INACTIVE`, `MERGED`; guard: ACTIVE requires all mandatory fields populated; MERGED preserves history on surviving record; INACTIVE blocks new orders; external_id immutable after creation.

Common implementation traps.

Treating the workflow as data entry

If the ERP only stores the final record, the team loses the decision trail that explains how the record became valid.

Hiding exception logic

Exceptions need owners, reason codes, and time stamps. A vague pending state is not a control.

Posting without recovery design

Retries, duplicate submissions, and partial failures must be explicit so the system does not create inconsistent records.

Skipping evidence design

A workflow that cannot produce evidence on demand will eventually push finance teams back into manual screenshots and spreadsheets.

Where Rivane fits.

Rivane is built for finance workflows where automation must stay tied to source documents, approvals, state transitions, ledger impact, reporting, and audit evidence. Use this guide as a checklist for evaluating whether an ERP workflow is merely digitized or actually controlled.

References and source basis.

These sources provide the standards, regulatory, or government context around the flow. They are included so the guide is useful to finance operators, auditors, and implementation teams, not only buyers reading software copy.

Back to ERP use cases