Shopify Payments transaction export

How to reconcile a Shopify payout CSV to a bank deposit

First confirm that your Shopify admin context establishes which rows belong to the selected payout. Then test whether their signed Net values support Shopify's displayed total before checking the bank.

One deposited payout · One currency · Admin context required

Quick answer

Confirm export scope, then add Net before touching the bank match.

Open the Shopify Payments payout you are reviewing and confirm its status is Deposited. Record its amount, currency, destination bank account, and transfer reference where available, then retain the admin context that establishes the exact export scope. Keep the export inside one currency and sum the Net cells exactly as exported, preserving positive and negative signs.

Shopify's documented CSV columns omit a payout ID. The file alone therefore cannot prove that its rows belong to one selected payout, and a date-plus-currency match is not a unique key when multiple same-day payouts exist. If the current admin view does not establish all and only the selected payout's rows, stop and leave payout composition unresolved.

Compare that result with Shopify's displayed payout amount. If those two figures tie, carry the Shopify payout—not gross sales or a second fee calculation—to the bank check. If they do not tie, stop at the export-selection question instead of forcing a bank explanation.

Sources: Shopify payout details and CSV columns; payout schedules and same-day payout groupings; payout-status guidance; and balance-transaction field definitions.

Why this split matters

A netted bank deposit is not an order total.

A current merchant discussion describes fees, refunds, adjustments, gift cards, and multi-day batching landing as one deposit that does not line up cleanly with QuickBooks. The workflow below uses Shopify's own records to isolate the first failed equality before any accounting treatment is considered.

Merchant discussion: single-store payout reconciliation discussion.

Read the source fields first

Amount, Fee, and Net do different jobs.

Amount

The transaction amount. It is a row-level source value—not the expected bank deposit for the whole payout.

Fee

The fee applied to that transaction. Keep the exported value for review, but do not subtract it again after using Net.

Net

Shopify describes this as the net amount contributing to the merchant balance. Preserve the cell's exported sign and sum this column for the payout check.

Shopify's documented merchant CSV also includes Transaction Date, Type, Order, Card Brand, Card Source, Payout Status, Payout Date, and Available On. Its published column list does not include payout currency, payout ID, destination account, or transfer reference, so retain that context from the selected admin view alongside the file. Regional exports can append VAT or GST fields for Shopify Payments processing fees; these are not general customer-sales-tax columns. Match columns by header name, preserve unfamiliar columns, and do not assume that every export ends at Net.

Sources: Shopify's current export guidance and core column descriptions, the regional VAT export note, and the regional GST export note.

Six-step payout check

Keep the export tie and bank tie separate.

  1. 01

    Record the payout before exporting.

    Open the specific payout and note its displayed total, status, payout date, currency shown with the total, destination bank account, and transfer reference where available. Continue to a bank-deposit check only when the payout status is Deposited; Scheduled waits, Failed has no deposit to match, and Withdrawn is an outgoing withdrawal request rather than an incoming deposit. Shopify says Pending transactions have only an estimated payout date, so do not treat them as part of a sent bank deposit.

  2. 02

    Keep payout membership visible.

    Start from the selected payout's detail view and retain the exact export scope beside the file. Do not filter out transaction types: charges, refunds, disputes, and adjustments can all contribute to the payout. Shopify separates payout groupings by currency and says the export respects currency filtering, so keep each currency in its own check. Do not treat payout date plus currency as a unique key; if the admin does not establish all and only the selected payout's rows, stop here.

  3. 03

    Preserve the raw export.

    For this manual method, keep an untouched copy of the exported balance transactions. Current Shopify guidance differs by region on whether the file downloads in the browser or arrives through email, so follow the current admin prompt instead of relying on one delivery assumption. As a privacy safeguard, keep the untouched original secured. If another person needs evidence, create a separate minimum-data copy, remove order IDs, transfer or bank identifiers, and unrelated rows, then limit access and use a secure transfer method.

  4. 04

    Sum signed Net values—without inventing a sign rule.

    Use the Net cells exactly as exported. Do not convert every fee, refund, dispute, or adjustment to a positive number, and do not rebuild or re-sign the documented Amount-minus-Fee relationship. Shopify defines Net as the resulting amount that affects the balance; use the supplied signed Net cell as the controlling source for each row.

  5. 05

    Compare the Net sum with Shopify's payout total.

    If the figures differ, first recheck the selected payout, currency, transaction-type coverage, pending rows, and export range. Because Shopify's documented CSV columns omit a payout ID, the file alone cannot prove that every row belongs to the selected payout. If the admin view and retained export scope do not establish membership, label the result payout composition not yet tied; do not move the unexplained amount to a bank or bookkeeping category.

  6. 06

    Compare the tied payout with the bank.

    For a Deposited payout, use its amount, destination account, transfer reference where available, bank date, and same-currency deposit. Shopify notes that banks can still take one to three business days to process a sent payout. A remaining difference belongs to this second check. Follow the bank-reference lookup guide rather than reusing a fee already contained in Net.

Synthetic example

One export tie, then one bank tie.

Assume the admin context has already established that these invented rows belong to one Deposited payout. They show the arithmetic only and do not predict the transaction types, fee treatment, or signs in a real store export.

Charge row A — Net+ US$116.40

Charge row B — Net+ US$78.60

Refund row — Net− US$20.00

Signed Net sumUS$116.40 + US$78.60 − US$20.00 = US$175.00

Shopify displayed payoutUS$175.00 → export tie passes

Bank depositUS$169.50 → bank variance is −US$5.50

The US$5.50 bank variance is not explained by subtracting row fees a second time: those rows already supplied their Net values. Check payout status, transfer timing, destination account, reference, and bank evidence, or leave the difference unresolved.

Use the right Shopify view

One payout CSV and a period report answer different questions.

One payout or bank deposit

Use payout details plus a transaction export whose one-payout scope you can establish from the admin context. A date-and-currency match alone is not enough. Tie composition before checking a specific deposit.

A month or other date range

Use the Shopify Payments activity report for starting balance, gross activity, fees, payouts, net movement, and ending balance. It is not a revenue statement and has a documented three-day data delay.

For a known order, use the order-to-payout process map. For a period close, use the activity-report guide.

Source: Shopify Payments activity report.

Carry the two checks into one review

Use the export as evidence—not as an automatic import.

The US$9 Shopify Payout Reconciliation Workbook keeps Shopify activity to net payout separate from net payout to bank deposit. Manually enter the totals you have already verified rather than importing transaction rows, retain the CSV and payout-view context as source evidence, and keep unresolved differences visible for bookkeeper review.

The workbook does not import CSV files, connect to Shopify, QuickBooks, Xero, or a bank, determine which CSV rows belong to a payout, post journal entries, or decide accounting treatment.

View the US$9 workbook on Gumroad

Shopify 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

Review support—not bookkeeping or missing-money recovery.

This guide helps organize payout evidence and locate which equality is still open. It does not prove Shopify, a bank, or an app made an error; recover funds; trace third-party processors; or make accounting, tax, ledger, gift-card-liability, or connector-mapping decisions. A qualified bookkeeper or accountant makes the final treatment decision.