Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REIMBURSEDETAILS() – Display reimbursement report and individual details

GORILLA_REIMBURSEDETAILS() – Display reimbursement report and individual details

Sample Usage

=GORILLA_REIMBURSEDETAILS(“LAST 7 DAYS”)
=GORILLA_REIMBURSEDETAILS(“THIS YEAR”, A2:A10)
=GORILLA_REIMBURSEDETAILS(“CUSTOM”, , “WAREHOUSE_DAMAGED”, “2022-01-01”, “2022-01-15”)
=GORILLA_REIMBURSEDETAILS(“2022”, B7:B27, “LOST_INBOUND”)

Syntax description

GORILLA_REIMBURSEDETAILS() – Display reimbursement report and individual details 1

Description:

Dump the reimbursement report showing all details of the reimbursement.

Syntax:

GORILLA_REFUNDSTOTAL(period, [filter], [reason], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REFUNDSTOTAL(sellerID, period, [filter], [reason], [start_date], [end_date])

period – REQUIRED

Predefined period to get the refunds value. See full list of predefined periods below.

Custom

This Month

Last 12 Months

Today This Quarter Last 7 Days Week Ago
Yesterday This Year Last 7 Days Year Ago
Same day last week This Year-to-Last-Month Last 30 Days Month Ago
Same day last month Last Week Last 30 Days Year Ago
Same day last year Last Month Last Week Year Ago
Last 7 Days Last Quarter Last Month Year Ago
Last 14 Days Last Year YYYY-MM (change format to text)
Last 30 Days Last 60 Days YYYYQ1… YYYYQ4
This Week YYYY

filter – OPTIONAL

OPTIONAL – SKU, ASIN or FNSKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123.

reason – OPTIONAL
OPTIONAL – Reason for adjustment. Valid values:

  • ALL (default)
  • CustomerReturn
  • Damaged_Warehouse
  • CustomerServiceIssue
  • Lost_Warehouse
  • Lost_Inbound
  • Reimbursement_Reversal
  • FeeCorrection
  • Lost_Outbound
  • ReturnAdjustment
  • Damaged_Inbound
  • Damaged_Outbound

start_date – OPTIONAL

OPTIONAL – Starting date for when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date – OPTIONAL

OPTIONAL – Ending date for when period is custom. To use custom dates, specify the period as “CUSTOM”.

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REIMBURSEDETAILS(“LAST 7 DAYS”)

Returns a details list of all reimbursed transactions and SKU over the last 7 days. No SKUs are specified which will show all transactions across the entire account.

=GORILLA_REIMBURSEDETAILS(“THIS YEAR”, A2:A10)

Supports 2-dimensional ranges. Bulk return the reimbursement details of the SKUs listed in A2:A10. Other SKUs will not be loaded.

=GORILLA_REIMBURSEDETAILS(“CUSTOM”, , “WAREHOUSE_DAMAGED”, “2022-01-01”, “2022-01-15”)

Returns all warehouse damaged-related reimbursements for all the SKUs in the account. Data is loaded for the custom date period.

=GORILLA_REIMBURSEDETAILS(“2022”, B7:B27, “LOST_INBOUND”)

Returns data for Lost Inbound SKUs listed in B7:B27 for 2022.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_REIMBURSEDETAILS(“SELLERID38”, “LAST 7 DAYS”)
=GORILLA_REIMBURSEDETAILS(“SELLERID38”, “THIS YEAR”, A2:A10)
=GORILLA_REIMBURSEDETAILS(“SELLERID38”, “CUSTOM”, , “WAREHOUSE_DAMAGED”, “2022-01-01”, “2022-01-15”)
=GORILLA_REIMBURSEDETAILS(“SELLERID38”, “2022”, B7:B27, “LOST_INBOUND”)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?