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

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.

Today	This month	Last 3 Months
Yesterday	This quarter	Last 12 Months
Same day last week	This year	Last 7 Days Week Ago
Same day last month	This Year-to-Last-Month	Last 7 Days Year Ago
Same day last year	Last Week	Last 30 Days Month Ago
Last 7 Days	Last Month	Last 30 Days Year Ago
Last 14 Days	Last Quarter	Last Week Year Ago
Last 30 Days	Last Year	Last Month Year Ago
Last 90 Days	Last 60 Days	YYYY-MM (change format to text)
This week	YYYY	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.

All	DE	PL	SG
US	FR	TR	IN
CA	ES	SA	EG
MX	IT	AE	EU (only for specific functions)
BR	NL	JP	EURO (only for specific functions)
UK	SE	AU

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