Hi @ERoden-WMF, please associate one or more active project tags with this task (via the Add Action... → Change Project Tags dropdown), so the task can be found when looking at project workboards or searching for tasks in certain projects, and folks can get notified about a task when watching a related project tag. Thanks!

Hi @AKanji-WMF @XenoRyet just flagging this phab as we'd like to try to get this sorted prior to our next revenue reforecast in January. We can make an assumption on the total amount we should be adjusting revenue, but having report accurate would be ideal. As far as I can see we also reached out to some of these donors (as some were tagged as major gift prospects). Let me know if I can provide more data to assist. Thanks.

This looks like another symptom of T405765: Contributions imported from gravy audit are in CiviCRM in non-USD currencies - @Eileenmcnaughton do you want to merge this patch for now? https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1193439 Then we can revert it after converting all the affected donations.

Shoot, I was hoping it would fix these when we converted all the donations that were mistakenly recorded in their original currency, but it seems not to have done so. These donations were already correctly recorded in the database converted into e.g. 35 USD (from 5200 JPY) when we got an incorrect message from the audit processor that added an extra financial transaction to 'top it up' to 5200 USD. I'll see how many of those we had and try to find the best way to reverse them.

(comment moved from T405765)
I count 4,496 distinct donations recorded wrong, with the bulk of the inaccuracy from about $600k worth of JPY donations T412025: Japan Recurring Gifts September

select count(*), sum(total_amount), original_currency
from civicrm_contribution c
inner join wmf_contribution_extra x on x.entity_id=c.id
where x.original_currency not in ('USD', 'PAB', 'BMD') --two currencies pegged to dollar
and c.total_amount=x.original_amount
and c.receive_date between '2025-07-01' and '2025-12-01'
group by original_currency;

Change #1224966 had a related patch set uploaded (by Ejegg; author: Ejegg):

[wikimedia/fundraising/crm@master] Fix amount for mistakenly recorded donations

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

Change #1224966 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix amount for mistakenly recorded donations

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

The fix for this is currently running on production. Should be done within the hour.

Thanks @Ejegg. I'll give it some time to update and check the numbers in Metabase.