Page MenuHomePhabricator

Japan Recurring Gifts September
Closed, ResolvedPublic

Description

It appears that recurring gifts from Japan for September 2025 were loaded with USD as the currency into Civi. For example, donors who gave 5200 yen are showing with a gift of $5200 USD. I think this likely impacts all gifts as we're seeing around $600k more in revenue than we'd expect.

Here are a few examples:

63936989
16027557
16027557
59438779
63901175
63944580
59445535
45859063
46416618

Event Timeline

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.

XenoRyet subscribed.

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.

XenoRyet set Final Story Points to 4.