Shopify Payments has no Xero bank feed. Import the payout report as one.

Why there is no feed for your Shopify Payments balance

Xero does not currently offer a native bank feed for the Shopify Payments balance. Sales-sync integrations post daily summary invoices into a clearing account, and your bank feed only ever sees the net deposit - the charges, refunds, adjustments and fees inside each payout never land in Xero as feed lines.

Shopify's payout export types every line - charge, refund, adjustment, dispute - with gross, fee and net columns per row, and two quirks bite on import: fees are stored as positive numbers (net equals amount minus fee), and refund rows show a zero fee because Shopify does not return the processing fee when you refund. Stores selling in more than one currency get separate payout streams per currency, each needing its own account in Xero. There is no running balance anywhere in the export, so an incomplete file looks identical to a complete one.

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 Shopify Payments 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 Shopify Payments and Xero

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.

• Import a PDF bank statementNative PDF import in the US and Canada, with plan and document requirements. Checked 30 September 2026.
• About bank feedsXero's own account of which feeds exist, how they connect and what they do not cover.
• Import a CSV bank statementThe manual import: the formats it accepts, and how it handles lines it has seen before.
• Bank Feeds API overviewThe interface StatementClear posts through, and the reason a fed line is not an imported one.

Related accounts

• Stripe bank feed for Xero: reconcile payouts against gross sales
• PayPal bank feed for Xero: import PayPal statements as a live feed
• Square has no Xero bank feed. Import the Square balance as one.
• Wise bank feed for Xero: import Wise statements as a live feed