In very rare cases the Amazon settlement file used by Link My Books can be corrupted or missing data.
In these cases you will see an error on the settlement status like this:
Why does this happen?
The settlement file from Amazon contains a list of all the transactions that make up a payout. When it works, the total of all the transactions should match the payout amount exactly.
In these rare cases, the total of the transactions contained in the settlement file do not match the payout amount meaning data is missing.
What to do when this happens
Unfortunately the only way to resolve this is to contact Amazon Seller Support.
To open a case with Amazon Seller Support follow these steps:
On Amazon Seller Central, click Help and select Get help and support:
Select My issue is not listed:
In the box that appears enter the suggested text below:
Dear Support
My settlement file for the settlement detailed below is missing data.
Marketplace:
Settlement Period:
Settlement Amount:
When I sum up the total column in the file it does not match the payout amount (which it should).
Please can you investigate this and correct the file fo that it contains all the transactions and that the total of those transactions then matches the payout amount.
Thanks
Once you click continue you will see a page like this, select Payment report questions:
You may also see this page, select Contact an associate:
Finally, select Email, attach the settlement report and click Send:
To download your settlement file, open a new tab and navigate to:
Amazon Seller Central > Menu > Payments > Payments > All Statments (tab)
Locate the settlement with the issue and click Download.
Once Amazon resolve the issue and fix the file it should automatically drop into Link My Books within 48 hours as the new data is made available via the API.
If that doesn't happen then please download the new file and send it to [email protected]
If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].