Shopify Payouts: Troubleshooting Errors, Pending Payouts, and Reconciliation
This article helps Webgility Desktop users resolve complex Shopify payout issues. It provides step-by-step instructions to address payout failures, reconciliation discrepancies, and situations that require manual adjustments to ensure accurate financial tracking and seamless integration with QuickBooks.
Overview
This guide details operational steps for resolving complex Shopify payout issues, including payout failures, reconciliation discrepancies, and manual adjustments.
Common Shopify Payout Issues
- Pending payouts not processing or stuck
- Error messages when processing or reconciling payouts
- Missed or failed payouts not appearing in bank feeds
- Invoice discrepancies between Shopify and accounting software (e.g., QuickBooks)
- Manual adjustments are required to reconcile records
Troubleshooting Steps
1. Review Payout Status
- Go to Shopify Admin > Settings > Payments > Payouts.
- Note the status of each payout (e.g., pending, failed, paid).
2. Investigate Failed/Pending Payouts
- Review linked financial accounts for connection issues.
- Use error logs to identify specific problems (e.g., invalid account details, processing delays).
- Cross-reference payout and invoice IDs with the customer’s accounting records.
3. Manual Adjustments and Transaction Linking
- For failed or mis-posted payouts, manually adjust records:
- In Shopify: Use Mark as Paid or Retry Payout options if available.
- In accounting software: Ensure all Shopify payouts are correctly imported and linked.
- Reconcile each payout line item to corresponding invoices/transactions.
4. Address Invoice and Reconciliation Discrepancies
- Audit invoice data for mismatches or omissions.
- Correct invoice or payout data in both Shopify and the external accounting tool.
- Re-run synchronization if necessary.