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