digi-f_icplus

[warped otter]

👋 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/1215710720079962163

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

[sterile viper]

I believe this is because of the specific fee/pricing plan you're on that calculates fees in a different way - I'd suggest talking to support (https://support.stripe.com/contact) to have them give you more details

You'll specifically want them to give you more details on your IC+ pricing plan and the best way to approach reporting/reconcillation with that

[little creek]

IC+ ?

[sterile viper]

Yeah, that's what your pricing plan is called

https://support.stripe.com/questions/understanding-ic-fees may be a good thing for you to read, and support will be able to clarify any additional questions you have

[warped otter]

digi-f_icplus

[little creek]

yes yes, I know. You were faster than me haha

Actually In order to get the details of all the fees, I am using the Stripe’s Activity Report that gathers all the operations that happened on the platform.

In order to achieve this, I have set-up the following steps :
Listen to reporting.report_type.updated webhook in order to know when the latest version of the Activity report is available
Call the POST /report_runs endpoint to generate this report
Listen to reporting.report_run.succeeded webhook in order to know when the Activity report is ready to be downloaded
Download the report using the link in the webhook
Filter data by connected_account_id to get all the charge IDs related to a specific connected account
Filter data by charge_id to get all the fee lines related these charge IDs
Select fees lines that need to be passed through to the connected account
Sum the amount field
Make a debit on the Connected Account
Apply monthly adjustments

[sterile viper]

If you want IC+ then you're using the wrong report, right? You need to use the IC+ specific report for those fees

[little creek]

this is the one I am calling :

report_type"="connected_account_payout_reconciliation.itemized.3

I perform a POST /reporting/report_runs to get all the payouts made to my Connected Accounts’ bank account.
And then listen to reporting.report_run.succeeded webhook

[sterile viper]

If you read the link I sent earlier it talks about a different report entirely https://support.stripe.com/questions/understanding-ic-fees

[little creek]

Actually now I get it well.

This is isn’t what I am looking for

I need some reports to share with my connected accounts (express)

curl https://api.stripe.com/v1/reporting/report_runs -u "{sk_test}" -d report_type="connected_account_payout_reconciliation.itemized.3" -d "parameters[interval_start]"=1702162800 -d "parameters[interval_end]"=1702767600 -d "parameters[columns][0]"="balance_transaction_id" -d "parameters[columns][1]"="created_utc" -d "parameters[columns][2]"="available_on_utc" -d "parameters[columns][3]"="currency" -d "parameters[columns][4]"="gross" -d "parameters[columns][5]"="fee" -d "parameters[columns][6]"="net" -d "parameters[columns][7]"="reporting_category" -d "parameters[columns][8]"="description" -d "parameters[columns][9]"="connected_account" -d "parameters[columns][10]"="source_id" -d "parameters[columns][11]"="automatic_payout_id" -d "parameters[columns][12]"="customer_id" -d "parameters[columns][13]"="payment_metadata[order_id]" -d "parameters[columns][14]"="payment_metadata[customer_id]" -d "parameters[columns][15]"="payment_metadata[customer_email]"

so exactly this

So as you can see I am asking for a the fees : columns][5]"="fee

[sterile viper]

Yes, I understand that but as I mentioned before fees work very differently for IC+ and what you're seeing is expected behavior. You're not going to see any transaction-specific fees with IC+ at all

[little creek]

ok got it
Last thing that confuse me ...

I did a request with Sigma and I had the expected behavior

select caari.account as account, caari.automatic_payout_id as virement, caari.event_type as type, (caari.amount/100) as montant, pim.value as order_id_from_platform, capim.value as order_id_from_CA
from connected_account_activity_report_itemized caari
left join connected_account_payment_intents_metadata capim on capim.payment_intent_id = caari.payment_intent_id
left join transfers t on t.id = caari.source_transfer_id
left join charges c on t.source_transaction_id = c.id
left join payment_intents_metadata pim on pim.payment_intent_id = c.payment_intent
UNION
select 'acct_1LHmJrH2uumRlpXh' as account, caari.automatic_payout_id as virement, caari.event_type as type, (caari.amount/100) as montant, pim.value as order_id_from_platform, '' as order_id_from_CA
from activity_report_itemized caari
left join payment_intents_metadata pim on pim.payment_intent_id = caari.payment_intent_id

[sterile viper]

Ah, were you asking about finding the application fees you're charging your connected acccounts? Not the Stripe fees?

[little creek]

yes
this is the difference between the the same reports

[sterile viper]

At this point I'd recommend you have support (https://support.stripe.com/contact) dig into this more - the specifics of what each report returns isn't something we really handle in this channel and they'll be able to dig into whether this is a problem with the specific report, the specific interval you're searching over, something related to IC+, etc.