Shopify Payout Discrepancies Involving Refunds and Fees in Webgility Desktop
This guide helps Webgility Desktop users understand and resolve Shopify payout posting discrepancies, including issues with refunds, multiple charges, missing or unposted fees, and mismatched balances between Shopify and QuickBooks Desktop.
Overview
This guide details the workflow for Shopify payout posting discrepancies, including issues with refunds, multiple charges, missing/unposted fees, and mismatched balances between Shopify and QuickBooks.
Common Discrepancy Scenarios
- Duplicate expense/fee postings
- Fees or charges shown in Shopify payout details but missing from QuickBooks
- Order refunds not matched/reconciled across systems
- Account balances between Shopify and QuickBooks not aligning
Preliminary Checklist
- Validate Report:
- Review the description of the discrepancy.
- Reproduce Issue:
- Access Shopify and QuickBooks (QB) accounts via test data.
- Identify examples of duplicate, missing, or mismatched entries.
- Confirm Data Consistency:
- Compare Shopify payout reports with QB posting records for the impacted period.
- Verify transaction IDs, dates, and amounts for refunds, fees, and payouts.
Re-attempt Data Sync:
-
- Trigger sync or manual export/import operations if standard workflow steps failed previously.
- Trigger sync or manual export/import operations if standard workflow steps failed previously.