Two Amazon reports can contain different sales totals without either being wrong. First check what each total measures before trying to force them to match.
Define the compared totals
Record marketplace, currency, reporting period and whether the figures refer to orders, shipments, ad attribution or payments. Keep tax, shipping, promotions and returns visible in the comparison.
Amazon notes that ad-attributed sales can differ from retail reporting because the calculations differ. Amazon Ads’ attribution definitions.
Build a reconciliation bridge
Start with the original totals, then list each known difference rather than changing the exports. Useful categories include a different date basis, included products, cancelled or returned items, fees and a later update to the source.
| Check | Evidence to retain |
|---|---|
| Date basis | The report definition and selected period |
| Included products | ASIN or SKU filters used |
| Currency | Currency on each original file |
| Adjustments | Relevant rows and the calculation applied |
| Unresolved balance | The amount and the next question |
Do not add overlapping sales
Ad-attributed sales are a view of sales credited to ads, not a separate pot to add to retail sales. Keep those measures in their own columns.
A completed reconciliation explains the known differences and names the remaining ones. It does not need to invent a single total that obscures the report definitions.