Short answer: A Shopify Payments payout is one bank deposit that nets together many orders, minus processing fees, refunds, chargebacks and adjustments. To reconcile it in NetSuite, record each payout as a single deposit that groups the payments it contains and adds fees, refunds and chargebacks as their own lines, so the deposit total equals the amount that hit your bank. When an integration builds that deposit automatically from Shopify’s payout data, bank reconciliation becomes a one-to-one match.
Why Shopify payouts don’t match NetSuite
Most Shopify–NetSuite integrations sync orders, and sometimes payments, one transaction at a time. The bank sees something different:
- One deposit, many orders. A daily payout can contain hundreds of orders across several days.
- Fees are deducted before deposit. The bank receives the net amount, not the order totals.
- Refunds and chargebacks come out of later payouts. A refund issued on Tuesday reduces a payout that mostly contains Wednesday’s orders.
- Timing differs. Orders are dated when placed; payouts arrive days later.
If NetSuite holds gross customer payments and the bank shows net payouts, the two never tie out without manual work.
The reconciliation model that works
Treat the payout as the unit of reconciliation.
- Payments land in undeposited funds. Each Shopify order’s payment is recorded in NetSuite (as a cash sale, customer payment or customer deposit, depending on your order flow) against an undeposited funds or clearing account.
- Build one deposit per payout. Using Shopify’s payout details, select the payments included in that payout.
- Add the deductions as lines. Add processing fees to a merchant fees expense account, refunds against the related credit memos or refund transactions, and chargebacks and adjustments to their own accounts.
- Check the total. The deposit total should equal the payout amount Shopify reports, which should equal the bank line.
- Match in bank reconciliation. Each bank deposit now matches exactly one NetSuite deposit.
Doing it by hand vs automating it
| Manual | Automated through the integration | |
|---|---|---|
| Effort | Export payout reports, match orders, key fees daily | Deposit created per payout from Shopify’s payout data |
| Error risk | High with refunds, partial refunds and chargebacks | Rules applied the same way every day |
| Month-end | Hunting unmatched deposits | Exceptions only |
| Best for | Very low order volume | Most Shopify Plus merchants on NetSuite |
Many connectors sync orders but not payouts, which is why finance teams still reconcile by spreadsheet after “integrating.” When we scope a Shopify–NetSuite integration, payout reconciliation is a named deliverable, and our Lightning integration platform handles payout-level deposits for NetSuite. See Shopify NetSuite integration.
Common problems and how to fix them
- Deposit is off by a few cents. Usually currency rounding or a fee calculated per order in one system and per payout in the other. Post fees from Shopify’s payout detail, not a percentage estimate.
- Refund appears in the wrong month. Refunds reduce the payout they are deducted from, not the original order’s payout. Date the refund line to the payout.
- Gift card and store credit orders. These carry no Shopify Payments transaction, so they should not be expected in a payout.
- Multiple payment gateways. PayPal, Shop Pay Installments and other gateways settle separately; reconcile each gateway’s settlements as their own deposits.
- POS sales. Shopify POS card sales settle through the same payouts; cash from stores needs its own deposit process.
Frequently asked questions
Can NetSuite automatically create deposits for Shopify payouts?
Not on its own. An integration has to read Shopify’s payout data and create the deposit in NetSuite with the included payments, fees and adjustments.
Where should Shopify fees go in NetSuite?
To a merchant or payment processing fees expense account, added as a line on the payout deposit so the deposit equals the net bank amount.
Should Shopify orders post as cash sales or sales orders?
It depends on your fulfillment flow. Either works for reconciliation, as long as the payment lands in a clearing account that payout deposits draw from.
How often should payouts be reconciled?
Daily, if payouts are daily. With automated payout deposits, month-end reconciliation becomes a review of exceptions.