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

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=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 reimbursements details function 1 Gorilla ROI

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.

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

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:A1000) in your formula wherever possible for 
quicker results and to prevent Google from 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”)

How can we help?