Resolving Shopify US Payout and Amazon CA Deposit Discrepancies in QuickBooks Desktop via Webgility Desktop

Overview

You're likely dealing with one or more of these issues:

• Failed Shopify US payout postings
  
  
• Amazon CA deposit mismatches, especially around tax and refunds
  
  
• Errors with order sync, mapping, or requests to undo/retry a sync
  
  

Step-by-Step Troubleshooting

1. Begin with an Account Review

Start by accessing the customer’s Shopify and Amazon CA integrations within Webgility Desktop.

• Review the integration status for both stores
  
  
• Look for any sync issues, mapping errors, or disabled services
  
  
• Document the current state of payout and deposit postings
  
  

👀 You're looking for any signs of partial syncs, missing records, or misconfigured mappings.

1. Identify the Source of the Discrepancy

Run transaction and payout reconciliation reports from both platforms.
Focus on:

• Sales tax fields (especially Canadian-specific rates in Amazon CA)
  
  
• Refunds vs. original order postings
  
  
• Any unposted or partially posted transactions
  
  

Note: Your goal is to find what doesn't match between the customer’s reports and what’s posted in QuickBooks Desktop.

1. Troubleshoot Shopify US Payout Posting Errors

If payouts from Shopify US aren’t posting correctly:

• Confirm the customer has mapped items, SKUs, and payment methods
  
  
• Check the audit and error logs for failed payout attempts
  
  
• If errors persist, try a manual sync or re-post the failed payout
  
  

Tip: Correct mapping is essential for accurate payout tracking.

1. Address Amazon CA Deposit Discrepancies

Dive into the Amazon CA deposit reports, and focus on:

• Sales tax records
  
  
• Refunds are listed separately from posted orders
  
  

Then:

• Match deposit amounts to order-level postings
  
  
• Double-check the integration mapping, especially for Canadian tax codes
  
  

Note: Mismatches are often caused by missing or incorrect sales tax mapping in CA settings.

1. Handle Refund and Order Sync Issues

If the issue involves refunds or sync failures:

• Explain that refunds must link back to the original order ID
  
  
• For delayed or failed syncs, locate the original sync job in the logs
  
  
• Use Undo Sync (if available), then re-post corrected data
  
  
• Guide the customer in updating item or tax code mappings if needed
  
  

Note: Resyncing often resolves issues after correcting mapping or configuration errors.

1. Finalize and Reconcile the Records

Once corrections are made:

• Run final reconciliation checks using Shopify and Amazon CA reports
  
  
• Verify that payouts and deposits now match posted records