Which Shopify report do I upload - payouts or sales?

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.

Shopify stores fees as positive numbers. How is that handled?

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.

I sell in two currencies. One feed or two?

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.

Is this just another CSV import with extra steps?

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.

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.

Join the waitlist

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.

Step 1
Connect Xero
Link your org and pick the account that has no feed.
Step 2
Upload your Shopify Payments statement
PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.
Step 3
We check it first
Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.
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

Related accounts

Stop importing Shopify Payments statements. Start feeding them.

Tell us how your Shopify Payments setup is structured and we'll get you connected.