ERP Migration & SelectionFree worksheetPDF, Excel, Word exportChina

China ERP Data Cleansing Tracker Worksheet

Most China ERP projects slip on data, not software. This tracker gives each load object an owner, an error rate and a clear fix percentage so the steering group sees real progress before cutover.

Download:
Data objectOwnerRecords in legacyRecords with errorsErrors fixedError rateErrors openFix progressStatusTarget date
11.4%
600
71.4%
24.8%
0
100%
7.5%
120
33.3%
16.4%
520
18.8%
5.3%
40
0%
Total records
26,710
Total errors
3,270
Open errors
1,280
Overall error rate
12.2%
Overall fix progress
60.9%

Count an error once per record. Add a row for each load object such as work centres, routings, opening balances and fixed assets. Chinese and English names should be in separate fields in the load file.

Migration data review

Optional: share a sample extract and we will suggest validation rules for your target ERP.

Optional. The tool and every export work without this. No spam.

How to use it

List every data object you will load: materials, vendors, customers, BOMs, routings, open orders, opening balances and fixed assets. Enter record counts from the legacy system and error counts from your validation checks. Update fixed counts weekly. The calculated columns show error rate, open errors and fix progress, and the summary gives one overall number for the status report.

What counts as an error

Use rules agreed with the business before you count. Typical rules are duplicate keys, missing unit of measure, missing tax code, inactive references, wrong decimal precision and mixed Chinese and English descriptions. Agree on a threshold such as signing off an object only when open errors are zero, or when the remaining errors are explicitly accepted by the owner.

  • Duplicate vendors and customers
  • Materials without unit of measure or category
  • BOMs referencing obsolete components
  • Open orders with closed vendors

Common mistakes

Teams count errors once at the start and never again, so the percentage looks fine until a trial load. Re-run validation after each mock load and update the row. Another mistake is letting IT own all fixes; business owners know which duplicate is correct. Keep the owner column filled with a named person, not a department.

Frequently Asked Questions

Can I use this for non-Chinese ERPs?

Yes. The structure fits any migration. The China angle is the guidance on bilingual names, tax codes and fapiao related fields.

How many mock loads should I plan?

Most projects plan at least two or three trial loads before cutover. Update this tracker after each one so trends are visible.

What does fix progress show?

Errors fixed divided by errors found for that object. An object with no errors shows 100 percent.

Does it export to Excel?

Yes, the worksheet exports to Excel and CSV so you can share it with the steering group.

Netray can help build repeatable validation queries against your legacy and target ERP data if the manual counts are getting heavy.

Talk to an ExpertExplore More Free Tools

Related Tools

Country & Tax

China Supplier Onboarding Form Template

A fill-in vendor onboarding form for Chinese suppliers covering legal entity, tax, bank and ERP vendor master fields. Exports a clean document.

ERP Migration & Selection

China ERP Go-Live Cutover Plan Template

A cutover plan form with freeze windows, load sequence, rollback criteria and approvals, written for China plant go-lives.

ERP Migration & Selection

China ERP UAT Test Script Worksheet

An editable UAT tracker with executed and passed counts per script and an overall pass rate for go/no-go.

Costing & Finance

China ERP Chart of Accounts Mapping Worksheet

Map each local account in a Chinese subsidiary to the group account, with opening balance and mapping status for review.

More ERP Migration & Selection tools

See all
Back to All Tools