Stripe CSV Export Cleaner
Stripe exports raw transaction data - amounts in cents, UTC timestamps with milliseconds, fees lumped together, 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 - amounts in cents, UTC timestamps with milliseconds, fees lumped together, 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): Divides all monetary values by 100 - Stripe stores integers to avoid floating-point errors
- Separated fee columns: The Fee column combines Stripe processing and Connect platform fees - we can help you separate them
Sources
- Balance reports - Stripe Docs
From raw payment data to accounting-ready
1Before
| Created (UTC) | Amount | Fee | Net | Description |
|---|---|---|---|---|
| 2024-01-15 14:32:05 UTC | 9900 | 317 | 9583 | Invoice INV-2024-001 |
| 2024-01-14 09:15:22 UTC | 4500 | 161 | 4339 | empty |
| 2024-01-13 18:45:00 UTC | 15000 | 465 | 14535 | 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 | Subscription renewal |
What Gets Fixed
Strips time and timezone from timestamps for clean date-only values
Divides all monetary values by 100 - Stripe stores integers to avoid floating-point errors
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
Cents → dollars, timestamps → dates, nulls removed, columns trimmed
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.
- Convert cents to dollars with a regex on the amount columns: match ^(\d+)(\d{2})$ and replace with $1.$2, turning 9900 into 99.00. Spot-check any sub-dollar amounts in the preview, since a two-digit value like 50 needs a leading 0.50 fixed by hand.
- 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 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 manually dividing by 100 in Excel. Transform Stripe data for bookkeeping in seconds.
Get Started