So Many Reports But None Of Them Match One Another For Settlement Periods/Same Time Frame
Reaching out to all FBA sellers to hopefully gain some insight as to how you reconcile each settlement period?
Each report we download is different (there are way too many reports) and nothing matches up. (Ex. units sold).
The Payment Statement, Summary Page, the Reports Repository Transaction report, Amazon Fulfilled Shipments, and the Customer Shipment Sales reports (all for the exact settlement period time frame) do not match, they are all different.
Also, does anyone know what determines the Account Level Reserve for each settlement period? They always keep $20k or more and we have never had chargebacks, very little returns/refunds and account is always in good standing.
Seller Support is not providing any information other than how to download a report (clearly we already know this).
So here we are reaching out to our fellow FBA sellers to get some insight on how you reconcile each settlement period for your orders so they match what was actually deposited into your bank account and what is the best way to conduct this and with which reports you use?
Thank you in advance for all your help! :)
12 replies
Seller_tzb0Adb4whsRu
Here are some of the reports we pull/download. Sorry if they're too small to read.
This is the Amazon Fulfilled Shipment Report
Customer Shipment Report
Payment Dashboard-Statement View
Payment Statement (printed off)
Reports Repository Report
TaylorR_Amazon
Hello @Seller_tzb0Adb4whsRu,
Amazon Fulfilled Shipments includes completed customer orders. I think some of the discrepancies you are seeing are reflecting the difference between orders placed and completed orders.
Purchase date is the date the order was placed.
Payments date is the date the buyer's credit card was charged and order processing was completed.
Shipment date is the date the shipment was completed (shipped) by the fulfillment center.
Reporting date is the date the data for this report became available in the FBA data store.
Quantity shipped refers to the number of this item that were shipped.
Item price here is the amount that the buyer paid for the item. Amount is aggregate of the quantity, not unit price.
Customer Shipment Sales includes shipped FBA customer orders. Here, the Product Amount or item-price-per-unit is the price paid for each product unit.
The Transaction View page displays the account transactions within a statement period, up until the prior day's close. A transaction can be an order, a refund, or an Amazon-initiated charge or credit.
Account level reserve is the amount of money that is reserved to ensure that you have enough funds to fulfill any financial obligations, such as refunds, claims, or chargebacks. This could even include withheld income tax depending on local regulations.
