Troubleshooting Shopify Payout Errors: Duplicate Orders & Reconciliation Issues
This article helps Webgility Desktop users resolve Shopify payout posting issues in Webgility Desktop caused by duplicate downloads or synchronization errors. It outlines step-by-step troubleshooting actions and offers best practices to prevent similar discrepancies in the future.
Overview
Shopify payout posting issues in QuickBooks can result from duplicate downloads or incorrect synchronization. This guide details the steps taken to resolve such discrepancies and provides recommended procedures to avoid recurrences.
Root Cause Analysis
- Duplicate posting in QuickBooks can lead to erroneous payout postings.
- Incorrect or outdated transactions may appear in QuickBooks if sync is not properly managed.
Issue Resolution Steps
1. Identify Duplicate or Incorrect Transactions
- Review the QuickBooks Bank Feed and recent transactions.
- Compare payout records between Webgility Desktop and QuickBooks to spot mismatches.
2. Remove Incorrect or Duplicate Transactions
- In QuickBooks, locate the transactions posted due to duplicate posting.
- Delete only the erroneously posted transactions to prevent reconciliation errors.
3. Repost the Correct Transactions
- Within Webgility Desktop, sync the Shopify payouts again to QuickBooks.
- Verify that the correct, reconciled transaction appears in QuickBooks.
4. Reconcile the Payout
- Confirm the payout total and transaction details in QuickBooks match those in Webgility Desktop after reposting.
- Check for date discrepancies, especially for any future-dated entries, and rectify as needed.
Preventive Best Practices
Undo Sync Before Redownload
- Always use Undo Sync in Webgility before attempting to redownload payouts to QuickBooks. This clears existing mappings and avoids duplication.
Double-Check Reconciliation
- After every sync or repost, cross-verify the reconciliation status in both QuickBooks and Webgility Desktop.
- Ensure there are no extra or missing entries for the payout period.