# Cleanup reconciliation

Designed example · synthetic data. This is a designed output, not a recorded agent run.

## Files

- `cleaned.csv`: all 14 original rows, with normalized person, cost-center, date/amount and review fields added. Every original field remains available.
- `exceptions.csv`: seven rows requiring review.

## Row reconciliation

| Count | Rows |
| --- | ---: |
| Source rows | 14 |
| Retained output rows | 14 |
| Silently deleted rows | 0 |
| Clear rows included in scoped totals | 7 |
| Rows requiring review and excluded from scoped totals | 7 |

The included rows are 1, 2, 3, 4, 5, 11 and 12. Rows 6, 7, 8, 9, 10, 13 and 14 remain in the cleaned file and exceptions log. Leading-zero IDs stay as text.

## Scoped totals

| Currency | Included rows | Amount |
| --- | --- | ---: |
| USD | 1, 2, 4, 5, 11 | 1,375.49 |
| EUR | 3, 12 | 420.00 |

These are totals for clear included records, not final accounting totals. No currency conversion was performed. The refund in row 11 is -45.00 under the sample's stated convention.

## Decisions still needed

- Row 6 duplicates row 5. Confirm whether one should be removed from a later approved working copy; neither was silently deleted.
- Rows 7 and 8 conflict on amount for ID 001006. Confirm the correct record.
- Row 9's date could mean 3 April or 4 March; no locale is supplied.
- Row 10 has no currency.
- Row 13's amount is TBC; it is not zero.
- Row 14's amount uses an unconfirmed locale; the original 1.234,50 is preserved.

Before using these numbers, review the exception decisions and open the CSV in a tool that preserves IDs as text.