To compare your orders between ConnectBooks and Amazon, use Amazon's Business Reports, not the SKU Economics report. The SKU Economics report often includes inaccurate data, such as canceled orders, and doesn't line up with other Amazon reports. Business Reports give clean data you can filter, and they match ConnectBooks when you use the same Order Date range.
Open them here: Amazon Business Reports.
Or in Seller Central, go to Reports, then Business Reports.
How to run ConnectBooks by Order Date
Go to Reports, then Sales, and click Standard P&L Report.
Click Customize, set Transaction Date to Order Date, and in the Type dropdown keep Orders and Replacements.
Use the same dates as your Amazon report, then click Run Report.
Key differences to note
ConnectBooks shows Orders and Replacements separately.
Amazon counts both as orders in Business Reports.
So when you compare totals, Orders + Replacements in ConnectBooks equals Orders in Amazon.
Avoid the SKU Economics report. It often includes canceled orders and misses adjustments, so the numbers won't match.
What should match?
Sales in ConnectBooks matches Amazon's sales. Sales Qty for Orders + Replacements matches Amazon's units ordered.
If it still doesn't match
If it's only off by a few units, it's usually because of how ConnectBooks matches orders to Amazon's payments.
Here's how it works:
We pull data from 2 Amazon sources: the Order Report (raw order details) and the Financial Events Report (posted and paid orders).
We match each order so both the quantity and the payment amounts agree.
If they don't agree, ConnectBooks records only the units Amazon posted. For example, if Amazon shows 10 units ordered but only 5 units posted (paid), ConnectBooks records 5 units for that order.
In many cases, the other units are canceled in Amazon, so the total stays at 5. That matches Amazon's final posted data.
This keeps your ConnectBooks reports matching Amazon's payment records to the penny. If an order is partly canceled, we keep only the final, correct amount.
Frequently asked questions
Why shouldn't I use the SKU Economics report?
It often includes canceled orders and misses adjustments, so it won't match ConnectBooks or other Amazon reports.
Why do I need to keep Replacements?
Amazon counts replacements as orders in Business Reports. ConnectBooks shows them as Replacements, so you need both to match Amazon.
Why is my unit count off by a few?
ConnectBooks records only the units Amazon posted. If Amazon shows more units ordered than it posted, the counts can differ by a few units.