Stripe export to dashboard
Your Stripe export, your revenue dashboard.
Export Payments from the Stripe Dashboard, drop the CSV here, and you get a revenue dashboard in a couple of seconds. Amounts arrive in cents and are divided by 100 for you, refunded charges are netted out of the totals, fees are kept separate from net, and the split by card country, brand and status is built automatically.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
Why the Stripe CSV is harder to read than it looks
A Stripe payments export is not a hard file to open. It is a hard file to total. The Amount column is in the currency's smallest unit, so a $39.00 charge is the integer 3900, and a naive SUM in a spreadsheet gives you a number a hundred times too large. Multi-currency accounts make it worse: the same column mixes cents, pence and yen, and yen has no minor unit at all, so dividing everything by 100 is also wrong.
Then there are the rows that should not count. Failed charges sit in the same file as successful ones. Refunds appear as a non-zero Amount Refunded on the original charge rather than as a separate negative row, so a total of Amount overstates what you actually kept. And the Fee column is what Stripe took, not what you received, which means net revenue is a subtraction nobody remembers to do at 11pm on the last day of the month. This page does all four of those before it draws anything.
How to export from Stripe
- Open Payments in the Stripe Dashboard Sign in at dashboard.stripe.com and pick Payments in the left sidebar. Check the account switcher at the top left first if you run more than one Stripe account, because the export follows whichever one is selected.
- Set the date range Use the date filter above the table. Stripe exports what the filter shows, so a default view of the last seven days quietly gives you a seven-day file. Pick a full quarter if you want a trend chart worth looking at.
- Click Export The Export button sits at the top right of the payments table. Choose All columns rather than the default set. The default omits Fee and Amount Refunded, which are the two columns you need most.
- Wait for the email or the download Small exports download straight away. Anything over roughly ten thousand rows is prepared in the background and mailed to you as a link, so keep an eye on the inbox tied to your Stripe user.
- Drop the CSV on this page Nothing gets uploaded. The file is read in the tab and the dashboard is drawn from it, with the currency conversion and refund netting already applied.
If you use Stripe Sigma or the Reporting API instead, the same page works: the column names are the same, and extra columns are simply extra dimensions you can group by.
Try with sample Stripe data (the same columns, 96 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Stripe names it.
- Net revenue over time. Created date (UTC) becomes the time axis, and the trend is built from Amount minus Amount Refunded, converted out of cents.
- Gross, fees and net side by side. Fee is summed separately so you can see the real take rate rather than assuming 2.9% plus 30 cents.
- Revenue by Description. For most accounts Description carries the plan or product name, which makes it the closest thing the export has to a product breakdown.
- Card Country on a map. Two-letter codes are recognized as countries, so geography comes for free without a lookup table.
- Status mix. succeeded, failed and refunded as a share, which is the fastest way to spot a payment method quietly failing.
- Card Brand and Customer Email. Brand as a donut, and email as a top-customers ranking with repeat charges collapsed into one row per address.
id,Created date (UTC),Amount,Amount Refunded,Currency,Converted Amount,Converted Currency,Fee,Status,Description,Customer Email,Card Brand,Card CountrySix things about this export that will bite you
- Cents, not dollars. Amount, Fee, Converted Amount and Amount Refunded are all integers in the currency's smallest unit. Divide by 100 for dollars, euros and pounds, but not for JPY, KRW or VND, which have no minor unit and are already whole.
- Converted Amount is the honest one. On a multi-currency account, summing Amount adds pence to cents. Converted Amount is restated in your settlement currency, so group by that instead and keep Currency only as a dimension.
- Refunds hide inside the original row. There is no negative row for a refund. Amount Refunded on the charge goes up instead, so any total that ignores it is overstated by exactly the refunded volume.
- The timestamp is UTC, always. Created date (UTC) does not follow your dashboard timezone setting. If your team reports on Pacific time, the last three hours of every day land on the wrong date until you shift it.
- Disputes are not in this file. Chargebacks and their fees live in the Balance report, not the Payments export. A month that looks clean here can still have money clawed back.
- The default column set is too small. Exporting with the default columns drops Fee, Amount Refunded and Card Country. Always pick All columns, or you will be back in the Dashboard ten minutes later.
None of that is Stripe being careless. Cents avoid floating point error, and keeping refunds on the charge preserves the link between them. It just means the file needs a reader that knows the conventions, which is what this page is.
Frequently asked questions
Why is my Stripe revenue total a hundred times too big?
Because Amount is in cents. Stripe stores money as integers in the currency's smallest unit so that no arithmetic ever hits a floating point rounding error, which means a 39 dollar charge is written as 3900. A spreadsheet SUM has no way to know that. This page reads the Currency column alongside Amount, divides by 100 for currencies that have a minor unit, and leaves zero-decimal currencies like JPY alone.
Does the dashboard subtract refunds?
Yes. Stripe does not write a separate negative row when you refund a charge; it increases Amount Refunded on the original payment. The net revenue figure here is Amount minus Amount Refunded, summed. Gross is still available as its own panel, so you can see both, and the gap between them is your refund rate without any extra work.
Which columns should I include in the export?
Choose All columns rather than the default set. The default leaves out Fee, Amount Refunded and Card Country, which between them cover net revenue, refund rate and geography. Extra columns cost nothing here, since anything categorical becomes a group-by chip and anything numeric becomes a candidate metric.
Can I use this with a multi-currency Stripe account?
Yes, and you should lean on Converted Amount rather than Amount when you do. Amount is in each charge's own currency, so summing it mixes units. Converted Amount is restated in your settlement currency at the rate Stripe used, which makes it the only column that can be totaled across the whole file. Keep Currency as a group-by so you can still see the mix.
Are Stripe disputes and chargebacks included?
No. The Payments export covers charges and their refunds. Disputes, dispute fees and payout adjustments live in the Balance report, which is a separate download from Reports in the Stripe Dashboard. If you need a full picture of what hit your bank account, load the Balance report as a second file and compare it against this one.
Is my customer data uploaded anywhere?
No. The file is read by JavaScript inside your browser tab. There is no upload step and no server that could receive it, which matters because a Stripe export carries customer email addresses and, depending on your columns, billing details. Closing the tab is the whole cleanup process. Nothing is remembered between visits unless you ask for it.
Related tools
See a Stripe dashboard before you export anything
The sample carries the real Stripe column names, 96 charges across a quarter, refunds and failures included. Nothing to install, nothing to sign up for.
Open the sample Stripe dashboard