Shopify Payout Reconciliation: Match Deposits and Fees

title: Shopify Payout Reconciliation: Match Deposits and Fees slug: shopify-payout-reconciliation-deposits-fees meta_title: Shopify Payout Reconciliation: Deposits and Fees meta_description: Use Shopify payout reconciliation to match bank deposits, transaction fees, refunds and reserves with payout and balance reports for store teams. primary_keyword: Shopify payout reconciliation secondary_keywords:

Shopify Payout Reconciliation: Match Deposits and Fees

Shopify payout reconciliation connects transactions, fees, refunds and adjustments in Shopify Payments to money received by the bank. A payout is not the same as a day's gross sales: transactions can settle on different dates, and a payout may include refunds, disputes, reserves or other balance activity.

Understand the records

Shopify's payout-details guide says the Payouts page shows pending and reserved funds, scheduled and previous payouts, and transaction exports. A payout marked Deposited was sent to the bank; Shopify notes that the bank may still need time to process it.

Reconcile one deposit

Open the payout and record its ID, currency, amount, date and bank reference if available. Export its transactions, then match the total to the corresponding bank statement entry. Investigate timing differences before assuming money is missing.

A simplified example: captured charges of $1,000, less $30 in processing fees and $100 in refunds, produce a $870 net payout if there are no other movements. Real payouts may include fee adjustments, disputes, reserves, prior-period transactions or other entries. Use the actual export rather than forcing the example formula onto every statement.

Reconcile a date range

Shopify's Shopify Payments activity report summarizes starting balance, activity, fees, payouts and ending balance by date range and payout currency. Use it to understand balance movement, then use individual payout exports for transaction-level investigation.

Because the report's stated balance change already includes payouts, do not subtract payouts again when using that field. A separate basic control is: starting balance plus net activity before payouts minus payouts equals ending balance, subject to the report's sign conventions and included categories. Reserved funds are not new sales revenue. Compare the report's dates and currency with your accounting period and bank records, and ask your accountant how to post each category.

Investigate common differences

Shopify's Shop Cash reconciliation guide says Shop Cash and another payment method can settle separately and a grouped payout row can cover multiple orders. Match IDs and payment methods rather than assuming one order equals one payout row.

Establish a monthly control

1. Export the relevant payout and balance reports in the correct currency.
2. Match each payout to the bank and flag unmatched or failed deposits.
3. Reconcile fees, refunds, disputes and reserve movements to source records.
4. Investigate transactions settling in a different period.
5. Review other payment providers separately.
6. Document adjustments and have finance approve the close.

See Shopify payout holds and reserves and payment-fee comparisons for related decisions. This is operational guidance, not accounting or tax advice.

7-day free trial · all themes included · cancel anytime