Payment Platforms

When a Stripe payout does not match your sales records, there are six places to check before assuming the data is wrong. This explains each one in the order most likely to find the cause quickly.

Stripe marketplace payouts split funds across multiple connected accounts. Matching these payout files against internal account ledgers requires a different approach than standard Stripe reconciliation.

Startup finance teams reconciling gateway payout spreadsheets without a data engineer need a file-based workflow that does not require SQL, Python, or API access. This is that workflow.

Shopify order exports and bank deposit records do not share a common reference. This explains how small e-commerce brands match orders to deposits without connecting Shopify to their bank directly.

Stripe payment records and FreshBooks invoice exports use different references and do not share a common match key. This explains how independent consultants reconcile the two files reliably.

Bank statement dates and Stripe payout dates are rarely the same. This explains why the dates differ, how timing affects matching, and the exact approach that resolves the mismatch.

Stripe transaction exports and Xero CSV downloads use different references, dates, and amount formats. This explains the file-based reconciliation workflow that works without connecting the two systems.

Klarna settlement CSV files and Shopify sales logs use different order references and settlement dates. This explains how to reconcile the two files and identify unmatched or delayed settlements.

Copy-pasting Shopify CSV rows into Excel changes data types silently: dates become numbers, IDs get truncated, and amounts lose formatting. This is why the matching breaks after paste.

Stripe subscription invoice logs and monthly bank statements rarely align by date or amount. This explains how recurring billing cycles, proration, and timing differences affect the reconciliation.

Stripe dispute CSV exports list chargebacks by dispute ID, not by order ID. This explains how to match dispute records against your order spreadsheet and identify which sales were affected.

WooCommerce order references and Stripe payout log IDs do not share a common key by default. This explains how to build a match between the two files reliably.

Payment processor CSV export layouts change without warning. When column names or positions shift, every matching formula built on the previous layout fails silently.

Stripe fee exports and internal sales reports use different references and amount types. This explains how to compare them accurately and identify where fees are understated or missing.

eBay Managed Payments CSV exports combine sales, fees, refunds, and adjustments in a single file. This explains how to reconcile eBay exports against a ledger or cashbook accurately.

Shopify sales exports and PayPal transaction CSVs share no common reference by default. This explains how to identify unmatched rows when the two files use different order and payment IDs.

Square settlement CSV reports bundle multiple transactions into single deposits. This explains how to match Square settlement exports against bank statement deposits reliably.

Stripe records transactions in UTC. Your bank statement uses local time. That timezone gap shifts dates by one day and causes false mismatches in every row-by-row comparison.

PayPal monthly exports use different date ranges, net amounts, and references than bank statements. This explains the exact reconciliation approach that accounts for fees, refunds, and timing.

Shopify order IDs and Stripe transaction IDs are not the same reference. This explains how to build a reliable match between Shopify order exports and Stripe transaction CSVs.

Shopify order exports and Stripe payout CSVs use different IDs, dates, and amount formats. This explains exactly why matching them manually takes so long and where the process breaks down.

A Stripe payout CSV and a bank statement use different references, dates, and amounts. This explains the exact matching approach that works when the two files do not align directly.

Excel auto-converts long PayPal transaction IDs to scientific notation, destroying the reference you need to match records. Here is why it happens and how to prevent it.