Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA and those that are currently in FBA. While Amazon provides a per-shipment reconciliation report, Sellercloud’s FBA Reconciliation report reconciles your entire inventory at FBA in a more comprehensive manner. This report compiles data from multiple Amazon reports, including all orders, returns, reimbursements, removals, etc., as well as from FBA inbound shipments in Sellercloud. All data is loaded onto a single page to provide the expected quantity at FBA.
Running the report
To run the FBA Reconciliation report:
- Click Settings > Client Settings > select Enable FBA Reconciliation Page.
- Click Inventory > FBA Reconciliation.
- Filter by Company, Product ID, ASIN, or FNSKU, then click Search to show your FBA products. Only Amazon-fulfilled products will appear.
- Select the products > click Action Menu > Set Start Date > Go. The page will refresh with editable Start Date and Beg. 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. The page will display the data shown in the table below.
Understanding the grid data
The table below defines each of the report’s columns.
HEADER | DESCRIPTION |
Product ID, Merchant SKU, ASIN, Product Name |
Product identifiers. |
Beg. Qty | Quantity at FBA at the time of the Start Date. |
Shipped | Quantity that was shipped to FBA since the Start Date. |
Received | Quantity that FBA marks 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 | Number of times this SKU appears in the FBA Removal Shipment Detail report. |
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 merchant is reimbursed. |
Adjustments | 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, inventory transfers, and so on. This column is not used in Sellercloud’s reconciliation calculations.Read more about the Amazon Inventory Adjustment report here. |
Expected Inventory |
Calculation: Beginning Qty + Shipped – ((Orders + Removals + Reimbursed) – Returns) = Expected Inventory |
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) |
Discrepancy | Calculation: Expected Inventory – Actual |
Setting start date in bulk
To set the start date in bulk, use the following column headers:
- FBA Reconciliation Start Date
- FBA Reconciliation Start Quantity
Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA versus those that are currently in FBA.
While Amazon provides a per-shipment reconciliation report, Sellercloud’s FBA Reconciliation report reconciles your entire inventory at FBA in a more comprehensive manner.
This report compiles data from multiple Amazon reports, including all orders, returns, reimbursements, removals, etc., as well as from FBA inbound shipments in Sellercloud. All data is loaded onto a single page to provide the expected quantity at FBA.
Running the report
To run the FBA Reconciliation report:
- Click Settings > Marketplaces > Amazon > 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 |
|
Beginning Qty | Enter the From and To quantity at FBA at the time of the Start Date. |
Shipped | Enter the From and To quantity that was shipped to FBA since the Start Date. |
Received | Enter the From and To quantity that FBA marks as received for that item since the Start Date. |
Returns | Enter the From and To quantity of units for this SKU in the FBA Return report. |
Orders | Enter the From and To quantity of orders for this SKU in the FBA Customer Shipment Sales report. |
Removals | Enter the From and To quantity of times this SKU appears in the FBA Removal Shipment Detail report. |
Custom Filters | Select the following optional filters:
|
- Click Search to show your Amazon-fulfilled products.
- Select the products > click 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.
Understanding the 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 | Quantity at FBA at the time of the Start Date. |
Shipped | Quantity that was shipped to FBA since the Start Date. |
Received | Quantity that FBA marks 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 | Number of times this SKU appears in the FBA Removal Shipment Detail report. |