Stripe CSV Export Cleaner
Stripe exports raw transaction data - UTC timestamps, gross, fee and net in separate columns, amounts in cents if the file came from the API, and 30+ columns you don't need. Accountants shouldn't need engineering resources to get usable data. PipeSheets transforms Stripe exports into QuickBooks-ready bookkeeping data.
Stripe is built for payments, not accounting. We bridge the gap.
What is Stripe CSV Export Cleaner?
Stripe exports raw transaction data - UTC timestamps, gross, fee and net in separate columns, amounts in cents if the file came from the API, and 30+ columns you don't need. Accountants shouldn't need engineering resources to get usable data. PipeSheets transforms Stripe exports into QuickBooks-ready bookkeeping data.
- 01/15/2024 simple date: Strips time and timezone from timestamps for clean date-only values
- 99.00 (dollars and cents): Stripe's report CSVs already use decimals, so the ready-made cleanup keeps amounts exactly as exported. Files built from the API use cents: add a Numeric Transformation step that divides by 100 for those
- Separated fee columns: The Fee column combines Stripe processing and Connect platform fees - we can help you separate them
Sources
- Balance reports - Stripe Docs
- How the Reports API works (CSV and API monetary formats) - Stripe Docs
From raw payment data to accounting-ready
1Before
| Created (UTC) | Amount | Fee | Net | Description |
|---|---|---|---|---|
| 2024-01-15 14:32:05 | 99.00 | 3.17 | 95.83 | Invoice INV-2024-001 |
| 2024-01-14 09:15:22 | 45.00 | 1.61 | 43.39 | empty |
| 2024-01-13 18:45:00 | 150.00 | 4.65 | 145.35 | sub_1234 renewal |
2After
| Created (UTC) | Amount | Fee | Net | Description |
|---|---|---|---|---|
| 01/15/2024 | 99.00 | 3.17 | 95.83 | Invoice INV-2024-001 |
| 01/14/2024 | 45.00 | 1.61 | 43.39 | empty |
| 01/13/2024 | 150.00 | 4.65 | 145.35 | sub_1234 renewal |
What Gets Fixed
Strips time and timezone from timestamps for clean date-only values
Stripe's report CSVs already use decimals, so the ready-made cleanup keeps amounts exactly as exported. Files built from the API use cents: add a Numeric Transformation step that divides by 100 for those
The Fee column combines Stripe processing and Connect platform fees - we can help you separate them
Removes the 25+ internal Stripe columns your accountant doesn't need
How It Works
Clean your data in three simple steps. No coding required.
Export from Stripe Dashboard
Drop your file here
CSV or XLSX, up to 25MB free
Go to Payments → Export, or use Balance → Download for payout data
Apply Stripe Cleanup
Timestamps → dates, nulls removed, amounts kept exactly as exported
Import to Accounting Software
Upload to QuickBooks, Xero, or use for monthly reconciliation in Excel
Payout Reconciliation Without the Double Counting
The most expensive Stripe bookkeeping mistake is quietly counting revenue twice. It happens like this: you import individual Stripe charges as income, and then your bank feed also imports the Stripe payout deposit as income. The same money now appears in your books twice - once gross, once net - and your revenue is overstated until someone notices at tax time. If you have ever searched 'stripe deposit double counted', this is almost certainly what happened.
The symptoms, causes, and fixes
Stripe bookkeeping symptoms, causes, and fixes
| Symptom | Cause | Fix |
|---|---|---|
| Revenue roughly doubled in your P&L | Charges imported as income AND bank payouts categorized as income | Pick one source of truth: book gross charges plus a fee expense, and categorize the bank deposit as a transfer, not income |
| Bank deposit matches no single charge | A payout batches many charges minus fees into one net amount | Reconcile the deposit against the payout total in Stripe's payout report, not against individual payments |
| Gross vs net confusion in reports | The bank sees net only; Stripe exports show gross, fee, and net | Keep gross, fee, and net as separate columns and always reconcile the net figure to the bank |
| Transactions missing from your export | The Payments export honors on-screen date and status filters | Clear filters and widen the date range before exporting - or use the Balance report for a complete picture |
Step-by-step: cleaning a Stripe export for your books
Stripe export cleanup steps
- Export from the right place: Payments → Export for charge-level data, Balance → Payouts for payout reconciliation. If you want to export all data from your Stripe account, note there is no single all-in-one CSV - each section (payments, payouts, customers, disputes) exports separately.
- Upload the CSV to PipeSheets (free up to 25MB) and open the preview - you will see 25+ columns, most of them internal IDs.
- Use drop columns to keep only what bookkeeping needs: created date, amount, fee, net, and description.
- Strip timestamps down to dates with a regex find & replace: match a pattern like \d{2}:\d{2}:\d{2} UTC and replace with nothing.
- Check the amount unit against one payment you know: report CSVs show 99.00, API-based files show 9900. Only cents need converting: the ready-made Stripe Export Cleaner keeps amounts exactly as exported, so for a cents file add a Numeric Transformation step (divide by 100) to your own cleanup.
- Standardize nulls, normalize headers, reorder columns to your import template, preview, and download.
Save the sequence as a pipeline and month-end becomes mechanical: export, run pipeline, import. The one decision PipeSheets cannot make for you is gross vs net accounting. Booking gross revenue with fees as an expense is what most accountants prefer, because deducting processing fees usually requires showing them; booking net-only understates both revenue and expenses. Ask your accountant once, then encode the answer in your pipeline's column choices.
Frequently Asked Questions
Guides for Stripe CSV Export Cleaner
- Stripe Deposits Double Counted? How to Fix Your BooksIf your books show more revenue than you actually earned, and Stripe is in the picture, you have almost certainly recorded the same money twice: once as Stripe payments and again as bank deposits. Here is why it happens, how to confirm it, and how to fix a ledger that is already double counted.
- How to Export All Data From Your Stripe AccountStripe has no single 'export everything' button, but it does have five export surfaces that together cover every record in your account. Here is what each one contains, which to use for taxes, bookkeeping, migration, or backup, and how to make the CSVs usable afterward.
- Stripe Payout CSVs for Accounting: Gross, Fees, Net, and Matching Transfers to DepositsYour bank shows one Stripe deposit; Stripe made hundreds of charges. Here's how to pull the right report, split gross, fees, and net, and tie every payout to its bank line.
- Merge Bank, Stripe, and PayPal CSV Exports for Monthly ReconciliationMerging bank, Stripe, and PayPal CSVs for monthly reconciliation double-counts revenue unless you handle payouts correctly. Here is how to normalize all three to one schema and match payouts to deposits.
- Import Stripe Payouts Into QuickBooks or Xero: Fix the CSV FirstStripe's CSV export is built for engineers, not bookkeepers. Here's how to convert it into something QuickBooks or Xero will actually accept.
- How to Merge Bank and Stripe CSVs into One Cash Flow SheetYour bank shows deposits, Stripe shows individual payments. Here's how to combine them into a single cash flow view that actually makes sense.
Clean Your Stripe Export
Stop reformatting Stripe dates and columns by hand. Turn Stripe data into bookkeeping-ready files in seconds.
Get Started