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.