What Square export file format does this tool accept?

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

Can I convert Square CSV to Xero Bank?

Yes, this tool converts Square Transactions CSV exports directly to Xero Bank Statement format compatible with Xero Bank.

How do I import Square transactions to Xero Bank?

Export your transactions from Square, upload the CSV file to this converter, then import the converted file to Xero Bank.

Square to Xero Integration Convert Transactions to Bank CSV

🥦

Xero Bank Statement Format

valid rows

Bridge the gap between Square POS and Xero accounting. Convert transaction exports to Xero-ready bank statement CSVs for seamless clearing account reconciliation.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample Square transactions export CSV

Download

How to Convert Square → Xero Bank

Export from Square

Dashboard → Reporting → Transactions → Export CSV

Upload and Configure

Upload Transactions Export CSV and choose Bank Statement format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Accounting → Bank Accounts → Select Account → Import Statement

Output is in Xero Bank Statement format — ready to import directly, no manual reformatting needed.

Square → Xero Bank Conversion Questions

What's the difference between single-line and two-line mode?

Single-line shows the Net Total (what hits your bank). Two-line separates the Sale (gross amount) from the Fee (Square processing charge), letting you track fees as a separate expense.

Why exclude cash transactions?

Cash payments don't go through Square's payment processing—they go straight into your cash drawer. Only card payments flow to your bank via Square. Excluding cash keeps your clearing account accurate.

How do I set up a Square clearing account in Xero?

Create a new bank account in Xero named 'Square Clearing' (type: Bank). Import these converted transactions there. When Square deposits to your real bank, transfer from Clearing to Bank to reconcile.

Why Square Doesn't Integrate Directly with Xero

The Integration Gap

Square's native Xero integration has limitations: it may not import historical data, lacks granular control over GL mapping, and struggles with complex scenarios like split tenders, gift cards, and multi-location tax jurisdictions. Many accountants need a CSV-based approach for proper financial control.

The Clearing Account Architecture

Professional accounting for Square requires a clearing account workflow: Square Clearing Account (asset) receives all card transactions, Real Bank Account receives actual deposits 1-2 days later, and you reconcile by matching clearing to bank when deposits arrive. Our two-line mode separates Sales from Fees, giving you accurate expense tracking and proper revenue recognition.

Your Square → Xero Bank Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Square Transactions fields map to Xero Bank Statement

Square Transactions	Source Value		Xero Bank Statement	Target Value	Note
`Date`	`2026-01-15`	→	`Date`	`2026-01-15`	Transaction date
`Total Collected`	`102.20`	→	`Amount`	`102.20`	Gross amount charged (single mode: Net Total)
`Fees`	`-2.90`	→	`Amount`	`-2.90`	Processing fees (two-line mode only, negative)
`Customer Name`	`John Smith`	→	`Payee`	`John Smith`	Customer name or 'Square Sale'
`Transaction ID`	`abc123def456`	→	`Reference`	`abc123def456`	Unique transaction identifier
`Description`	`In-store purchase`	→	`Description`	`In-store purchase`	Sale description with card info

Why Use the Square → Xero Bank Converter?

Clearing Account Ready

Creates bank feed for Square clearing account reconciliation workflow.

Fee Separation

Optional two-line mode splits sales from processing fees for expense tracking.

Cash Filtering

Exclude cash transactions that don't flow through Square to bank.

Regional Date Formats

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

Batch Processing

Handles large exports with automatic batching for Xero's 1,000 row limit.

Browser Privacy

All processing happens locally. Your financial data never leaves your device.

Data Transformation

Each Square transaction becomes 1 or 2 bank rows depending on mode

One POS transaction with sales, fees, tips, taxes

Key columns: Transaction ID, Date

1:N — One input row creates multiple output rows

CR Sale Line Money received from customer

DR Fee Line (two-line mode only) Square processing fee (negative)

Net Total = Total Collected + Fees (fees are negative)

Common Bank Statement Import Errors

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

Cash Transactions in Clearing

Cash doesn't flow through Square to bank

Enable 'Exclude cash transactions' option

Cash should go to separate Cash on Hand account

Fees Have Wrong Sign

Square exports fees as negative, Xero needs negative for outflows

We preserve the negative sign automatically

Check that fee rows show negative amounts

Transaction vs Deposit Date

Bank shows deposit on different day than transaction

This is normal - Square batches daily, deposits next day

Match by Deposit ID or batch deposits together

Gift Card Recorded as Revenue

Gift card sales are liability, not revenue

Enable gift card detection for proper handling

Post to Gift Card Liability account, not Sales

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Single-line shows the Net Total (what hits your bank). Two-line separates the Sale (gross amount) from the Fee (Square processing charge), letting you track fees as a separate expense.

Create a new bank account in Xero named 'Square Clearing' (type: Bank). Import these converted transactions there. When Square deposits to your real bank, transfer from Clearing to Bank to reconcile.

Tips and taxes are included in the Total Collected amount. For detailed tip/tax tracking, use the two-line mode and set up separate manual journals for the daily summary.

Gift card sales appear as regular transactions. For proper GAAP accounting, gift card sales should be posted to a liability account (deferred revenue), not sales. This requires manual adjustment.

Square bundles transactions and deposits next-day. Transaction dates and deposit dates differ by 1-2 business days. Match by date range, not individual transactions.

Our converter handles bulk CSV imports quickly without any subscription. Export your Square transactions, convert with our tool, and import to Xero in minutes. For automated API-based syncing, third-party apps offer recurring subscriptions, but our tool gives you full control without monthly fees.

Square deducts fees before depositing funds. With the integration, fees are automatically separated. For CSV import, ensure your fees account is mapped correctly.

Refunds reduce revenue and should be recorded separately. Use a clearing account to track gross activity, then reconcile the net payout to Xero.

Xero requires DD/MM/YYYY format for most regions or MM/DD/YYYY for US. Do not include currency symbols or thousand separators in amounts.