Analyze Stripe Payout Reports in Excel
Stripe payout reports list every transaction included in each bank deposit, along with fees, refunds, and adjustments. Reconciling these to your bank statement and accounting system requires matching transaction IDs, summing net amounts by payout, and separating different currencies and fee types.
Upload your Stripe payout report and get payout summaries, fee breakdowns, and transaction lists that reconcile directly to your bank account.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountSee it on a sample file
What DataMimi shows for a Stripe balance transactions
2,391 rows, Jul 2025 – Aug 2026. Computed by DataMimi from a sample export with the same columns as yours — the data is invented, the figures are exactly what the app produces from it.
What this export contains
| id |
| type |
| amount |
| fee |
| net |
| currency |
| available_on |
| created |
| description |
| customer_email |
| customer_description |
| charge_id |
| payment_intent_id |
| automatic_payout_id |
Common questions
What is a stripe payout report?
A stripe payout report lists every transaction included in each bank deposit, showing charges, refunds, fees, and adjustments. Each row represents one transaction, grouped by automatic_payout_id to match the net amount Stripe transferred to your bank account.
How do I match a Stripe payout to my bank deposit?
Filter the automatic_payout_id column to the payout ID from your Stripe dashboard, then sum the net column for those rows. That total matches the deposit in your bank account. Each payout ID corresponds to one bank transfer.
What is the total net amount for each payout ID?
Create a pivot table with automatic_payout_id as rows and sum of net as values. Each payout ID will show the exact amount Stripe transferred to your bank, including all fees and refunds for that period.
How do I convert the created timestamp to a readable date?
Divide the created value by 86400, then add 25569. Format the result as a date. This converts Unix epoch seconds to Excel's date system, though you may need to adjust for your timezone.
How do I calculate gross revenue before fees?
Filter the type column to only 'charge' rows, then sum the amount column. This gives total charges before Stripe deducted fees. Do not use the net column for gross revenue.
Why do some rows have negative amounts?
Refunds, disputes, and dispute reversals appear as negative amounts. The type column will show 'refund' or 'adjustment'. These reduce the net payout but are separate transactions from the original charge.
How do I separate payouts by currency?
Filter or group by the currency column before summing. Stripe pays out each currency separately, so EUR payouts go to a EUR bank account and USD to a USD account. Mixing currencies in one sum produces incorrect totals.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file