Supplier master data

Supplier master data.Ready for migration and integration.

Establish which businesses your records represent, how they connect across systems and what needs to improve for migration, integration or reliable spend reporting.

Start with a scoped supplier data assessment. A quality baseline, evidenced record decisions and a practical plan for the work ahead.

01 / What your data needs to support

Ready for change.
Useful in daily decisions.

A migration needs sound mapping decisions. Procurement needs an accurate view of suppliers. A cleansing project needs a plan that reflects the work.

Before migration or integrationKnow what must move, align or remain local.

An ERP and procurement platform may hold the same supplier under different names and IDs. Establish the common legal identity, retain the source links and decide which attributes synchronise and which operating arrangements stay local.

The useful output: reconciled source-to-target mappings, explicit record decisions and checks against the agreed target requirements.

How the data informs system requirements ↗

For procurement and spend reportingSee legal entities and supplier relationships behind the accounts.

Several accounts can represent one business; several separate businesses can belong to an evidenced supplier group. These are different relationships and should remain distinguishable.

The useful output: spend connected to entities and groups, traceable to the original transactions. Category teams can review the wider commercial relationship on a sounder basis.

See the spend behind supplier records ↗

During a cleansing programmeTurn findings into work that can be planned and managed.

A backlog count does not show the supplier enquiries, internal decisions or transaction dependencies involved. Separate work supported by existing evidence from work waiting for supplier responses, and plan capacity accordingly.

The useful output: a prioritised delivery plan and reporting that distinguishes verified corrections from new, reopened and newly discovered issues in the live data.

Plan cleansing around the actual work ↗

02 / Start with an assessment

A clear baseline.
An actionable plan.

Agree the purpose and supplier population. Datanovel turns the findings into evidence, record decisions and prioritised work.

The systems, fields, sources and deliverables are agreed around your project. The outputs below are tailored to that scope.

Discuss the scope
Quality and readiness baselineApplicable field checks, unresolved exceptions and the evidence behind them.

Define what good data means for the intended use, supplier jurisdiction and operating purpose. Report completeness, validation and external verification separately, with the applicable population behind each measure.

You receive a baseline and an exception register connecting each issue to the affected record, check and available source evidence. Unresolved checks remain visible.

How quality is measured ↗

Supplier identity and relationship mapLegal entities, cross-system overlap and justified operating accounts.

Connect records to evidenced legal entities while preserving source IDs and transaction traceability. Distinguish purposeful site, currency or payment arrangements from unnecessary records.

Where in scope, map separately evidenced corporate or other supplier relationships. A shared name, bank detail or tax grouping is not treated as proof that records are the same legal entity.

How many suppliers are behind the records? ↗

Record decisions with dependenciesWhat to retain, link, correct, restrict or review for retirement.

Give each proposed action a reason, evidence and an accountable owner. Uncertain matches remain investigations. Useful operating accounts can stay separate while sharing an aligned identity.

Review open orders, invoices and other dependencies before retirement. Restricting new use and closing an account after its obligations are resolved can be separate decisions, subject to your approval process.

Necessary records or unnecessary duplicates? ↗

Prioritised improvement planActivities, owners, capacity assumptions and acceptance checks.

Translate findings into the agreed target mappings and cleansing work. Separate supplier enquiries from internal corrections, identify dependencies and estimate effort and elapsed time using the activities and capacity available.

You receive a proposed sequence of work and acceptance criteria, giving the project team a practical basis for agreeing delivery and tracking readiness.

Plan the capacity needed for delivery ↗

03 / From findings to delivery

Put the plan
into practice.

Use the assessment to commission the work your project needs. Datanovel can lead the agreed cleansing and mapping work with your team, then establish continuing controls.

Plan and manage the cleansing programmeWork allocation, supplier enquiries, decisions and source-system corrections.

Organise enquiries around the supplier identity so accepted evidence can be reused across linked records. Coordinate the approved corrections, accountable decisions and supplier response dependencies with your team.

Manage the activity plan and capacity; validate completed work in the live source records. Progress reporting shows gross closures, incoming issues and net improvement, giving the project team a basis for adjusting priorities and resources.

How cleansing progress is measured ↗

Implement the agreed mappings and checksSupport migration and integration with traceable record decisions.

