If you're missing Amazon settlements in your Link My Books account, or a settlement is showing an error or won't send, follow the steps below to troubleshoot.
🔍 Jump to your specific issue:
• Settlements are missing entirely — check historical data allowance
Step 1: Check your historical data allowance
Check that your plan includes the right amount of historical data. Plan tiers are based on the number of sales channels 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 directly in the app — no need to contact support. See our Accessing Historical Data article for full details on how to purchase and set your history date.
Step 2: Request the older reports from Amazon
Amazon archives settlement reports after 90 days. Before Link My Books can import them, you need to request them from Amazon Seller Central.
Go into your Seller Central account and navigate to:
Reports > Payments > All Statements
On the All Statements tab you will see a list of all your past settlements. Older settlements will show a Request Report button — click it to ask Amazon to generate a Flat File V2 report for that settlement period.
Once Amazon has processed the request, the button will change to Download Flat File V2.
💡 Good to know
Once the Download Flat File V2 button appears, the settlement should drop into Link My Books within 48 hours. You do not need to download the reports or send them to support — the system picks them up automatically.
If after 48 hours the settlements are still not showing in Link My Books, please contact support.
⚠️ To avoid delays, include BOTH of the following in your first message to support:
A screenshot of the All Statements page in Amazon showing the Download Flat File V2 button is available for the affected settlement(s)
The actual .txt Flat File V2 downloaded from that button (click "Download Flat File V2" and attach the file)
Sending only a screenshot without the .txt file means we'll need to ask for it separately, which causes delays. If you send both upfront, our team can investigate and manually import the settlement straight away.
Step 3: Settlement showing a "! Error" status
If a settlement is showing a ! Error badge on your Settlements Dashboard, this means the data in Amazon's Flat File V2 report does not match the payout amount — some transactions may be missing from the file.
💡 Two types of Error — most can be fixed without raising an Amazon case
Some Error badges are caused by a transient processing glitch rather than a genuine file mismatch. In these cases, our support team can reload or "nudge" the settlement to clear the error — often within minutes, without any action needed from you or Amazon.
Always contact Link My Books support first. We'll attempt to reload the settlement for you. Only if the error persists after our team has tried will you need to raise a case with Amazon Seller Support.
If the error cannot be cleared from our end, you'll need to raise a case with Amazon asking them to correct and reissue the Flat File V2. For full step-by-step instructions and a template message to use, see our Error Handling article.
💡 What happens after Amazon fixes the file?
Once Amazon corrects and reissues the report, it should automatically update in Link My Books within 48 hours. If it doesn't, download the corrected file from Seller Central and send it to [email protected].
Step 4: Settlement is in Link My Books but COGS bills are missing
If your Amazon settlements have been posted to Xero or QuickBooks but the corresponding COGS (Cost of Goods Sold) bills are missing, this is usually because one or more of your product SKUs have no cost entered. Link My Books allows the sales invoice to post, but will not send a COGS bill for any SKU with a cost of £0 / $0.
To find and fix SKUs with no cost:
Go to Inventory → Product Costs
Toggle on "Show only SKUs with no cost"
Add the missing costs for each SKU listed
Once costs are entered, you can re-send the COGS bills for those settlements.
⚠️ Note on inactive SKUs
If a SKU is no longer active and you don't have a cost for it, you can enter a value of £0.01 / $0.01 as a placeholder so that it doesn't block COGS bills from sending.
⚠️ Large number of settlements affected (e.g. after a data migration or reprocessing event)?
If you have many settlements with missing COGS — for example, following a system migration, a rollback, or Amazon account reprocessing — manually updating each SKU and re-sending individually may not be practical.
In these cases, please contact our support team. We can:
Export a spreadsheet of all SKUs currently set to £0 / $0
Accept your updated costs via spreadsheet and upload them in bulk
Trigger COGS bills to resend across a date range once costs are updated
Note that the sales invoices will have already posted correctly — it's only the COGS bills that are affected. This is expected behaviour: Link My Books posts the sales side immediately and only sends COGS once costs are available.
If your Amazon account shows only Flat Files, not Flat File V2 buttons
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 — if your account is still on the old Flat File version, we can't import your settlements.
This can be resolved by following these steps:
Go to your Seller Central account and navigate to:
Reports > Payments > All Statements
Under the Action column, check whether you have Flat File V2 available as shown here:
If you don't have the Download Flat File V2 available, 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 to ensure a suitably qualified support rep 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.
Settlement is in Link My Books but won't send to Xero / QuickBooks
If your settlement is showing as Ready to Send but there is no option to post it, or clicking "Send to Xero" appears to do nothing, this is usually caused by missing tax rate or account mappings for that marketplace.
See our No Option to Send Settlements article for troubleshooting steps. In short: check your Accounts & Taxes mappings for the affected marketplace and ensure all required fields are completed.
⚠️ Settlement spanning multiple months still won't send after checking mappings?
Occasionally, a settlement that spans multiple billing periods can get stuck even when all mappings are correctly set up. This requires our support team to rerun the VAT reports for that settlement on the back end — it's not something that can be fixed from within the app.
If you've verified your mappings are complete and the settlement still won't post, please contact support and let us know the settlement date range and the marketplace affected.
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].