ConnectBooks and Amazon can sum up data differently, so it's important to compare them the right way. For example, ConnectBooks may include some fees that some Amazon reports don't. Credit card payments for ads won't appear in Amazon's date range report, and Amazon reserve funds won't show in the ConnectBooks Profit and Loss report.
Viewing the ConnectBooks report
Go to Reports, then Sales, and click Standard P&L Report.
Click Customize. Set Display Items By to SKU and Transaction Date to Posted Date.
In the Type dropdown, select only Orders, then click Run Report.
Viewing the Amazon report
In your Amazon account, go to the Payments tab and select Reports Repository.
Choose Transaction as the report type.
Select All account types.
Set the date range, then click Generate.
In the Amazon report you made:
Use the filter in the Type column and select orders.
In the Marketplace column, make sure only amazon.com is selected.
In the Product Sales column, deselect all $0 sales. ConnectBooks records these as Replacements.
Comparing the reports
In your Amazon report, add up the Product Sales column.
The total should match Sales in ConnectBooks exactly.
Quantity comparison
In your Amazon report, add up the Quantities column.
In ConnectBooks, check the total at the bottom of the Sales Qty column.
These numbers should also match exactly.
You can repeat this 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!
Frequently asked questions
Why do I leave out the $0 sales in Amazon?
ConnectBooks records $0 sales as Replacements, not Orders, so they aren't in the ConnectBooks total.
Why don't my ad payments show in Amazon's report?
Credit card payments for ads don't appear in Amazon's date range report.
Why does Amazon show reserve funds that ConnectBooks doesn't?
Amazon reserve funds don't show in the ConnectBooks Profit and Loss report.