Reconcile Stripe in Xero — Complete Payout Matching

🥦

Reconcile Complete

Xero Bank Statement Format
reconciled

Reconcile your Stripe account in Xero. Match individual transactions to bank deposits, track fees, and close your books accurately.

No API required
Browser-based processing
Run on Google Cloud Platform

Download Sample

Sample balance transactions CSV

Download

Tool Rating

4.7 / 5 (312 votes)

How It Works

1

Export

Stripe Dashboard → Balance → Export all transactions

2

Convert

Upload here, select fee splitting options

3

Import

Import to Stripe Clearing Account in Xero

4

Reconcile

Match bank deposits as transfers from Clearing Account

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

Field Mapping

How Stripe Balance_Transactions fields map to Xero Bank Statement

Stripe Balance_Transactions Source Value Xero Bank Statement Target Value Note
Created (UTC) 2025-01-15 14:00:00 → Date 01/15 14:00:00/2025 Regional date format conversion
Fee 3.20 → Amount (Row 2) Negative fee expense
Type charge → Payee charge Transaction type as payee label
id txn_1AbcXYZ123def → Reference txn_1AbcXYZ123def Balance transaction ID for audit trail

Data Transformation

Each charge/refund becomes 1-2 rows (gross + optional fee)

Input Stripe Balance Transaction

Single ledger entry with gross, fee, and net

Key columns: id, Type, Amount, Fee
1:N — One input row creates multiple output rows
Output Xero Bank Statement Rows 1-2 rows per input

Gross amount row + fee row (if fee > 0)

Why Stripe Reconciliation Is Challenging

The Aggregated Payout Problem

Stripe deposits aggregated amounts to your bank — multiple charges bundled into single deposits. Your bank shows $1,000 deposited, but that could be 50 individual charges minus fees. Professional bookkeepers solve this with a "Stripe Clearing Account" that receives individual transactions while your bank receives the aggregated payouts.

How This Tool Helps

We convert Stripe Balance Transactions to Xero bank statement format with fee splitting: individual charges as positive amounts, fees as separate negative amounts, refunds as negatives, and payouts excluded (they appear in your real bank). Import to your Stripe Clearing Account in Xero, then reconcile payouts as transfers. When done correctly, the balance should match Stripe's "Available Balance."

Common Bank Statement Import Errors

Issues you might encounter when importing Balance Transactions Export data to Bank Statement - and how we solve them

Date Format Mismatch

Xero may reject dates in wrong regional format

Select your Xero organization's region in options

Re-process with correct region setting

Payout Duplication

Including payouts creates duplicates with bank feed

Payouts are excluded by default (appear in real bank)

Reconcile payouts against actual bank deposits

Fee Sign Convention

Fees must be negative (money paid out)

We automatically convert fees to negative amounts

Verify fee rows show negative in Amount column

Why Use This Tool?

Transaction-Level Detail

Every charge, refund, and fee as individual bank statement lines.

Fee Tracking

Stripe fees extracted as separate expense transactions.

Payout Matching

Match individual transactions to aggregated bank deposits.

Month-End Ready

Clearing account should zero out when all payouts are matched.

Audit Trail

Transaction IDs preserved for tracking back to Stripe.

Browser Processing

Financial data processed locally. Never sent to external servers.

Frequently Asked Questions

Create a new bank account in Xero (Accounting → Bank Accounts → Add Bank Account). Name it 'Stripe' and select 'Other' as the account type. This acts as a holding account for Stripe transactions.
Payouts appear in your real bank account as deposits. Including them in the clearing account would double-count the money. The clearing account tracks individual transactions; your bank tracks aggregated deposits.
After processing all transactions and matching all payouts, your Stripe Clearing Account balance in Xero should match Stripe's 'Available Balance' in the Dashboard. Any difference indicates missing transactions or unmatched payouts.
Pending transactions haven't settled yet. Filter to 'Available' status for completed transactions, or include pending if you want to see everything.
Most businesses reconcile monthly. High-volume businesses may reconcile weekly. The key is consistency — reconcile at the same time each period.

Stripe → Xero Data Ecosystem

All available data flows from Stripe to Xero

Stripe Balance Transactions Export Complete financial ledger: charges, refunds, fees, payouts, disputes
→
Xero Bank Statement Bank transactions for reconciliation
Created (UTC) → Date Amount (Gross) → Amount (Row 1) Fee → Amount (Row 2)
Payout reconciliation, fee tracking Current tool
Stripe Customers Export Customer profiles with contact info and addresses
→
Xero Contact Customer or supplier contact records
Name → Name Email → EmailAddress Phone → PhoneNumber
Customer sync, supplier management
Stripe Invoices Export Invoice records with amounts, dates, and status
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
Number / id → InvoiceNumber Customer Name / Email → ContactName Created → InvoiceDate
B2B sales, invoiced orders, payment terms
Stripe Payments Export Payment charges with fees, customer info, and card details
→
Xero Bank Statement Bank transactions for reconciliation
Created (UTC) → Date Amount / Net → Amount Customer Name / Email → Payee
Payout reconciliation, fee tracking
Stripe Payouts Export Bank deposits with amounts, dates, and status
→
Xero Bank Statement Bank transactions for reconciliation
Arrival Date → Date Amount → Amount Description → Payee
Payout reconciliation, fee tracking Current tool