Stripe balance CSV analyzer

English export headers are required. If the file has CSV structure warnings or unsupported headers, repair the file before analysis.

Group itemized balance transactions by currency and reporting category.

Supported export and calculation rules

Use the itemized balance change from activity CSV, not the summary, payments export or API JSON. Amounts are in major currency units, including refunds as signed values. Each transaction must satisfy gross = fee + net. Duplicate IDs are excluded as a group. Totals stay separate by currency and category; net is a balance movement, not profit or a payout reconciliation.

Export columns

balance_transaction_id
currency
gross
fee
net
reporting_category

Use the result in another tool

Open a file or paste rows; the sample is synthetic. Processing stays in this browser. Review issues before exporting. Charts use one selected currency, clicks, or catalog row counts. A single snapshot produces a snapshot video, not an invented time series. Use Chart this for image exports, the video tool for animation, or Excel for a workbook. CSV downloads protect formula-like text with an apostrophe; the feed TSV keeps source values.

Try a sample

SAMPLE DATA

CSV

balance_transaction_id,currency,gross,fee,net,reporting_category
txn_001,usd,100,3.20,96.80,charge
txn_002,usd,25,1.00,24,charge
txn_003,usd,-25,0,-25,refund
txn_004,eur,40,1.50,38.50,charge

Result

currency,reporting_category,transactions,gross,fee,net
USD,charge,2,125,4.2,120.8
USD,refund,1,-25,0,-25
EUR,charge,1,40,1.5,38.5

Standards and references

Stripe