Reconciliation guide

How to reconcile Stripe payouts in Xero

In Xero, the cleanest way to handle Stripe is to treat Stripe as a bank account of its own. Customer payments, refunds and fees are reconciled there at their real amounts, and each payout becomes a transfer to your operating bank account.

By BillVerge · Updated · 8 min read · General accounting practice, not advice for your specific situation.

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.)

Example lines on the Stripe account in Xero. Account names are examples.
Stripe statement lineReconciled asAmount
ChargesInvoice payments and sales+$9,800.00
RefundCredit note refund−$120.00
Stripe feesSpend money · Merchant fees−$248.60
PayoutTransfer 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.

Where BillVerge fits

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.

Check a real payout in a minute

Upload a Stripe payout report and your bank CSV to the free Payout Reconciler and get a line-by-line gap report. Up to three payouts a month, no sign-up.