Returns & Reimbursement Summary (FBA)

This report facilitates the process of reconciling FBA refunds with returns and reimbursements.

Whenever one of your customers returns a product to FBA for a refund they obtained, Amazon will assess the product’s disposition as sellable or unsellable, and proceed as follows:

  • 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.

This report also includes quantities returned as an RMA directly to the seller, not to the Amazon FBA warehouse.

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.

For answers to general questions about using Sellercloud’s Financial Reporting Suite, see the Reports FAQs.

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
  • Custom (default) – Enter the Start and End Dates. For a single date, choose the same Start and End Date.
  • Date ranges (presets) – There are 22 choices from Yesterday to the Last Year to Date.
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:

  • By order date – View all activity where the order date is in your selected date range.
  • By refund date – View all activity where the refund date is in your selected date range.
  • By transaction date – View all activity where the return date and/or the reimbursement date is in your selected date range.
Order # Include specific orders, or include all orders in your date range. This field has 3 options:

  • For a specific order number – Enter the number and click Run Report.
  • For multiple order numbers – Click the Order # List, then enter or copy/paste multiple order numbers on separate lines, then click Select Orders to populate the Order # box, and then click Run Report.
  • For all order numbers in your date range – Leave this field blank and click Run Report.
SKU Include specific product SKUs, or include all SKUs in your date range:

  • For one SKU – Enter a specific SKU and click Run Report.
  • For all SKUs in your date range – Leave this field blank and click Run Report.
  • To enter multiple SKUs – Click SKU List, then enter or copy/paste multiple SKUs on separate lines, then click Select Products to populate the SKU box, and Run Report.
  • To find SKUs – Click the SKU link to open the Search Products window.
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

  • Qty Original = 2
  • Cash Reimbursed = 0
  • Inventory Reimbursed/FBA Qty Returned = 2
  • RMA Qty Returned = 0
  • Qty Balance = 0
 No action is needed. The Qty Balance is 0.
Scenario 2

  • Qty Original = 2
  • Cash Reimbursed = Yes
  • Inventory Reimbursed/FBA Qty Returned/RMA Qty Returned = 0
  • Qty Balance = 0
 No action is needed. The Qty Balance is 0.
Scenario 3 (within the timeframe)

  • Qty Original = 2
  • Cash Reimbursed = 0
  • Inventory Reimbursed/FBA Qty Returned/RMA Qty Returned = 0
  • Qty Balance = 2
 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)

  • Qty Original = 2
  • Cash Reimbursed = 0
  • Inventory Reimbursed/FBA Qty Returned/RMA Qty Returned = 0
  • Qty Balance = 2
 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.

Was this article helpful?

Yes No

Related Articles