Are you missing Amazon settlements from A2X? There are two main reasons why A2X may not be able to import all of your settlement file data from Amazon's API. 

Please try the two suggestions below - check the format, and the archive both on the Reports > Payments screen in Seller Central.

Old settlement report format 

Amazon has two formats for the settlement file, and older V1 and a newer V2 format. A2X. You can check which format your Amazon account has, as the older V1 format may not be importing to A2X if your A2X account is using the new V2 format. Below are steps for checking the format, and requesting Amazon upgrade your format.

  1. Go to Amazon Seller Central > Reports > Payments > All Statements
  2. Look for a button labelled "Download flat file V2" or "Download flat file". If your buttons say "V2" flat file, then you have the new version, if they do not, you have the older V1 format. See the screenshot below that shows both buttons.
  3.  If the missing settlements are in the old format, you will need to request Amazon to upgrade those reports (and at the same time they can upgrade your account to use the new format going forward). To learn more about the format, and how to ask Amazon to change, please see this guide that explains V1 and V2 format.

Once your settlement reports are available in V2 format, you can go to A2X Settings > History and request your settlement history. A2X will then look back in your previous accounting periods for any settlements that were missed the first time due to the format.

Archived reports

For some sellers Amazon will archive your settlement reports after some specified number of weeks or months. As strange as this sounds, once archived, A2X is unable to import the data via Amazon's API. You first need to manually 'unarchive' the reports in Amazon Seller Central, before A2X can access the data. Below are steps for how to check for archived reports and fix the issue.

  1. Go to Amazon Seller Central > Reports > Payments > All Statements
  2. Look for a button labeled 'Request Report' (see example below).
  3. If you see this button, then that settlement is archived. The way to unarchive the report is by clicking the 'Request Report' button. The request process can take anywhere from a few minutes to a few hours, once available you should see a Download button beside that settlement. This indicates the settlement has been unarchived and is available for download by A2X.

Once your settlement reports are available and not archived, you can go to A2X Settings > History and request your settlement history. A2X will then look back in your previous accounting periods for any settlements that were missed the first time due to being archived.

If you have checked the format, and the archive and you are still missing settlements in A2X

If you have checked that the format is correct, and the settlements are not archived using the instructions above, and you have requested A2X history (in A2X settings > History) and after a few hours the missing settlements have not been imported, then there could be a problem with A2X importing the settlements. Our support team is available to assist you.

Here's the information the support team will need in order to investigate:

  1. Screenshots of the settlement screen in Amazon Seller Central, showing the missing settlement is both in the correct format, and not archived.
  2. A copy of the V2 formatted flat file, downloaded from Seller Central that we can verify the format for.

Please take a screenshot and send it, along with a copy of the missing settlement file to our support deck (contact@a2xaccounting.com) and our team will be able to assist you.

Did this answer your question?