Worked example · Synthetic data
Compare two order exports by record ID
See which records need review before you try your own files. These invented CSV exports are the same sample included in the free demo; they contain no customer information.
Header rows are not counted
ORDER-001 and ORDER-008
Different categories, explained below
1. Start with the same comparison scope
For a real check, use the same reporting period, export filters, record granularity and amount basis on both sides. Compare one record ID per order or invoice; this version does not consolidate line items or split invoices. A difference in two exports is not proof of an error or financial loss.
2. Get the files and map the fields
Download the left order export (8 rows) · Download the right order export (7 rows) · Download the expected report
Choose Load synthetic sample to use these exact inputs, or select the two downloaded CSVs. For both sources, select the comma delimiter and dot decimal separator. Map the record key to record_id, amount to amount, and currency to currency. The description column is context, not a comparison field. Choose Compare exports.
3. Review each outcome
| Record ID | Outcome | What to check |
|---|---|---|
| ORDER-001 | Match | 1250.00 NOK and 1250 NOK are the same decimal amount. |
| ORDER-002 | Amount differs | 450.00 → 475.00 NOK. Review the amount basis and source record. |
| ORDER-003 | Currency differs | The amount is 80.00 on both sides, but EUR changes to NOK. No currency conversion is performed. |
| ORDER-004 | Only on left | 99.00 NOK appears only in the left export. Check dates and filters before treating it as missing from a source system. |
| ORDER-005 | Duplicate left key | The left export has 20.00 and 30.00 NOK for the same key; the right has 50.00 NOK. The tool does not add 20 + 30 or match this key. Both sides are excluded until the duplicate is resolved. |
| ORDER-006 | Only on right | 60.00 NOK appears only in the right export. Check dates and filters. |
| ORDER-007 | Invalid left amount | The left amount is the text “invalid”; the right has 10.00 NOK. This key is excluded from matching on both sides. It is not classified as a missing order. |
| ORDER-008 | Match | −12.50 NOK and −12.500 NOK are the same signed decimal value. |
The review consists of one invalid row, one duplicate-key entry, one amount difference, one currency difference and two one-sided records. Two keys are excluded from matching because of the duplicate and invalid amount. No duplicates are summed, and no financial totals are inferred.
4. Compare your downloaded report
The expected CSV was generated by the same comparison engine as the demo. It includes all 8 report entries: 2 matches and 6 review entries. Changing the visible filter does not narrow the downloaded report. Source row numbers include the header as row 1.
The report protects spreadsheet cells that start with formula-like characters. For example, a negative amount may be prefixed with an apostrophe in the CSV; this is an export safeguard, not a change to the comparison result.
Try a workflow you repeat
Once the sample makes sense, try two small, non-confidential exports with a shared record key. The demo accepts 50 rows and 2 MiB per source. For other delimiters, decimal commas and mapping profiles, read the format guide.