The Scenario
Your accountant has been staring at six months of bank statements trying to reconcile Stripe payouts against actual deposits. The bank shows 47 deposit line items over that period. She has a rough Stripe payout total, but the arrival dates and amounts don't line up cleanly with what the bank shows, and she needs the full payout history in a sheet to find the discrepancy.
She asks you to pull every Stripe payout from the last six months into the reconciliation sheet with arrival date, amount, and the destination account. You open Stripe's Payouts section. The UI shows payouts in a paginated list. The export option is limited — it downloads a CSV with more columns than she needs and arrival dates as Unix timestamps. Filtering to exactly six months requires manual date manipulation in the export.
The bad version:
- Download the payouts CSV, open it in a separate file, locate the arrival date, amount, status, and destination columns among the dozen others.
- Paste the relevant columns into the reconciliation sheet, convert the Unix timestamp dates, and discover that three payouts show a status of "in transit" rather than "paid" — which means they need to be excluded from the bank reconciliation but included in a pending column.
- Spend an hour on formatting before any actual reconciliation work has started.
Six months of bank statements don't wait for formatting work. The accountant has been on this for three days already.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Stripe and pulls payout records with the fields and date range you specify — no CSV reformatting, no timestamp conversion.
List all Stripe payouts from the last 6 months and write payout ID, amount, currency, arrival date, status, and destination account into this sheet
What You Get
- The sheet fills with one row per payout: payout ID, amount in the currency's major unit, currency code, arrival date as a readable date, status, and the destination bank account identifier.
- Payouts of all statuses appear — paid, in transit, failed — with status visible in its own column for easy filtering.
What If the Data Is Not Quite Ready
You want a running total to cross-check against the bank statement
Export all Stripe payouts from the last 6 months and write payout ID, amount, currency, arrival date, status, and destination account into this sheet — add a running total of amount in column G so I can compare the cumulative figure against the bank statement
You only want paid payouts — exclude in transit and failed
List all Stripe payouts from the last 6 months with status 'paid', write payout ID, amount, currency, and arrival date into this sheet, sorted by arrival date ascending — so I can match each line against the bank deposit chronologically
You want to flag payouts that don't match a round-number expectation
List all Stripe payouts from the last 6 months in this sheet and add a column G that flags any payout where the amount is not a whole-dollar figure — so I can investigate odd amounts that might indicate a fee deduction I haven't accounted for
The full kill chain — pull, separate by status, add running total, and flag anomalies in one shot
Fetch all Stripe payouts from the last 6 months, write paid payouts into Sheet1 and in-transit payouts into Sheet2 — both sheets should include payout ID, amount, arrival date, and destination account — add a running total of amount in column E on Sheet1 and flag any paid payout amount that differs from the nearest round hundred by more than 5 in column F
The pattern: the separation, totalling, and anomaly detection all arrive in one pass so the reconciliation can start immediately.
Try It
Get the 7-day free trial of SheetXAI and open your bank reconciliation sheet — then ask it to pull your Stripe payout history into a format that lines up with your bank statement columns. For related reads, see how to export balance transactions for cash-flow reconciliation or trigger a Stripe balance report run.