# MIS reconciliation report

Orders reviewed: **9**. Matched: **4**. Mismatched: **5**. Rejected source rows: **5**.

Sources are CSV snapshots; these findings do not update a ledger or authorize transactions.

## Currency totals

| Currency | Stated total | Line total | Net payments | Line delta | Payment delta |
| --- | ---: | ---: | ---: | ---: | ---: |
| USD | 1245.48 | 1175.48 | 1099.98 | -70.00 | -145.50 |

## Order review queue

| Order | Status | Line delta | Payment delta | Source |
| --- | --- | ---: | ---: | --- |
| ORD1003 | LINE_AND_PAYMENT_MISMATCH | -10.00 USD | -10.00 USD | orders.csv:5 |
| ORD1004 | PAYMENT_MISMATCH | 0.00 USD | -40.00 USD | orders.csv:6 |
| ORD1005 | PAYMENT_MISMATCH | 0.00 USD | -20.00 USD | orders.csv:7 |
| ORD1007 | PAYMENT_MISMATCH | 0.00 USD | -75.50 USD | orders.csv:9 |
| ORD1009 | LINE_MISMATCH | -60.00 USD | 0.00 USD | orders.csv:11 |

## Rejected source rows

| Source | Entity | Reason |
| --- | --- | --- |
| orders.csv:12 | ORD_BAD | INVALID_ORDER_DATE: expected calendar date YYYY-MM-DD |
| line_items.csv:14 | L1012 | INVALID_QUANTITY: expected integer from 1 to 1000000 |
| line_items.csv:15 | L_ORPHAN | ORPHAN_ORDER: referenced order is absent, invalid or ambiguous |
| payments.csv:12 | P_DUP | DUPLICATE_ID_REVISION: ambiguous source rows; no deduplication guess |
| payments.csv:13 | P_DUP | DUPLICATE_ID_REVISION: ambiguous source rows; no deduplication guess |

## Interpretation

- Negative payment delta means net payments are below the stated order value.
- Refund events subtract from settlement; an order total is never silently revised.
- Missing lines are findings even when the stated order value is zero.
- Highest revisions must be valid and unambiguous; older versions are not fallback data.
- Line items and payments were independently aggregated before joining; currencies remain separate.
- 0 source rows had a half-up money rounding warning; inspect lineage.csv.
- Read lineage.csv for every raw row, rejected/superseded decision and normalized value.