Square Refund API to Middleware Celigo for import to NetSuite not returning negative refund amount

Questions
1

I am creating a data flow in Celigo to GET/v2/refunds?begin_time={{lastExportDateTime}}, per the Refund API documentation, we should see the refund amount (as a negative number), in the response.

{
“refunds”: [
{
“id”: “bP9mAsEMYPUGjjGNaNO5ZDVyLhSZY_69MmgHubkLqx9wGhnmenRUHOaKitE6llfZuxcWYjGxd”,
“status”: “COMPLETED”,
“amount_money”: {
“amount”: 555,
“currency”: “USD”
},
“payment_id”: “bP9mAsEMYPUGjjGNaNO5ZDVyLhSZY”,
“order_id”: “9ltv0bx5PuvGXUYHYHxYSKEqC3IZY”,
“created_at”: “2021-10-13T19:59:05.342Z”,
“updated_at”: “2021-10-13T20:00:03.497Z”,
“processing_fee”: [
{
“effective_at”: “2021-10-13T21:34:35.000Z”,
“type”: “INITIAL”,
“amount_money”: {
“amount”: -34,
“currency”: “USD”
}
}
],
“location_id”: “L88917AVBK2S5”,
“reason”: “Example Refund”
}
],
“cursor”: “5evquW1YswHoT4EoyUhzMmTsCnsSXBU9U0WJ4FU4623nrMQcocH0RGU6Up1YkwfiMcF59ood58EBTEGgzMTGHQJpocic7ExOL0NtrTXCeWcv0UJIJNk8eXb”
}

In Square it is clearly showing the (.50) refund.

In Celigo, the record is pulling correctly, but the refund amount is $0.

{
“page_of_records”: [
{
“record”: {
“refunds”: [
{
“id”: “L9omksavypVSpnxM3mks0htatuKZY_An62g3eXXscWf5xSaX40WNXxy7hbRq12mqJxZwrQzvU”,
“status”: “COMPLETED”,
“amount_money”: {
“amount”: 50,
“currency”: “USD”
},
“payment_id”: “L9omksavypVSpnxM3mks0htatuKZY”,
“order_id”: “4YCFmQZdPHqewknd2ipjdw1eV”,
“created_at”: “2024-03-27T15:26:55.185Z”,
“updated_at”: “2024-03-27T16:01:49.758Z”,
“processing_fee”: [
{
“effective_at”: “2024-03-27T16:57:31.000Z”,
“type”: “INITIAL”,
“amount_money”: {
“amount”: 0,
“currency”: “USD”
}
}
],
“location_id”: “L3TMDRT9RPP3H”,
“reason”: “Testing an issue”,
“destination_type”: “CARD”
}
]
}
}
]
}

Any insight would be greatly appreciated

Paula Courtemanche
[email protected]
781-439-9500

2

The amount of a refund is expected to be a positive number as it represents the positive money that went back to the payment source. :slightly_smiling_face:

3

Thank you.

In the API it is showing the processing fee as a negative number, (-34), so I assume the refund of positive 50 minus the processing fee of negative 34. Is that correct.

4

Thank you for your response.

I was able to pull a refund through the Refunds API this AM for $16.30. The original Payment was for $16.30 and the processing fee was $0.52, therefore $15.78 was transferred to our bank account.

The customer was refunded the total amount of $16.30, with is correct.

When pulling the Refunds API, I would expect to see an amount of $15.78 and a processing fee refund of $.52, however the processing fee amount is $0.00 and the amount refunded is $16.30.

Why is the processing fee split out in the API if the total amount is refunded. The amount transferred to our bank is $15.78, and the refund is $16.30. How are other customers reconciling the difference between the refund and the payment through the API.

Thank you for your insight in advance.

Paula Courtemanche
[email protected]
781-439-9500

5

Payment Screenshot:

COMPOST SALES

$2.00/T × 8.150 T

Regular

$16.30

TOTAL

$16.30

Visa 8467 (SALVADOR MONTOYA)

$16.30

Apr 30, 2024 9:16 am

Receipt #hc4l

$15.78 Transferred

Fees: Dipped 2.60% + $0.10 ($0.52)

6

Refund Screenshot:

COMPOST SALES

$2.00/T × 8.150 T

Regular

($16.30)

TOTAL

($16.30)

Visa 8467 (SALVADOR MONTOYA)

($16.30)

May 7, 2024 9:09 am

Receipt #hc4l

$16.30 Deducted

7

Refund API Results:

{
“record”: {
“refunds”: [
{
“id”: “hc4lkxftX9DcBP9Dlo9nhFXksNHZY_2jSgVndjshB8SemsFn0seVqHT4xUteANulFKNZEporZ”,
“status”: “COMPLETED”,
“amount_money”: {
“amount”: 1630,
“currency”: “USD”
},
“payment_id”: “hc4lkxftX9DcBP9Dlo9nhFXksNHZY”,
“order_id”: “dfTAi6pWiSL22GAHJdOHkbheV”,
“created_at”: “2024-05-07T13:09:09.552Z”,
“updated_at”: “2024-05-07T13:30:06.521Z”,
“processing_fee”: [
{
“effective_at”: “2024-05-07T13:10:31.000Z”,
“type”: “INITIAL”,
“amount_money”: {
“amount”: 0,
“currency”: “USD”
}
}
],
“location_id”: “LVM4HF5FF5KKP”,
“reason”: “Accidental charge”,
“destination_type”: “CARD”

8

Thank you for all the answers. I have been advised that we will not see the fee’s being refunded, which is where my confusion was. We are reconciling the fee’s paid versus the refund returned internally in our accounting department.

Thank you again for all the assistance.

Paula Courtemanche
[email protected]
781-439-9500