How to reconcile Shopify Payments payouts to bank deposits

Use the payout as the bridge

Reconciling each Shopify order directly to the bank is usually the wrong level of detail. Charges, refunds, fees, chargebacks, adjustments, and reserves first change the Shopify Payments balance. Shopify then sends available funds to a linked bank as a payout. Only Shopify Payments activity belongs in this reconciliation. Exclude other gateways, even when those orders appear in the same store.

Your reconciliation therefore has two related checks. First, confirm that the balance transactions assigned to a payout explain its net amount. Second, match that payout to the bank deposit or debit. If the export already isolates deposited payout totals with a reliable Net amount, begin with the second check and retain the surrounding transactions as support.

Export files with enough overlap

From the Shopify admin, go to Settings, then Payments, then View payouts, then View Transactions, then Export balance transactions. An alternate path is Finance, then Payouts, then Transactions, then Export. Keep the columns you need for matching and support: Transaction Date, Type, Order, Card Brand, Card Source, Payout Status, Payout Date, Available On, Amount, Fee, and Net. From the bank, export statement lines with posting date, description, debit, credit, and currency.

Build a working set of payout totals rather than matching every order. Group the exported rows by payout date and currency, then sum Net. The Payouts page shows the payout total, status, destination, and transfer reference. Finance, then Documents, also provides a payout reconciliation report that can support composition. Use that report as evidence, not as a replacement for the bank match.

Include several business days on both sides of month end. Settlement timing varies by country. A Deposited status means Shopify has sent the funds. The bank can still take one to three additional business days to post the deposit. An overlap prevents ordinary clearing from appearing as missing.

Confirm that the Shopify Payments destination matches the bank account under review. Businesses with more than one store, more than one settlement currency, or more than one linked bank can compare a valid payout with the wrong statement. Also confirm that the export covers only Shopify Payments and not another payment provider used on the same store.

Normalize dates, signs, and currencies

Shopify supplies Transaction Date, Payout Date, and Available On. The bank supplies a posting date. Choose the date that best represents payout initiation, retain the other dates as reference, and compare within a documented business-day window that includes ordinary bank clearing days. Do not rewrite dates to make records match.

Normalize the sign convention before matching. A deposited payout should normally correspond to a bank credit. Withdrawn payouts can post as bank debits. Verify both conventions with a known deposit and a known debit. Handle reversals as separate records rather than deleting both sides.

Keep currencies separate. A USD payout and a CAD deposit are not an amount match, even if the numbers agree. When Shopify settles more than one currency, reconcile each currency as its own population. Foreign exchange gains, losses, and conversion spreads require accounting treatment outside a simple amount match.

Match exact payouts first

1. Filter to Deposited Shopify Payments payouts and bank credits or debits in the expected destination account.
2. Match exact currency and amount within the normal posting window, including ordinary bank clearing days.
3. Use the transfer reference plus the bank description, which often shows Shopify and, in the United Kingdom and Ireland, Earthport PLC Shopify.
4. Remove confirmed pairs from the open list.
5. Review repeated amounts carefully so date proximity does not create a false match.

Shopify Payments fees usually appear on the transaction rows in the Fee column before a payout is created. In that common setup, the payout net should equal the bank deposit when fees were already deducted. If the bank receives an amount different from the grouped Net, investigate a reserve, a Capital adjustment, a withdrawn payout, a split posting, or an incorrect source column before classifying the variance.

Explain common Shopify Payments differences

Payout still in transit

A Scheduled payout has not yet been sent. A Deposited payout has left Shopify Payments and may still be in bank clearing. Record the transfer reference, Net, payout date, status, and destination. Carry scheduled and recently deposited items forward and confirm the bank posting in the next period. If the payout later fails or is withdrawn, update the classification rather than leaving it as in transit.

Refunds, chargebacks, and reserves

Refunds and chargebacks reduce the Shopify Payments balance before the next payout, so they change composition rather than creating a separate bank line. Reserves can delay what is available to pay out. Use Type, Payout Status, Amount, Fee, and Net to support these movements. Do not assume every amount difference is a processing fee.

Shopify Capital and other adjustments

Shopify Capital loans issued on or after 9 March 2026 are collected from the Shopify Payments balance and appear under Adjustments. Those collections change the payout net rather than creating a separate customer payment. If a Capital collection fails, Shopify may debit the linked bank, except for the Texas exception described in Shopify documentation. Treat a failed-collection bank debit as its own record, supported by the adjustment evidence, rather than netting it silently into a later payout.

Multiple currencies or failed payouts

Stores that settle more than one currency can produce several bank lines on one day. Preserve the individual payout totals, list every bank component, and document any one-to-many relationship. The sum should agree by currency. A failed payout should not be matched to an unrelated bank deposit. Trace the original payout, any withdrawal or retry, and the replacement payout. If the bank posted and returned the funds, retain both bank lines. This preserves the cash trail and avoids hiding a failed settlement inside a later successful batch.

Prepare review-ready support

A completed file should show the Shopify transfer reference, settlement currency, payout Net, relevant Shopify date, bank posting date, bank description, match status, and exception explanation. Attach or retain the original balance-transaction export, payout reconciliation report when used, and bank files. For open items, include an owner and next action. Reviewers should be able to distinguish ordinary bank clearing from a scheduled payout, a reserve, a Capital adjustment, or an item that requires Shopify or bank follow-up.

Compare the total of matched and open Shopify Payments payouts with the grouped source report, then compare matched and unexplained bank deposits and debits with the statement. These completeness checks catch records omitted by Type filters, gateway mix, or import ranges. The goal is a supported zero difference after timing and other documented items, not a spreadsheet made to balance through plugs.

Using ReconcileCSV for the comparison

ReconcileCSV accepts a Shopify Payments payout or balance-transaction CSV and a bank statement CSV as generic date and amount files, lets you map those columns, proposes deterministic matches inside a date window, and surfaces ambiguous or unmatched rows. Shopify is not a named source type in the live picker, and the product does not save a Shopify mapping profile. The preview is free. Full ledger, print, and exception exports are available after a one-time $39 purchase. There is no account and no OAuth. CSV processing and matching run in the browser; files never leave the browser.

ReconcileCSV does not connect to Shopify, retrieve live payout status, post entries to accounting software, or determine the proper account for fees, refunds, chargebacks, reserves, Capital adjustments, or foreign exchange. It cannot repair incomplete exports. A preparer must review ambiguous matches and support every accounting conclusion with the original source data.