Import Square Transactions to Xero — Bank Statement Upload Tool

🥦

Import Complete

Xero Bank Statement Format
valid rows

Import your Square POS data directly into Xero. Upload CSV exports and convert them to Xero-compatible bank statement format for instant import.

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

Sample Square CSV

Example Square transactions export

Download

Tool Rating

4.5 / 5 (189 votes)

How It Works

1

Export from Square

Square Dashboard → Transactions → Export CSV

2

Upload Here

Drop your Square CSV and select your Xero region

3

Preview Results

Check the converted transactions look correct

4

Download & Import

Download the Xero CSV and import to your bank 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 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

Data Transformation

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

Input Square Transaction

One POS transaction with sales, fees, tips, taxes

Key columns: Transaction ID, Date
1:N — One input row creates multiple output rows
Output Xero Bank Line 1 or 2 rows per input

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)

Getting Square Data Into Xero

The Import Challenge

Square exports transactions in its own CSV format, but Xero expects a specific bank statement structure. This tool transforms Square's export into exactly what Xero needs—with proper date formatting, amount handling, and references.

What Gets Imported

Each Square transaction becomes a bank statement line in Xero: - **Date**: Transaction date formatted for your region - **Amount**: Net total (what hits your bank) - **Payee**: Customer name or "Square Sale" - **Reference**: Square transaction ID for audit trail - **Description**: Card type and location info

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

Why Use This Tool?

One-Click Import Ready

Output matches Xero's bank import format exactly. No manual editing needed.

Automatic Date Formatting

Dates converted to your Xero region's format automatically.

Transaction References

Square transaction IDs preserved for cross-referencing with Square Dashboard.

Batch Import Support

Large exports split into 1,000-row batches (Xero's limit).

Free Preview

Preview 10 converted transactions before purchasing.

Secure Local Processing

Data processed in your browser. Nothing uploaded to servers.

Frequently Asked Questions

Create a dedicated 'Square Clearing' bank account in Xero. This separates Square transactions from your actual bank feed and enables proper clearing account reconciliation.
In Xero: Accounting → Bank accounts → Square Clearing → Manage Account → Import a Statement. Select the downloaded CSV and confirm the import.
We automatically split large exports into multiple 1,000-row files (Xero's import limit). You'll download a ZIP file containing numbered batches to import sequentially.
Yes! Export any date range from Square and import it. This is useful for migrating to Xero or catching up on backlogged bookkeeping.
We import Net Total (after fees). This matches what arrives in your bank. Use two-line mode if you need separate fee tracking.

Square → Xero Data Ecosystem

All available data flows from Square to Xero

Square Customers Export Customer directory with contact info, addresses, and purchase history
→
Xero Contact Customer or supplier contact records
Given Name + Family Name → Name Email Address → EmailAddress Given Name → FirstName
Customer sync, supplier management
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Xero Bank Statement Bank transactions for reconciliation
Date → Date Total Collected → Amount Fees → Amount
Payout reconciliation, fee tracking
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
Transaction ID → InvoiceNumber Date → InvoiceDate Date + terms → DueDate
B2B sales, invoiced orders, payment terms