How to solve Shopify Payout and Duplicate order posting issues in Webgility Desktop
This article helps Webgility Desktop users in troubleshooting Shopify payout posting discrepancies in QuickBooks Desktop caused by duplicate downloads or posting errors through Webgility Desktop. It also outlines best practices to prevent such issues from recurring.
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.