What Stripe export file format does this tool accept?

This tool accepts Stripe Export CSV files. Export from Stripe and upload the CSV file directly.

Can I convert Stripe CSV to Xero Import?

Yes, this tool converts Stripe Export CSV exports directly to Xero Import Format format compatible with Xero Import.

How do I import Stripe export to Xero Import?

Export your export from Stripe, upload the CSV file to this converter, then import the converted file to Xero Import.

Import Stripe Transactions to Xero — Bank Statement Format

🥦

Xero Import Format Format

imported

Import Stripe transactions to Xero's bank feed. Fee extraction, regional dates, reconciliation-ready format.

No API required

Browser-based processing

Run on Google Cloud Platform

Download Sample Stripe Export

Sample CSV to test the converter

Download Sample

Tool Rating

4.6 / 5 (521 votes)

How It Works

Export

Export from Stripe Dashboard (Balance, Payments, Invoices, or Customers)

Select Type

Choose the conversion type that matches your export

Configure

Set your Xero region and options

Import

Upload the converted file to Xero

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.

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)

Single ledger entry with gross, fee, and net

Key columns: id, Type, Amount, Fee

1:N — One input row creates multiple output rows

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

Why Stripe Exports Don't Import to Xero Directly

Format Mismatch

Stripe exports data in its own format — UTC timestamps, lowercase currency codes, and single-row transactions that combine gross amounts and fees. Xero expects regional dates, uppercase currencies, and prefers gross/fee separation for proper accounting.

What We Convert

- **Balance Transactions** → Xero Bank Statement (with fee splitting) - **Payments/Charges** → Xero Bank Statement (simple) - **Invoices** → Xero Sales Invoices - **Customers** → Xero Contacts Each conversion handles the format differences automatically.

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?

Multiple Export Types

Convert balance transactions, payments, invoices, or customers to Xero format.

Fee Splitting

Gross revenue and fees as separate entries for proper accounting.

Regional Dates

Automatic date conversion for UK, AU, NZ, US, and EU organizations.

Currency Handling

Currency codes normalized from lowercase (Stripe) to uppercase (Xero).

Batch Processing

Large files automatically split into batches for Xero's import limits.

Browser Privacy

All conversion happens locally. Your data never leaves your browser.

Frequently Asked Questions

For comprehensive accounting with fee tracking, use Balance Transactions. For simple payment records, use Payments. For AR/invoicing, use Invoices. Import Customers first if you'll be importing invoices.

Balance Transactions is Stripe's complete ledger — all charges, refunds, disputes, and fees. Payments is just the charge records. Balance Transactions with fee splitting is recommended for proper accounting.

Only if you're importing invoices. For bank statement imports, customer names are included in the transaction description. For invoice imports, the customer must exist in Xero first.