ConnectBooks and Amazon can summarize data differently, so it’s essential to compare them correctly. For example, ConnectBooks may include certain fees that some Amazon reports do not. Credit card payments for ads won’t appear in Amazon’s date range report, and Amazon reserve funds won't show in ConnectBooks' Profit and Loss report.
Viewing the ConnectBooks Report
Go to the Profit and Loss section and select the Standard Report.
Click Customize Report, group items by SKU, and view orders by the posted date.
Click the Filter button, choose only "orders," and then click Run Report.
Viewing the Amazon Report
In your Amazon account, navigate to the Payments tab and select Reports Repository.
When generating the report:
Choose Transaction as the report type.
Select All account types.
Set the date range, then click Generate.
When generating the report:
Select report type - Transaction
Select account type to include - All
Select report range
Then hit Generate.
In the generated Amazon report:
Use the filter in the Type column and select "orders."
In the Marketplace column, ensure only "amazon.com" is selected.
In the Product Sales column, deselect all $0 sales, as ConnectBooks records these as replacements.
Comparing the Reports
In your Amazon report, sum the values in the Product Sales column.
The sales figures should match exactly to the ConnectBooks reports.
Quantity Comparison
In your Amazon report, sum the values in the Quantities column.
In ConnectBooks, check the total quantity at the bottom of the Qty column in the Profit and Loss report.
These numbers should also match exactly.
You can repeat this process for other transaction types, such as refunds and adjustments.
If you have any questions about matching your reports, please contact our support team. We’re here to help!