Skip to main content

Some of my Amazon settlements are missing

What to do if Amazon settlements are missing from your Link My Books account

Daniel Little avatar
Written by Daniel Little
Updated yesterday

If you're missing Amazon settlements in your Link My Books account, follow these steps to troubleshoot.

Step 1: Check your historical data allowance

Check to ensure your plan type includes the right amount of historical data, our plan tiers are based on the number of sales channels you have connected to Link My Books:

Plan Tier

Sales Channel Connections Included

Historical Data Included

Free Trial

Unlimited

3 months

Lite

1

3 months

Plus

2

12 months

Pro

5

18 months

Premium

10

24 months

If you require more historical data you can purchase a one off historical data bundle.

We offer the following historical data bundles:

  • Access up to 12 months of historical data: £49 +VAT

  • Access up to 24 months of historical data: £99 +VAT

To purchase an additional historical data bundle, please contact our support team.

For more details on historical data bundles please see this help article.

Step 2: Request the older reports from Amazon

Go into your seller central account and navigate to:

Reports > Payments > All Statements

On that page should be a list of all of your past settlements from Amazon:

 A screenshot of the "All Statements" page from an Amazon Seller Central account. The page displays a table with several rows, each representing a statement period.  The columns of the table include: "Statement Period", "Beginning Balance", "Sales", "Refunds", "Expenses", "Others", "Payout Amount", and "Download".  The first row, "3/17/2021 - Present", shows a "Beginning Balance" of "Amount Carried Forward - $12.05" and "Paid to Amazon: $12.05". "Sales", "Refunds", "Expenses", and "Others" are all $0.00. The "Payout Amount" is "$0.00 Available after settlement close" with a "View transactions" link.  The second row, "2/17/2021 - 3/17/2021", has the same "Beginning Balance" as the first row. "Sales", "Refunds", and "Others" are $0.00, while "Expenses" is "-$12.05". The "Payout Amount" is "$12.05" with "View transactions" and "Request Report" buttons.  The third row, "1/20/2021 - 2/17/2021", shows a "Beginning Balance" of "Amount Carried Forward - $12.00" and "Paid to Amazon: $12.00". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fourth row, "12/9/2020 - 1/20/2021", has a "Beginning Balance" of "Amount Carried Forward - $12.23" and "Paid to Amazon: $12.23". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fifth row, "11/11/2020 - 12/9/2020", displays a "Beginning Balance" of "Amount Carried Forward - $12.44" and "Paid to Amazon: $12.44". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.23". The "Payout Amount" is "-$12.23" with "View transactions" and "Request Report" buttons.  Above the table, there are filters for "Account Type" (set to "Standard Orders") and "From" and "To" date ranges. There are also links for "When will I be paid?" and "Why are some reports missing?". The top of the page includes navigation tabs such as "Statement View", "Transaction View", "All Statements", "Disbursements", and "Reports Repository".          Analysis

The older settlements will have Request Report beside them. On clicking that Amazon will generate Flat File V2 reports for these settlements.

A screenshot of the "All Statements" page from an Amazon Seller Central account, displaying a table of statement periods.  The table includes columns for "Statement Period", "Beginning Balance", "Sales", "Refunds", "Expenses", "Others", "Payout Amount", and "Download".  The first row, "3/17/2021 - Present", shows a "Beginning Balance" of "Amount Carried Forward - $12.05" and "Paid to Amazon: $12.05". "Sales", "Refunds", "Expenses", and "Others" are all $0.00. The "Payout Amount" is "$0.00 Available after settlement close" with a "View transactions" link.  The second row, "2/17/2021 - 3/17/2021", has the same "Beginning Balance" as the first row. "Sales", "Refunds", and "Others" are $0.00, while "Expenses" is "-$12.05". The "Payout Amount" is "$12.05 In Progress" with a "View transactions" link. Unlike the previous image, this row does not have a "Request Report" button.  The third row, "1/20/2021 - 2/17/2021", shows a "Beginning Balance" of "Amount Carried Forward - $12.00" and "Paid to Amazon: $12.00". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fourth row, "12/9/2020 - 1/20/2021", has a "Beginning Balance" of "Amount Carried Forward - $12.23" and "Paid to Amazon: $12.23". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fifth row, "11/11/2020 - 12/9/2020", displays a "Beginning Balance" of "Amount Carried Forward - $12.44" and "Paid to Amazon: $12.44". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.23". The "Payout Amount" is "-$12.23" with "View transactions" and "Request Report" buttons.  Above the table, there are filters for "Account Type" (set to "Standard Orders") and "From" and "To" date ranges. There are also links for "When will I be paid?" and "Why are some reports missing?". The top of the page includes navigation tabs such as "Statement View", "Transaction View", "All Statements", "Disbursements", and "Reports Repository".

