Merge Bank & Stripe Exports
Your bank shows a Stripe deposit while Stripe shows the individual payments behind it, minus fees. The dates may not match because payouts can arrive after the original charge date. PipeSheets standardizes both data sources so you can actually reconcile them.
Finally match those Stripe payouts to your bank deposits
What is Merge Bank & Stripe Exports?
Your bank shows a Stripe deposit while Stripe shows the individual payments behind it, minus fees. The dates may not match because payouts can arrive after the original charge date. PipeSheets standardizes both data sources so you can actually reconcile them.
- Consistent MM/DD/YYYY dates: Aligns date formats so you can sort chronologically across sources
- Plain numbers in both files: Strips $ signs and thousands separators so bank and Stripe amounts compare directly (for API-based Stripe files in cents, add a divide-by-100 step)
- Human-readable descriptions: Cleans cryptic bank references and Stripe charge IDs into useful labels
Sources
- Balance reports - Stripe Docs
- QuickBooks Learn and Support - Intuit
Unified financial data for reconciliation
1Before
| Date | Source | Description | Gross | Fees | Net |
|---|---|---|---|---|---|
| 01-17-2024 | Chase | STRIPE TRANSFER 240115 | empty | empty | $2,847.33 |
| 2024-01-15 14:32:05 UTC | Stripe | ch_3abc123 | 99.00 | 3.17 | 95.83 |
| 2024-01-15 09:15:22 UTC | Stripe | ch_3def456 | 45.00 | 1.61 | 43.39 |
2After
| Date | Source | Description | Gross | Fees | Net |
|---|---|---|---|---|---|
| 01/17/2024 | Bank | Stripe Payout (Jan 15) | empty | empty | 2847.33 |
| 01/15/2024 | Stripe | Customer Payment | 99.00 | 3.17 | 95.83 |
| 01/15/2024 | Stripe | Customer Payment | 45.00 | 1.61 | 43.39 |
What Gets Fixed
Aligns date formats so you can sort chronologically across sources
Strips $ signs and thousands separators so bank and Stripe amounts compare directly (for API-based Stripe files in cents, add a divide-by-100 step)
Cleans cryptic bank references and Stripe charge IDs into useful labels
Standardizes columns so gross, fees, and net align for reconciliation
How It Works
Clean your data in three simple steps. No coding required.
Export from Stripe & Your Bank
Drop your file here
CSV or XLSX, up to 25MB free
Download Stripe payouts from Balance → Payouts and your bank statement CSV
Clean Each File Separately
Apply the Stripe cleanup (dates, columns) and Bank cleanup (date format, amounts)
Stack Them and Match
Stack the cleaned files with Merge Files (or in Excel), sort by date, and match payouts to deposits
Matching Stripe Payouts to Bank Deposits, Step by Step
Reconciling Stripe against your bank is really one question asked over and over: does this deposit equal the net of that payout? It sounds trivial until you try it with raw exports - the bank file says 'STRIPE TRANSFER 240115' with a net amount, while the Stripe file has UTC timestamps, gross, fee and net columns, and charge IDs. Most reconciliation pain, including double counting revenue, comes from comparing files that were never made comparable.
Diagnosing the usual mismatches
Reconciliation symptoms, causes, and fixes
| Symptom | Likely cause | Fix |
|---|---|---|
| Deposit matches no single Stripe charge | A payout bundles many charges minus fees | Match the deposit to the payout's net total in Stripe's payout report, never to individual payments |
| Revenue counted twice in your books | Charges booked as income AND the deposit categorized as income | Book gross charges plus fees from Stripe; mark the bank deposit as a transfer so it never hits revenue |
| Deposit smaller than expected | Refunds, disputes, or adjustments were netted into the payout | Open the payout's detail in Stripe to see every charge, refund, and fee it contains |
| Dates off by two to seven days | Payout schedule lag between charge date and arrival | Match on the payout arrival date, not the original charge dates |
The workflow: clean both files, stack them, match by hand
The hard part is making two incompatible exports structurally identical. Once both files share the same columns, date format, and number format, PipeSheets' Merge Files stacks them into one file (or you paste one below the other in Excel or Google Sheets), and the matching becomes a sort and a scan:
Reconciliation workflow steps
- Export the Stripe payout report (Balance → Payouts) and your bank statement CSV for the same period.
- Build a Stripe pipeline: drop the ID and metadata columns, strip timestamps down to dates with a regex find & replace, rename columns to Date / Description / Net, and reorder them into that order.
- Build a bank pipeline: fix the date separator with regex, convert parentheses negatives, strip $ and commas, and rename/reorder to the same Date / Description / Net structure.
- Preview both outputs - the columns should now line up exactly - then download each as CSV.
- On the Files page, select both cleaned files and choose Merge Files: pick Vertical (stack rows) and switch on Add Source File Column so every row says where it came from. Download the merged file, sort by date, and walk down the list matching each payout net to its bank deposit. (Pasting one file below the other in Excel and adding a Source column by hand works too.)
- Save both cleanups. Next month, reconciliation is two uploads, one merge, and one download.
Anything that does not pair up after sorting is your exception list: a payout still in transit, a refund that shrank a deposit, or a stray non-Stripe transaction. That short list - not the hundreds of matched rows - is where your attention should go, and it is exactly what this workflow surfaces.
Frequently Asked Questions
Guides for Merge Bank & Stripe Exports
- 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.
- Reusable Monthly CSV Cleaning Pipelines for Accountants and BookkeepersMonth-end means the same messy exports every time. Instead of a fresh Excel session, document your cleanup steps once as a saved pipeline and re-run it on each client's bank, Stripe, and PayPal CSV.
- How to Merge Inventory CSVs by SKU: Supplier Stock + Amazon, eBay, and Shopify ExportsMerging inventory files by SKU is only as reliable as the SKU column itself. Here is how to clean the join key, choose left join vs update-only vs append, and verify matched, unmatched, and conflicting rows before you trust the result.
- 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.
Clean Your Financial Data
Stop guessing which Stripe charges match which bank deposits. Standardize your data for proper reconciliation.
Get Started