Reconciled revenue to the cent with the payments processor
0.8% revenue drift had gone undetected for 5 months. Built a daily reconciliation between the warehouse and the payments processor; surfaced the drift in 24h.
- Drift detected0.8%
- Time to alert5 mo → 24 h
- Engagement3 weeks
A LATAM marketplace's BI revenue did not match the payments processor's settlement reports — by ~0.8%. Finance had been writing it off; ops had no way to investigate.
Built a daily reconciliation marts table joining warehouse charges to processor balance_transactions at the cents level. Surfaced rows where they disagreed.
Found a refund-processing race condition that had quietly under-counted refunds for 5 months. Recovered the corrected vintage with the auditor; tightened the contract on the staging table to forbid the race.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.