Dominik_FINN

[strong urchin]

Hi! Let me help you with this.

What do you mean by "funding event" exactly?

[feral estuary]

The events with ids starting with ccsbtxn_. We are getting the ones starting with cbtxn_

Ideally we would be able to see/trace to which payment intents a cash balance funding gets allocated

[strong urchin]

Could you please share one example ID?

[feral estuary]

ccsbtxn_1NidohDOkQuZ6Q4MDqpyTJVx as the funding event and cbtxn_1Nsk3gDOkQuZ6Q4Mw8CP9UTk as the transaction event (could be funding/deposit, but also can be withdrawl/allocated to payment intent)

ccsbtxn_1NidohDOkQuZ6Q4MDqpyTJVx we get when going manually through the dashboard into a funding event, cbtxn_1Nsk3gDOkQuZ6Q4Mw8CP9UTk when calling v1/customers/{Customer_ID}/balance_transactions

[strong urchin]

Maybe you could provide a bit of a high level context about what you're trying to do?

[feral estuary]

Ideally we would be able to see/trace to which payment intents a customer cash balance funding is associated to. So if a customer transfers us 100$ we would like to see to which payment intent these 100$ gets allocated. We often have multiple intents incomplete/open per customer, which obviously increases error rate and would like an automated solution to trace what went wrong/where it went wrong, as right now this needs to happen completely manual

[frosty mulch]

Thanks for the context. So you are using automatic reconcilliation but are unclear on how to see which Payment Intent(s) are getting paid by the various funds that you are getting sent?

[feral estuary]

Yes. And most of the time the auto reconciliation is working great, but sometimes for complex customers or with manual errors on customer side, things get wrongly matched. And we only know then that sth went wrong and need to do tedious manual investigation to find out exactly where the issue was/which intents got incorrectly matched.

[frosty mulch]

Gotcha, so the end goal is to go from some cash balance transaction ID like ccsbtxn_1NidohDOkQuZ6Q4MDqpyTJVx to the ID of the PaymentIntent that it funded?

[feral estuary]

Yes exactly and vise versa.

Right now we do it with a combination of manually checking the dashboard and transactions and comparing against each other, but this is obviously quite labour intensive

[frosty mulch]

Have you tried using the applied_to_payment.payment_intent property? It looks like that should give the link from cash balance transaction to PaymentIntent
https://stripe.com/docs/api/cash_balance_transactions/object#customer_cash_balance_transaction_object-applied_to_payment

[feral estuary]

Yes, that is the Transaction itself, but as far as I understand doesn't link back to funding of the cash balance in the first place.

[frosty mulch]

Gotcha, thanks for the clarification. Having trouble finding a way to do this myself, I will ask colleagues and get back to you with what we can find

[feral estuary]

Thank you, no worries

[haughty spear]

👋 taking over here as Pompey needs to step away soon

[feral estuary]

Hey, thank you

[haughty spear]

With automatic reconciliation, it is almost impossible to associate these objects unfortunately. As there might be more than one invoices involved with one transfer

Typically, we recommend switching to manual reconciliation in this case where your integration controls which funds are used for which invoices etc

[feral estuary]

Ok, thank you. For a few tricky customers will do that then

[haughty spear]

NP! 🙂 Happy to help