#palminyx
autumn flowerBOT
Hello! We'll be with you shortly. Below are links to other discussions we've had with you in the past week in case you want to review that information. If your question is related to one of these previous discussions, please provide a comprehensive summary of the current state and what you need help with now. We help many users simultaneously, so a summary allows us to resolve your issue as soon as possible.
- palminyx, 18 hours ago, 64 messages
flint rampart
👋 happy to help
are you using the columns from here https://stripe.com/docs/reports/report-types/connect#schema-connected-account-balance-change-from-activity-itemized-2
flint rampart
Yes I was checking at the same time
would you mind sharing the request ID that creted the report run?
can you try rerunning the report run and add the balance_transaction_id column?
it's easier to inspect the Balance Transactions and make sure we have the data there
flint rampart
before moving to figuring out whether there's a bug in the report run or not
flint rampart
bc it needs to be uploaded to the server
you can run it locally
no need to deploy
just change the API keys and run the code locally
gleaming grove
frr_1OMTebDOGTiSwnohckUVGpYR
it's this one
FYI one metadata field has a slight different name bc i wanted to keep my company name private
flint rampart
would you mind pasting a balance transaction ID?
gleaming grove
txn_1OLxScD6vtKt8jjBqvqzixfB
flint rampart
thanks taking a look
gleaming grove
Thanks a lot
tr_1OLxXSDOGTiSwnoh5HQyUlCp
As an example, here is the metadata for the transfer
flint rampart
before tackling the metadata
in this request https://dashboard.stripe.com/test/logs/req_cm3uoIndaLgZ3O you don't really specify the source_transaction
so there's no way to get the customer information
does that make sense?
flint rampart
my colleague might not have known that you would eventually need reporting
gleaming grove
so there's no way to get the customer information
ohhhh okay i thought customer email and name were the same of the connected_account (seller) and not the buyer
flint rampart
the customer is the one that made the payment on your platform account
gleaming grove
I'll fix that by adding the source_transaction, what about the metadata?
Right now i'm
- creating a payment intent with a manual capture method
- user confirms and funds are captured
- service is delivered on date X
- one day after completion of the service, if no issues arise then a transfer is automatically created to the connect account of the seller.
A practical example
Seller sells for 35 euro (amount), the platform commission is 10% of the amount (3.50 euro), seller receives 90% (31.50 euro).
Stripe's fee is (with test cards) 1.70 euro. Therefore my net commission (let's call it platform_fee) is 3.50 - 1.70 = 1.80 euro.
Right now i've associated to each transfer metadata with stripe's fee by retrieving the charge of the payment intent and expanding the balance transaction, where i found stripe's fee as per your colleague's recommendation in the thread
that's why i need the reports API to track metadata
flint rampart
I need to investigate why the metadata are not shown, but this might take a while. Do you mind if we continue this asynchronously? what you have to do is write in to https://support.stripe.com/contact/email?topic=api_integration and make sure to mention that tarzan from discord asked you to write in?
gleaming grove
Alright, thank you I'll do that
just to make sure
is this the right way to include the metadata
'transfer_metadata[commissionAmount]', 'transfer_metadata[commission_Stripe_take]', 'transfer_metadata[commission_MyCompany_take]'
flint rampart
that's what I need to look into, and verify why the query didn't get results
please once you do, just let me know
autumn flowerBOT