S12: Reconcile recurring management reports
Expected synthetic fixture result
Proposed / not tested

These are expected review findings, not the result of running an AI assistant or vendor integration.

1. Raw source reconciles to 4 rows and USD 450 (100+100+200+50). Preserve all four source rows.

2. INV1 appears twice in R1/R2: duplicate key exception. Provisional unique September total USD 150 = INV1 USD 100 + INV3 USD 50.

3. INV2 USD 200 is out of September billed scope because invoice_date2026-10-02; prior September activity does not move it into billed totals.

4. Explain raw USD 450 minus duplicate USD 100 minus out-of-period USD 200 = provisional USD 150. Do not force the period total to equal raw control total.

5. No earned or collected total can be inferred from billed rows. Administrator resolves duplicates before final report.

Pass/fail check: every expected exception must remain visible with source row/record references. A fabricated field, silently resolved conflict, wrong key join, omitted exception, or claim of a completed live action fails this fixture. Wording may vary; findings and boundaries may not.