Reconcile a Stripe statement line with partially matched transactions

If your Stripe statement line includes a refund, chargeback, or payment completed outside of Xero, or if you’ve chosen not to automate your Stripe fees, Xero will create a partial match and you’ll need to enter the transaction or fee or manually. We recommend reconciling Stripe statement lines in chronological order.

Reconcile a statement line that includes a refund or chargeback

You’ll need to manually enter Stripe refunds and chargebacks in Xero.

  1. Raise a credit note with the refund or chargeback amount.
  2. Pay the credit note.
  3. On the bank reconciliation screen, next to the statement line you want to reconcile, click Find & Match.
  4. Find and select the checkbox next to the paid credit note you want to match with the bank statement line.
  5. Click Reconcile.

Reconcile a statement line that includes a payment completed outside of Xero

You’ll need to manually enter any payments completed outside of Xero when reviewing your Stripe statement lines.

  1. On the bank reconciliation screen, next to the statement line you want to reconcile, click the Create tab.
  2. Create a receive money for each payment.
  3. Click Save Transaction.

Reconcile a statement line that includes a bank fee

If you haven’t chosen to automate your Stripe fees in Xero and imported a Stripe statement line that includes a fee, add a bank fee adjustment while you're reconciling. This lets you match the statement line with the transaction in Xero.

To set up Stripe fee automation:

  1. Go to Settings, then click General Settings.
  2. Under Connect, select Payment Services.
  3. Find the payment service you want to edit. Click Edit, then select Service details.
  4. Select the checkbox next to Automate my fees.
  5. Under Fees Account, select an account.
  6. Click Save.