Shopify Payments guide

How to find a Shopify payout by bank reference or deposit amount

Start from the bank line you already have, narrow the nearby Shopify Payments payouts, and keep any remaining mismatch unresolved until the payout, transfer, or bank evidence explains it.

Manual lookup · Shopify Payments only · Review support

Quick answer

Use the bank line to build a shortlist—not a guess.

Record the deposit amount, currency, posting date, destination account, and the description or reference shown on the bank statement. In Shopify, open Finance → Payouts, stay inside the same payout currency, and inspect payouts near that date. Compare the exact Shopify net payout, status, destination account, and Shopify transfer reference where one is available.

A bank-statement description, a Shopify transfer reference, and a Shopify payout ID—when the view exposes one—are not interchangeable. Compare identifiers only when both sources label them compatibly, after date, amount, currency, and account have narrowed the candidates.

Why the lookup is manual

The missing shortcut is a real reconciliation pain.

A July 2026 Shopify Community feature-request thread reports that its author could not search payouts by bank reference or deposited amount and instead filtered by date and opened several nearby payouts. That is a merchant report, not an official confirmation of current search behavior. Shopify's payout details do show the payout total, status, destination bank account, transfer reference when available, and included transactions.

Sources: merchant feature request and Shopify payout-detail guidance.

Five-step lookup

Trace the candidate payout without forcing a match.

  1. 01

    Capture the bank evidence first.

    Note the amount, currency, posting date, destination account, and the description or reference shown on the bank statement. Call an identifier a Trace ID only when Shopify or the bank labels it that way. Use only masked account digits, never record credentials or routing numbers, and redact bank details before sharing the review.

  2. 02

    Open the matching payout currency.

    Go to Finance → Payouts. If multi-currency payouts are enabled, Shopify groups payouts separately by payout currency. Do not compare a bank line against a different payout currency or combine currencies into one expected deposit.

  3. 03

    Shortlist by date and net amount.

    Inspect payouts near the bank posting date and compare the payout's total amount—not gross order sales—to the bank deposit. A payout can contain many transactions, refunds, fees, adjustments, and reserves.

  4. 04

    Confirm the candidate with payout details.

    Check status, destination account, and the transfer reference where available. If you need the composition of the net payout, inspect its transaction breakdown or export the relevant transactions.

  5. 05

    Record the outcome—or leave it unresolved.

    Save the payout date and, if visible, its ID; otherwise assign a stable internal label. Record the Shopify net amount, bank amount and date, reference, visible difference, and evidence still missing. A plausible nearby payout is not a confirmed match by itself.

Status is not bank receipt

“Deposited” still leaves a bank-processing step.

Shopify says a Deposited payout has been sent to the bank; it does not mean the bank has posted the funds. Bank processing typically takes another 1–3 business days. If the payout is still missing after that, Shopify directs merchants to share the bank reference number, also called the Trace ID, with the bank.

Source: Shopify's lower or missing payout guidance.

Synthetic example

Do not spend the same fee twice.

Store activity → Shopify net payout US$3,554.35 − US$30.00 − US$42.18 = US$3,482.17

Shopify net payoutUS$3,482.17

Bank depositUS$3,441.92

Bank variance−US$40.25

The first equation shows that the US$42.18 Shopify fee was already included when store activity produced the US$3,482.17 net payout. It cannot also explain the separate US$40.25 difference between that net payout and the bank deposit. The next evidence must come from payout status, transfer timing, destination-account, or bank records.

Use Shopify's report for the right job

Period activity and one bank deposit are different views.

Shopify's Payments activity report is useful for reviewing balance movement across a date range and payout currency. Shopify says to use the Payouts page when you need details for one payout or bank deposit. The activity report excludes Shopify billing fees, third-party processors, and third-party payment methods, so those sources need their own evidence.

Source: Shopify Payments activity report.

Keep the two checks visible

Carry the confirmed candidate into a manual review.

The US$9 Shopify Payout Reconciliation Workbook is delivered as one ZIP containing one editable .xlsx file. It gives you manual Shopify Payments input, a separate bank-deposit check, worked synthetic examples, and a checklist tab.

It does not search or match payouts by reference. Record relevant payout status, masked destination-account detail, statement description, and transfer-reference evidence in Notes or keep it with the supporting source files used for the review.

View the US$9 workbook on Gumroad

One currency per workbook. No automatic imports or connections to Shopify, accounting software, or a bank. 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

Review support—not proof of underpayment.

This process organizes sources and unresolved questions. It does not trace funds, predict payout timing, prove Shopify or a bank made an error, or make accounting, tax, or ledger decisions. A qualified bookkeeper or accountant makes the final treatment decision.