Get Paypal audit processing Intactable
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Eileenmcnaughton
	Nov 5 2025, 9:46 PM

Project Tags

Referenced Files

None

Subscribers

AKanji-WMF

Aklapper

Eileenmcnaughton

Description

Following on from Adyen start paypal (includes moving from python)

https://docs.google.com/spreadsheets/d/1X4hJuZ9N09PRTdVCKAW1G1yXxc4Hp_TPcp7g-QmjayE/edit?gid=0#gid=0

Details

Related Changes in Gerrit:

Subject	Repo	Branch	Lines +/-
Load gravy paypal from pending/transactionLog even when paypal id differs	wikimedia/fundraising/crm	master	+6 -0
Load gravy paypal from pending/transactionLog even when paypal id differs	wikimedia/fundraising/crm	deployment	+6 -0
Load gravy paypal from pending/transactionLog even when paypal id differs	wikimedia/fundraising/crm	master	+6 -0
Ignore dlocal Cleared.csv files	wikimedia/fundraising/crm	master	+4 -0
Move gravy settlement reports to ignored	wikimedia/fundraising/crm	master	+4 -0
Move ignored reconciliation files to an ignored directory	wikimedia/fundraising/crm	master	+57 -29
Condense fee rows into associated chargebacks (etc)	wikimedia/fundraising/SmashPig	master	+65 -9
Stop passing up note from Paypal Audit	wikimedia/fundraising/SmashPig	master	+0 -9
Opps test file in wrong directory	wikimedia/fundraising/crm	master	+1 -1
Use DB as source of truth for Paypal gateway	wikimedia/fundraising/crm	master	+58 -4
Add handling for payouts	wikimedia/fundraising/SmashPig	master	+17 -6
First pass on Paypal audit process	wikimedia/fundraising/crm	master	+227 -1
Add handling for header and footer rows	wikimedia/fundraising/SmashPig	master	+82 -2
Add initial settlement data	wikimedia/fundraising/SmashPig	master	+44 -4

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Eileenmcnaughton	T409362 Get Paypal audit processing Intactable
		Resolved		Eileenmcnaughton	T415606 Handle paypal recurrings coming in through audit with no transactionLog data

Event Timeline

Eileenmcnaughton created this task.Nov 5 2025, 9:46 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 5 2025, 9:46 PM

Flagging anyone can work on this

AKanji-WMF added a project: Fundraising-Tech-Roadmap.Nov 27 2025, 6:44 PM

AKanji-WMF added a project: 25 Dec Q3 Planning.Dec 4 2025, 6:47 PM

AKanji-WMF moved this task from Backlog to February - D on the 25 Dec Q3 Planning board.Dec 4 2025, 7:33 PM

AKanji-WMF moved this task from February - D to February - C on the 25 Dec Q3 Planning board.

OK we got paypal added to the gravy settlement file (or perhaps we got paypal instead of adyen in the file since there is no adyen in that file)

Here is how it compares to what we need (the adyen audit files have all these things, the gravy audit files have them for adyen, as they are the same files as the adyen ones)

requirement	actual
Payout information - Total paid out to each currency we settle in	a USD amount only, nothing about the other currencies - unsure how this relates to what is banked - perhaps this is after they were transferred
Batch number -number of the batch - the totals in the contributions are matched to the bank payout	not present
exchange rate information	Only present for BRL - which settled to USD
Paypal identifiers	present, different format to adyen, may not be required - TBD
all transaction types - including refunds, chargebacks etc	only donations
actual settlement date for each transaction	unsure as not sure how they settle (we calculate this for adyen as the date in the file is not the date it settles to us
any fees that are included in the settlement batch in the settlement batch currency	? probably? not sure about the currency

So I guess I need to understand what the settled USD amount is equivalent to - my understanding is that we are settled in multiple currencies and then we transfer to our USD account from them - does the

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

[wikimedia/fundraising/SmashPig@master] Add handling for header and footer rows

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

gerritbot added a project: Patch-For-Review.Jan 7 2026, 7:30 PM

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

[wikimedia/fundraising/crm@master] First pass on Paypal audit process

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

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

[wikimedia/fundraising/SmashPig@master] Add initial settlement data

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

Change #1224233 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add initial settlement data

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

Change #1224165 abandoned by Eileen:

[wikimedia/fundraising/SmashPig@master] Add handling for header and footer rows

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

AKanji-WMF moved this task from Next to Current Sprint on the Fundraising-Backlog board.Jan 13 2026, 8:36 PM

AKanji-WMF removed a project: Fundraising-Tech-Roadmap.

AKanji-WMF edited projects, added: Fundraising Sprint: ARMchair, fr-current-sprint; removed: 25 Dec Q3 Planning.Jan 13 2026, 9:35 PM

Change #1224180 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] First pass on Paypal audit process

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

Maintenance_bot removed a project: Patch-For-Review.Jan 14 2026, 9:34 PM

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

[wikimedia/fundraising/SmashPig@master] Add handling for payouts

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

gerritbot added a project: Patch-For-Review.Jan 14 2026, 11:02 PM

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

[wikimedia/fundraising/crm@master] Use DB as source of truth for Paypal gateway

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

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

[wikimedia/fundraising/crm@master] Opps test file in wrong directory

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

Change #1226958 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add handling for payouts

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

Change #1226982 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Use DB as source of truth for Paypal gateway

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

Change #1226998 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Opps test file in wrong directory

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

Maintenance_bot removed a project: Patch-For-Review.Jan 15 2026, 5:30 PM

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

[wikimedia/fundraising/SmashPig@master] Stop passing up note from Paypal Audit

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

gerritbot added a project: Patch-For-Review.Jan 15 2026, 10:08 PM

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

[wikimedia/fundraising/SmashPig@master] Condense fee rows into associated chargebacks (etc)

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

Change #1227444 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Stop passing up note from Paypal Audit

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

Change #1227463 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Condense fee rows into associated chargebacks (etc)

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

Maintenance_bot removed a project: Patch-For-Review.Jan 16 2026, 4:30 AM

Eileenmcnaughton moved this task from Backlog to Doing on the Fundraising Sprint: ARMchair board.Jan 20 2026, 3:22 AM

Current status is I have moved the code from python over to php & our audit (reconciliation) process is parsing the paypal STL file with *most* batches passing validation. The missing chargebacks seem to have sorted themselves out as I applied our more recent code to the files but hitting a challenge around paypal grants which are currently missing the transaction ID - https://phabricator.wikimedia.org/T414999

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

[wikimedia/fundraising/crm@master] Move ignored reconciliation files to an ignored directory

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

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

[wikimedia/fundraising/crm@master] Move gravy settlement reports to ignored

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

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

[wikimedia/fundraising/crm@master] Ignore dlocal Cleared.csv files

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

Change #1229943 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Move ignored reconciliation files to an ignored directory

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