#bram_best-practices
deep lightBOT
👋 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/1371768035987296381
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
leaden tusk
👋
You should probably use reports instead if you want deeper insights
You can retrieve your balance reports:
https://docs.stripe.com/reports/balance
balance_change_from_activity.itemized.3 is the one with most details I think it's the good one for you use case.
heady finch
Example of a Balance transaction where we want to perform a further specification:
{"id": "txn_1RI5GTDF092UZLzTcvd8uGAp", "object": "balance_transaction", "amount": -8082, "available_on": 1745660597, "created": 1745660597, "currency": "eur", "description": "Card payments (2025-04-25): Stripe volume fees", "exchange_rate": null, "fee": 0, "fee_details": [], "net": -8082, "reporting_category": "fee", "source": null, "status": "available", "type": "stripe_fee"}
This is a deduction for network tokens on a specific date. I want to see for which events/transactions these network tokens where used.
I'm gonna try downloading that report, based on the documentation this doesn't seem to provide additional details. But let's try to be sure. I'll get back if it doesn't provide desired specification
i downloaded the "balance_change_from_activity.itemized.3" report. It gives me these details for this specific transaction, no calculation details:
deep lightBOT
heady finch
Do you provide fee specific reports that (that include links to balance transactions) that might help in this case?
In this example you see that Stripe charges 80,82 euro as fee for Card payments (volume fees) on the 25-04-2025th. I want to gain insights in how these fees are constructed/calculated (P*Q)
leaden tusk
Ah then I'm not hoonestly, maybe Sigma is better fit here 🤔
knotty sparrow
👋 taking over for my colleague. Let me know if there's any follow-up Qs I can answer!
heady finch
Thank you for taking over:
- I want to see if there is information available via (free) reports, api or other routes
- If we come to the conclusion that this isn't the case. I have some additional questions regarding the Sigma route
knotty sparrow
catching up on the thread, please give me a few minutes
ok this is not something that we deal with a lot, I need to investigate more to be honest
heady finch
If i can help providing additional details, please let me know
knotty sparrow
I think what you're try to achieve is to figure out how the 80,82 has been calculated right?
are you on IC+ pricing?
In all cases, I think you can look into https://docs.stripe.com/stripe-data/query-all-fees-data
heady finch
Yes, i hope you have some kind of reports available that would give me additional insights.
The goal is to as much as possible assign fees to the transactions that cause them. If i look at the balance transaction for a specific day (for example 26-04-2025). I get totally charged 1083.63 in fees. Out of the 1083.63 i'm not able to explain 90% (+-1000.00) to a transaction level basis. Because they get deducted on a daily basis
knotty sparrow
I understand
heady finch
Can you explain why the pricing your on matters? I'm not sure which pricing is active
knotty sparrow
it doesn't really in a sense
just let me ask you this
do you have a direct contact at Stripe?
heady finch
In all cases, I think you can look into https://docs.stripe.com/stripe-data/quer...
Yes i read this article. This seems to require a Sigma or datapipeline licence. Before we further investigate this route i want to confirm with Stripe that the route we are currently taking (API, reports and potential other routes) cannot provide this information
knotty sparrow
the reasoning why I'm asking is that they might be able to help on this type of questions
heady finch
do you have a direct contact at Stripe?
I don't have a direct contact. I'm purely interested in the technical solution to this question. To make sure we are using the correct technical possibilities (and best practices) you provide to retrieve an answer to this question
knotty sparrow
I don't have one, and I'm trying to orient you to people that might be able to help.
Reports, pricing and fees aren't really a topic we have expertise on, on this channel
again the reason why I asked you about your contact is that they could help identify what you need, and get you an answer from the appropriate team
if you don't have one, you can just contact https://support.stripe.com/?contact=true
deep lightBOT
heady finch
Reports, pricing and fees aren't really a topic we have expertise on, on this ch...
I understand. My reasoning was I'm not asking for expertise on pricing itself. I'm asking about the technical possibilities to retrieve fee details from Stripe. Since i'm a developer and using API's and reports to retrieve this data i hoped i was in the right place here
Before reaching out to Stripe support i have additional question about Sigma:
- Is it possible to get access to a test Sigma environment, to see which information can be retrieved?
- Do you also have some kind of partner support? I think this can make sense because we want to give these insights into multiple accounts.
exotic widget
- Schema should be accessible here: https://dashboard.stripe.com/test/stripe-schema
- Not something we'd know anything about specifically. What exactly do you envision?