Carry the agreed identities, retained records and relationships into source-to-target mappings. Define which shared attributes align, which remain local and how unresolved cases are handled.

Implement and test the agreed mappings and quality checks with the client project team, against the target requirements and acceptance criteria.

How useful records stay connected ↗

Keep quality visible after the projectRecurring checks, accountable exceptions and better input processes.

Agree the ongoing measures and ownership. Monitor relevant supplier changes and recurring issues, and connect exceptions to follow-up rather than relying on a headline quality score.

Use the findings to improve onboarding and change processes. New issues remain visible alongside completed corrections so reporting reflects sustained improvement in the operating data.

Improve the process behind the records ↗

Delivered in your existing environmentYour approved platforms, your processes and your team.

Datanovel implements the agreed checks, mappings, workflows and reporting in your existing ERP, procurement, master-data, workflow or analytics environment, according to the capabilities available.

The assessment confirms data access, integration requirements, approved evidence sources and operational ownership. Procurement, finance and technology teams are involved in decisions, delivery and handover.

See the data issues. Manage the improvement.

Follow quality by field, understand supplier identities and relationships across systems, and track cleansing progress alongside the new issues that still need attention.

Explore the supplier data quality dashboardsField-level quality, supplier records, relationships and cleansing performance.
Supplier master data qualityDatanovelReport

Supplier master data quality

Four agreed field goals · reporting week 4

01 / 06
VAT / tax identity verified91.3%2,920 / 3,200 applicable records
Purchasing email checked86.5%3,200 / 3,700 required records
Remittance email checked76.8%2,610 / 3,400 required records
Registration verified63.2%2,400 / 3,800 applicable records

Verified / checked field coverage

Same applicable cohort at every snapshot

025507510004 Sep11 Sep18 Sep25 Sep02 Oct
  • VAT / tax identity
  • Purchasing email
  • Remittance email
  • Company registration

Percent of applicable records

Remaining field exceptions

One record can have several field exceptions

Goal status

Completeness, validity and evidence requirements are defined separately for each field.

Goal status
GoalApplicable recordsVerified / checkedOpen exceptionsFour-week gainForecast
VAT / tax identity3,2002,920 (91.3%)280+40023 Oct
Purchasing email3,7003,200 (86.5%)500+68023 Oct
Remittance email3,4002,610 (76.8%)790+69006 Nov
Company registration3,8002,400 (63.2%)1,400+80020 Nov
Forecasts use recent net improvement and a comparable case mix; supplier responses remain a dependency.
Coverage by field uses its agreed evidence and applicable population.
Supplier master data qualityDatanovelReport

Field checks and the correction queue

From missing or inconsistent data to a named next action

02 / 06
Open field exceptions2,970Across four field goals; records can repeat
Records with ≥1 field issue1,56039.0% of the 4,000-record cohort
Missing required values1,860VAT, registration and required contact routes
Invalid values130Format or issuer check failed

Why a field is still open

A field exception has one primary reason

  • Missing1,860
  • Invalid130
  • Name mismatch480
  • Inactive email500

Registration exceptions by jurisdiction

Count / applicable registration population

Country and field matrix

Exceptions / applicable records · requirements follow jurisdiction and operating purpose.

Country and field matrix
JurisdictionSource recordsVAT / taxPurchasing emailRemittance emailRegistration
United Kingdom1,600100 / 1,280200 / 1,480310 / 1,360500 / 1,540
Germany1,00080 / 850120 / 940200 / 870400 / 950
Netherlands80060 / 650100 / 740160 / 690300 / 750
Ireland60040 / 42080 / 540120 / 480200 / 560
Counts across fields cannot be added to obtain a distinct supplier or record count.

Record exception log

Selected records from the live correction queue · owner and next action

