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.
Control point: reconcile each store, settlement currency, and destination bank account separately.
Export files with enough overlap
From the Shopify admin, go to Settings, then Payments, then View payouts, then View Transactions, then Export balance transactions (view payout details, read 2026-10-17). To export one payout, go to Finance > Payouts, click the payout date (then the payout, if there are several that day), then Export > Export payout transactions (view payout details, read 2026-10-17). Both exports have the same CSV columns, and Shopify emails the file to you and the store owner (view payout details, read 2026-10-17). 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 (view payout details, read 2026-10-17). 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 > Documents > Shopify Payments activity report gives a period-level summary (starting balance, gross activity, fees, payouts, net movement, ending balance) for a date range and payout currency, exportable as PDF (Shopify Payments activity report, read 2026-10-17). Custom ranges are available from January 1, 2025 (Shopify Payments activity report, read 2026-10-17). Use it for month-end support, and the Payouts page for a specific bank deposit (Shopify Payments activity report, Shopify changelog, read 2026-10-17). 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
- Filter to Deposited Shopify Payments payouts and bank credits or debits in the expected destination account.
- Match exact currency and amount within the normal posting window, including ordinary bank clearing days.
- Use the transfer reference plus the bank description, which often shows Shopify and, in the United Kingdom and Ireland, Earthport PLC Shopify (configuring Shopify Payments, read 2026-10-17).
- Remove confirmed pairs from the open list.
- 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
Scheduled means the payout is in the process of being sent to your bank (view payout details, read 2026-10-17). Deposited means it was sent (your bank may take 1–3 business days to post it) (view payout details, read 2026-10-17). Failed means the bank did not process it (view payout details, read 2026-10-17). Withdrawn applies only in regions where Shopify Payments debits negative balances (view payout details, read 2026-10-17). 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
For US merchants, Shopify Capital loans accepted on or after March 9, 2026 are repaid from the Shopify Payments balance and the deduction shows in the payout's Adjustments section (Shopify Capital, United States, read 2026-10-17). If balance attempts fail, the repayment is debited from the business bank account (Shopify Capital, United States, read 2026-10-17). In Texas this has applied to loans accepted on or after September 1, 2025, and no bank debit is made when balance attempts fail (Shopify Capital, United States, read 2026-10-17). Those collections change the payout net rather than creating a separate customer payment. 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.
Limit: a CSV workflow cannot confirm facts missing from the exports. When status, destination, or payout composition is unclear, return to Shopify Payments, Finance Documents, and the bank for source evidence.
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, Shopify Payments activity 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
To see the match on sample files before using your own export, open the Stripe worked example (two sample CSVs; the same date-and-amount mapping applies to a PayPal, Square or Shopify export).
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.
FAQ
Why reconcile Shopify Payments payouts to the bank instead of each order?
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, and the bank usually records only the resulting deposit. Match the payout to the bank and keep the balance transactions as support. Only Shopify Payments activity belongs in this reconciliation, so exclude other gateways even when those orders appear in the same store.
Which Shopify export should I use for one bank deposit?
Go to Finance > Payouts, click the payout date (then the payout, if there are several that day), then Export > Export payout transactions. The balance-transaction export has the same CSV columns, including Transaction Date, Type, Order, Payout Status, Payout Date, Available On, Amount, Fee, and Net. Shopify emails the file to you and the store owner.
The payout says Deposited. Why isn't it in my bank yet?
Deposited means Shopify has sent the payout, and your bank may take 1–3 business days to post it. Scheduled means the payout is in the process of being sent to your bank. Record the transfer reference, Net, payout date, status, and destination, carry scheduled and recently deposited payouts forward, and confirm the bank posting in the next period.
Should the bank deposit equal the Shopify payout Net?
In the common setup, yes. Shopify Payments fees usually appear on the transaction rows in the Fee column before a payout is created, so the payout net should equal the bank deposit. If the bank amount differs, investigate a reserve, a Capital adjustment, a withdrawn payout, a split posting, or an incorrect source column before classifying the variance.
How do refunds, chargebacks, and reserves affect a payout?
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, and don't assume every amount difference is a processing fee.
How do Shopify Capital repayments show up?
For US merchants, Shopify Capital loans accepted on or after March 9, 2026 are repaid from the Shopify Payments balance, and the deduction shows in the payout's Adjustments section. If balance attempts fail, the repayment is debited from the business bank account. In Texas this has applied to loans accepted on or after September 1, 2025, and no bank debit is made when balance attempts fail. Treat a failed-collection bank debit as its own record, supported by the adjustment evidence.
What should I do with a Failed or Withdrawn payout?
Failed means the bank did not process the payout. Don't match it to an unrelated bank deposit. Trace the original payout, any withdrawal or retry, and the replacement payout, and keep both bank lines if the bank posted and returned the funds. Withdrawn applies only in regions where Shopify Payments debits negative balances, and a withdrawn payout can post as a bank debit.
How should I handle more than one settlement currency?
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.
Sources (read 2026-10-17)
- https://help.shopify.com/en/manual/payments/shopify-payments/payouts/view-details
- https://help.shopify.com/en/manual/payments/shopify-payments/payouts/payouts-activity-report
- https://changelog.shopify.com/posts/review-shopify-payments-balance-activity-with-the-new-activity-report
- https://help.shopify.com/en/manual/finance/shopify-capital/united-states
- https://help.shopify.com/en/manual/payments/shopify-payments/configuring-shopify-payments