Skip to content

Square has no Xero bank feed. Import the Square balance as one.

Xero offers no native bank feed for the Square balance. Square's own Xero integration posts a daily summarised sales invoice into a clearing account, which is a sales sync, not a feed. StatementClear lets you review the statement, then send eligible lines to Xero or download a Xero-ready CSV. Direct delivery supports dates within the last year; older history uses CSV.

Your bank feed shows one net deposit per Square transfer - sales minus fees, refunds and tips - and Xero never sees what happened inside the balance. So each month someone exports the transfer report and reverse-engineers the difference by hand. StatementClear lets you review the statement, then send eligible lines to Xero or download a Xero-ready CSV. Direct delivery supports dates within the last year; older history uses CSV.

Upload a statement

1 complete statement free per account. No card required.

Why there is no feed for your Square balance

Xero does not currently offer a native bank feed for the Square balance itself. Square's own Xero integration posts a daily summarised sales invoice into a clearing account, which is a sales sync rather than a feed - the balance's own ins and outs never arrive in Xero as bank feed lines.

Square settles net: each transfer bundles sales, refunds, tips and per-transaction fees into a single deposit, and that one figure is all your bank feed sees. The detail lives in the transfer and transaction CSVs on the Square Dashboard, which report gross, fee and net for every payment - three amounts per line where Xero wants one, so the column you map decides whether your ledger shows takings or takings-less-fees. Transfers also refuse to line up with calendar days: a weekend's trading typically rolls into one Monday deposit, which is why deposit-by-deposit matching against daily sales never quite works.

The manual way, every month

  • Download the statement for the missing period
  • Check the file format, dates and signed amounts
  • Import into the correct Xero account and review overlaps
  • Compare the closing balance and reconcile the lines

A usable CSV or OFX from the provider may be enough. Native PDF import is also available for eligible US and Canadian Xero organisations.

Review the statement, then choose how to import it

Preview the extraction, check the transactions, then send eligible lines through Xero's Bank Feeds API or download a Xero-ready CSV. Direct delivery supports dates within the last year and can be blocked by another provider's feed connection. Use CSV for older history. Overlap checks cover previous uploads to the same StatementClear feed, so also check any period already imported from other sources.

  1. Step 1

    Start with your statement

    Preview a file before choosing how to get it into Xero.

  2. Step 2

    Upload your Square statement

    PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.

  3. Step 3

    We check it first

    Review dates, amounts and signs. Balance checks use the source data, and overlap checks use prior StatementClear uploads.

  4. Step 4

    Send to Xero or download CSV

    Send eligible lines directly to Xero or download a Xero-ready CSV. You complete reconciliation in Xero.

See the PDF-to-Xero workflow · Check PDF import in your region

Questions about Square and Xero

Both, in the right places. The Square balance feed carries the gross activity and the fee lines; your bank account already shows the net deposits. With both sides present, each payout reconciles as a transfer and the fees stop disappearing into the difference.

No. That app posts a daily summary invoice, which is a sales record, not a feed - the balance's actual movements never become bank lines. StatementClear lets you review the statement, then send eligible lines to Xero or download a Xero-ready CSV. Direct delivery supports dates within the last year; older history uses CSV.

The transaction or transfer CSV from the Square Dashboard works, and so does a PDF statement. You map the columns once - including which of gross, fee and net to use - and the mapping is saved for every future upload on that feed.

As a transfer. The Square balance becomes its own Xero account holding the gross sales, fees, refunds and tips; the payout leaves that account and arrives on your bank feed as the same figure, so the two match off instead of being reverse-engineered.

Where this comes from

Everything above about what Xero's native feed covers, what its manual import accepts and how feed lines reach a bank account comes from Xero's own documentation. The relevant pages are below, so you can check the claim rather than take it.

Related accounts

Get your Square statement into Xero.

Upload a Square statement and review the preview. Your first complete statement is free.

Upload a statement

1 complete statement free per account. No card required.

Browse every bank and platform or read the Xero bank feed guides.