Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_RECONCILEREFUNDS() – Shows units purchased vs refunded

GORILLA_RECONCILEREFUNDS() – Shows units purchased vs refunded

Separate reimbursement data upgrade is required to access this function

Add from your account or see the reimbursement plan info

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_RECONCILEREFUNDS("LAST 7 DAYS")
=GORILLA_RECONCILEREFUNDS("THIS YEAR", A2:A10)
=GORILLA_RECONCILEREFUNDS("THIS YEAR", A2:A10, "UK", "NO")
=GORILLA_RECONCILEREFUNDS("CUSTOM", , , , "2022-09-03", "2022-12-23")

Syntax description

reconcile refunds
Reconcile refunds with this formula

Description:

Returns a table of all orders and compares the quantity of units purchased, shipped and refunded side by side to find discrepancies between purchased vs refunded.

For detailed refunds data, use REFUNDSORDER() to get the full details of the order.

Syntax:

GORILLA_RECONCILEREFUNDS(period, [filter], [marketplace], [reconciled], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_RECONCILEREFUNDS(seller ID, period, [filter], [marketplace], [reconciled], [start_date], [end_date])

period – REQUIRED
Enter a predefined period to look up the data or a custom start and end date. 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
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

marketplace – OPTIONAL
Enter the marketplace code to look up the data. Leave it empty to default to your main marketplace.

AllDEPLSG
USFRTRIN
CAESSAEG
MXITAEEU (only for specific functions)
BRNLJPEURO (only for specific functions)
UKSEAU

reconciled – OPTIONAL
Select to choose whether to show all refunded orders or unreconciled refunds.
Valid values:

  • ANY – Default value and will show all orders with a refund
  • NO – Displays only refunded orders where the number of units purchased vs refunded do not match. In other words, show there refunds are potentially “not reconciled”.

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

end_date – 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_RECONCILEREFUNDS("LAST 7 DAYS")

Returns a details list of all refunded orders over the last 7 days showing the number of unit purchased and refunded for the order. No SKUs are specified which will show all transactions across the entire account.

=GORILLA_RECONCILEREFUNDS("THIS YEAR", A2:A10)

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

=GORILLA_RECONCILEREFUNDS("THIS YEAR", A2:A10, "UK", "NO")

Will display the results of all orders with refunds in the UK where the quantities of the units purchased and refunded do not match.

=GORILLA_RECONCILEREFUNDS("CUSTOM", , , , "2022-09-03", "2022-12-23")

To list all the data between the start and end date.

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

=GORILLA_RECONCILEREFUNDS("bookstore USA", "LAST 7 DAYS")
=GORILLA_RECONCILEREFUNDS("Mega Big Bucks", A2:A10)
=GORILLA_RECONCILEREFUNDS("Cossies", "THIS YEAR", A2:A10, "UK", "NO")
=GORILLA_RECONCILEREFUNDS("Shoes_NYC", "CUSTOM", , , , "2022-09-03", "2022-12-23")

How can we help?