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 left record_id to right order_id, left amount amount to right total, and left currency currency to right ccy. Add text pairs status → state and quantity → qty. The description column remains unselected and is visibly disclosed as not compared. Text comparisons preserve spaces, case and leading zeros. Choose Compare exports.
3. Review each outcome
| Record ID | Outcome | What to check |
|---|---|---|
| ORDER-001 | Mapped fields match | 1250.00 NOK and 1250 NOK are the same decimal amount. |
| ORDER-002 | Multiple fields differ | Amount: 450.00 → 475.00 NOK. Status: pending → paid. Quantity: 1 → 3. The text headers differ across files; the report shows both names and values. |
| 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 record with amount, status and quantity differences, 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. Use Export current view for the current key search and status filter across all pages. Download full report always includes every entry. 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 500 rows and 2 MiB per source, from CSV or Excel files. For other delimiters, decimal commas and mapping profiles, read the format guide. Reconciling order or invoice exports every month? Work through the reconciliation checklist.