Before / after preview

Representative rows show the cleanup shape.

The downloadable files carry the complete synthetic sample. This table keeps the public proof scannable.

Before vendorBefore termsAfter vendorAfter terms
ACME SuppliesNet 30ACME SuppliesNet 30
Acme Supply Co.N30excludedalias duplicate
Contoso FreightImmediateContoso FreightDue on receipt

Change summary

Changes and unresolved review items stay visible.

A strong sample does not pretend all issues are automatically safe to fix.

Vendor ID cleanup

5 values

Converted mixed vendor identifiers to standard IDs.

Payment term cleanup

4 values

Standardized N30, 30 days, Net45, and Immediate terms.

Country cleanup

5 values

Converted country aliases into short normalized values.

Rows excluded

2 rows

Excluded one alias duplicate and one summary row from the clean export.

Conflicts kept

4 items

Missing tax ID, missing bank reference, and Globex duplicate candidate remain for review.

Output families

The readiness verdict changes by downstream purpose.

A sample can be useful for operations and still blocked for AI.

Output

Use this for

What it contains

Operational Clean Export

Daily spreadsheet work

Clean CSV/XLSX, source row IDs, removed-row summary, review list

Compliance-Safe Export

Safer sharing

Masked direct PII, restricted notes, and sensitivity caveats

Reporting Package

Dashboards and month-end reporting

Clean table, column profile, issue log, and readiness summary

AI Package

Business search and assistant setup

Structured records, PII report, and blocked/partial reasons when unsafe

Audit Trail Bundle

Review and traceability

Change history, check results, review decisions, and anything still unavailable

Try this pattern on your own recurring file.

Use the free scanner first, then create a workspace when you need full cleanup, downloadable files, and review history.