Shopify Fees, Refunds, and Payout Mismatch Checklist

Start with identity and period

A payout mismatch is easier to solve when the team can name the exact store, provider, payout currency, period, payout ID, and bank account. Save the sales or finance report, Shopify Payments activity report, payout detail, refund evidence, and bank statement line for the same review window. If multiple currencies or gateways exist, never combine them before each source has been reconciled.

Also check the date definition. Shopify's payout guidance says payment capture timestamps are recorded in UTC, and Friday through Sunday captures can be grouped into one payout. A local month-end report and a settlement report can therefore contain different transaction populations while both are internally correct.

Run the mismatch checklist

Work from gross activity to the bank rather than starting with the deposit. Confirm captured payment lines, then identify refunds, processing fees, disputes, reserves or holds, and payouts. Check whether a fee belongs to Shopify Payments or another provider. Confirm that a refund is linked to its original payment and that a dispute remains open until its outcome is known.

Next, compare the report's ending balance with the prior period's closing balance. Match each payout detail to one bank line or an explicitly documented bank batch. If a payout is absent, check whether it is still pending, was sent near a weekend or holiday, or is in the bank's processing window. If a bank line is larger or smaller than expected, inspect the payout's component rows rather than changing the sales total.

• Scope: correct store, provider, payout currency, dates, and permissions.
• Transactions: captured payments, refunds, disputes, holds, and releases.
• Deductions: provider fees and other documented adjustments, kept separate.
• Settlement: payout ID, payout amount, bank reference, and arrival date.

Use categories, not assumptions

Shopify describes the activity report as a view of Shopify Payments balance activity. Its summary includes starting balance, gross activity, fees, payouts, net movement, and ending balance; the report can show related line items under charges, refunds, disputes, fees, reserves and holds, and payouts. It is not a statement of revenue, and it does not include Shopify billing fees or third-party processors and methods.

That distinction prevents four common errors: treating a hold as an expense, treating a dispute as necessarily final loss, assuming a refund always returns fees, and treating a bank deposit as new revenue. Keep each item in its documented category until the provider record and the merchant's accounting policy support a different treatment.

Fictional simplified example

This is a fictional simplified worked example, not a provider fee quote. Suppose a selected report starts at $0 and shows $5,000 of captured payment activity, $350 of refunds, $150 of fees, $200 of dispute activity, and a $100 release from a reserve or hold. It also shows $4,000 of payouts. The arithmetic is $0 + $5,000 - $350 - $150 - $200 + $100 - $4,000 = $400 ending balance.

The $400 is an unexplained remaining balance only until the report's full line detail explains it; it is not automatically revenue. The $200 dispute is not automatically a final loss, the $100 release is not a sale, and the $150 fee should not be deducted again from the bank match. If the $4,000 deposit appears in the next month, carry it as a documented settlement timing item.

Package the review for Xero or QBO

A useful handoff includes the report filters, source exports, payout and bank identifiers, a bridge from opening to ending balance, and an exceptions table. A generic clearing-account workflow can keep captured receipts, fees, refunds, and payout clearing separate until the evidence is reviewed. The merchant and adviser should choose account names and posting policy; this article is not tax advice and does not calculate GST or VAT.

Close each exception with a source, not a guess. If the item is a timing difference, record the expected next evidence. If it is a missing refund, fee, or dispute line, request the provider detail. If it is a hold, keep availability and expense concepts separate. Review before posting, and retain the trail a future month-end reviewer will need.

Sources and further reading

For report scope, balance categories, and the warning that activity is not revenue, read Shopify's Shopify Payments activity report. For settlement, weekend, and bank-processing timing, read Understanding Shopify Payments payout timing.

Payout Explainer is coming soon

Payout Explainer is coming soon. Join the waitlist for a review-before-posting workflow that helps surface payout exceptions before an entry is considered. It will not provide tax or FX advice, and this article does not claim current upload or connect availability.