Record exception log
Record IDSupplier / accountSystem / countryFieldExceptionOwnerNext action
A-1007Aldermere Service Parts LtdERP A · UKVAT / taxMissing required valueRiya PatelConfirm applicability with tax owner; obtain issuer evidence
B-0448Northwick Industrial Trading LtdP2P B · UKVAT / taxRegistered name differsTom WhitbyResolve trading name against registration evidence
A-1124Plenthorpe Facilities LtdERP A · UKPurchasing emailMailbox no longer activeHannah ReedRelationship owner to confirm the current ordering route
B-0836Bergtal Technical Services GmbHP2P B · DEPurchasing emailInvalid email formatLena FischerCheck the approved source; update and retest
A-1432Westmere Logistics BVERP A · NLRemittance emailMissing required valueNoor de VriesConfirm AP contact using the approved enquiry process
B-1228Ardwell Packaging LtdP2P B · IERemittance emailMailbox over quotaAisling ByrneAsk supplier finance for an operational contact route
A-1710Bergtal Service Components GmbHERP A · DERegistrationIdentifier cannot be validatedLena FischerCheck jurisdiction and identifier against the registry
B-1364Marshfield Workplace LtdP2P B · IERegistrationRecorded legal name differsAisling ByrneConfirm legal entity, update name and retest linked records
Resolve name mismatches against identity evidence before changing or joining a record.
Supplier master data qualityDatanovelReport

Supplier identity across systems

Same legal entity, distinct operating accounts and synchronised shared attributes

03 / 06
Source records4,0002,400 ERP A + 1,600 P2P B
Evidenced legal entities2,600100 unresolved records held outside this count
Entities in both systems7001,900 + 1,400 − 700 = 2,600
Pairs needing shared-field work400900 / 1,300 known pairs consistent

Legal-entity overlap

Distinct entity sets after evidenced matching

  • ERP A only1,200
  • Both systems700
  • P2P B only700

Known and consistent record pairs

Improved registration reveals more pairs as well as closing work

05001000150004 Sep11 Sep18 Sep25 Sep02 Oct
  • Known pairs
  • Consistent pairs

Record pairs

Record-pair consistency matrix

Consistent / known pairs · shared fields only; preserve justified local differences.

Record-pair consistency matrix
SystemERP AP2P B
ERP A300 / 440500 / 700
P2P B500 / 700100 / 160
The mirrored A–B cell is counted once: 900 consistent + 400 requiring work = 1,300 known pairs.

Source population bridge

Records and legal entities answer different questions.

Source population bridge
SourceRecordsIdentity resolvedLegal entitiesUnresolved records
ERP A2,4002,3401,90060
P2P B1,6001,5601,40040
600 additional records occur within a system; 700 further record appearances are the cross-system overlap.

Identity and account decision log

Examples of mapping decisions used for migration, integration and ongoing synchronisation.

Identity and account decision log
Source IDsSupplier / operating purposeEvidenceAccount decisionOwner / action
A-2010 + B-0762Ternvale Engineering Ltd · central buyingSame registry identityConverge common identity; retain source-ID traceRiya Patel · align tax attributes
A-0672 + A-0673Ternvale Engineering Ltd · UK / EUR accountSame entity; approved currency purposeKeep both accounts; synchronise shared legal fieldsTom Whitby · preserve local currency
A-0840 + B-0390Elmstead Packaging Ltd · same operating purposeSame registration and approved account purposeOne target account; preserve both source mappingsHannah Reed · approve target mapping
B-1081 + B-1082Westmere Logistics BV · two approved sitesSame entity; separate site orderingRetain site accounts and legal-entity linkNoor de Vries · repair missing link
A-1603 + A-1705Ormond Digital Services Ltd · redundant accountIdentity confirmed; open invoice on A-1705Hold new buying; retain until open item closesTom Whitby · review close-out dependency
A-1940 + B-1436Bracken Technical Ltd / Bracken Services LtdSimilar names; identity unresolvedKeep separate; investigate before mergingRiya Patel · obtain identity evidence
Anchor mappings count each additional record once. Preserve approved site, currency and contact differences.
Supplier master data qualityDatanovelReport

Supplier relationships and consolidated spend

Make evidenced family links visible without merging separate legal entities

04 / 06
Confirmed links not recorded100280 confirmed relationship links; 180 recorded
Existing links unconfirmed20Review before retaining in the reporting hierarchy
Entities needing consolidation work330110 identity-link + 260 relationship − 40 overlap
Spend requiring link review£6.5mMeasured within £24.0m reviewed invoice spend

Missing evidenced relationship links

Typed relationships between distinct legal entities

Entities affected by reporting links

De-duplicated union; each entity is counted once

  • Identity links only70
  • Relationships only220
  • Both40

Relationship coverage

