How to Reconcile Shopify Payments Payouts in Your ERP

“The Shopify deposit doesn’t match” is one of the most common complaints finance teams have about an ecommerce integration, and it’s almost never a bug in Shopify. Payouts are net amounts that bundle many movements, and books that only record gross sales will never tie out to the bank. This guide explains the accounting pattern and how to automate it. It’s integration guidance, not accounting advice — agree the account structure with your accountant. As on every page, documented marks statements from Shopify documentation, and recommendation marks our guidance.

What a payout actually contains

Documented: through the Admin GraphQL API, the Shopify Payments account exposes payouts — transfers between the Shopify Payments balance and your bank, each with a net amount, issue date, status, and a summary — and balance transactions, each recording a money movement such as a charge, refund, adjustment, or payout, with its gross amount, fee, and net, a type, and the payout it’s associated with. Reading this data requires the read_shopify_payments or read_shopify_payments_accounts access scope.

That means a single payout can contain:

Movement	Effect on payout
Card charges from several days	+ gross amount, − processing fee
Refunds	− refunded amount (fees may or may not be returned)
Chargebacks and dispute fees	− disputed amount, − dispute fee
Won disputes	+ reversed amount
Adjustments and reserves	+ or −
Other gateways (PayPal, manual payments)	Not included at all

The accounting pattern

Recommendation: three steps.

1. At sale: post the payment to a Shopify Payments clearing account, not to the bank. (Other gateways get their own clearing accounts.)
2. At payout: post one deposit per payout:
   • debit Bank for the payout net,
   • debit Merchant fees expense for processing fees,
   • debit or credit chargebacks, adjustments, and refunds to their own accounts as appropriate,
   • credit the clearing account for the gross payments the payout settles.
3. Check: after each payout, the clearing account balance should return to roughly zero (plus payments not yet paid out). A growing balance is the signal that a payment, refund, or adjustment wasn’t posted.

Automating it with the Admin API

Recommendation: run a scheduled job (see scheduled synchronization) that:

1. Lists payouts issued since the last checkpoint, with their status.
2. For each payout that has reached its final status, fetches the balance transactions associated with it.
3. Groups transactions by type and sums gross, fees, and net.
4. Verifies that the sum of nets equals the payout’s net. If not, stop and alert — don’t post a partial deposit.
5. Posts the deposit to the ERP with the payout ID as the external reference, so a rerun can’t post it twice.

query PayoutsSince($after: String) {
  shopifyPaymentsAccount {
    payouts(first: 20, after: $after) {
      nodes {
        id
        issuedAt
        status
        net { amount currencyCode }
      }
      pageInfo { hasNextPage endCursor }
    }
  }
}

Illustrative only. Filtering options, the balance transaction query arguments, and status values depend on your API version — check the Shopify Payments objects in the GraphQL Admin reference for the version you pin. Don’t assume every balance transaction is available the moment a payout appears: design the job to retry a payout whose transactions don’t add up yet, rather than failing permanently or posting a partial deposit.

Refunds and chargebacks

Recommendation:

• Refunds have two sides: the sales/tax reversal in your books (posted when the refund happens — see refunds and cancellations) and the cash movement in the payout. Keep both linked through the order reference.
• Chargebacks are their own events. Book the disputed amount and dispute fee when they hit the balance, and reverse them if the dispute is won. Don’t edit the original sale.

Multiple currencies and stores

Recommendation: reconcile per Shopify store and per payout currency, each with its own clearing account. If you sell in several currencies, decide with your accountant where currency conversion is recognized — at sale, at payout, or both — and record the exchange difference explicitly instead of letting it hide in the clearing balance.

Other channels

The same pattern works for marketplaces: Amazon and Walmart settlements net sales against their fees over a period, and you reconcile the settlement, not individual orders. See Amazon and Walmart marketplace integration. For accounting-system specifics, see Shopify + QuickBooks Online and Shopify + NetSuite.

Common pitfalls

• Payments posted straight to the bank, so deposits never match.
• Fees never recorded, overstating revenue and cash.
• Posting a payout before all its balance transactions are available.
• No external reference on the deposit, so a rerun posts it twice.
• Ignoring other gateways, leaving PayPal or manual payments in the Shopify clearing account forever.