Payout Proof

Why your Shopify clearing account doesn't match Xero

If the "Shopify Payments" or "Shopify Payment Balance" account in your Xero chart of accounts never sits at exactly zero, you're not doing anything wrong — the way Shopify pays out and the way most connectors post sales are structurally mismatched. Here's the mechanism, and the three things it's usually hiding.

The actual mismatch

Shopify pays you out in batches — net of fees and refunds, often a few days after the sale, sometimes bundling several days of orders into one deposit. Most sync connectors (Amaka, A2X, and similar) post the sales side into your clearing account by day, gross, with fees recorded separately.

Those two groupings — Shopify's batches and the connector's daily postings — almost never line up dollar-for-dollar on any given date. A small leftover balance most of the time is completely normal timing lag. The problem is that a normal timing lag and a real error look identical from the account balance alone. Nobody can tell which one they're looking at without going payout by payout.

The three things it's usually hiding

In practice, dropped refunds are the single most common cause by a wide margin — they're easy for a connector to miss because they don't always arrive as a clean, matchable transaction.

How to tell which one you've got

Pull your Shopify payout list for the period in question and check each payout's net amount against the matching bank deposit. Where they agree, that payout is clean. Where they don't, you're looking at one of the three patterns above — and the only way to know which is to work back through what should have been posted for that batch versus what actually was.

That's the tedious part, and it's exactly why most businesses only look when a number is obviously, badly wrong, or when a bookkeeper flags it at year-end as a write-off.