Overview
This report facilitates the process of reconciling FBA refunds with returns and reimbursements. It includes the following information:
- Company
- Order #
- Channel Order
- Refunds
- QTY Original
- Cash Reimbursed
- Inventory Reimbursed
- FBA QTY Returned
- RMA QTY Returned
- QTY Balance
Filters
There are numerous filters to include the data you want in your report. Most filters offer single-choice and multiple-choice fields.
In Sellercloud, to access this report:
FILTER | DESCRIPTION |
Date Range |
|
Start Date and End Date | If you chose a custom date range, choose the starting and ending dates. If you chose a default date range, these will auto-populate. |
Date Type | Have refund, return, and reimbursement activity reflected in one of 3 ways:
|
Order # | Include orders by order number. This field has 3 options:
|
SKU | Include specific product SKUs, or include all SKUs in your date range:
|
You can also see only Refunds Without Return or Reimbursement by selecting the checkbox.
You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon.
The table below defines each of these columns:
COLUMN | DESCRIPTION |
Company | Shows the company name. |
Order # | Shows the number of the order which was refunded. |
Channel Order | The unique order number from the channel. |
Refunds | The amount of refund the customer received per each order. |
QTY Original | Shows the original quantity of the product. |
Cash Reimbursed | Cash value reimbursed for inventory.
*Source: Amazon’s Reimbursements report. |
Inventory Reimbursed | Quantity reimbursed with inventory.
*Source: Amazon’s Reimbursements report. |
FBA QTY Returned | Item quantity returned to FBA inventory (regardless of disposition).
*Source: Amazon’s FBA Customer Returns report. |
RMA QTY Returned | Item quantity returned directly to the seller through the RMA workflow, not to the FBA warehouse. |
QTY Balance | Calculation: Qty Original – (Inventory Reimbursed + FBA Qty Returned + RMA Qty Returned). |
Spreadsheet Data
Exported spreadsheets include more data than the grid report. You can click the Filter tab to see the initial filter settings.
Below is part of a sample spreadsheet trimmed for display purposes:
Interpret the Report
Here’s how to use this report to reconcile your FBA refunds. The table below outlines all four possible scenarios. Compare your report’s results against these scenarios to determine if any follow-up action is needed with Amazon.
REPORT RESULTS | ACTION NEEDED |
Scenario 1
|
No action is needed. The Qty Balance is 0. |
Scenario 2
|
No action is needed. The Qty Balance is 0. |
Scenario 3 (within the timeframe)
|
No action is needed yet. The Qty Balance is 2, but is still within the expected timeframe for processing. |
Scenario 4 (past the set timeframe)
|
Action is needed. The Qty Balance is 2 and is now past the expected timeframe for processing. Contact Amazon to investigate why no return or reimbursement has occurred. |
- If the disposition is sellable – The item is returned to stock in the FBA warehouse and available for purchase
- If the disposition is unsellable (for various reasons) – Amazon may issue you, as the seller, a reimbursement for the value of the item, either as:
- the cash value of the item, or
- the actual item
Important: Amazon will only issue reimbursements if they take responsibility for a product’s unsellable disposition. Conversely, if the seller is deemed responsible, no reimbursement will occur. Instead, Amazon will return the item to the FBA warehouse as unsellable, and the seller must issue an order for removal; otherwise, Amazon will dispose of the product within a pre-determined time.
You can use this report to reconcile each of these FBA refunds with an associated FBA return or reimbursement, and determine which refunds need follow-up investigation with Amazon. See how to interpret this report.
To access this report in Sellercloud, click Reports, then either:
- Returns & Refunds Reports > Returns & Reimbursements Summary (FBA); OR
- Transaction Reports > Returns & Reimbursements Summary (FBA)
Take a look at a sample grid report:

For the report showing each individual order’s refund details by item, see the Returns & Reimbursements Details report. You can open that version right from this summary by clicking the order #, and then drill down even further into that order and its items and refund transactions.
Choose your filters
There are numerous filters to include the data you want in your report. (Most filters offer single-choice and multiple-choice fields. See a generic example of both.)

