← All examples
Technical demonstration · synthetic data

Data reconciliation
between exports or systems

When orders, invoices and warehouse exports disagree, you need to find the affected records. This example lets you inspect each discrepancy and its source.

Try a sample comparison ↓

Compares order, invoice and warehouse exports using explicit rules. The result identifies the record, discrepancy and recommended next action.

●
Browser-side processingData is processed locally in the browser and is not sent to a server.
Input

CSV: orders, invoices, warehouse.

How the check works

Matching keys and deterministic field comparison.

What the system detects

Missing records, duplicates and inconsistent amounts, quantities and statuses.

What you receive

Record, expected and actual values, evidence and CSV report.

How the result is accepted

Fixture: 120 records, 18 agreed discrepancies; export matches the result.

Controlled change: invoice INV-2001 amount increases by 12.50 while order ORD-1001 amount stays unchanged.

Data sources

Run validation

You can use the built-in dataset or upload a matching set of three files.

≋

The result will appear here

The built-in set contains 120 records and intentionally added edge cases.

What this example demonstrates

From input file to acceptance criterion

The demonstration rules are examples. For a real scope, they are defined from the company's processes and data.

01 · Input

3 CSV exports

Orders, invoices and inventory issues with shared identifiers.

02 · Rules

Explicit comparisons

Uniqueness, completeness and consistency of quantities, amounts, statuses, dates and SKUs.

03 · Result

Exception report

Filters, priority, reason, comparison values and next action.

04 · Acceptance

Measurable result

A stable test-set result, detection of every seeded error and a matching CSV export.

Implementation scope

Validator for a specific process

2–3 exports → agreed matching rules → validator → discrepancy report → acceptance on an agreed sample.

The scope can run locally, cyclically or as part of an existing process depending on data and system constraints.

Have a similar problem?

Describe how the process works in your company. No technical specification or introductory call is required.

Describe your problem →

If I sent you this example by email, you can simply reply there.