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.
💡Good to know
If you connected your Amazon account to Link My Books after 1st June 2023 then we now automatically account for this by adjusting our settlement summaries to match the business report timezones.
Comparing Amazon settlement data to Amazon business reports
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.
Actions to Resolve Discrepancies
Navigate to Payments > Reports Repository in Amazon Seller Central
Select Transaction as the Report Type
Choose Month as the Reporting Date Range
Select the desired month and click Request Report
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 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].