Confirmed typed links require the appropriate reporting hierarchy and owner approval.

Relationship coverage
RelationshipConfirmedRecordedMissingReporting action
Direct parent1309040Add evidenced ownership link
Ultimate parent603525Connect the group reporting hierarchy
VAT group604020Maintain as a tax-group relationship
Common control301515Record the relationship; retain separate entities
Twenty additional existing links lack current evidence and require separate review.

Relationship evidence and decision log

Selected cases for the spend-reporting owner and category manager

Relationship evidence and decision log
SupplierRelated entityEvidence / findingERP / reporting statusOwner / next action
Elmstead Packaging LtdElmstead Materials Group plcREG-024 · direct parent confirmedOwnership link missingHannah Reed · approve and load link
Bergtal Technical Services GmbHBergtal Industries GmbHREG-061 · ultimate parent confirmedLocal link onlyLena Fischer · complete group hierarchy
Westmere Logistics BVWestmere Freight BVTAX-018 · group membership evidencedVAT-group link missingNoor de Vries · preserve entity IDs and add group
Bracken Technical LtdBracken Services LtdREG-072 · common control confirmedRelationship missingRiya Patel · add typed link; do not merge
Ormond Digital Services LtdOrmond Holdings plcOld parent link; current evidence absentExisting link unconfirmedTom Whitby · resolve before reporting as group
Ardwell Packaging LtdMarshfield Workplace LtdShared payment detail; no relationship establishedEvidence lead onlyAisling Byrne · investigate; no group link inferred

Spend affected by missing links

Invoice spend associated with affected entities; overlap is subtracted.

Spend affected by missing links
Issue populationEntitiesReviewed spend
Unlinked operating / identity records110£2.4m
Missing group relationships260£5.2m
Overlap in both issue populations40£1.1m
Combined, counted once330£6.5m
This is spend requiring consolidation review, not a calculated saving.
Affected spend identifies the scope of link review; category teams assess any commercial opportunity.
Supplier master data qualityDatanovelReport

Cleansing delivery and new issues

Weekly management summary · field checks and record-pair consistency

05 / 06
Open check exceptions3,3702,970 fields + 400 pair-consistency checks
Validated closures this week770680 field checks + 90 record pairs
Incoming / reopened checks250120 intake + 40 reopened + 90 pairs revealed
Net backlog reduction5203,890 last week → 3,370 current

Open checks by reporting week

Fixed field cohorts; pair scope expands as identities are established

020004000600004 Sep11 Sep18 Sep25 Sep02 Oct
  • Open checks

Open check exceptions

Validated closures this week

Records are updated and retested before a check closes

Weekly goal delivery

Gross completion and incoming work remain separate.

Weekly goal delivery
GoalOpenClosed this weekNew / reopenedAvg. net per weekConditional forecast
VAT / tax identity28011020 / 1010023 Oct
Purchasing email50018040 / 1017023 Oct
Remittance email79017025 / 15172.506 Nov
Company registration1,40022035 / 520020 Nov
Pair consistency4009090 revealed / 00Reassess scope; no current finish date
Four-week field averages include new and reopened checks. Pair discovery can offset valid progress.

Cleansing work and escalation queue

Selected work packages; one lead owner reuses evidence across linked records.

Cleansing work and escalation queue
CaseSupplier / recordsWork typeAge / dependencyOwnerNext action
DQ-0407Aldermere Service Parts · A-1007Supplier tax enquiry9 working days · evidence pendingRiya PatelRelationship owner to chase the agreed enquiry
DQ-0411Westmere Logistics · A-1432 + B-0312Remittance contact enquiry14 working days · supplier responseNoor de VriesEscalate through the supplier relationship owner
DQ-0418Bergtal Service Components · A-1710Registry / identity check3 working days · analyst reviewLena FischerConfirm correct identifier; update and retest
DQ-0422Elmstead Packaging · A-0840 + B-0390Cross-system synchronisation4 working days · owner approvalHannah ReedApprove common attributes; retain source mapping
DQ-0426Ormond Digital Services · A-1705Redundant account close-out12 working days · open invoiceTom WhitbyRetain account until AP confirms the dependency closed
DQ-0430Newly created records · intake batchNew-issue prevention120 field issues this weekMDM process ownerReview intake requirements and issuer-check controls
Closures are retested in the source systems. Forecasts use recent net pace; newly discovered pairs are tracked separately from intake defects.
Supplier master data qualityDatanovelReport

