Page MenuHomePhabricator

Get dlocal audit processing into Intacct
Closed, ResolvedPublic

Description

This involves

  1. establishing how it settles
  2. figuring out how to get the settlement total
  3. updating our reconciliation / audit code to process this and to add settlement data
  4. eliminating all the edge cases

With regards 1 & 2 - this has always been challenging with dlocal because they amount they tote up the transactions rounded to 6 decimal places and only round it after adding them all together. Obviously we round every individual transaction and then the 2 don't add up. Currently I'm creating a rounding transaction as a 'fee' but will confirm if Finance would rather give it a gl code

Related Objects

Event Timeline

Change #1226997 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Refactor smashpig dlocal parser in preparation for new report

https://gerrit.wikimedia.org/r/1226997

Change #1227405 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add dlocal parser for settlement file

https://gerrit.wikimedia.org/r/1227405

Change #1227471 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Remove invalid field

https://gerrit.wikimedia.org/r/1227471

Change #1226997 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Refactor smashpig dlocal parser in preparation for new report

https://gerrit.wikimedia.org/r/1226997

Change #1227405 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add dlocal parser for settlement file

https://gerrit.wikimedia.org/r/1227405

Change #1227495 had a related patch set uploaded (by Cstone; author: Cstone):

[wikimedia/fundraising/crm@master] Also parse settlement reports

https://gerrit.wikimedia.org/r/1227495

Change #1227471 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Remove invalid field

https://gerrit.wikimedia.org/r/1227471

Change #1227564 had a related patch set uploaded (by Cstone; author: Cstone):

[wikimedia/fundraising/crm@master] Fix dlocal audit tests

https://gerrit.wikimedia.org/r/1227564

Change #1227495 merged by Eileen:

[wikimedia/fundraising/crm@master] Also parse settlement reports

https://gerrit.wikimedia.org/r/1227495

Change #1227564 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix dlocal audit tests

https://gerrit.wikimedia.org/r/1227564

Change #1228660 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Handle trailing return in csv header

https://gerrit.wikimedia.org/r/1228660

Eileenmcnaughton renamed this task from Placeholder - Get dlocal audit intactable to Get dlocal audit processing into Intacct.Jan 20 2026, 3:20 AM
Eileenmcnaughton updated the task description. (Show Details)

Change #1228683 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add chargeback handling for settlement files

https://gerrit.wikimedia.org/r/1228683

Change #1228660 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Handle trailing return in csv header

https://gerrit.wikimedia.org/r/1228660

Change #1228683 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add chargeback handling for settlement files

https://gerrit.wikimedia.org/r/1228683

Change #1235887 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add refund handling for dlocal audit

https://gerrit.wikimedia.org/r/1235887

Change #1235887 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add refund handling for dlocal audit

https://gerrit.wikimedia.org/r/1235887

Change #1236111 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Address currency conversion rows, take 2

https://gerrit.wikimedia.org/r/1236111

Change #1236111 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Address currency conversion rows, take 2

https://gerrit.wikimedia.org/r/1236111

Change #1247733 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix confusing merge_data function

https://gerrit.wikimedia.org/r/1247733

Change #1247737 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix dlocal grabbing the wrong donation in the series

https://gerrit.wikimedia.org/r/1247737

Change #1247738 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Try order ID first, not last

https://gerrit.wikimedia.org/r/1247738

Change #1247733 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix confusing merge_data function

https://gerrit.wikimedia.org/r/1247733

Change #1247737 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix dlocal grabbing the wrong donation in the series

https://gerrit.wikimedia.org/r/1247737

Change #1247738 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Try order ID first, not last

https://gerrit.wikimedia.org/r/1247738

XenoRyet set Final Story Points to 4.