# Synthetic CSV quality triage
Parsed 6 data records, excluding the header. The quoted note “first, order” remains one field. Required fields and candidate key come from the request, not inference.

## Findings
- Records 1 and 3 share invoice_id A1 and are identical across all four fields. This is one duplicate-key group with one excess occurrence; neither row was removed.
- Record 2 (A2) has a missing amount. It is excluded from amount sums, not converted to zero.
- Record 5 has -5.00 USD, a valid refund under the supplied contract.
- Record 6 has 0.00 EUR, a valid zero amount, included in the EUR total.
- All invoice_id and currency values are present. Five amounts parse as decimal numbers; one is missing; none are invalid. Currency values are USD and EUR.

## Raw totals, duplicates retained
| Currency | Included records | Arithmetic | Raw total | Limitation |
| --- | --- | --- | --- | --- |
| USD | 1, 3, 5 | 10.00 + 10.00 - 5.00 | 15.00 USD | Includes duplicate A1; excludes missing record 2 |
| EUR | 4, 6 | 20.00 + 0.00 | 20.00 EUR | Includes valid zero |

No combined total is meaningful without an explicitly chosen exchange-rate contract. These are raw data totals, not reconciled revenue.

Next actions: confirm whether A1 is a repeated export or a legitimate repeated transaction; obtain the missing A2 amount from its source. Keep the source unchanged until the repair rule is agreed. Reconciliation: 5 numeric amounts + 1 missing + 0 invalid = 6 records.