The idea: give Stripe its own account
A Stripe payout is net: charges, minus refunds, minus Stripe fees, minus disputes and adjustments. If you reconcile that net deposit directly against invoices in your main bank account, nothing adds up, and the fees vanish into a rounding entry.
Instead, you hold all Stripe activity in a separate Stripe account in Xero. It works as a clearing account: its balance should track your Stripe balance, and every payout moves money from it to your real bank account.
Set up the Stripe account in Xero
- Add a bank account in Xero named something like Stripe or Stripe Clearing. Using a bank account (rather than a plain current asset account) is what lets you reconcile statement lines against it.
- Make sure you have an expense account for Stripe fees, for example Merchant fees or Bank fees.
- If you settle Stripe in more than one currency, create one Stripe account per currency. Foreign currency bank accounts need a Xero plan that supports multiple currencies.
- If customers pay Xero invoices through Stripe using Xero’s payment services, check which account those payments are recorded to and point it at the Stripe account, so invoice payments and payouts end up in the same place.
Get Stripe activity into the Stripe account
The Stripe account needs statement lines just like a real bank account. You have two common options:
- A connector or feed that sends Stripe balance activity to Xero for you.
- Importing a statement file: export Stripe balance activity (for example the itemized payout reconciliation report, which lists each balance transaction in each automatic payout with gross, fee and net amounts) and import it into the Stripe bank account as a bank statement.
Either way, the goal is a line for each charge, refund, dispute and fee (or a daily or per-payout summary of them), plus a line for each payout leaving Stripe.
Reconcile charges, refunds and fees
- Charges that pay invoices: match them to the invoice payment, at the gross amount.
- Charges with no invoice: create a receive-money transaction coded to the right revenue account, or post a daily summary.
- Refunds: match to a credit note refund, or create a spend-money transaction against the revenue or refunds account.
- Stripe fees: create a spend-money transaction coded to your fees account. One per payout is usually enough if the fees arrive as a total.
- Disputes: Stripe withdraws the disputed amount and a dispute fee from your balance when a dispute opens. Code the amount against the original sale or a disputes account, and the fee to fees. If the dispute is won and money returns, reconcile that line too.
Reconcile each payout as a transfer
On the Stripe account, the payout appears as money leaving. Reconcile it as a transfer to your operating bank account. When the deposit appears in your operating bank feed, reconcile it against that same transfer. Do not code it to revenue: the revenue was already recorded when the charges were reconciled.
Worked example
A payout of $9,431.40 covers $9,800.00 of charges, one $120.00 refund and $248.60 of Stripe fees. (Example data.)
| Stripe statement line | Reconciled as | Amount |
|---|---|---|
| Charges | Invoice payments and sales | +$9,800.00 |
| Refund | Credit note refund | −$120.00 |
| Stripe fees | Spend money · Merchant fees | −$248.60 |
| Payout | Transfer to operating bank | −$9,431.40 |
| Stripe account balance after the payout | $0.00 | |
In the operating bank account, the $9,431.40 deposit is reconciled against the transfer. Revenue is $9,800.00 gross and fees are $248.60.
Month-end check
At month end, compare the Stripe account’s balance in Xero with your Stripe balance on the same date. They should agree, apart from payouts that Stripe has sent but your bank has not yet received, depending on which date you use for the transfer. If they do not agree, something was recorded on one side only; work through payouts one by one.
The usual culprits are covered in why a Stripe payout does not match the bank deposit. If you use QuickBooks Online as well or instead, the QuickBooks guide uses the same structure.
BV Recon ties each payout to its charges, fees and refunds and matches it to the bank, then raises anything it cannot explain as an exception. Try it on one payout with the free Payout Reconciler.