#annabanana - Reoncile Payments
reef bolt
I'm trying to understand the best way to have Stripe payouts break out into deposit lines that are related to invoices or invoice items so I can reconcile them with customer payments
I assumed they would be tracked against the invoices in the billing engine but the billing vendor said usually they don't connect that way because they don't have access to the deposit data
storm dome
Stripe Payouts in the Dashboard are aligned with all the transactions that have occurred on that account. We have the data for the funds transfers from your Stripe account to an external account and the dashboard aligns the transactions adding/removing funds from your Stripe account balance with the funds transferred to your external account.
reef bolt
what about to a billing engine though - not the bank account
so the billing engine should have access to the transaction details to reconcile against invoice?
storm dome
If by "billing engine" do you mean a 3rd party reconciliation service?
reef bolt
The billing engine is the 3rd party software that creates the invoice, bills the client and collects payment. Since it collects payment via stripe we would want to reconcile within this software too
that way if there are multiple gateways in the future, we wouldnt need to build the connection to reconcile payment across multiple systems - it would jsut use the same process
stoic nexus
You can use the List Balance Transactions API https://stripe.com/docs/api/balance_transactions/list with payout: 'po_123' to reconcile what is bundled in that specific Payout.
And then each BalanceTransaction object https://stripe.com/docs/api/balance/balance_transaction has a source property that points to the object that caused the money movement such as a Charge, adn the Charge https://stripe.com/docs/api/charges/object has an invoice property
and so you can "chain" all of this in the API with the Expand feature: https://stripe.com/docs/expand
stoic nexus
@reef bolt does that make sense?