Step 1: Download the detailed ledger report from Amazon
Follow the steps in How to download the Inventory ledger detail report in Amazon. The key point is to select detailed view as the report type, not summary. The summary report does not contain shipment level data, so it cannot be used for this comparison.
Set the date range wide enough to cover from when the shipment was shipped until it was fully received, then request and download the CSV.
Step 2: Filter the report to your shipment
Open the CSV and apply three filters to isolate the rows for the shipment you are checking:
Column D to your SKU
Column F to receipt (this is the event type that represents units physically received into FBA)
Column G to the shipment ID (for example, FBA1983XTV9D)
Filtering on receipt is important. The ledger logs many event types such as adjustments and transfers, and you only want the units that were received against this specific shipment.
Step 3: Total the received units
With the filters applied, sum the quantity column for the remaining rows. This gives you the total units Amazon recorded as received for that shipment ID and SKU.
Step 4: Compare to ConnectBooks
Open the same shipment in ConnectBooks and compare the received quantity. The two numbers should match.
A quick example
Say ConnectBooks shows 200 units received for SKU B07L5D3QQ8 on shipment FBA1983XTV9D, but you want to verify against Amazon. You download the detailed ledger, filter column D to B07L5D3QQ8, column F to receipt, and column G to FBA1983XTV9D. You get three receipt rows totaling 200 units across two days. That confirms the match, and it also explains why the units may have posted on two different dates.