Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_RECONCILEREFUNDS(...

GORILLA_RECONCILEREFUNDS() – Shows units purchased vs refunded

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

Syntax description

ReconcileRefunds 1 Gorilla ROI
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(Seller ID, period, [filter], [marketplace], [reconciled], [start_date], [end_date])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

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
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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "CUSTOM", , , , "2022-09-03", "2022-12-23")

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

=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")

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.