Most Shopify merchants never actively verify that the revenue Shopify reports actually matches what lands in their bank account. The assumption is that the numbers are right — and most of the time, they roughly are. But "roughly" isn't good enough when you're making hiring decisions, negotiating supplier contracts, or talking to investors based on those numbers.
Here are five warning signs that your Shopify payout doesn't match your bank balance for a real, fixable reason — and the exact steps to investigate each one.
Your Shopify revenue and bank deposits never match exactly
If you've accepted this as normal, it isn't. A consistent gap between Shopify-reported revenue and actual bank deposits — even a small one — usually means one of: Stripe or PayPal fees aren't being accounted for, a recurring refund or chargeback pattern isn't surfacing in your reports, or currency conversion rates are applied inconsistently.
Export your Shopify financial summary for the last 30 days. Export your bank statement for the same period. The difference should equal exactly: gateway processing fees + any outstanding refunds in transit. If it doesn't, you have an unaccounted variance worth investigating.
You've ever issued a refund and couldn't confirm it went through
Refunds in Shopify generate a refund record in Shopify. But the actual reversal of funds depends on your payment gateway processing it correctly. In high-volume stores, refunds occasionally fail silently — the customer doesn't receive their money, and the merchant's Shopify dashboard shows the refund as processed.
For any refund over $50, confirm the refund record in your gateway dashboard (Stripe → Refunds, PayPal → Activity) matches the Shopify refund record. Check that the refund ID exists in both systems and that the status shows "succeeded" in the gateway — not just "refunded" in Shopify.
Your accountant finds unexplained entries in your bank reconciliation every month
If your bookkeeper or accountant regularly flags "unmatched deposits" or "unexplained debits" in your monthly close, these are almost always gateway-level discrepancies that didn't surface in your Shopify reports. Common culprits: dispute fees deducted directly from payouts, reserve amounts held by gateways, and rolling payout batches that split across accounting periods.
Ask your accountant for a list of the specific unmatched amounts and dates. Cross-reference each one against your Stripe or PayPal payout reports for the same date range. Dispute fees, reserves, and adjustment entries will show up in the gateway's payout detail report but not in Shopify.
You use more than one payment gateway simultaneously
Stores that accept both Stripe and PayPal (or Shopify Payments and an alternative gateway) have a fundamentally harder reconciliation problem. Each gateway has its own reporting format, its own payout schedule, and its own fee structure. Orders don't always route to the same gateway — customer choice and retry logic can split a single day's sales across both.
Map every Shopify order to its payment method (visible in the Order detail view under Payment). Group orders by gateway. Reconcile each gateway separately against its own payout export. Never mix gateway payout data across providers — the IDs and formats aren't compatible.
Your revenue growth looks smoother in Shopify than in your bank account
This is the subtlest sign and the most telling. If your Shopify sales chart shows consistent upward growth but your bank balance tells a bumpier story, the smoothing effect is usually caused by phantom revenue — orders Shopify counts as collected that your gateway is still processing, or that were actually declined after the order was recorded. Over time, this creates a systematic gap between reported and actual revenue.
Run a cohort comparison: take all orders from 60 days ago (old enough for all settlements to have completed) and compare the total Shopify reported revenue for that cohort against the total amount that actually appeared in your bank for the same orders. Any difference is your real discrepancy rate.
How many of these apply to your store?
If even one of these signs matches your situation, it's worth running a proper reconciliation. For most merchants, the first audit uncovers discrepancies they had no idea existed — ranging from small fee accounting gaps to genuine missing settlements worth hundreds or thousands of dollars.
The earlier you catch them, the easier they are to investigate and recover. Gateway support teams can re-investigate settlements up to 90–180 days old in most cases. After that window, the trail goes cold.
Find out in 5 minutes if your payouts are accurate
Fincile connects to your Shopify store and payment gateways, cross-references every order, and shows you exactly where the numbers don't match — including the order ID, the variance amount, and the likely cause.
No credit card required · Read-only access · Results in minutes