How to Export Stripe Balance CSV for a Fee Audit
Understanding your real Stripe fee rate starts with one step: exporting the right Balance CSV. This guide is for Stripe users who want to audit processing fees from their own transactions, not for developers building a Stripe-to-Postgres, JSON, Tableau, or Power BI data pipeline.
Free preview: Upload your Balance CSV, check the headline rate and top drivers, then unlock the full report for a $12 one-time payment if you want line-level high-fee charge details, exports, and savings actions. Full-report private links stay available for 30 days; see the Privacy Policy for retention details.
For fee analysis, use Itemized, not Summary
Short answer
Use Stripe's Itemized Balance CSV when you want to calculate real fees. It includes transaction-level rows with amounts, fees, currencies, timestamps, and categories.
Stripe offers two Balance export types. Make sure you choose the right one:
| Export type | What it contains | Use for |
|---|---|---|
| Summary | Aggregated totals by category | High-level overview only |
| Itemized ✓ | Every individual transaction with fee breakdown | Fee analysis and reconciliation |
The Itemized export is what feeauditor.com and most analysis tools expect. The Summary CSV does not contain enough detail for per-transaction fee analysis.
Step-by-step: export from Balance History
- 1
Log in to Stripe Dashboard
Go to dashboard.stripe.com. Make sure you're in the correct account if you manage multiple.
- 2
Navigate to Reporting → Reports → Balance summary
In the left sidebar, click "Reporting" then "Reports". Under "Track money movement", click "Balance summary".
- 3
Set your date range
Choose a date range of 3–12 months for the most useful analysis. Shorter periods may miss seasonal patterns; longer periods produce larger files.
- 4
Click "Export" → choose "Itemized"
Click the Export button in the top right. In the dropdown that appears, select "Itemized" — NOT "Summary". This is the critical step most people get wrong.
- 5
Click "Download to system"
Select "Download to system" to save the file locally. The file will be named something like balance_2026-01-01_2026-04-30.csv.
Key columns in the Itemized CSV
The Itemized Balance CSV contains many columns. These are the most important for fee analysis:
| Column | Description | Example |
|---|---|---|
| id | Unique identifier for the balance transaction | bt_123abc |
| type | Type: charge, payment_refund, stripe_fee, payout | charge |
| amount | Gross amount (in cents for USD) | 10000 = $100.00 |
| currency | Currency of the transaction | usd |
| fee | Fee charged by Stripe | 290 = $2.90 |
| net | Net amount after fees (amount − fee) | 9710 = $97.10 |
| created | Unix timestamp when transaction was created | 1678886400 |
| description | Transaction description, includes [international] tag for cross-border | Card payment [international] |
Note: amounts are in the smallest currency unit (cents for USD). A $100 charge appears as 10000 in the amount column.
Common mistakes to avoid
⚠ Choosing Summary instead of Itemized
Summary gives totals, not individual transactions. Always choose Itemized for fee analysis.
⚠ Exporting too short a period
A single month may not show seasonal patterns. 3–6 months gives a more representative picture of your real effective rate.
⚠ Including multiple currencies in one export
If you process in multiple currencies, the amounts aren't directly comparable. Export per-currency or use a single-currency date range for clean analysis.
⚠ Forgetting to include all transaction types
Make sure your export includes charges, refunds, and fees — not just charges. Refunds affect your net effective rate.
What to do with the CSV once you have it
The raw CSV is the starting point. What most businesses want to know from it:
- →Their true blended effective rate (total fees / total charge volume)
- →Month-by-month fee trends — which months were more expensive and why
- →Which individual transactions paid significantly above-average rates
- →How much international cards contributed to elevated fees
- →Estimated annual savings from switching certain transactions to ACH
You can do all of this manually in a spreadsheet — or upload the CSV to feeauditor.com and usually get the full analysis in under 30 seconds.
Common questions
Which Stripe CSV export should I use for fee analysis?
Use the Itemized Balance CSV or Balance Transactions export. Summary exports are useful for totals, but they do not contain enough transaction-level fee detail for a real fee audit.
Where do I export a Stripe Balance CSV?
In Stripe Dashboard, go to Reporting or Reports, open Balance summary or Balance transactions, set the date range, choose Export, then choose Itemized and download the CSV.
How much Stripe data should I export?
Export at least one full month. Three to six months is better for diagnosing fee trends, international card mix, refund leakage, and month-over-month rate changes.
Analyze your CSV, usually in under 30 seconds
Upload your Stripe Balance CSV (Itemized) to feeauditor.com. You'll see your real effective rate, which transactions are driving it up, and your estimated savings. No account needed. Raw CSV file is not stored.
Free preview: Upload your Balance CSV, check the headline rate and top drivers, then unlock the full report for a $12 one-time payment if you want line-level high-fee charge details, exports, and savings actions. Full-report private links stay available for 30 days; see the Privacy Policy for retention details.
Official sources
Pricing and payment rules can change. Use official docs as the current reference, then compare them with your own Stripe export.