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 Invoice?

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

How do I import Square transactions to Xero Invoice?

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

Square Transactions to Xero Invoices Detailed Accounting

🥦

Xero Invoice CSV Format

valid rows

Create individual Xero invoices from Square POS transactions. Full accrual accounting with fee tracking, tips separation, and customer mapping.

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

Free preview before you pay

Files never leave your browser

No account needed to start

Sample Transactions

Example Square transactions export

Download

Tool Rating

4.5 / 5 (59 votes)

How to Convert Your File

Export from Square

Dashboard → Reporting → Transactions → Export CSV

Upload and Configure

Upload Transactions Export CSV and choose Sales Invoice format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Business → Invoices → Import → Upload CSV

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

How People Use This

Our retail group needs full accrual accounting for Square sales in Xero. I convert each month's transactions to invoice format with fee line items enabled, so processing fees post as separate expenses against the correct GL account. The SQ- invoice prefix prevents number conflicts with our existing Xero invoice sequence.

Several restaurant clients need per-transaction invoices in Xero for audit trail purposes. I convert their Square exports with tips separated into their own line items so gratuity income maps to a dedicated revenue account. The cash exclusion filter keeps only card transactions that flow through the clearing account.

I switched from the bank statement import to invoice format because my accountant wanted detailed line items for each Square sale in Xero. The converter creates individual invoices with sales, fees, and tips broken out. The custom account code mapping posts everything to the right accounts without manual reclassification after import.

We need accrual-basis records for each franchise location's Square transactions in Xero. I run each location's export through the converter with region set to AU and fee account code mapped to our chart of accounts. The per-transaction invoice format gives our auditors the line-item detail they require for the annual review.

Common Conversion Questions

When should I use Invoice format vs Bank Statement format?

Use Invoice format for detailed accrual accounting where you need to track each transaction as a receivable with line items. Use Bank Statement format for simpler clearing account reconciliation.

Why are fees negative amounts?

Square charges fees on each transaction. We post them as negative line items so they reduce the invoice total, reflecting the actual amount you receive.

How do I handle invoice number duplicates?

Use the Invoice Prefix option (default: SQ-) to ensure Square transaction IDs don't conflict with existing Xero invoice numbers.

Why Use Invoice Format for Square Transactions

Accrual Accounting Requirements

For full accrual-basis accounting, you need each transaction recorded as a receivable with detailed line items. Bank statement format is simpler but doesn't provide the same level of detail and audit trail.

Fee and Tip Tracking

Invoice format lets you track processing fees as separate expense lines, separate tips from sales for proper categorization, and map each component to the correct GL account. Use Invoice format for detailed line-item tracking; use Bank Statement format for simpler clearing account reconciliation workflows.

Your 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 Invoice

Square Transactions	Source Value		Xero Invoice	Target Value	Note
`Transaction ID`	`abc123def456`	→	`InvoiceNumber`	`abc123def456`	Unique invoice identifier
`Date`	`2026-01-15`	→	`InvoiceDate`	`2026-01-15`	Transaction date converted to regional format
`Customer Name`	`John Smith`	→	`ContactName`	`John Smith`	Customer name or 'Square Customer'
`Total Collected`	`102.20`	→	`UnitAmount (Sale)`		Gross sale amount
`Fees`	`-2.90`	→	`UnitAmount (Fee)`		Processing fee as expense (negative)
`Tip`	`5.00`	→	`UnitAmount (Tip)`		Gratuity amount (optional line)

Why Use This Converter?

Per-Transaction Invoices

Each Square transaction becomes a complete Xero invoice with unique number.

Fee Line Items

Processing fees posted as separate expense lines for accurate cost tracking.

Tip Separation

Optional separate line items for gratuities and tips.

Custom Account Mapping

Configure sales, fee, and tip account codes to match your chart of accounts.

Invoice Prefix

Customizable prefix prevents duplicate invoice number conflicts.

Browser Privacy

All processing happens locally in your browser.

Data Transformation

Each Square transaction becomes 1-3 invoice lines

One POS transaction

Key columns: Transaction ID, Date, Total Collected

1:N — One input row creates multiple output rows

CR Sale Line Revenue from sale

DR Fee Line (optional) Processing fee expense (negative)

CR Tip Line (optional) Gratuity (if tracked separately)

Common Sales Invoice Import Errors

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

Invalid Date Format

Xero rejects dates not matching your organization's format

2026-01-15

15/01/2026 (UK) or 01/15/2026 (US)

Select your Xero region for correct date format

Re-process with correct region selected

Duplicate Invoice Number

Invoice numbers must be unique in Xero

TXN001 (already exists)

SQ-TXN001 (with prefix)

Enable invoice prefix to avoid conflicts

Delete existing invoices or use different prefix

Fee Posted to Wrong Account

Processing fees should go to expense account, not revenue

Fee posted to Sales (200)

Fee posted to Processing Fees (404)

Configure separate fee account code

Review account mapping in Xero after import

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

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.

Use Invoice format for detailed accrual accounting where you need to track each transaction as a receivable with line items. Use Bank Statement format for simpler clearing account reconciliation.

Square charges fees on each transaction. We post them as negative line items so they reduce the invoice total, reflecting the actual amount you receive.

Use the Invoice Prefix option (default: SQ-) to ensure Square transaction IDs don't conflict with existing Xero invoice numbers.

This tool creates Invoices. For immediate payment scenarios without receivables, you may prefer the Bank Statement format which creates bank transactions.

Use per-transaction sync mode instead of daily summary to import individual line items from Square with full detail for better accounting visibility.

Our converter syncs Square customer data to Xero invoices automatically. Export invoices from Square, convert with our tool, and import to Xero with customer details included. For automated API-based syncing, third-party tools offer subscriptions, but our tool works perfectly for manual imports without monthly fees.

Yes, use specialized import tools that let you separate refunds from sales income so you can track them as separate line items in Xero.

Tips are included in your Square payout. Most tools automatically categorize them as income, but you can split them into a separate account if needed.

Map your Square tax rates to matching Xero tax codes during setup. Ensure tax-exclusive amounts are used so totals match your bank deposits.

Square deposits combine multiple days or includes pending transactions. Check your Square account for payout timing and ensure you're reconciling the correct date ranges.