#jessa_api
ancient bobcatBOT
đ 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/1314048869465718834
đ Have more to share? Add more details, code, screenshots, videos, etc. below.
hasty siren
https://docs.stripe.com/api/balance_transactions/list#balance_transaction_list-type you can use the balance transaction list API and apply the type filter. For example, you can set type=stripe_fee to retrieve all balance transactions related to stripe_fee
oblique pike
Thanks! But is there some way to also filter for balance transactions that are attached to multiple payouts? It seems like we have to get the balance transactions for each payout one at a time, but we're trying to make a report that has an entire month of data.
hasty siren
Yes, you just need to leave payout param empty https://docs.stripe.com/api/balance_transactions/list#balance_transaction_list-payout
oblique pike
we need the balance transactions that are attached to the specific payouts that happened in the date range, though, so that accountants can match the payouts with their bank balance
sorry, to be clearer, we are providing the payment totals from our app, and they want to reconcile that with their bank balances, but we need to deduct the fees and disputes so that it matches exactly
hasty siren
You can only specify one payout. Note that if you are on automatic payouts, Stripe will generate one payout per day, so you can just filter balance transactions by created param
oblique pike
ok, i'm not sure that will work for our use case, due to the time zone differences between stripe servers and our app, but i understand there's no way to provide multiple payout IDs for the balance txn query
thanks for your help
hasty siren
All Stripe timestamps are in UTC, so you just need to covert your local time to UTC when call the list balance transactions API
oblique pike
Hm, ok let me think about it.. is it 100% certain that the transactions within 1 UTC day will always be included in the same payout? I feel like the payouts aren't sent exactly every day, sometimes a payment will be included on the payout 2 days later if it's a weekend, or refunds are included in the payout the same day it happened, even if the original payment is not included until the next payout, things like that.
We've found it's perfectly reliable if we get the payouts within the date range and then rely on you to tell us which transactions were included.
FWIW we have this report already but it's only available on a daily basis, we are expanding it to a month's date range.
hasty siren
https://docs.stripe.com/payouts/customized-start-of-day Your default start of day for payout is midnight in your timezone
oblique pike
oh my goodness when did you add this feature
oh it's not available in the US
our business day is not midnight - midnight (it's for brick and mortar businesses that are open past midnight) so that default doesn't work for us unfortunately
sorry i'm also confused, you said the default is midnight in our timezone, but the article says "Your default start of day is UTC midnight" which is our experience
again, we've also experienced things like this:
refunds are included in the payout the same day it happened, even if the original payment is not included until the next payout
which makes getting balance transactions in a date range unreliable