How to Reconcile Stripe Payouts in Xero with CSV Exports

Why the bank deposit is not the sales total

A Stripe payout is usually a net settlement. It may combine charges, processing fees, refunds, disputes, adjustments, and transactions that became available on different dates. Comparing that deposit directly with gross sales therefore leaves an unexplained difference.

The useful review unit is a payout bridge: start with the transactions allocated to one payout or availability date, separate each movement type, and compare the resulting Stripe net amount with the bank or Xero-side amount.

Files and fields to prepare

Export a Stripe balance or transaction report as the primary source. An optional payout, bank, or Xero export confirms the deposited amount. An optional WooCommerce or sales export provides a separate gross-sales comparison.

• Stripe: created date, type, amount, currency, and preferably fee, net, available date, transaction ID, payout ID, and order ID.
• Payout or bank side: date, amount, currency, and preferably payout ID or reference.
• Sales side: date, gross amount, currency, and preferably transaction ID or order ID.

Build and review the bridge

Normalize the exports, group Stripe rows by payout ID when available, and otherwise use availability date plus currency. Review gross sales, fees, refunds, disputes, adjustments, Stripe net, payout amount, and residual separately for each currency.

A zero or small residual only proves that the provided files tie at the selected level. Account coding, tax treatment, journal entries, and final accounting conclusions still require the merchant or accountant to confirm the source data and intended treatment.