💡Good to know

Once the settlements show the Download Flat File V2 button, as shown above, they should drop into Link My Books within 48 hours.

You do not need to download the reports or send them to support.

If after 48 hours your settlements are still not showing in Link My Books then please contact support and include a screenshot of your settlements in Amazon showing that the Flat File V2 reports are available. At this point, you can download the files and send them to support for us to manually investigate.

This is generally caused because your seller account is still on the old version of the settlement files.

We use the Flat File V2 format and if your account is still on the old Flat File version then we can't import your settlements.

This can be resolved though - just follow these steps:

Go to your seller central account and navigate to:

Reports > Payments > All Statements

On that page should be a list of all of your past settlements from Amazon.

Under the Action column, you will see some buttons to view and download the settlements.

What you are looking for is that you have the "Flat File V2" available, as shown here:

A screenshot of the "All Statements" page from an Amazon Seller Central account, displaying a table of statement periods.  The table includes columns for "Statement Period", "Beginning Balance", "Sales", "Refunds", "Expenses", "Others", "Payout Amount", and "Download".  The first row, "3/17/2021 - Present", shows a "Beginning Balance" of "Amount Carried Forward - $12.05" and "Paid to Amazon: $12.05". "Sales", "Refunds", "Expenses", and "Others" are all $0.00. The "Payout Amount" is "$0.00 Available after settlement close" with a "View transactions" link.  The second row, "2/17/2021 - 3/17/2021", has the same "Beginning Balance" as the first row. "Sales", "Refunds", and "Others" are $0.00, while "Expenses" is "-$12.05". The "Payout Amount" is "-$12.05" with a "View transactions" link. In the "Download" column, there is a dropdown menu labeled "Download Flat File V2" with a red rectangular outline around it, indicating it has been clicked or is highlighted.  The third row, "1/20/2021 - 2/17/2021", shows a "Beginning Balance" of "Amount Carried Forward - $12.00" and "Paid to Amazon: $12.00". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fourth row, "12/9/2020 - 1/20/2021", has a "Beginning Balance" of "Amount Carried Forward - $12.23" and "Paid to Amazon: $12.23". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.00". The "Payout Amount" is "-$12.00" with "View transactions" and "Request Report" buttons.  The fifth row, "11/11/2020 - 12/9/2020", displays a "Beginning Balance" of "Amount Carried Forward - $12.44" and "Paid to Amazon: $12.44". "Sales", "Refunds", and "Others" are $0.00, and "Expenses" is "-$12.23". The "Payout Amount" is "-$12.23" with "View transactions" and "Request Report" buttons.  Above the table, there are filters for "Account Type" (set to "Standard Orders") and "From" and "To" date ranges. There are also links for "When will I be paid?" and "Why are some reports missing?". The top of the page includes navigation tabs such as "Statement View", "Transaction View", "All Statements", "Disbursements", and "Reports Repository".

If you don't have the "Download Flat File V2" available then please send a seller support email to Amazon that specifically requests: "Please enable the new V2 flat-file format settlement reports for my seller account". 

You may need to raise the case several times or escalate the case to ensure a suitably qualified support rep from Amazon responds and actions the change. 

Sometimes if you only sell through MFN and not FBA you will need to create one FBA item listing in order for them to activate the V2 reporting.

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].

Did this answer your question?