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

How to Resolve Amazon Settlement Report Posting Errors in QuickBooks Desktop Due to Recent Configuration Updates

This article helps Webgility Desktop users in resolving Amazon settlement report posting errors in QuickBooks Desktop caused by recent updates to Amazon configurations affecting currency, payee, and discount settings across regions, including the US, Canada, Mexico, and Brazil. It provides steps taken to identify and fix these issues, providing a reference for addressing similar problems in the future.

Overview

This article documents the successful resolution of multiple errors encountered during settlement report posting in QuickBooks. Issues were traced to recently updated sales channel configurations impacting currency, payee, and discount setups (across US, CA, MX, and BR). The steps below detail how to identify and resolve similar issues for future reference.

Problem Summary

  • Errors surfaced when posting settlement reports.
  • Issues traced to mismatched currencies, vendor/payee configuration, and discount account setup across various sales channels.
  • Updates or configuration changes shortly before error onset.

Step 1: Review Error Messages

  • Collect and analyze error logs from QuickBooks during the settlement posting process.
  • Identify if errors reference the following:
    • "Currency mismatch"
    • Incorrect or missing payee/vendor
    • Invalid discount account

Step 2: Validate Sales Channel Settings

For Each Affected Channel (US, CA, MX, BR):

  • Go to Sync and Sales Channel Settings in Webgility.
  • Check the following for each channel:
    • Default currency matches channel’s home market (e.g., USD for US, MXN for MX).
    • Vendor/Payee is set to an active and correctly configured vendor record in QuickBooks.
    • Discount handling is mapped to a valid income/expense account.

Step 3: Verify Payee and Currency in QuickBooks

  • In QuickBooks, open Lists > Vendors and confirm:
    • Vendors/payees align with integration configuration.
    • Vendor profile currency matches expected channel currency.
    • No duplicate or inactive vendor accounts are mapped.

Step 4: Check Discount Account Configuration

  • Navigate to Chart of Accounts in QuickBooks.
  • Verify that linked discount accounts are active and appropriate for the channel’s locale/currency.
  • Update any retired or incorrect mappings as needed.

Step 5: Test Settlement Posting Transaction

  • Run a test posting for a limited batch, covering each sales channel.
  • Confirm proper posting in QuickBooks > Transactions.
  • Check that the batch includes relevant currency, payee, and discount data for each sales region.

Step 6: Monitor

  • Continue posting in manageable batches to catch return errors early.
  • Document configuration changes and follow best practices.