How Shopify Fees Affect Bank Deposits

A fee changes settlement, not the sale

When Shopify Payments processes a captured payment, the customer’s charge and the processor’s fee are different lines of activity. The charge is payment activity related to an order; the fee is a deduction from the payment balance. The bank receives the net settlement after the activity included in that payout. Recording only the net bank deposit as sales hides both the customer receipt and the cost of collecting it.

Do not use a generic fee percentage copied from another merchant. Shopify Payments pricing can depend on the store, plan, country, payment method, and other account conditions. Reconciliation should use the fee amount shown in the relevant transaction or payout detail. The goal is evidence-based classification, not a universal rate.

Which fee scope are you reviewing?

First identify the provider and the report. Shopify says the Shopify Payments activity report includes its relevant balance activity, but does not include Shopify billing fees, third-party payment processors, or third-party payment methods. A bank deposit can be affected by costs outside that report, so a complete finance review may need more than one source.

• Payment-processing fees: deductions associated with captured payment activity and shown with the transaction or payout detail.
• Refund and dispute-related adjustments: separate activity that may alter the balance; do not assume a fee is always returned or that a dispute is final.
• Shopify billing or subscription charges: not automatically part of the Shopify Payments activity report.
• Third-party provider costs: reconcile to that provider’s statement rather than forcing them into Shopify Payments.

Worked example: $800 of charges becomes a $655 deposit

Fictional simplified example — the amounts are for arithmetic, not a Shopify fee quote. Suppose three captured charges total $800. The payout detail shows $48 of processing fees, a $100 refund, and a $3 positive fee-related adjustment. The net movement is $800 − $48 − $100 + $3 = $655. The sales activity remains $800 in this simplified example; the customer refund and payment costs explain why the bank settlement is lower. Tax treatment is intentionally omitted, so this is not a tax calculation.

The $48 is not a reason to reduce the order’s selling price in the sales report. It is a cost line to classify using the chart of accounts and policy your bookkeeper or adviser has approved. The $3 adjustment is not a standing promise about returned fees. Use the actual line description and amount, and leave an unusual adjustment for review.

Map gross, fee, and net without double counting

A generic Xero or QBO workflow starts with the business’s order or sales source and a payment-processor clearing balance. Captured receipts increase the clearing balance. Processing fees reduce it and go to the fee category selected by the finance team. Refunds reduce the customer-payment side; disputes and adjustments remain visible until their status and treatment are known. The bank settlement then clears the processor balance instead of creating another revenue line.

The exact accounts and timing depend on the bookkeeping design, so do not copy a menu path or journal template blindly. Ask the adviser to decide whether the business records sales by order date, capture date, or another established policy, then apply it consistently. Keep the payout export attached to the period review so a future reviewer can reproduce the net amount.

Why a net bank deposit can still look wrong

A mismatch can come from the payout cutoff, a captured payment in another period, a refund issued after the original payout, or activity in another currency. It can also come from comparing a Shopify Payments deposit with a separate provider’s sales or fees. Shopify’s payout timing guidance distinguishes capture, settlement, and the time a bank takes to display the transfer, so the calendar date on a statement is not enough evidence by itself.

Start with the payout currency, selected date range, payout status, and transfer reference. Then trace each charge and deduction. Never classify held funds as a fee merely because cash is unavailable, and never use a net deposit as a new sale. A short exception note is better than an unexplained expense.

Sources and further reading

For included activity and excluded fee scopes, see Shopify’s Payout reconciliation report. It distinguishes balance activity from revenue reporting.

Shopify’s Shop Pay and Shopify Payments FAQ describes payment-provider and transaction-fee context. Check the terms that apply to the specific store rather than assuming every payment method has the same treatment.

Payout Explainer is coming soon

Product Payout Explainer is coming soon. Join the waitlist for fee-aware payout review with proposed entries shown for approval before posting. It will not give tax or FX advice, and it will not remove the need for merchant or adviser review.