brianc6053 | Stripe Developers | Page 1

crystal citrusBOT Jul 7, 2023, 12:35 AM

#

solar portal Jul 7, 2023, 12:37 AM

#

Do you have a ID that starts with rtx_ prefix ?

leaden crystal Jul 7, 2023, 12:37 AM

#

Yes. Here's one. rtx_1N6hRvKTXOeT140ni5cI3DRJ

#

The description is reserve_transaction but I cannot find it anywhere, Does not come up in dashboard and don't really know exactly what that means in this context

#

To be clear. When we put id in the search bar of the dashboard we get no results. same with all other rtx

solar portal Jul 7, 2023, 12:43 AM

#

It's an internal Stripe object, and you don't need to manage it.

leaden crystal Jul 7, 2023, 12:44 AM

#

Fine. But it is being imported into our financial reports so we need to know what it is and more detail on it. Where can we find that?

solar portal Jul 7, 2023, 12:45 AM

#

Which financial report?\

leaden crystal Jul 7, 2023, 12:45 AM

#

Transactions export into our financial software.

#

If it is internal, why can we see it? 🙂

solar portal Jul 7, 2023, 12:47 AM

#

https://support.stripe.com/questions/view-reserve-status-and-details-in-dashboard you can see the reserve transations in Dashboard, but there's no API to access them.

View reserve status and details in Dashboard : Stripe: Help & Support

Find help and support for Stripe. Our support center provides answers on all types of situations, including account information, charges and refunds, and subscriptions information. Get your questions answered and find international support for Stripe.

#

If you can share with me how you export the data, I can take a further look.

leaden crystal Jul 7, 2023, 12:48 AM

#

Simple export of transactions to csv

#

from the dashboard

solar portal Jul 7, 2023, 12:49 AM

#

Which Dashboard?

leaden crystal Jul 7, 2023, 12:49 AM

#

Stripe dashboard.

#

payments> all transactions

solar portal Jul 7, 2023, 12:49 AM

#

Can you share with me your merchant ID? you can find it from the Stripe Dashboard -> Settings ->Account Details

leaden crystal Jul 7, 2023, 12:50 AM

#

acct_15n9ZnKTXOeT140n

#

I don't think we need help with export. We do need to see the historic record of the transaction though. no record comes up with search. How can we get details on these rtx_ transactions to confirm reserve was released, etc.

solar portal Jul 7, 2023, 12:53 AM

#

Did you export all columns, or just default columns?

leaden crystal Jul 7, 2023, 12:53 AM

#

default

solar portal Jul 7, 2023, 12:53 AM

#

And what's the date range?

leaden crystal Jul 7, 2023, 12:54 AM

#

We want to see them. We just need to see historical data on them when needed.

#

is there a setting to allow them to come up in search results?

solar portal Jul 7, 2023, 12:56 AM

#

What's the date range you set for export?

leaden crystal Jul 7, 2023, 12:58 AM

#

You may be misunderstaning what we need. We do not need help with export. We are getting these transactions. We now know what they are but there is no historical data attacthed to them that we can see. We need to know details on the transaction id by looking it up in search or some other method. Make sense? Use the past year if you need a date range but want to be clear on what we are requesting.

solar portal Jul 7, 2023, 1:00 AM

#

I'm just trying to reproduce the flow. I exported the data from your Dashboard and I don't see any ID starts with rtx_

leaden crystal Jul 7, 2023, 1:01 AM

#

Do you need more ids? If you exported the past year the one I gave you was from last month

solar portal Jul 7, 2023, 1:01 AM

#

Do you have a specic date range of last year?

#

Or shall I try last month?

leaden crystal Jul 7, 2023, 1:01 AM

#

OK. Search from march 1 - present

solar portal Jul 7, 2023, 1:02 AM

#

Got it, let me take a look

leaden crystal Jul 7, 2023, 1:02 AM

#

What we need is once we have the ids (which we do) where do we find historical data on them

#

Once they are imported to our books we need to periodcially go back and look up what it was for, if it was released, etc but cannot search byt ID

solar portal Jul 7, 2023, 1:04 AM

#

So I exported march 1 - present data from Payment -> All Payments Dashboard, and I don't see any rtx_ IDs. Is it possible that you exported the data from another Stripe Dashboard? (for example Balances?)

leaden crystal Jul 7, 2023, 1:04 AM

#

rtx_1MtlOdKTXOeT140nu0ux9jGH april 6 , 2023

#

rtx_1N6hRvKTXOeT140ni5cI3DRJ may 11, 2023

#

no. this is where we downloaded them from. I jsut did again.

#

see txn_1N7pMOKTXOeT140nLTvkUf10\

#

This is the transaction id associated with one of them

#

txn_1N7pMOKTXOeT140nLTvkUf10

solar portal Jul 7, 2023, 1:08 AM

#

OK. let me refine the date range

leaden crystal Jul 7, 2023, 1:08 AM

#

also shows nothing is search

solar portal Jul 7, 2023, 1:08 AM

#

One sec

leaden crystal Jul 7, 2023, 1:11 AM

#

Let's simplify. Why doesn't the rtx_1N6hRvKTXOeT140ni5cI3DRJ or txn_1N7pMOKTXOeT140nLTvkUf10 show up in search results although it is listed in export? That is all we need to know.

#

and where can we find data attached to those transactions

#

that's all we need to know. thanks for your help

solar portal Jul 7, 2023, 1:12 AM

#

OK. I found it.

#

The reason why these two IDs are shown up in search results is because there's no dedicated page to render a reserve transaction or balance transaction in Dashboard.

#

However, there's a balance transaction API that you can use to retrieve the details of the balace transaction (https://stripe.com/docs/api/balance_transactions/retrieve#balance_transaction_retrieve)

Stripe API reference – Retrieve a balance transaction – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

leaden crystal Jul 7, 2023, 1:16 AM

#

OK. that will do it. Thanks1

solar portal Jul 7, 2023, 1:16 AM

#

https://stripe.com/docs/reports/balance-transaction-types#types this page explains various balance transaciton types (reserve_transaciton) is one of them. And this page tells you when a reserve_transaction would happen https://stripe.com/docs/connect/account-balances#understanding-connected-reserve-balances

#

Sorry for the back and forth. I just wanted to make sure what I get from Dashboard is the same data that you got from Dashboard.

#brianc6053