Books Watchdog

Xero

Shopify payout doesn't match the bank deposit in Xero

Xero's bank reconciliation shows the Shopify deposit with no match, or the invoices were marked paid in full so the money never lines up. Here's how payouts work and how to reconcile them.

Updated 11 November 2026

Why the numbers differ

Each Shopify Payments payout is several days of card charges, minus refunds, minus processing fees, plus or minus adjustments such as chargebacks, reserves and currency conversion. Your bank receives that net amount. Connectors usually do one of two things in Xero:

Shopify integration by Xero (Xero's free app) uses its own Shopify Payment Balance account in Xero. Depending on its settings, it posts either one summary per day or one entry per order, records fees as daily spend money, and creates a transfer from that account to your bank for each payout. That transfer is what you reconcile against the bank line.

Some connectors mark each invoice as paid straight into your bank account, at the gross amount. The bank then has a pile of small "payments" that never happened, and the real deposit has nothing to match. Merchants describe exactly this: deleting and redoing fake payments every month.

Other common causes: missing or wrong-amount orders, refunds that didn't sync, and PayPal or gift card sales mixed in with Shopify Payments.

Check by hand

1. Break the payout down in Shopify

  1. In Shopify admin, go to Finance → Payouts and open the payout with the bank line's date and amount.
  2. Note total charges, refunds, fees and adjustments. Use the export icon → Export payout transactions if you need the order list.

2. See where the money landed in Xero

  1. Find out where your connector records payments. Open one synced invoice in Sales → Invoices and look at the payment at the bottom: it names the account it was paid into.
  2. If it's a clearing account, run Reporting → All reports → Account Transactions for that account for the payout's dates. Money in should be the payout's charges, money out the refunds, fees and the transfer to the bank. The balance left over shows what's missing.
  3. If invoices were paid straight into the bank account, open Accounting → Bank accounts and look at that account's transactions: you'll see the per-invoice payments that don't exist in your real bank statement.

Fix it

  1. Use a clearing account. In the connector's settings, set Shopify Payments payments to go to a clearing account (create one in Accounting → Chart of accounts, as the account type the connector asks for), not your real bank account.
  2. Add what's missing: missing orders, refunds (as credit notes) and the payout's fees. Record fees as a spend money transaction from the clearing account to your merchant fees account: in Accounting → Bank accounts, open that account's menu and choose Spend money.
  3. Reconcile the deposit in Accounting → Bank accounts, then Reconcile on your bank account. Record the payout line as a transfer from the clearing account (the Transfer tab on the statement line), or use Find & Match if a transfer already exists. Once fees and refunds are in, the clearing account's balance for that payout goes back to zero.
  4. If invoices were paid into the bank directly, open each invoice, click the payment and remove it, then record it against the clearing account instead. Do this only for unreconciled payments, and check with your accountant if a return has been filed.