dematech-payout-reconciliation | Stripe Developers | Page 1

sharp dock Oct 1, 2021, 11:24 PM

#

There are many reports in the Dashboard that you can use to figure out what transactions are in a given Payout and how to reconcile that information

heavy shale Oct 1, 2021, 11:47 PM

#

I have an API integration so I need to track the stripe fees for certain grouped products.

So if a payout has payments to Product A, B and C, I need to track the stripe fees separately for the payouts for all products A, B and C.

The challenge comes in when the batch deposit is made and how accounting software like Quickbooks manages it. That's why it will be ideal to separate payouts based on Product A, B and C

#

Hope the challenge is clear

sharp dock Oct 1, 2021, 11:50 PM

#

I've never used Quickbooks reconciliation myself. But in the API you can figure out all of this. Are you write code for it with the Stripe API or just using Quickbooks?

heavy shale Oct 1, 2021, 11:59 PM

#

Writing code for it with Stripe API

#

So everything is working fine but on the accounting side tracking stripe fees is a nightmare. So the soluiton I need from Stripe's end to resolve this is to separate payouts so I can track the stripe fees accordingly

sharp dock Oct 2, 2021, 12:00 AM

#

So you can use https://stripe.com/docs/api/balance_transactions/list to list all balance transactions and pass payout: 'po_123' to find all BalanceTransactions in that Payouts

#

that tells you exactly what's in the Payout, each transaction and their corresponding fee

heavy shale Oct 2, 2021, 12:01 AM

#

That part is great and I tried using it but the challenge is in the third party software, there are limitations - that's why I am trying to figure out if I can separate payouts from Stripe

#

I wonder if this will help - https://stripe.com/docs/api/payouts/create

I can write logic to create a payout based on specific criteria and then create a payout request using that endpoint

sharp dock Oct 2, 2021, 12:18 AM

#

yeah you can but IMO that's the wrong approach to try and split everything by hand yourself

heavy shale Oct 2, 2021, 12:19 AM

#

That's what I was worried about as well... it could lead to a lot of other challenges and was hoping there was another suggested method

sharp dock Oct 2, 2021, 1:04 AM

#

Unfortunately I know nothing about Quickbooks so I don't have a good recommendation. If it were me, I'd do the reconciliation myself and export the data I need to a CSV or similar

#dematech-payout-reconciliation