Dev9051 | Stripe Developers | Page 1

sharp cliffBOT May 9, 2023, 10:52 PM

#

tough raptor May 9, 2023, 10:56 PM

#

Hi there! Just to confirm, is this a screenshot of a connected account's balances?

sonic lily May 9, 2023, 10:57 PM

#

Yes, it is

tough raptor May 9, 2023, 11:02 PM

#

Got it. The balance breakdown above is available in the Dashboard only. You can retrieve current balance and any pending funds for a connected account using the API but this won't include lifetime total volume or pending payouts: https://stripe.com/docs/connect/account-balances#check-connected-account-balance

sonic lily May 9, 2023, 11:04 PM

#

I see. I did try the balance API call and was not receiving what I was expecting. Would it be possible to retrieve that dashboard information some other way? For example using Sigma to query the information?

tough raptor May 9, 2023, 11:16 PM

#

I don't think there's a Sigma table you can use to quickly pull the same information. There's a balance_transaction table but you'd have to calculate the total volume, payouts, etc.

#

The same goes for balance reports you can generate using the API: https://stripe.com/docs/reports/balance

sonic lily May 9, 2023, 11:20 PM

#

I see. So if I were to make a scheduled query that calculates all those values and runs at the end of every day. Would I be able to retrieve the same values that are on the dashboard for the day prior?

#

Or would you recommend using the balance reports instead?

tough raptor May 9, 2023, 11:23 PM

#

Up to you, really. You can try both out and see which process fits your flow better

#

We're not experts on reporting in this channel so I recommend reaching out to our Support team about this if you have any other questions on reporting guidelines or best practices: https://support.stripe.com/contact/

#Dev9051