FBA Reconciliation

Overview

Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA versus those that are currently in FBA. This report is generated using data from multiple Amazon reports, including All Orders, Returns, Reimbursements, and Removals. While Amazon provides an FBA reconciliation report as well, theirs is provided per shipment whereas Sellercloud’s report reconciles your entire inventory at FBA in a more comprehensive manner. You can learn more about the data included in this report below.

FBA Reconciliation Report

To run the FBA Reconciliation report:

Navigate to Client Settings > General Client Settings > select Enable FBA Reconciliation Page > Save.
Go to Inventory > FBA Inbound Shipments > FBA Reconciliation.

Select your filters. The table below defines each of these filters.

FILTER	DESCRIPTION
Company	Company name.
Product ID, FNSKU, ASIN	Product identifiers.
Show Discrepancy Only	All - Show all products Yes - Only show units with discrepancies No - Only show units with no discrepancies
Beginning Qty	Enter a From and To amount at FBA at the time of the Start Date.
Shipped	Enter a From and To amount that was shipped to FBA since the Start Date.
Received	Enter a From and To amount that FBA marked as received for that item since the Start Date.
Returns	Enter a From and To amount of units for this SKU in the FBA Return report.
Orders	Enter a From and To amount of orders for this SKU in the FBA Customer Shipment Sales report.
Removals	Enter a From and To number of times this SKU appears in the FBA Removal Shipment Detail report.
Custom Filters	Select the following optional filters: Actual: Taken from the “afn-warehouse-quantity” column in the most recent FBA Manage Inventory Report. Calculation: afn-warehouse-quantity = (afn-fulfillable-quantity) + (afn-unsellable-quantity) + (afn-reserved-quantity) Adjustment: This value is based on the FBA Inventory Adjustments report’s Quantity column. This report shows corrections and updates to your inventory in response to issues such as damage, loss, receiving discrepancies, and inventory transfers. This column is not used in Sellercloud’s reconciliation calculations. Read more about the Amazon Inventory Adjustment report here. Discrepancy: Calculation: Expected Inventory - Actual Expected: Calculation: Beginning Qty + Shipped - ((Orders + Removals + Reimbursed) - Returns) = Expected Inventory Reimbursed: Number of times this SKU appeared in the FBA Reimbursement report. Reimbursements occur when Amazon recognizes that your units were lost or damaged, and they accept responsibility for the loss. The item is removed from inventory and the merchant is reimbursed.

Click Search to show your Amazon-fulfilled products.
Select the products > click the action menu > Set Start Date. The page will refresh with editable Start Date and Beginning Qty fields.
Complete those two fields with the start date and the quantity at FBA on that start date. This will designate the date from when to start calculating the inventory sent and received.
Click Save.

Grid Results

The table below defines each of the report's columns.

HEADER	DESCRIPTION
Start Date	Date from which to start calculating the inventory sent and received.
Product ID, Merchant SKU, ASIN, Product Name	Product identifiers.
Beginning Qty	The quantity at FBA at the time of the Start Date.
Shipped	The quantity that was shipped to FBA since the Start Date.
Received	The quantity that FBA marked as received for that item since the Start Date.
Returns	Number of units for this SKU in the FBA Return report.
Orders	Number of units for this SKU in the FBA Customer Shipment Sales report.
Removals	The number of times this SKU appears in the FBA Removal Shipment Detail report.