#nimisha_api
toxic saddleBOT
👋 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/1498874882841251881
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
long ether
Hey!
Could you share with me what API endpoint you are using to extract the data from?
devout vessel
Please let me know if you need any other details ,
in bank statememt I can see details like
IND ID NO=ST-Q7Q3G6Q5C1D8
TRACE NO=111000024592733
but not able to find any details under stripe
pls help
I see the amount matching for a day , but looking for some id so that I can join dat aand reconcile it
sure
devout vessel
Could you share with me what API endpoint you are using to extract the data from...
sure, will let you know
first I find all payouts then
to get itemized data I am using balalnce transactions
https://api.stripe.com/v1/balance_transactions?payout=po_xxxx
for trace id
I tried this api - which gave me trace id but its not matching with bank statmenet trace id
long ether
Just to inform you, this chat is focused on developers and technical questions. Your question seems to be about Payout reconciliation, which we have dedicated teams supporting.
Nonetheless, let me see if I can help you out a bit.
I found this documentation that seems to address payout reconciliation: https://docs.stripe.com/bank-reconciliation#reconciliation-records
But it does not talk about retrieving and assessing payouts via API
devout vessel
yes, I went thru documentaion, but not sure how to get data
can u pls let me know how to connect with the team and find out these details ?
long ether
Sure, but let me look for additional resources first before directing you to another team.
Have you tried the Reporting API: https://docs.stripe.com/reports/payout-reconciliation#available-columns
Sounds like what you are looking for is : Itemized payout reconciliation -API report type: payout_reconciliation.itemized.7
the generated report would have: trace_id and source_id
Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number.
Source ID: The Stripe object to which this transaction is related.
https://docs.stripe.com/reports/report-types/payout-reconciliation#schema-payout-reconciliation-itemized-7
devout vessel
let me try this report
no this report doesnot provide trace number , it just gave the payout details
"automatic_payout_id","automatic_payout_effective_at","balance_transaction_id","created","available_on","currency","gross","fee","net","reporting_category","description"
only these above headers
long ether
Those are the default columns, you would need to specify the specific columns of trace_id and source_id as well
https://docs.stripe.com/api/reporting/report_run/create?rds=1#create_reporting_report_run-parameters-columns
devout vessel
I am still chking how to add for specific columns I am using Postman, passing key is yielding an invalid column name
long ether
NP! take your time
This curl command worked for me
curl https://api.stripe.com/v1/reporting/report_runs \ -u REPLACE_WITH_YOUR_SECRET_KEY: \ -d report_type="payout_reconciliation.itemized.7" \ -d "parameters[columns][]"=trace_id \ -d "parameters[columns][]"=source_id \ -d "parameters[interval_start]"=1776654846 \ -d "parameters[interval_end]"=1777346046
but do note, you should also be including some of these important columns, this worked for me as well
curl https://api.stripe.com/v1/reporting/report_runs \ -u REPLACE_WITH_YOUR_SECRET_KEY: \ -d report_type="payout_reconciliation.itemized.7" \ -d "parameters[columns][]"=automatic_payout_id \ -d "parameters[columns][]"=automatic_payout_effective_at \ -d "parameters[columns][]"=balance_transaction_id \ -d "parameters[columns][]"=charge_id \ -d "parameters[columns][]"=payment_intent_id \ -d "parameters[columns][]"=reporting_category \ -d "parameters[columns][]"=created \ -d "parameters[columns][]"=description \ -d "parameters[columns][]"=net \ -d "parameters[columns][]"=trace_id \ -d "parameters[columns][]"=trace_id_status \ -d "parameters[columns][]"=source_id \ -d "parameters[interval_start]"=1776654846 \ -d "parameters[interval_end]"=1777346046
devout vessel
Thanks much for ur help.
though this gives me trace id for each line item like trace id for charge, trace_id for refund, etc.
in bank stamtemt I see only payout and payout trace id whats in stripe in not matching with bank stataments data
long ether
Ok, given that we have tried the Report APIs and they are still not matching, could you reach out to Stripe Support - https://support.stripe.com/contact , they'll be able to advise you on reconciling payouts with whats on your bank statement