Resolving Duplicate Transaction Errors When Posting Amazon Settlement Reports in Webgility Desktop
This article helps Webgility Desktop users resolve errors that occur when posting Amazon settlement reports to QuickBooks Desktop due to duplicate transactions. These errors typically arise when similar transactions were manually entered or previously imported. The article provides steps to identify and manage duplicates to ensure accurate posting.
How to Identify the Issue
-
The error appears during the settlement report posting process.
-
The message points to duplicate transactions already existing in QuickBooks Desktop.
-
You may see overlapping amounts or dates when comparing the settlement report with your QuickBooks records.
Steps to Resolve the Issue
1. Locate Duplicate Transactions in QuickBooks Desktop
-
Open QuickBooks Desktop.
-
Use filters (by date, transaction type, or amount) to help locate potential duplicates referenced in the error.
2. Delete Duplicate Transactions
-
Open each duplicate transaction in QuickBooks.
-
Go to the Edit menu and select Delete, or right-click the transaction and choose Delete Transaction.
-
Confirm the deletion.
-
Repeat this for each duplicate entry.
3. Confirm the Duplicates Are Removed
-
Run a transaction report for the relevant date range or accounts.
-
Make sure only one version of each transaction remains in QuickBooks.
4. Repost the Settlement Report in Webgility Desktop
-
Go back to Webgility Desktop.
-
Reinitiate the posting of the Amazon settlement report.
-
Confirm the process completes without triggering any duplicate transaction errors.