After clicking Run Report to show these transactions, you can see each specific filter you applied. If a filter is not shown, you left it blank or chose All. Here’s a common report filter.
The table below defines each of the filters.
FILTER | DESCRIPTION |
Date Range |
|
Start Date and End Date | If you chose a custom date range, choose the starting and ending dates. (If you chose a default date range, these auto-populate.) |
Date Type | Have refund, return, and reimbursement activity reflected in one of 3 ways:
|
Order # | Include specific orders, or include all orders in your date range. This field has 3 options:
|
SKU | Include specific product SKUs, or include all SKUs in your date range:
|
Only Show Refunds Without Return or Reimbursement | Include only those refunds that currently have no associated return or reimbursement transactions. |
About the grid data
Take a look at a sample grid report:

You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon. For more details, see About the spreadsheet data.
The table below defines each of these columns:
COLUMN | DESCRIPTION |
Company | Company name. |
Order # | The unique order identification number in Sellercloud.
Click the order # to see the Returns & Reimbursements Details with that order’s refund details. |
Channel Order # | The unique order number from the channel. |
Refunds* | Refunded amount.
*Source: Amazon’s Settlement report. |
Qty Original | Original quantity of product on the order. |
Cash Reimbursed* | Cash value reimbursed for inventory.
*Source: Amazon’s Reimbursements report. |
Inventory Reimbursed* | Quantity reimbursed with inventory.
*Source: Amazon’s Reimbursements report. |
FBA Qty Returned* | Item quantity returned to FBA inventory (regardless of disposition).
*Source: Amazon’s FBA Customer Returns report. |
RMA Qty Returned | Item quantity returned directly to the seller through the RMA workflow, not to the FBA warehouse. |
Qty Balance | Calculation: Qty Original – (Inventory Reimbursed + FBA Qty Returned + RMA Qty Returned). |
About the spreadsheet data
Exported spreadsheets may include more data than the grid report. Spreadsheets also let you manipulate data, such as filter within a column, sort with advanced parameters, etc. You can even create custom bar graphs and pie charts; for example, to show daily sales trends for a selected date range.
Take a look at a sample spreadsheet report:

The table below defines each of its columns:
COLUMN | DESCRIPTION |
Company | Company name. |
Order # | The unique order identification number in Sellercloud. |
Channel Order # | The unique order number from the channel. |
Refunds* | Refunded amount.
*Source: Amazon’s Settlement report. |
Qty Original | Original quantity of product on the order. |
Cash Reimbursed* | Cash value reimbursed for inventory.
*Source: Amazon’s Reimbursements report. |
Inventory Reimbursed* | Quantity reimbursed with inventory.
*Source: Amazon’s Reimbursements report. |
FBA Qty Returned* | Item quantity returned to FBA inventory (regardless of disposition).
*Source: Amazon’s FBA Customer Returns report. |
RMA Qty Returned | Item quantity returned directly to the seller through the RMA workflow, not to the FBA warehouse. |
Qty Balance | Calculation: Qty Original – (Inventory Reimbursed + FBA Qty Returned + RMA Qty Returned). |
Interpret the report
Here’s how to use this report to reconcile your FBA refunds. The table below outlines all four possible scenarios. Compare your report’s results against these scenarios to determine if any follow-up action is needed with Amazon.
REPORT RESULTS | ACTION NEEDED |
Scenario 1
|
No action is needed. The Qty Balance is 0. |
Scenario 2
|
No action is needed. The Qty Balance is 0. |
Scenario 3 (within the timeframe)
|
No action is needed yet. The Qty Balance is 2, but is still within the expected timeframe for processing. |
Scenario 4 (past the set timeframe)
|
Action is needed. The Qty Balance is 2 and is now past the expected timeframe for processing. Contact Amazon to investigate why no return or reimbursement has occurred. |