Firstly, matching the Amazon sales between the two types of reports from Amazon (Settlements and Business Reports) is never an exact match. Timing discrepancies often arise due to Amazon's settlement system, where B2B orders have a 30-day credit period and B2C orders follow a "Delivery Date + 7 Days" rule.

The reason for this is that the Amazon settlement reports are in UTC time zone and the business reports are in the timezone of the marketplace which they are generated for. This can give anything from a 1-10 hour window at the start and end of a month where the two reports don't line up. Additionally, VAT differences and Amazon's reconciliation restrictions contribute to discrepancies, as VAT is included in Seller App sales figures but excluded in Link My Books reports, and Amazon's system lacks specific data on deferred sales.

Link My Books uses the Amazon settlement reports to accurately break down each payout you receive from Amazon.

Whilst it is possible to compare the figures contained in the settlement reports to those in the business reports it can be tricky.

You can then navigate to Analytics > Amazon Reconciliation on Link My Books where you can use this file to reconcile your Amazon figures with Link My Books summaries.

If you need any assistance with this, then please get in touch with our customer support team who will be happy to help.

Rest assured that since we are using Amazon's own settlement reports and those are a full breakdown of all the transactions that make up each payout you receive from Amazon - you can trust that the data is 100% accurate.

The invoices we post to Xero and the sales journals we post to QuickBooks are simply a summarised aggregated version of the settlement reports from Amazon which will always match exactly the payout you received from Amazon.

We also attach a file in Xero and QuickBooks to each entry we post, with a full audit trail showing all the transaction level data and how we categorised it.

If you notice that your Sales Dashboard in Link My Books shows a higher figure than what appears in your settlements or in Xero/QuickBooks, this is usually explained by Amazon V2 settlement files and deferred revenue.

Amazon's V2 settlement format includes transactions that are deferred (e.g. DD+7 and B2B orders held back from the current payout). The Sales Dashboard may reflect gross sales including deferred amounts, while the settlement summaries only reflect what Amazon has actually released for payment in that period. This means a gap of around 5% or more between the two views is not unusual and does not indicate an error.

For more detail on how deferred transactions work and how to account for them correctly, see our Amazon Deferred Transactions & Revenue Recognition article.

If you have been seeing a consistent discrepancy between your Link My Books data and Amazon's Sales Dashboard or Business Reports for an extended period (e.g. 12 months or more), and you have ruled out deferred revenue as the cause, the most likely explanation is an issue with Amazon Seller Central's own reporting rather than with Link My Books.

In these cases we recommend: