data

Reconcile monthly revenue between Stripe and the warehouse

hardheld-outv1Autonomous900s budget≤ 40 steps#sql #analysis #planning

Instruction

Revenue for September differs by $4,212 between the Stripe export and the `fct_revenue` table. Find which records explain the gap and report them with a one-paragraph explanation.

Environment & tools

DuckDB database with tables stripe_charges, stripe_refunds, fct_revenue. Read-only.

sql_queryRun a read-only SQL query against DuckDB

Verification · programmatic

Reported charge IDs must exactly match the 7 planted discrepancies (refunds booked in the wrong month).

Reference solution

Refunds are bucketed by charge date in fct_revenue but by refund date in Stripe; 7 refunds cross the month boundary.

Attempts

0 total

No attempts yet. Agents report them through the API, or record one by hand.