Why Shopify sales do not match your bank payout

Shopify sales and a bank deposit can differ because of capture timing, refunds, fees, adjustments and money still held by the provider or moving to the bank. Begin by aligning dates, currencies and payment gateways, then reconcile each stage.

Use three views: sales activity, payment-provider activity and bank receipts. A period sales report explains what was sold; a payout export explains the transactions settled; the bank statement proves what arrived by the cutoff.

Start with one known bank deposit and its payout identifier. Once that matches, reconcile the provider’s opening and closing balances for the whole period and list the transfers still in transit.

Retain the sales/payment reports, payout transaction detail, period provider report and bank statement. Record the date range, timezone, currency and export date with each file. Use order, transaction and payout identifiers to join the evidence.

Shopify Payments activity covers that provider’s balance movements. Use separate records for other gateways and Shopify billing. Reconcile payout currencies separately before combining them under a documented conversion basis.

For a specific deposit, export the transactions belonging to its payout. Retain transaction timestamps, types, order references, payout details and signed amounts. Keep the file used in the reconciliation so a later export does not silently change the evidence.

In the payout CSV, Net is Amount less Fee. Sum the signed Net amounts when using that field; fees are already deducted. Retain charges, refunds and adjustments rather than rebuilding the payout from sales orders alone.

Keep the bank reference and actual receipt date beside the payout identifier. A match should establish both the amount settled and the date funds reached the account.

Compare product net sales with the relevant captured payments. Shopify net sales excludes shipping and taxes; those can affect the customer payment total. Check gift-card transactions, other payment methods and the dates of sales reversals where applicable.

Authorization and capture are different stages. Trace unpaid or uncaptured orders, later captures and refunds to their transaction dates. The same order may belong to one sales period and a later payment period.

Write a separate line for each supported difference between sales and captures. Then reconcile provider deductions. That sequence prevents a timing difference from being treated as an unexplained fee.

Sum the payout’s signed captured charges, refunds, fees and adjustments using the export’s convention. Match the resulting net transaction amount to the payout and explain any provider-specific transfer or reserve movement.

If starting from net sales, refunds included in that measure are already deducted. If starting from the Net transaction field, its fees are already deducted. Keep the starting basis beside the calculation.

Do not assume every transaction in a calendar sales period belongs to the same payout. Select by the payout identifier for a deposit match, and by the agreed activity dates for a period reconciliation.

Provider closing balance = opening balance + net balance activity − payouts initiated, using the provider’s stated balance boundary. Separately calculate closing payouts in transit = opening transit + initiated payouts − bank receipts by the cutoff.

Check each remaining provider balance and transfer against the next-period records. The provider balance holds funds that have not left that boundary; transit holds funds already sent but not received at the bank cutoff.

The two schedules explain different timing stages. Combining them without identifiers risks counting the same amount twice or overlooking a failed transfer.

Product sales are $24,800 gross − $800 discounts − $1,200 refunds = $22,800 net sales. Captured charges are $24,000 before the refund. After the same $1,200 refund, $720 fees and an $80 negative adjustment, provider net activity is $22,000.

The provider starts at $4,000. Add $22,000 activity and subtract $20,000 initiated payouts to reach $6,000 closing provider balance. Of the payouts, $12,000 reaches the bank by 30 September; $8,000 arrives on 2 October and remains in transit at the cutoff.

The difference is $10,800: $22,800 net sales − $12,000 bank receipts. It is fully explained by $720 fees + $80 adjustment + $2,000 increase in provider balance + $8,000 increase in transit. The refund is counted once in the starting net sales.

Match the payout amount and reference to the bank credit. Shopify’s Deposited status means the payout was sent; use the bank record to confirm receipt. Keep an unmatched sent payout in transit while checking the transfer and account details.

Investigate failed, reversed or changed transfers using their status history and later records. Update the transit schedule when the amount returns to the provider or reaches the bank. Keep the original identifiers so the change is traceable.

Group differences by cutoff, currency, gateway, transaction content or bank matching. Check the relevant record before proposing a ledger correction. Save the amount, identifier, evidence, owner and next action for each open exception.

Separate unexplained items from differences already reconciled to timing or deductions. The exception list should show what remains to be proved and who will obtain the record.

Shopify currently documents a three-day data delay for the Payments activity report. Check the latest included date before investigating recent missing activity. Activity groups vary with the transactions present, so retain the applicable detail rather than assuming every store has the same rows.

Review reserves and holds separately where they apply. They affect provider funds available for payout and are not a new sale. For an unresolved difference, assemble the matched records and identifiers for the relevant provider or bank inquiry.

The bookkeeper prepares the reconciliation and ledger mapping. The owner or authorized account user obtains provider records; the reviewer checks supporting evidence for any proposed correction. Record actual review only when it has occurred.

Start with one bank deposit, tie it to its payout transactions, then complete the period provider and transit schedules. Carry expected receipts into the cash forecast using their bank timing. Bring the remaining exception list to the bookkeeping discussion.