Skip to main content

Understanding Data Discrepancies Between MRP and Amazon

Why MRP and Amazon Business Reports or Campaign Manager show different numbers. The real causes, what MRP excludes, and how to troubleshoot correctly.

Why MRP Shows Higher Sales Than Amazon Business Reports

If your MRP revenue is higher than what Amazon Business Reports show, there are two likely causes:

1. You're using FBM and charging customers for shipping. Amazon Business Reports show only item sales. MRP shows total revenue, which includes any shipping fees you charge customers. If you fulfill via FBM and charge separately for shipping, that shipping revenue is included in MRP's total — which is the correct representation of your actual revenue.

2. Pending and cancelled orders on recent dates. When you check data for a recent time period, small discrepancies are normal because some orders will be in "Pending" status and may later become cancelled. MRP will adjust its data once the order status is finalized. This is expected behavior and resolves on its own within 24–48 hours.

What Costs Are NOT Included in MRP

Multi-Channel Fulfillment (MCF) fees are excluded. MCF fees are costs related to fulfilling orders from non-Amazon channels (e.g., Shopify) through Amazon FBA. Because these costs are not related to Amazon sales, MRP excludes them by design.

Inbound transportation fees are excluded. The cost of shipping inventory from your warehouse to Amazon is not included in MRP. The reason: if you use a third-party shipping provider, this cost won't be accurately attributed at the product level through Amazon's API. The correct approach is to add your inbound transportation cost to your product's landed cost and include it in your COGS upload. This gives you more accurate per-ASIN profitability.

Inbound placement fees ARE included. You do not need to account for inbound placement fees separately. MRP captures these automatically.

How to Troubleshoot Advertising Spend Discrepancies

When comparing ad spend between MRP and Campaign Manager, always start at the account level. If the total account-level spend matches, then any differences you see at the product level are about distribution, not a data error.

Here's why per-product numbers may differ: Campaign Manager shows spend at the campaign or portfolio level. MRP uses advertised product data, meaning it attributes spend accurately to the specific ASIN that was being advertised, even within campaigns that contain multiple products. This is more precise than what Campaign Manager shows by default.

Additionally, Campaign Manager's ASIN-level view only shows Sponsored Products data. MRP allocates Sponsored Products, Sponsored Brands, and Sponsored Display spend all at the product level. So if the account-level totals match, MRP's per-ASIN breakdown is likely the more accurate picture, you just can't verify it directly in Campaign Manager for SB and SD.

Troubleshooting order: Check account total → if it matches, the distribution is correct → investigate at ASIN level in MRP.

Why FBA Fees and Referral Fees May Differ From Settlements

MRP allocates all fees (FBA fulfillment, referral fees, storage) by order date — the date the customer placed the order.

Amazon's settlement and payout reports use the transaction posted date - the date funds were disbursed. This creates timing differences, especially around month-end when orders placed in one month are settled in the next.

For a detailed explanation, see the article "Why MRP Data Differ From Settlements/Payouts."

If you still face issues, feel free to reach out to us for a help. When contacting please include: account name, metric affected, date range, MRP value, and Amazon value.

Did this answer your question?