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

How to Resolve Settlement Posting Errors Caused by Unpaid and Duplicate Orders in Webgility Desktop

This article helps Webgility Desktop users resolve errors encountered when posting Amazon settlement reports to QuickBooks Desktop caused by unpaid orders and duplicate transactions. It explains how to address these issues, outlines best practices for handling exceptions, and ensures data integrity throughout the posting process.

Overview

This article explains how to resolve errors in Webgility involving unpaid orders and duplicate transactions when posting settlement reports to QuickBooks. It outlines best practices for addressing exceptions and ensuring data integrity.

Common Errors

  • Unpaid Order in Settlement Report: Attempting to post unpaid orders to QuickBooks can lead to accounting discrepancies.
  • Duplicate Transaction Error: Occurs when an order is posted multiple times, causing data duplication and reconciliation issues.

Step-by-Step Troubleshooting

1. Reviewing Settlement Reports

  • Open Webgility and navigate to Settlement Reports.
  • Identify reports with errors, especially those mentioning unpaid orders or duplicate transactions.

2. Handling Unpaid Orders

  • Best Practice: Only post paid orders to QuickBooks to maintain clean financial records.
  • Action:
    1. Locate the unpaid order in the settlement report.
    2. Remove or exclude the unpaid order from the report; alternatively, try to fix payment issues on the affected order.
    3. Save the adjusted report before attempting to post.
  • Note: If uncertain, consult with your accountant on whether to post the unpaid order or wait until payment is received.

3. Resolving Duplicate Transaction Issues

  • Verify if the order in question has already been posted to QuickBooks.
  • To Correct a Duplicate Entry:
    1. Identify the duplicate transaction in QuickBooks.
    2. Manually delete or void the duplicate entry.
    3. Check Webgility to ensure the order is only marked as posted once.
  • Re-run the posting process for the affected report if necessary.

4. Confirming Successful Posting

  • After corrections, post the relevant settlement reports from Webgility to QuickBooks.
  • Confirm the following:
    • All paid orders are posted without error.
    • Duplicate transactions have been removed.