Operating records and unnecessary duplicates

Keep a useful operating account; prevent new buying against records that need review

06 / 06
Records for status decision300200 redundant + 60 inactive-entity + 40 drafts
Open-item dependencies6250 redundant accounts + 12 inactive-entity records
Old incomplete drafts32Older than four weeks; 8 recent drafts separate
Primary records with old names52Update before another duplicate is created

Extra accounts within a system

600 extra records · a purpose is different from consistency

  • Purposeful and linked280
  • Purposeful; link missing120
  • Redundant200

Status-review records by jurisdiction

Distinct 300-record decision population

Record decisions and dependencies

Distinct populations in the 300-record review; the 52-name prevention list is separate.

Record decisions and dependencies
Record populationRecordsOwnerRequired decision / dependency
Redundant · no open item150MDM + business ownerApprove retirement; preserve audit and source-ID links
Redundant · open item50AP + MDMHold new buying; retain until obligations close
Inactive legal entity60Procurement + finance55 entities; review status and hold; 12 records have open items
Incomplete draft · older than four weeks32Onboarding ownerPrevent selection; confirm whether the request is still needed
Incomplete draft · recent8Onboarding ownerFinish approved onboarding or withdraw the request
Old name on primary account · separate list52MDM identity ownerConfirm registered identity and update the canonical name
Ninety of the 200 redundant accounts use outdated names. This subset is not an additional population.

Selected record-management log

Purpose, dependency and a named owner determine the action.

Selected record-management log
Record IDSupplier / accountFindingCurrent restrictionOwner / next action
A-0673Ternvale Engineering Ltd · EURPurposeful currency accountActive · linked to legal identityTom Whitby · preserve operating currency
B-1082Westmere Logistics BV · RotterdamPurposeful site; legal link missingActive · link repair queuedNoor de Vries · add approved identity link
A-1705Ormond Digital Services Ltd · old accountRedundant · invoice openNew buying held; payment remains availableTom Whitby · retire after AP close-out
B-0562Cedarwyn Print Services LtdRegistry status requires reviewNew buying heldRiya Patel · confirm status and open-item handling
A-1908Fenwick Office Services · draftIncomplete request · 37 days oldSelection heldHannah Reed · withdraw or complete approved request
B-1204Ardwell Industrial Supplies LtdPrimary account has former legal nameActive · identity already evidencedAisling Byrne · update name and check alias search
An inactive legal entity and an account with no recent spend are different findings. Payment and transaction-close dependencies must be resolved before full account deactivation.

Illustrative reports based on Datanovel’s reporting approach. All data and supplier names are simulated, not client results.

Datanovel know-how

Explore the decisions behind the data.

Explore 24 practical articles on supplier identity, field quality, system requirements and managed cleansing. Open the area relevant to your project.

Quality and readinessUnderstand what your data can support and where it needs attention. · 5 articles
Supplier identity and spendConnect records, preserve useful differences and see the commercial relationship. · 7 articles
Supplier change and ongoing controlsKeep identity, contacts and verification useful as suppliers change. · 7 articles
Cleansing, migration and capacityPlan the work, implement improvements and measure progress in the live data. · 5 articles

Start with a scoped assessment

What needs to be ready
for your next step?

Discuss the migration, integration, reporting or cleansing priority and the systems involved. Agree an assessment that establishes the data issues, the decisions and the work ahead.

Contact Datanovel on LinkedIn
Andrey Matveev, founder of Datanovel

Andrey Matveev

Founder & Delivery Lead
Datanovel

Experience across supplier data management, procurement analytics and operational reporting, including developing and operating supplier-verification tools.

Andrey leads each engagement directly, with your team involved in delivery.

  • PO Value Signals™

    Act while the order can still be adjusted.

    Targeted follow-up with the PO creator, supported by evidence and a proposed correction.

    Explore PO Value Signals™
  • Supplier Commercial Intelligence

    See the patterns behind supplier value erosion.

    Review recurring pricing, charge and product changes. Give category managers the evidence to act.

    Explore supplier commercial intelligence

Illustrative dashboard

Illustrative data · not client results.