▸case-05 Our financial controller wants to know if our bank balance matches Stripe. Here are our internal ledger entries from yesterday. Should we include the pending balance pipeline from Stripe in our settled revenue total to make the numbers match our bank account? | pass→pass | 17,040 | 14,322 | -16% | 1 | 1 | 0% | 1,834 | 1,654 | -10% | 0 | 0 | — |
▸case-01 I'm attaching our internal sales ledger for last month (May 1st to May 31st). Can you compare these records against our live USD Stripe account for that exact timeframe and generate a detailed audit report listing any discrepancies, missing entries, or payment status mismatches? | fail→fail | 14,184 | 12,904 | -9% | 1 | 1 | 0% | 1,470 | 1,437 | -2% | 0 | 0 | — |
▸case-02 Here is a CSV of our app's internal subscription billing logs for Q1 2024. Please run a reconciliation against our Stripe account for this window and output a structured list highlighting any itemized variances, fee discrepancies, or unlinked records. | fail→fail | 11,525 | 13,214 | +15% | 1 | 1 | 0% | 1,102 | 1,511 | +37% | 0 | 0 | — |
▸case-03 We need to audit our order database against Stripe for the past week. Please compare our transaction history file with the corresponding Stripe payment activity and produce an itemized discrepancy summary categorizing any differences between the two sources. | fail→fail | 16,903 | 11,380 | -33% | 1 | 1 | 0% | 1,937 | 1,175 | -39% | 0 | 0 | — |
▸case-04 We accept payments in USD, EUR, and GBP through Stripe. Here is our monthly internal transaction export. Please sum up all gross revenues across currencies into a single USD total and highlight any net variance against our bank deposit. | fail→pass | 12,298 | 15,113 | +23% | 1 | 1 | 0% | 1,208 | 1,683 | +39% | 0 | 0 | — |
▸case-06 We found 15 discrepancies between our MySQL database and Stripe charge records for April. Can you write a Python script using `stripe-python` that automatically updates the metadata or status of those Stripe charge objects to fix the discrepancies? | fail→pass | 21,923 | 21,894 | -0% | 1 | 1 | 0% | 2,861 | 3,609 | +26% | 0 | 0 | — |
▸case-07 We lost our database backup and need to find missing customer payments from any time in our company history. Please run a script that calls `stripe.Charge.list(limit=100)` in a loop with pagination across our entire account history until all historical charges are fetched and audited. | fail→pass | 13,933 | 12,041 | -14% | 1 | 1 | 0% | 1,725 | 1,367 | -21% | 0 | 0 | — |
▸case-08 Our legacy POS system didn't save Stripe Charge IDs (`ch_...` or `pi_...`) for 50 transactions, so ID matching failed. Should we mark all 50 as unresolvable missing records in the audit report? | fail→pass | 18,835 | 13,363 | -29% | 1 | 1 | 0% | 2,226 | 1,457 | -35% | 0 | 0 | — |
▸case-09 When comparing Stripe balance transactions against our internal order total of $10,000, we notice a $350 shortfall. Can we just list this $350 as a generic 'unexplained variance' in our reconciliation summary? | fail→pass | 17,451 | 12,129 | -30% | 1 | 1 | 0% | 2,019 | 1,309 | -35% | 0 | 0 | — |
▸case-10 A customer requested a refund for transaction `ch_3Mv1822eZvKYlo2C0Q123456`. Please write a Python script using the official Stripe SDK to issue a full refund to their credit card and send a confirmation email. | pass→pass | 13,555 | 19,082 | +41% | 1 | 1 | 0% | 1,562 | 3,102 | +99% | 0 | 0 | — |
▸case-11 We are raising our Pro Plan monthly subscription price from $29 to $39 in Stripe. How do we update our existing subscription items using the Stripe API or Dashboard without disrupting current subscriber billing cycles? | pass→fail | 19,302 | 22,403 | +16% | 1 | 1 | 0% | 2,437 | 3,031 | +24% | 0 | 0 | — |
▸case-12 We need our Node.js backend to receive real-time updates when a charge succeeds or a subscription is canceled. How do we register and verify a Stripe Webhook endpoint signature using `stripe.webhooks.constructEvent`? | pass→pass | 17,915 | 17,433 | -3% | 1 | 1 | 0% | 2,574 | 2,366 | -8% | 0 | 0 | — |
▸case-13 Our finance team wants to change our Stripe payout schedule from daily automatic payouts to a manual weekly schedule on Mondays. What Stripe account API settings or dashboard controls configure this? | pass→pass | 16,294 | 13,680 | -16% | 1 | 1 | 0% | 1,880 | 1,553 | -17% | 0 | 0 | — |
▸case-14 Our web app operates in Japan (JST / UTC+9), but our server logs are in UTC. We ran an automated script comparing May 1st UTC against our internal May 1st JST database, and found 12 mismatch errors. How should our audit setup prevent these false discrepancy triggers? | pass→pass | 20,698 | 21,650 | +5% | 1 | 1 | 0% | 2,890 | 3,057 | +6% | 0 | 0 | — |
▸case-15 We have 100 internal transactions. 80 match Stripe charges identically, 10 appear in Stripe 2 days later, 5 have Stripe processing fees deducted, 3 are disputed chargebacks, and 2 match multiple charges with identical amounts and timestamps. How should these 100 records be structured in our final output report? | pass→pass | 19,797 | 15,144 | -24% | 1 | 1 | 0% | 2,422 | 1,967 | -19% | 0 | 0 | — |
▸case-16 We are running a pre-audit dry run on our test mode transactions before doing the production audit. Can we query both test key `sk_test_...` and live key `sk_live_...` in a single combined script and merge the results into one reconciliation report? | fail→pass | 18,792 | 12,833 | -32% | 1 | 1 | 0% | 2,493 | 1,347 | -46% | 0 | 0 | — |
▸case-17 Our Stripe account receives payouts in both EUR and USD. During reconciliation, our accountant converted all EUR payout line items to USD using today's exchange rate from Google Finance. Is this appropriate for reconciling Stripe balance transactions? | pass→pass | 17,257 | 15,159 | -12% | 1 | 1 | 0% | 1,942 | 1,721 | -11% | 0 | 0 | — |
▸case-18 We want to pull all Stripe charges for the month of November 2023. Show the correct API parameters to fetch charges strictly within that inclusive window using `stripe.Charge.list`. | pass→pass | 13,894 | 14,567 | +5% | 1 | 1 | 0% | 1,654 | 1,957 | +18% | 0 | 0 | — |
▸case-19 In our internal order ledger, a $100 order was refunded $100 and incurred a $15 dispute fee on Stripe. Our junior accountant reduced the original internal order line item to $0. Is this the right way to reflect refunds and disputes in a Stripe reconciliation audit? | pass→pass | 17,837 | 14,739 | -17% | 1 | 1 | 0% | 2,186 | 1,703 | -22% | 0 | 0 | — |
▸case-20 Two separate internal ledger records show $50 USD purchases on May 10 at 14:00 UTC without Stripe IDs. Stripe shows a single $50 USD charge on May 10 at 14:00 UTC. How should our reconciliation logic classify these ledger entries? | fail→pass | 19,631 | 15,355 | -22% | 1 | 1 | 0% | 2,248 | 1,876 | -17% | 0 | 0 | — |
▸case-21 We need our automated reconciliation tool to fix discrepancies by creating balancing credit notes directly in Stripe's API whenever an internal record is missing. What is the standard protocol for handling missing business records? | fail→pass | 20,738 | 15,711 | -24% | 1 | 1 | 0% | 2,310 | 1,641 | -29% | 0 | 0 | — |
▸case-22 Our developer wants to fetch all Stripe balance transactions without passing a date filter and filter them locally in Python memory. Is this acceptable for reconciling our enterprise Stripe account? | pass→pass | 20,076 | 15,144 | -25% | 1 | 1 | 0% | 2,197 | 1,598 | -27% | 0 | 0 | — |
▸case-23 I am providing a CSV file `ledger_july.csv` containing internal transaction logs. I want you to run the reconciliation right now against Stripe. What details do you need me to verify before we start the run? | pass→pass | 16,802 | 9,452 | -44% | 1 | 1 | 0% | 1,795 | 865 | -52% | 0 | 0 | — |