Mini-App · Payments
See Gross, Fees, Refunds and Net for Every Stripe Payout
For businesses paid through Stripe that want to see what each payout really held. Upload the itemized balance transactions CSV from Stripe Reports. You can add several monthly exports, and they will be combined.
You get one row per payout with gross, fees, refunds, net and fee % of gross. You also get a 'Not yet paid out' row, a TOTAL row and a bar chart of net per payout.
Stripe balance transactions export
Your file stays private to you. One free try without an account; then 2 credits a run.
A real result, on the sample file
Excluded 0 payout/transfer rows, then grouped the remaining transactions by automatic_payout_id (blank IDs labelled 'Not yet paid out', listed last; payouts in date order). Gross is the gross of charge rows, refunds is the gross of refund rows, so gross + refunds − fee = net; fee % is fee ÷ gross, and the TOTAL row's fee % is computed from the totals.
| Payout | Transactions | Gross (charges) | Fee | Refunds | Net | Fee % of gross |
|---|---|---|---|---|---|---|
| po_20250703 | 2 | 78 | 2.86 | 0 | 75.14 | 3.67 |
| po_20250704 | 5 | 385 | 12.66 | 0 | 372.34 | 3.29 |
| po_20250706 | 3 | 447 | 13.86 | 0 | 433.14 | 3.1 |
| po_20250707 | 4 | 376 | 12.1 | 0 | 363.9 | 3.22 |
| po_20250709 | 2 | 38 | 1.7 | 0 | 36.3 | 4.47 |
| po_20250710 | 7 | 734 | 23.08 | -29 | 681.92 | 3.14 |
| po_20250711 | 3 | 147 | 5.16 | 0 | 141.84 | 3.51 |
| po_20250712 | 3 | 197 | 6.61 | 0 | 190.39 | 3.36 |
| po_20250713 | 3 | 177 | 6.03 | 0 | 170.97 | 3.41 |
| po_20250714 | 4 | 346 | 11.23 | 0 | 334.77 | 3.25 |
| po_20250715 | 5 | 345 | 11.5 | 0 | 333.5 | 3.33 |
| po_20250716 | 2 | 298 | 9.24 | 0 | 288.76 | 3.1 |
| po_20250717 | 1 | 99 | 3.17 | 0 | 95.83 | 3.2 |
| po_20250718 | 4 | 416 | 13.26 | 0 | 402.74 | 3.19 |
| po_20250719 | 3 | 427 | 13.28 | 0 | 413.72 | 3.11 |
How to use it
- 1In the Stripe Dashboard, go to Reports → Balance and export the balance transactions (itemized) as CSV. Make sure the automatic_payout_id and reporting_category columns are included.
- 2Check that the export covers the full period you care about. A payout that started before your date range will show only part of its transactions.
- 3To cover several months, add each monthly export. They will be combined into one summary.
- 4Read the table one row per payout, in date order. Gross minus fees plus refunds equals net, and refunds show as negative numbers. 'Fee % of gross' tells you what share Stripe kept.
- 5The 'Not yet paid out' row, listed last, shows transactions Stripe has not paid out yet. The TOTAL row sums everything.
Common questions
Which Stripe file do I upload?
In the Stripe Dashboard, go to Reports → Balance and export the itemized balance transactions as a CSV. It needs the balance_transaction_id, created_utc, currency, gross, fee, net, reporting_category and automatic_payout_id columns. Add each monthly export if you want to cover several months.
What if a column in my export has a different name or is missing?
Stripe lets you choose columns when you export, so automatic_payout_id and reporting_category are sometimes left out. Re-export with those columns turned on. If a column has a slightly different name, rename the header to match the names listed above before uploading.
Why does a payout look smaller than what hit my bank?
If a payout started before the date range of your export, only part of its transactions are included. Export a wider period to get the full payout. Transactions Stripe has not paid out yet appear in the 'Not yet paid out' row instead.
Is my data kept private, and what does it cost?
Your file is used only to build this summary. Running the tool costs 2 credits.