Sales in Shopify, Amazon, Walmart or BigCommerce almost never equal the money that lands in the bank. Commission, fulfilment and payment fees, refunds, chargebacks, adjustments and payout timing all sit in between. Finance ends up rebuilding the difference in a spreadsheet every period, plugging residuals to suspense accounts, and closing late because nobody can say which deposit covers which orders.
APIWORX takes the settlement or payout report each channel and processor actually publishes, breaks it into its components, and posts each one to the accounts and dimensions your finance team nominates — carrying the payout reference through so the bank line reconciles as a whole. Period cut-off rules are agreed once and applied consistently. Anything that cannot be explained is held for review rather than balanced silently.
Payout Reconciliation Features
Everything you need for a successful implementation
Key Benefits
- Every bank deposit traceable back to the orders and fees behind it
- No spreadsheet rebuild of fees and refunds at each period close
- Fees and refunds landing in the accounts finance actually chose
- Cross-period payouts identified before the close, not after
- New channels and payment methods added as configuration, not another manual routine
Common Use Cases
- Shopify payouts reconciled into QuickBooks Online
- Amazon settlement reports posted to Sage Intacct with fee breakdown
- Walmart Marketplace settlements matched to deposits in the ERP
- Multi-channel fee and refund analysis by channel dimension
- Multi-entity marketplace revenue split across accounting entities