Why Shopify payouts never match your order revenue
A Shopify Payments payout is a net figure: gross sales, minus processing fees, minus refunds, minus any rolling reserve, settled to your bank on a delay. So a day's orders and the deposit that eventually shows up are almost never the same number, and they often land in different accounting periods. Multiply that across hundreds of orders per payout and manual matching becomes a multi-day spreadsheet job.
Common friction points:
- Fees and refunds are bundled into the net deposit, not itemized against orders.
- Payout timing lags the sale, splitting revenue and cash across periods.
- Reserves and chargebacks appear on their own schedule.
- Multi-currency stores add FX gain/loss on top.
How to reconcile a Shopify payout (the three-way match)
- Order: the sale recorded in Shopify.
- Payment: what Shopify Payments captured, net of the processing fee.
- Payout / bank deposit: the net cash Shopify deposited.
Match order → payment → payout, split out every fee, refund, and reserve, and post the resulting entry to your GL so the books tie to the bank.
How Blue Onion automates Shopify payout reconciliation
Blue Onion connects directly to Shopify, your payment processors, and your bank, and reconciles every order to every payout at the transaction level. Its Close module decomposes each Shopify payout back to the underlying orders, fees, refunds, and reserves automatically, performs the three-way match across systems, and posts daily summary journal entries to NetSuite, QuickBooks, or Xero with a full audit trail, turning a multi-day reconciliation into a one-day review. Late refunds and re-cleared payouts are auto-detected and booked to the right period.
FAQ
Why doesn't my Shopify payout match my sales?
Shopify deposits a net amount, gross sales minus fees, refunds, and reserves, so the payout is always lower than order revenue and has to be broken back down to reconcile.
How do I reconcile Shopify payouts in NetSuite, QuickBooks, or Xero?
Match each payout to its orders and fees, then post an entry that books revenue, processing fees, and refunds correctly. Blue Onion does this automatically and posts daily entries to NetSuite, QuickBooks, or Xero.
Can Shopify payout reconciliation be automated?
Yes. Blue Onion reconciles Shopify payouts to orders at the transaction level continuously, so month-end becomes a review instead of a spreadsheet exercise.
See it on your own data
Blue Onion reconciles every order to every payout automatically, so your close runs faster and your numbers are trustworthy from the first order to the final close.
Book a demo →