Page MenuHomePhabricator

dLocal audit file question + missing reversed transaction
Closed, ResolvedPublic

Description

dLocal's console has been unreliable for refunds in recent months, which may be related to a refund that hasn't reached Civi.

cid=67388170 made donation T-648-d744553c-0962-4fae-be1a-0981e9f7d80f / 229188669.1 on March 11th. We refunded it and instead of going to Refunded Status, it went to Canceled. That reversal has not reached Civi, so this Task is a request to check whether / why the weekly audit may not have picked this up. The refund ID is REF-648-d8e90141-09f1-4b31-8dc0-373100a444ca.

There are 40 Canceled transactions since January 1st at the dLocal console. I spot-checked some, and the outcomes vary:

CIDReversed in Civi?little IDbig ID
67349459Y as Chargeback228771212.1REF-648-e6289da8-00e2-42c2-9796-3384b3f143ed
67347596Y as Chargeback228500337.1REF-648-7f2a7973-7580-45dd-8a7e-058b55e070b1
67347154N228488539.1REF-648-3d121c32-94cc-4049-9275-462d0526693d
67347035N228485838.1REF-648-8a311948-ea04-4c7e-a6f0-4ccf6b55b5d5
67374260Y as Refund228970146.1REF-648-caa99037-2dcf-4718-97e2-15c933ec98f5

Event Timeline

From a batch of 10 refunds on 3/31, two yielded Server Error messages and then moved to status canceled, but the reversals are not in Civi:

  1. cid=67499342 reference T-648-45b112ad-e05e-4e28-b7b8-7ba16534cbfc invoice 229591572.1
  2. cid=67487553 reference T-648-422e39fb-bb6d-489d-ac30-b5bc61fbc94d invoice 229546648.1

I'll monitor next week to see if the weekly audit catches them.

XenoRyet triaged this task as High priority.Apr 7 2025, 7:34 PM

The canceled transactions from the prior comment are not in Civi as of today.

@MBeat33 Following up on an old task here, checking the two transactions mentioned we never got updated statuses in the audit so they are still not refunded in civi.

Looking at civi I see not that many refunds from dlocal, and most related to fraud.

Is this low amount normal or is there still an issue with dlocal refunds getting into civi?

I do see 2 recent ones from gravy.

Thanks, @Cstone we haven't done a dLocal refund at dLocal since 8/5/2025. The refunds done at dLocal before then have reached Civi.

From Gravy, the two fraud refunds from September 9th 235466165.2 and 235466059.2 have reached Civi.

It doesn't look like there's still an issue - should I just manually update the status of two from the initial description in Civi?

@MBeat33 catching back up on this, yeah if we have fully moved off of them since August, manually marking them would be the easiest

Thanks @Cstone I updated the statuses for cid=67388170 and cid=67347154. cid=67347035 became a chargeback on its own in the meantime.