#crenon-payout-transactions
tribal field
Unfortunately not. Once they land in your balance, there is no way to associate them with a payout.
marsh beacon
But is it possible to pull a detail of the available balance, showing the transactions in that balance?
e.g. "List all balance transactions" but only for the current available balance
tribal field
No. Once the funds are reconciled to the balance, there is no way to tell if a balance transaction or charge has been paid out or not
marsh beacon
Ok that makes sense, but then how do platforms track what transactions have been paid out and which haven't? Currently, we're pulling the available balance nightly on each connected account, and then paying out the balance if it's over a threshold ($500). The problem is that our clients want to be able to reconcile those payouts.
Thanks very much for any guidance
I see that when you pull all balance transactions ($stripe->balanceTransactions->all([]);), you can then loop through them for "status": "available". Maybe that'd do what I'm talking about here? Provide a list of all the payments that are currently in the available balance?
tribal field
I believe that remains as available after the payout is created, but I'm not sure. Let me check
marsh beacon
oh interesting. I'd think it'd change from "available" after it had been paid out? fingers crossed!
tribal field
That seems more intuitive, but it looks like it will only ever have values of pending or available.
The status remains as available after payout occurs unfortunately
marsh beacon
oh bummer
but i could still probably make this work by limiting for payments from the date of the last payout
but i'd need to figure out how to capture payments that were made before the last payout but were pending until after that payout
Do you have any idea how other platforms do this? Letting connected accounts reconcile their payouts down to the transaction?
thanks so much for your help, i've been banging my head against the wall
tribal field
I think that the reporting obligations are usually met by getting the transaction-level report and the payout-level report separately for each account. Most platforms don't have much of a need for showing what charges made up which payout, since all their funds are paid out eventually and there aren't a lot of reporting obligations that aren't satisfied by one or both of these.
I can't really speak on behalf of them, though. That has just been my experience
marsh beacon
thank you, that's helpful, but our platform accepts donations on behalf of nonprofits, so they very frequently want and need to know what transactions are in a payout, as they reconcile their deposits.
I'm sad that there's no way to do that in the system, and I'm confident we can figure out some kind of workaround - we can't be the first platform that needs to let connected accounts reconcile their payouts to the transaction level
I'm thinking something like listing all balance transactions since the last date of a payout and saving the available ones as the payments in the payout, and then saving the pending ones separately
then on subsequent payouts, doing the same except also checking each pending payment from the last batch and adding it if it's switched to available since the last check
not very elegant but it might work
i'm very open to any other suggestions