Monthly sales reconciliation | Synthetic demo

Self-directed synthetic demo, created with AI assistance. All businesses, invoices and amounts are fictional. No paid-client result or earnings are claimed.

This workbook reconciles two fictional sales exports by invoice ID and month, preserves source rows, and separates amount differences, missing records, timing differences and multiple ledger rows.

The September example has 18 sales rows, 19 ledger rows, 13 matched invoice keys and 7 keys for review. The signed source variance reconciles to -$520. This is an illustrative dataset difference, not money recovered or lost by a client.

The project includes a formula-driven report, original CSVs and reproducible quality checks. The images show actual demo workbook output. Items needing a decision remain visible rather than being silently forced into agreement.