WooCommerce, Shopify and BigCommerce to Xero accounting workflows. Book a demo
Stripe reconciliation

Keep WooCommerce Stripe sales, payouts and fees understandable in Xero

The Stripe payment on a WooCommerce order is evidence of captured customer money; the later bank payout is a settlement. Treating those as the same event is what creates unexplained differences.

A Stripe clearing workflow

When eligible WooCommerce orders are paid through Stripe, their gross payment amount can be allocated to a Stripe clearing account as part of the Xero sales record. The later Stripe payout reduces that clearing balance when it reaches the bank.

Fees should not reduce sales

If Stripe pays £4,850 to the bank for £5,000 of captured customer money, the £150 difference is not missing revenue. It is normally a processor fee or another settlement adjustment that needs its own accounting evidence and account.

Refund dates matter too

A refund may occur days after the original order. Keeping the refund's source reference and date avoids silently rewriting the original sales day and helps explain why a later Stripe settlement is lower.

What ClearCommerce controls

The WooCommerce payment method remains source data. The store mapping chooses the Xero clearing account and posting treatment, while daily-summary or individual-invoice rules decide the sales document.

Example

Captured Monday, paid out Wednesday

Monday

£5,000 of Stripe-paid WooCommerce activity joins Monday's paid-date summary and increases the Stripe clearing balance.

Wednesday

The payout arriving in the bank is matched against Stripe clearing rather than posted as a second sale.

Difference

Processor fees or adjustments are posted separately so the clearing movement can be explained.

Why the numbers look "wrong" at first

Stripe payouts almost never match a single day of sales

A Tuesday payout can contain Monday's late orders, part of Tuesday's captures, and none of Wednesday's — plus the rolling fee deduction. That is normal, not a reconciliation error.

What you seeWhat is actually happening
Payout is smaller than the day's salesStripe fees (typically 1.4%–2.9% plus a fixed charge) were deducted before transfer
Payout date does not match order dateStripe batches captures on a rolling settlement cycle, often T+2 for UK cards
Payout total does not match any single dayRefunds, disputes and reserve holds are netted into the same payout
Questions people ask

FAQs

Why doesn't the Stripe payout match one day of WooCommerce sales?

Stripe settles on a rolling cycle and nets fees, refunds and reserves into each payout, so a single payout rarely lines up with a single trading day.

Can Stripe fees be tracked separately in Xero?

Yes. Stripe fee data can be mapped to its own expense account so gross sales, fees and net settlement all remain visible instead of being netted into one figure.

How does ClearCommerce handle Stripe refunds?

Refunds are imported with their source reference and applied through the same mapping layer as the original sale, keeping the Stripe clearing account traceable.

Want to test your Stripe numbers before exporting?

Use a small WooCommerce date range, map Stripe to the correct Xero clearing account and preview the result first.

Book a demo