Shopify Payments difference guide
Total sales, captured payments, Shopify Payments balance activity, a net payout, and a bank deposit answer different questions. Separate those sources before calling the difference missing money.
Shopify Payments only · One payout currency at a time · Manual review prep
Quick answer
Shopify's Finance sales reports are based on orders and sales activity. The Shopify Payments activity report follows movement in the Shopify Payments balance. A positive payout is one net transfer from that balance, and the bank statement records when the bank posts it. Different provider, capture, refund, dispute, fee, adjustment, reserve, currency, and timing scopes can all separate those values.
The reliable sequence is: verify the order and payment scope, explain Shopify Payments balance movement, open the specific payout, and only then compare that net payout with the bank.
Sources: Shopify Finance reports and Shopify Payments activity report.
Five source views
| Source | What it answers | Do not treat it as |
|---|---|---|
| Finance total sales | Order-based sales activity for the selected report scope and dates | One Shopify Payments payout |
| Payments finance report | Captured customer payments across the selected payment scope | Movement in one payout balance |
| Shopify Payments activity report | Starting balance, activity, fees, payouts, net movement, and ending balance for a date range and payout currency | A revenue statement or one bank deposit |
| Specific payout | For a positive payout, the net batch Shopify sent or attempted to send, with its included transactions | Every order placed in the same calendar period |
| Bank statement | What the bank actually posted, when, in which account and currency | Shopify's order or balance-activity report |
Common scope breaks
01
Shopify's sales reports can cover orders paid through more than one method. The Shopify Payments activity report excludes third-party processors and third-party payment methods. Keep PayPal and other provider settlements in their own evidence trail.
02
Sales reports follow order and return activity; payment reports follow captured payments. Payout scheduling follows another clock, and a bank can post a sent payout later. A shared month label does not make the underlying rows comparable.
03
Shopify's Payout balance represents captured funds that have not yet been added to a scheduled payout, excluding reserved funds. Pending transaction payout dates are estimates rather than proof of a sent transfer.
04
Payout details can include charges, refunds, adjustments, and reserves. The period activity report can also show fees, disputes, holds, credits, shipping, and other balance activity that applies to that store and period. Use the types that actually appear; do not invent a generic plug.
05
When a reserve applies, Shopify separates the payout balance from reserved funds. Reserve transactions can reduce current available payout funds and later release them; they are not new sales when released.
06
Shopify groups multi-currency payouts separately, and the activity report is selected by payout currency. Compare one payout currency at a time and keep any conversion evidence with the source.
Sources: payout details and transaction export, Shopify Payments reserves, and lower or missing payout guidance.
Four-pass review
Record the exact Finance report, filters, date range, timezone, sales channels, and customer payment methods. If the question is revenue or tax treatment, stop at the relevant reports and route the accounting conclusion to a qualified professional; a payout workbook does not decide it.
Open the activity report for the relevant date range and one payout currency. Review its starting balance, applicable activity groups, fees, payouts, net movement, and ending balance. Shopify documents a three-day delay, so keep a recent period open instead of treating absent activity as a resolved difference.
Use the Payouts page for the payout total, status, destination account, transfer reference where available, breakdown, and included transactions. If the on-screen evidence is too narrow, export the balance transactions and preserve every relevant type and its signed Net value.
Compare only a Deposited payout with the same-currency bank line, destination account, amount, and available reference evidence. If the payout and bank do not tie, keep that variance separate from the earlier sales-versus-payout scope difference.
Privacy: Shopify treats access that exposes banking, financial, or customer data as sensitive. Keep the original evidence secured. If another person must review the exception, make a separate copy and share only the rows and fields necessary for that named exception, securely to the correct authorized recipient. Mask unrelated order or customer data and full account or routing numbers. Keep a transfer reference visible only when the authorized Shopify, payment-provider, or bank team needs it to trace that exception. Sources: Shopify sensitive permissions and the UK Information Commissioner's Office's data-sharing advice.
Synthetic example
Assume the source reports have already verified the following invented facts for their own stated scopes. These values illustrate routing only; they are not a universal Shopify payout formula.
Order-based total sales for the selected periodUS$1,000
Gross Amount of charge rows included in one payout+ US$850
Fees on those charge rows− US$25
Signed Net of those charge rows+ US$825
Refund row, signed Net− US$40
Reserve transaction, signed Net− US$50
Payout identityDeposited · USD · account ending 4242 · reference SHP-EXAMPLE-73
Verified net payout from signed Net valuesUS$825 − US$40 − US$50 = US$735
Matching bank lineUS$735 · USD · account ending 4242 · reference SHP-EXAMPLE-73
Payout-to-bank varianceUS$735 − US$735 = US$0
The US$265 difference between the selected sales total and the bank line is not, by itself, a missing-money amount. The example first needs the sales/payment scope that explains why US$850—not US$1,000—entered this Shopify Payments payout. The US$25 fee is already reflected in the charge rows' US$825 signed Net, so it is not subtracted again. The payout's signed Net rows then explain how US$825 became US$735. Because the payout is Deposited and the same-currency bank line also matches its masked destination account, amount, and synthetic reference, the later payout-to-bank check has zero variance.
Why this guide exists
Shopify Community discussions describe merchants comparing a calendar period's total sales with Shopify, PayPal, and bank payouts, or finding order-level and Shopify Payments values that still differ after manual checks. Those reports establish recurring confusion and investigation effort—not proof that Shopify or a bank withheld funds, and not proof of willingness to buy this workbook.
Merchant-language sources: total sales compared with payouts, sales compared with bank payouts, and Shopify Payments compared with Shopify sales.
Keep the two checks visible
The US$9 Shopify Payout Reconciliation Workbook starts after Shopify's native reports have identified the payout to review. It separates the Shopify net-payout check from the bank-deposit check and leaves unsupported differences visible rather than forcing a match.
The ZIP contains one editable .xlsx workbook with synthetic examples and a checklist tab. It does not import reports, connect to Shopify or a bank, replace native reports, decide revenue, or make accounting or tax entries.
View the US$9 workbook on GumroadShopify Payments only. One currency per workbook. Requires an app that can open and recalculate Excel formulas; compatibility with Google Sheets, Apple Numbers, mobile apps, and browser-only editors is not verified.
Boundary
This guide does not establish revenue, tax liability, processor or bank fault, underpayment, missing funds, payout timing, or accounting treatment. Preserve the source reports and ask Shopify Support, the relevant payment provider or bank, and a qualified bookkeeper or accountant to resolve the part each source controls.