ERP Data Quality Scorecard Worksheet
A scorecard gives managers one page that says how healthy each master data domain is. Enter record counts from your data quality checks and the worksheet calculates completeness, validity, uniqueness and a score per domain.
| Domain | Active records | Complete records | Valid records | Non-duplicate records | Completeness | Validity | Uniqueness | Domain score | |
|---|---|---|---|---|---|---|---|---|---|
91.8% | 96.2% | 95.7% | 94.6% | ||||||
92.6% | 96.7% | 94.4% | 94.6% | ||||||
93.1% | 96.7% | 94.7% | 94.8% | ||||||
94.2% | 93.3% | 100% | 95.8% | ||||||
89.6% | 93.8% | 100% | 94.4% |
Counts come from your rule runs: complete means all mandatory fields filled, valid means formats and lists pass, non-duplicate means not flagged as a likely duplicate. The domain score is a simple equal-weighted average. Weight dimensions if your policy requires.
Automated data quality scorecard
Want the scorecard populated from your ERP data on a schedule? Request an expert review of your data and ERP.
Optional. The tool and every export work without this. No spam.
How to fill it in
Add one row per domain such as items, vendors, customers, BOMs and routings. Use active records only, because inactive history inflates counts and hides problems. Take the complete, valid and non-duplicate counts from your rule runs. Completeness is complete records divided by active records. Validity and uniqueness follow the same pattern. Each percentage is shown per row and averaged into a domain score.
- Count active records only
- Use the same rules each period
- Record the run date in the notes
- Keep the previous period's file for trends
Reading the score
Do not treat the score as a grade. Use it to compare domains and track movement. A 94% completeness on 18,400 items still means over a thousand items with a missing mandatory field, which may include fast moving parts. Combine the scorecard with a defect log that lists the actual records and owners, and prioritize by business impact.
Choosing what to measure
Measures should reflect decisions. For items, completeness of planning attributes such as lead time, UoM and planner code drives MRP. For vendors, tax ID and bank data drive payments and compliance. For BOMs, consistency such as no inactive components drives costing and shop floor releases. Define each measure once in your rule catalog so the numbers are comparable between periods.
Common mistakes
Changing rules between periods, which makes trends meaningless, counting a record as complete when a field holds a placeholder such as TBD or 999, and reporting one big percentage that hides a bad domain. Check for placeholder values in your completeness rule.
Frequently Asked Questions
What is a good data quality score?
There is no universal target. Many teams aim for the high 90s on critical fields and accept lower scores on optional attributes. Set targets by business impact and raise them over time.
Should the dimensions be weighted?
Equal weighting is a fair starting point. If duplicates are far more costly than blank optional fields in your business, weight uniqueness higher and document the choice.
How often should I update the scorecard?
Monthly is common for governance reviews, with weekly rule runs feeding it. Daily runs suit high volume creation and migration cutovers.
Can I add more dimensions?
Yes. Export to Excel and add columns for consistency or timeliness, then include them in the domain score formula.
If the counts are gathered by hand each month, we can run the checks against your ERP read-only and populate this scorecard automatically.
Related Tools
Master Data Quality Rules Catalog Worksheet
An editable catalog of data quality rules with check type, threshold, owner and run frequency.
ERP OperationsData Cleansing Defect Log Worksheet
Log each data quality defect with the affected records, severity, owner, effort and status, and see the total cleanup effort and cost.
Costing & FinancePoor Master Data Quality Cost Calculator
Estimate the annual cost of master data errors from rework time, expediting and stewardship, and see how it scales with error rate.
ERP OperationsData Steward Role Description Template
A role description for the ERP master data steward: purpose, duties, authority, KPIs and escalation.
More ERP Operations tools
See allKeep exploring
Free tools
- Distributor Vendor Performance Scorecard WorksheetAn editable vendor scorecard that turns PO line counts into on-time, complete and accuracy percentages and a weighted score you can rank and export.
- Packaging Supplier Scorecard WorksheetAn editable scorecard that weights quality, on-time delivery, price, responsiveness and compliance into one score per packaging supplier.
- Carrier Performance Scorecard WorksheetAn editable carrier scorecard that computes on-time %, damage % and cost per shipment from monthly counts. Exports to Excel.
ERP fixes and how-tos
- How to Score ERP AI Vendors in an RFPBuild a defensible scoring model for ERP and AI bids: pass/fail gates, weighted criteria, scoring scales, evidence rules, and how to avoid demo bias and ties.
- How to Build NetSuite Dashboards and KPI ScorecardsHow to build NetSuite dashboards with KPI, KPI Scorecard, and saved search portlets, set comparison periods, and share dashboards by role.
Guides
- Infor LN Domain Administration GuideAdminister Infor LN domains effectively. Domain architecture, user management, environment configuration, and system maintenance best practices.
- How to Configure Vendor Qualification in SyteLineLearn how to set up vendor qualification and approved supplier management in Infor SyteLine. Configure vendor assessments, quality scorecards, approval workflows, and ongoing performance monitoring.
- Infor LN Domain Structure Design: Architecture GuideDesign robust Infor LN domain structures including data dictionary domains, table relationships, key definitions, and index strategies for BAAN/LN development.