Skip to content
StatementClear
Start a free trial

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

Xero has no native bank feed for the Shopify Payments balance. Sales-sync apps post daily summary invoices to a clearing account, and your bank feed only ever sees the net deposit. StatementClear posts the charges, refunds, adjustments and fees into Xero as live feed lines.

Every Shopify payout lands in your bank feed as a single net figure, while the charges, refunds, adjustments and fees that produced it sit in a payout report Xero never sees. Reconciling means downloading that report and picking the deposit apart by hand, every month. StatementClear turns that payout report into a live bank feed in Xero, deduped and checked, so the net deposits match off as transfers.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

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. StatementClear maps those columns once, keeps gross activity separate from fee lines, catches duplicates and sign errors before anything posts, and feeds the balance as its own account - so each net payout in your bank feed reconciles as a transfer instead of a mystery deposit.

The manual way, every month

  • Log in and export a statement (and hope the format didn't change)
  • Reformat columns, dates and signs until Xero's importer accepts it
  • Upload the CSV into the right account and pray nothing doubled up
  • Eyeball the balance, fix what broke, repeat next month

And after all that, it still isn't a feed - it's a one-off import you'll redo next month.

The StatementClear way: a real feed

Upload the statement and it posts into Xero as a live bank feed through Xero's Bank Feeds API - deduped, balance-checked and ready to reconcile. Not another file to import. Converters hand you a CSV; this arrives in Xero the way a bank feed does.

  1. Step 1

    Connect Xero

    Link your org and pick the account that is missing transactions.

  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

    Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.

  4. Step 4

    It lands as a feed

    Clean lines arrive in Xero through the Bank Feeds API, ready to reconcile.

Questions about Shopify Payments and Xero

The payout export, from Settings, then Payments, then View payouts, then Transactions. It is the one that shows gross, fee and net per line and ties to the money that actually moved. Sales reports describe orders, not cash, and will never tie to your bank.

The column mapping tells StatementClear which columns are money in, money out and fees, and it is saved after the first upload. Sign and direction checks then catch any file that would run the account the wrong way before a single line posts to Xero.

Two - one per payout currency, matching Shopify's own per-currency payout streams. Each feed posts into a matching currency account in Xero, and each keeps its own saved mapping.

No. Converters hand you another file that you still import by hand, and it never becomes a feed. StatementClear posts lines through Xero's Bank Feeds API, so they arrive in Xero as live feed lines, deduped and ready to reconcile.

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.

  • 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

Stop importing Shopify Payments statements. Start feeding them.

Connect Xero, drop in a Shopify Payments statement, and watch the lines arrive as feed lines.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

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