Returns & Reimbursement Details (FBA)

Updated 2 weeks ago

Newly enhanced! This report facilitates the process of reconciling FBA refunds with returns and reimbursements, per order item with return reason and disposition.

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.

To access this report in SellerCloud, click Reports, then either:

  • Returns & Refunds Reports > Returns & Reimbursements Summary (FBA); OR
  • Transaction Reports > Returns & Reimbursements Summary (FBA)

Below is part of a sample grid report trimmed for display purposes (see one with all columns):

For the report summarizing refund totals by order, see the Returns & Reimbursements Summary report.

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.

Return Reason

Include orders with specific return reasons, or include all orders in your date range.

Disposition

Include orders with specific return dispositions, or include all orders in your date range.

Order #

Include orders by order number. 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

Below is part of a sample grid report trimmed for display purposes (see one with all columns):

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.

Trans ID

The transaction ID in SellerCloud for the refund.

Order Date

Date the order was placed.

Refund Date

Date the order was refunded.

Transaction Date

Date the return or reimbursement transaction occurred.

Order #

The unique order identification number in SellerCloud.

Channel Order #

The unique order number from the channel.

Order Item #

SellerCloud's internal number for each specific item on the order.

SKU

Unique stock keeping unit (SKU) code assigned to the product.

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

Return Reason*

Reason for the return on the order.

*Source: Amazon's FBA Customer Returns report.

Disposition*

Product condition.

*Source: Amazon's FBA Customer Returns report.

LPN*

Unique license-plate number label on the FBA warehouse's pallet, bin, or case that contains the product. Used for tracking purposes.

*Source: Amazon's FBA Customer Returns report.


About the spreadsheet data

Exported spreadsheets 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 (click image to enlarge):

The table below defines each of its columns:

COLUMN

DESCRIPTION

Company

Company name.

Transaction ID

The transaction ID in SellerCloud for the refund.

Order Date

Date the order was placed.

Refund Date

Date the order was refunded.

Transaction Date

Date the return or reimbursement transaction occurred.

Order #

The unique order identification number in SellerCloud.

Channel Order #

The unique order number from the channel.

Order Item #

SellerCloud's internal number for each specific item on the order.

SKU

Unique stock keeping unit (SKU) code assigned to the product.

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

Return Reason*

Reason for the return on the order.

*Source: Amazon's FBA Customer Returns report.

Disposition*

Product condition.

*Source: Amazon's FBA Customer Returns report.

LPN*

Unique license-plate number label on the FBA warehouse's pallet, bin, or case that contains the product. Used for tracking purposes.

*Source: Amazon's FBA Customer Returns report.


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 (after 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.


How did we do?


Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter