Inventory reconciliation
A corrected CSV with an exceptions log and a record of each formatting change.
Synthetic sample. All 12 input records were created for this demonstration.
12source records
8retained records
1exact duplicate
3unresolved records
What changed
Item codes and locations were trimmed and capitalized. A thousands separator was removed from one quantity. One exact duplicate was linked to its retained source record.
Missing quantities, negative quantities and a unit price with excess decimal precision were excluded for clarification. No replacement values were invented. The eight retained rows total 1,251 units and $840.15; that subtotal excludes unresolved rows.
| Source ID | Input | Result |
|---|---|---|
| I02 | “ tc-101 ”, location “a1” | TC-101, A1 |
| I04 | Exact duplicate of I03 | Excluded; linked to I03 |
| I05 | Missing quantity | Needs clarification |
| I07 | Unit cost 19.995 | Needs clarification; no rounding assumed |
| I08 | Quantity “1,200” | 1200 |