Shopify Payout Does Not Match Sales - Review Payout Support and Bank Deposits

Review Shopify payout details export, payout status, refunds, adjustments, timing, and grouped payout support when sales totals do not match the bank deposit.

Try with sample files | View sample report

Problem statement

A Shopify sales total is usually a gross order view, while the bank deposit is the payout after deductions, refunds, timing shifts, and possible grouped activity. The right workflow starts from the payout support, not from a single sales total.

Numeric example

Line item	Amount
Gross order total	$2,134.24
Refunds	-$120.00
Payout deductions	-$64.20
Possible adjustment	-$15.00
Bank payout	$1,935.04

Why the numbers do not match

The Shopify payout details export can contain fees, refunds, adjustments, and payout status changes that do not show up in the same way inside a gross sales report.
Refunds and chargebacks can land in a different payout period than the original sale.
Several days of orders can be grouped into one payout deposit.
Pending orders, manual payments, and third-party gateways may not belong inside the Shopify Payments payout support.
Payout status can show that the money is delayed, under review, or failed before it becomes a true bank mismatch.
Payout schedule timing can move the bank date away from the order date.
A lower bank deposit is not always provably one fee row; sometimes the export only proves a broader amount difference or adjustment.

What files to export

Shopify orders export with order number, paid date, payment status, gross total, payment method, and refund fields.
Shopify payout details export with payout ID, gross, fees, refunds, adjustments, status, payout date, and net amount.
Bank statement export with deposit date, amount, and bank description for Shopify transfers.

Manual workflow

Start from the payout ID, payout date, status, and net amount instead of the store-wide sales total.
If the payout status shows a delay, review state, or failure, keep the bank match unresolved until that status is clear.
Separate gross orders, refunds, payout deductions, payout status, and possible adjustments.
Use the payout details export columns first when the order report and payout support disagree about what belongs in the bank movement.
Match the payout net amount to the bank deposit by amount, date, and reference.
Keep orders from non-Shopify gateways outside the payout explanation unless the export proves they belong there.
Use amount-difference wording unless the export explicitly proves the shortfall is a fee, refund, reserve, or adjustment.
Leave timing gaps and weak-reference rows in review instead of forcing a final explanation.

Common mistakes

Comparing gross sales totals directly to one bank deposit.
Treating a delayed or failed payout status like a settled bank mismatch.
Calling every shortfall a fee when the payout export only proves a broader amount difference or adjustment.
Ignoring refunds that landed in a later payout period.
Forgetting that non-Shopify gateways may be excluded from Shopify Payments payouts.

How Reconcile Locally helps

Keeps gross orders, payout rows, and bank rows in one local review flow.
Keeps payout status visible beside bank rows so delayed or failed payouts are not mislabeled as settled deposit differences.
Separates matched deposits from amount differences, unknown bank payments, and review rows instead of hiding them in spreadsheet formulas.
Keeps unpaid or excluded orders visible when the payout support is incomplete.
Exports a report you can review before you change accounting entries.

What still needs manual review

Some payout differences still need manual review when references are incomplete, payout status history is unclear, or several deposits could match the same payout.
Cross-gateway workflows may need one more exported file before the difference is fully explained.
The payout details export may show a deduction or adjustment without proving the exact accounting classification of every row.

Content review and sources

Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.

Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.

Frequently asked questions

Which Shopify export should I use first?

Start with the Shopify payout details export and match its payout ID, net amount, and status to the bank deposit. Then use the order export to explain what sits behind that payout.

Does every Shopify payout difference mean a fee?

No. A lower bank deposit can also reflect refunds, chargebacks, timing differences, payout adjustments, or grouped activity. Use amount-difference wording unless the export explicitly proves the cause.

Which Shopify payout columns matter most?

Start with payout ID, status, payout date, gross, refunds, adjustments, and net amount. Those columns usually explain more than a store-wide sales total.

What if the payout status is delayed or failed?

Keep the bank side unresolved until the payout status is clearer. A delayed or failed payout can explain why the expected deposit is missing without proving a fee or a final bank mismatch.

When should I move this review into Xero?

After the payout-level amount, status, and transfer evidence are strong enough to explain the bank movement. Then use the Xero workflow to review the accounting-side deposit or existing entry without starting over from gross sales.

When should I use the broader Shopify payout guide instead?

Use the broader guide when you still need the full payout-first workflow across normal Shopify payout cases. Stay on this mismatch page when the main issue is a shortfall, delay, payout-status clue, or unresolved bank-side explanation.