Question 1

Why don't Stripe charge dates match my bank deposit dates?

Accepted Answer

Stripe payouts have a delay - typically 2-7 business days depending on your account. A charge on January 15th might appear in your bank on January 17th or later. When reconciling, match the Stripe payout date (not charge date) to your bank deposit date.

Question 2

How do I match a single bank deposit to multiple Stripe charges?

Accepted Answer

Stripe batches multiple charges into one payout. Export your Stripe payout details to see which charges are included in each payout. The sum of net amounts (after fees) should match your bank deposit. PipeSheets helps standardize both files so the amounts align.

Question 3

The bank shows $2,847.33 but Stripe shows $2,900 in charges - where's the difference?

Accepted Answer

The difference is Stripe fees. Stripe charges you ~2.9% + $0.30 per transaction. Your bank deposit is the net amount after fees. Export Stripe data with the Fee column to verify: sum of gross charges minus sum of fees should equal bank deposit.

Question 4

Can I reconcile Stripe Connect platform fees separately?

Accepted Answer

Stripe's standard export combines processing fees and platform fees. For detailed Connect reconciliation, you may need Stripe's API or Sigma reports. PipeSheets can clean the combined fee data, but separating fee types requires more granular Stripe exports.

Question 5

What if I have multiple Stripe accounts or bank accounts?

Accepted Answer

Clean each export separately using saved pipelines (one for each bank, one for each Stripe account). Add a 'Source' column to identify the origin. Then combine all cleaned files in Excel for a complete cash flow view across all accounts.

Question 6

How do I handle Stripe refunds in reconciliation?

Accepted Answer

Refunds reduce your next payout or create a negative balance. They appear as negative amounts in Stripe exports. When reconciling, a smaller-than-expected bank deposit often means refunds were deducted. Check Stripe's payout details to see refunds included in each batch.

Question 7

Can PipeSheets automatically merge the files for me?

Accepted Answer

Yes! PipeSheets supports automated file merging. Select multiple files from your Files page, click 'Merge Files', and choose to stack files vertically (append rows) or join them horizontally on a key column like date or transaction ID. You can also apply additional cleaning after the merge. This makes reconciling Stripe exports with bank statements much easier.

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	9900	317	9583
2024-01-15 09:15:22 UTC	Stripe	ch_3def456	4500	161	4339

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

Merge Bank & Stripe Exports

Finally match those Stripe payouts to your bank deposits

Unified financial data for reconciliation

1Before

2After

What Gets Fixed

How It Works

Export from Stripe & Your Bank

Clean Each File Separately

Combine in Excel for Reconciliation

Frequently Asked Questions

Clean Your Financial Data