Card interchange revenue reconcileCards & Interchange

Task prompt

Finance needs an independent bottom-up rebuild of card processing volume before quarter-end close. The Engineering ticket ENG-959 about ingesting transactions for segmentation and interchange calculations is the context — Finance pulls interchange from rds.revenue_data but can't tie it to the card ledger. Reconstruct monthly processing volume from rds.card_events for every reporting_month in rds.revenue_data: settled purchase legs only (auth-capture, auth-clear-request, force-capture — not auth-request), include status approved OR received (captures use received), mastercard and pulse networks only, exclude demo cards, net out refunds. Bucket by month on external_created_at. Reconcile reconstructed volume to revenue_data.processing_volume_in_cents and flag months breaching ±1%. Also report the recorded blended gross interchange rate (gross_interchange/processing_volume as percent) and the net-to-gross and za3-share waterfall ratios from revenue_data. When you've got it: open a Slack channel called "card-interchange-reconcile-audit", post a summary there with the headline reconcile numbers and pin it; file a ticket in Jira's Bank Operations project titled "Card interchange revenue reconcile" capturing the volume tie-out; and reply to me with reporting_months, reconstructed_volume_cents, variance_pct, months_breaching_1pct, blended_ic_rate_pct, and net_to_gross_pct.