Skip to content
  • There are no suggestions because the search field is empty.

Troubleshooting Amazon Settlement Posting Failures Due to Data Mismatches in Webgility Desktop

This article helps Webgility Desktop users in diagnosing and resolving Amazon settlement posting errors between Webgility Desktop and QuickBooks Desktop caused by order amount mismatches. It outlines steps to identify the root data issues preventing successful Amazon settlement report posting and guides users through the resolution process to ensure accurate and seamless financial integration.

Overview

This article outlines the steps to diagnose and resolve settlement posting errors when integrating Webgility with QuickBooks, specifically concerning amount mismatches in orders.

Problem Description

When attempting to post settlement reports from Webgility to QuickBooks, errors may occur due to order amount mismatches. This can prevent successful settlement posting until the underlying data issues are identified and resolved.

Prerequisites

  • Access to the Webgility environment.
  • Admin access to QuickBooks.
  • Ability to update or patch the Webgility app.

Step-by-Step Resolution

1. Update the Webgility application.

  • Ensure the latest version of Webgility is installed.
  • Apply any relevant patches or hotfixes as needed.
  • Restart the application after the update.

2. Attempt posting the settlement report.

  • Navigate to Settlement Reports in Webgility.
  • Select the required settlement period and click Post to QuickBooks.
  • Observe for any error messages, especially those referencing amount or payment mismatches.

3. Identify Mismatched Orders

  • Review the error logs generated by Webgility during the posting attempt.
  • Look for entries indicating mismatched order amounts or payment discrepancies.

4. Analyze and Correct Order Data

  • Use the enhanced logs to identify specific order IDs with amount mismatches.
  • Verify and correct these orders within the Webgility or source e-commerce system so that payment and order amounts are synchronized.

5. Retry Settlement Posting

  • After correcting order data, attempt posting the settlement report again from Webgility to QuickBooks.
  • Confirm that the posting completes successfully with no errors.