Hey thanks for this,
I modified my program to match stripe charge id with itch "source_id" and it works. everything matches up!
Later i have to do the same for Paypal. I was hoping to match on email (slightly bogus), but i don't know if you already have a paypal sales id, but if you don't, that would be _very_ useful too.
You are correct that the "primary source" is either the Stripe or Paypal figures when "direct to you", BUT those figures do know if, for any given transaction, there is a tip or not. Basically, they only have the combine charge.
So i have to link back to the itch payout sheet to break each transaction down to; sales, tips, fees and tax.
According to my accountant, tips are earnings but not sales and have no sales tax, which is correct because it agrees with the tax actually charged. over here in Europe, we have a ridiculous thing called MOSS, whereby i have to report sales & sales tax for EACH of the 28 EU regions (so much for it all being one unified region!!), and thus i need to actually report separate; sales + sales tax for those regions.
Annoying i know. but that's why i have to connect itch sales with those from the payment processors.