#loaderchips_code
drifting juniperBOT
👋 Welcome to your new thread!
⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.
⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.
🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1273153982386147329
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
dim spade
hey @narrow cape
narrow cape
By lifetime total volume, do you mean all transactions, equal to current balances + all payouts?
narrow cape
I see. Can you provide that account Id? acct_xxx
dim spade
acct_1PGP0YQiwxvIn6Fy
we will have to do this for a lot of accounts so consider that a variable
narrow cape
Hmm I see but don't find that number anywhere too. If you (let's say only use PaymentIntent) calculate the sum of all transanction, does it add up?
Using List PaymentIntent API
dim spade
let me check
do i have to provide a stripe_Account param in the header?
for example in this case it will be stripe_account : acct_1PGP0YQiwxvIn6Fy
narrow cape
Yes yes
dim spade
thats not working. i think that makes sense actually since our platform has accepted payments with the destination marked as acct_1PGP0YQiwxvIn6Fy
dim spade
checking
actually taking a step back. let me describe the problem
there is some bug in our accounting code.
so whats happening is that the transfer amount in our db are not accurate.
what we are looking for is a source of truth to base our accounting on. What should that be
All the payments we received which have a stripe intent attached to it?
narrow cape
We are talking about payment in a specific Connected Account, aren't we?
dim spade
right, so we are a platform.
we have several express connected accounts
donors come in to our platform
and they donate to these accounts which we collect on their behalf.
it is sometimes possible business onboard a bit later than when donors start donating. we hold this amount
and then as soon as they onboard we first do a transfer of everything they have received from donors so far
and then they get regular payouts
everything goes through the platform on first touch.
express connected accounts dont directly interact with donors
narrow cape
I would say List all PaymentIntent which has the destination of the Connected Account, grab the amount - application_fee_amount there, plus all the Transfer amount
dim spade
sorry for the long object -- but here is an example of the data in payment intent
narrow cape
Oh you have the Transfer Id there tr_3PmzokHnmYFjoKos1YbhI0mW
You can List all Transfers then
Take the Transfer amount
dim spade
are these transfers manual or automated?
sorry for my ignorance. i m trying to understand if there is a possibility the data is getting tainted anywhere
narrow cape
If you only have that one pattern, then each of them generate 1 Transfer like above. So if you List all Tranfer you would have everything targetted that Connected Account
dim spade
unfortunately no. there is also the pattern where there is no connected account is there. in other words. no destination. so no transfer.
narrow cape
But then you will eventually send a Transfer to them, when they finish Onboarding, right?
That time you will also has a Transfer