Check what your agent returned
Clean up a spreadsheet export
Checker 3.0.0 · definition 3 · Changes
Add your agent's three output files. The page checks them against the kit's sample input, in this browser. Nothing is uploaded.
Drop cleaned.csv, exceptions.csv and reconciliation.md here
- cleaned.csv
- exceptions.csv
- reconciliation.md
Try a sample run
Or paste text instead
Checks on the files
- Every row kept
- Original values unchanged
- Field format and values
- IDs keep their leading zeros
- Unknown amounts not turned into numbers
- No currency guessed for row 10
- Row 9 date left as written
- Refund reads as minus 45.00
- Every unclear row logged
- Duplicate and conflict logged as separate problems
- Totals are USD 1,375.49 and EUR 420.00
- Dollars and euros not added together
Stops in this job
Left open
- Rows 7 and 8: one ID, two amounts
- Row 9: is 03/04 March or April?
- Row 10: no currency
- Row 13: amount still TBC
- Row 14: is 1.234,50 one thousand or one?
Already settled
- Row 6: an exact copy of row 5
- Rows 1, 2 and 11: spaces, lower case, a refund in brackets