Troubleshooting Settlement Report Discrepancies Between Webgility Desktop and Amazon channel
This article helps Webgility Desktop users investigate and resolve deposit amount discrepancies between Webgility Desktop and Amazon Seller Central settlement reports. It emphasizes a structured approach to identify the root causes of differences and ensure accurate financial reconciliation.
Steps To Resolve:
- In Webgility navigate to Orders go to Amazon then Amazon Settlement Reports.
- Go to the Posted Tab, you may enter the Settlement ID in the search bar or search by Deposit Date, depends on the user.
- Select the affected report on the far right-hand side click on the blue icon with a search mark, this is the detailed view of the report.
- Check how much amount is on Amazon, Webgility Desktop and in QuickBooks.
- If you see any fields in red, it means the report is incomplete. The user need to unsync the report from QuickBooks, re-download the report.
- Verify the Deposit to Amount via detailed view and post the report.
- In certain cases, sometime the funds are not manually transferred from Amazon Clearing A/C (virtual account) to the real Bank account in QuickBooks, due to which the reporting is impacted.