Interactive controls could not load. Reload this page to try again; the content and guides below are still available.
Reload pageData Studio
Compare two tables by a shared business key for free. Check record counts and amount totals with an absolute tolerance, inspect exceptions and export a full CSV report.
YOUR WORKSPACE
Compare two tables by a shared business key for free. Check record counts and amount totals with an absolute tolerance, inspect exceptions and export a full CSV report.
In the sample, 001 matches. For 002, left amounts 50+20 compare with right 70.01: within 0.02 tolerance, but row counts differ. 003 is left-only and 004 right-only. Leading zeros remain intact.
One file per side, up to 20 MB. Keys cannot be blank; missing or nonnumeric amounts are flagged as invalid. Duplicate-key values are grouped with review notes. Results do not certify accounting agreement, duplicate payment or transaction authenticity. Align currencies and units first.
Its row counts may differ. Counts are checked alongside totals so similar amounts do not hide missing or repeated records.
No. The complete report includes every business key; the exceptions checkbox changes the preview only.
Use this tool for free without a KitNelo account. Processing runs in your browser; input limits, browser support and device memory still apply.
Counts and totals are both checked. Similar totals cannot prove that all underlying records match.
Read KitNelo data and privacy detailsLoad two tables and select a shared business key to group records for comparison. Inspect both group counts and amount totals before accepting a match; equal totals can conceal offsetting differences or different underlying records.
Choose the order key and amount fields, then set an absolute tolerance for the reconciliation. Verify currencies and amount definitions first, since a small numeric difference has no useful meaning when the source columns describe different monetary measures.
Review keys that appear on only one side and groups whose counts suggest repeated records. Export the full CSV exception report and investigate its source rows, rather than assuming that similar aggregate amounts prove every individual order matches.
