Hi @EMartin, how are you getting the numbers for the google spreadsheet? If I do this search in Civi:

Date Received - greater than or equal to "August 1st, 2019 12:00 AM" AND less than or equal to "August 31st, 2019 11:59 PM" ...AND...
Contribution Status In Completed ...AND...
Gateway = astropay

I end up with 6,440 results. It's still less than the 6,654 you have for Astro Console / August, but far more than the 2,258 you have for Civi / August.

Once we fixed our firewall (looks like Sep 23), we were able to successfully download all of the report files for the period when the download was failing (looks like Sep 7 - 23), and we processed them the same day.

Hi Elliott,

I just reran the recon report out of civi, which I use for all recons and
came up with the same result (give or take a few $) for August. The report
name is:
Gateway Reconciliation MINIMAL

As you can see, Astropay doesn't align to your numbers, however, Amazon and
Adyen match to the respective provider portals. Astropay/Dlocal seems to
be the only one grossly off to the report.

Row Labels Sum of Total Amount (USD) Sum of Number of Contributions
adyen 3741.19 316
amazon 202917.38 14921
*astropay* *16855.8* *2263*
benevity 43858.45 2985
bitpay 2196.35 8
citibank 5286.79 62
engage 46215.28 564
globalcollect 265902.63 42421
ingenico 1228835.12 91795
paypal 197046.11 31356
paypal_ec 1317299.86 135446
(blank) 1152878 632
Grand Total 4483032.96 322769

OK, digging in I see there's a filter in that report on the 'to_financial_account_id' of the civicrm_financial_trxn table, and that for AstroPay / DLocal, many of those rows have a NULL value in 'to_financial_account_id'. I'll try to see if those correspond with the way the contribution was recorded.

Aha, found it. The ones with NULL are all using newer payment methods. Something's broken in the way we add new ones, and we're not getting the rows we need in civicrm_entity_financial_account which say which accounts should map to which payment methods.

Excellent. Do you need anything from Dlocal to troubleshoot resolution here?

Nope @EMartin, this is purely CiviCRM internals. I'll fix the existing records first, then see what we need to do to make sure that any new payment methods we add in the future end up with the right configuration.

Change 548809 had a related patch set uploaded (by Ejegg; owner: Ejegg):
[wikimedia/fundraising/crm@master] Fix account relationships for new methods

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

Change 548823 had a related patch set uploaded (by Ejegg; owner: Ejegg):
[wikimedia/fundraising/crm@master] Fix payment method update fn to add account relationship

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

Change 548809 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Fix account relationships for new methods

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

OK, the missing account references have been added for all the contributions made with new payment methods, and the code has been fixed so the next one we add gets the right setup.

@EMartin can you verify that the report gives you some plausible numbers now?

@Ejegg Thanks Elliott, the numbers are definitely within the realm now. Things definitely moved from 60% off to 4% off. With the changes Dlocal is proposing in a separate task, all should come into alignment now. Thanks. We can close this one!

@EMartin out of curiosity, are Civi's numbers higher than those from their console, or lower? I'd like to know if Civi is missing contributions or fees.

Civi is lower in count but higher in amount, as follows:

Astro Console CIVI Finance
Trnx # Trxns amount Trnx # Trxns amount
1,056 $677.91 713 $1,282.96 $678.00
6,654 $36,712.69 6540 $38,077.08 $36,713.00
4,506 $29,766.81 4,462 $30,898.59 $29,767.00

Change 548823 merged by Eileen:
[wikimedia/fundraising/crm@master] Fix payment method update fn to add account relationship

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

@Ejegg . This seems to be resolved. Civi seems to be matching the DLocal portal now. I was able to reconcile November and December. Thank you!