Shopify payout vs profit and how to reconcile payment fees

Choose the date that answers your question

If the number in your bank account looks lower than your Shopify sales, start by identifying which deposits you received and which orders they cover. A payout is the amount Shopify Payments sends to your bank after the activity in that payout is settled. To calculate profit, use the sales and refunds for the period you are reviewing and subtract the costs tied to that period, including product costs, shipping, and marketing.

Write down the order period, transaction date, payout date, and bank posting date when investigating a difference. A late-Friday order may settle in a later payout and reach your bank after that. Shopify groups the Payouts view by the date it sends funds, and a payout marked Deposited may still be processing at your bank. See Shopify’s payout status and export guide.

Reconcile one payout before reviewing a full month

1. In Shopify admin, go to Finance → Payouts. Open the payout date and select the specific payout whose amount you want to match.
2. Export that payout’s transactions. Use the Type, Order, Amount, Fee, and Net columns to identify which captures, refunds, and adjustments contribute to the payout total.
3. Compare the signed Net amounts and any itemized adjustments to the payout details. Check the currency first, then match the total to the corresponding bank deposit. Use the bank reference if the statement has more than one similar deposit.
4. If the amounts differ, check for pending activity, a reserve, or a failed payout that Shopify retried. For a period-wide comparison, use the Shopify Payments activity report for the relevant dates and currency.

Keep any external payment provider’s deposits and transaction fees in its own reconciliation. That way the totals stay tied to the statements that prove them.

A $990 bank payout and $320 in tracked profit

In this illustrative US example, the payout and the operating report happen to cover the same transactions. The store captured US$1,200, refunded US$100, paid US$35 in processing fees, and had US$75 held in reserve. The US$1,100 of sales after refunds and before fees excludes separately collected tax in this example.

The reserve explains why part of the cash is currently unavailable. When it is later released, the deposit increases without creating a new sale.

Reconcile US and Canadian payouts in their own currencies

A Canadian shopper can pay in CAD while a US store receives a USD payout. Write down the shopper’s currency, the store’s reporting currency, and the bank payout currency before comparing an order total with a deposit. Reconcile each payout in the currency Shopify sent to the bank. For a profit report in another currency, convert each figure using a consistent, documented method. Use the exchange information from the transaction for comparisons, especially when a refund was processed later.

Use the fee shown on the transaction instead of estimating a percentage. Where a fee is already deducted in a Net amount, count it only once. If your bank makes a separate conversion, record that adjustment with the bank transaction. See Shopify’s exchange-rate guidance and its guide to supported payout currencies.

Keep a weekly record you can explain

For every currency, record the payout reference, bank posting date, amount matched, and any difference still under review. In your profit report, keep a separate line for processor fees and one for any costs you still need to confirm. Start with one finished week and trace a refund from the Shopify order to the payment statement and the profit report. That small check helps catch an incorrect date filter or a refund deducted twice before it distorts a monthly review.

Use the weekly reconciliation blueprint for the full checklist. In the Profit Inspector sample dashboard, compare sales, fees, and ad spend in the same reporting period to see how the numbers that drive profit fit together.

Common questions