Stripe payouts won’t reconcile in Xero

A Stripe payout almost never matches a single invoice — and if it’s handled the wrong way it quietly double-counts your income and leaves a clearing account that never empties. Here’s why, and how to untangle it.

Why Stripe trips Xero up

One Stripe payout is a batch: several customer charges, bundled together, minus Stripe’s fees, paid into your bank as a single deposit. So the deposit never equals one invoice, and often doesn’t neatly equal any combination of them once fees are taken out.

The classic mess: an integration routes every charge into a clearing or “undeposited funds” account, the payout gets coded as fresh income on top of the invoices it was actually settling, and the clearing account just grows. Now income is overstated, the clearing balance is meaningless, and the bank rec won’t tie out.

How to untangle it

1. 1. Decompose the payout. Pull the Stripe balance history and break each payout into the individual charges and fees that make it up.
2. 2. Match charges to invoices. Each charge settles a specific invoice — link them, so income is recognised once, not twice.
3. 3. Book the fees. Stripe’s cut is an expense, not lost income — record it so the net ties to the deposit.
4. 4. Reconcile the net to the bank. The net payout should match the real bank deposit to the cent, and the clearing account should empty.

When to get help

A few payouts you can unpick by hand. Years of batched payouts through a clearing account is tedious and error-prone manually. That’s what Extrua Reconcile is for: it traces every payout back to the charges and invoices behind it, on a read-only copy, with the evidence for each change.

FAQ