deep randhawa | Stripe Developers | Page 1

ember auroraBOT Jun 14, 2023, 4:09 PM

#

mighty shard Jun 14, 2023, 4:10 PM

#

Hey there

#

So to clarify you are looking to programatically reconcile transactions with Connect Payouts?

stoic turret Jun 14, 2023, 4:11 PM

#

There will be some payments / payouts that the Platform will go through Stripe Connect, but some transactions might not.

But for the Platform to become the core system of record, the Platform will want the ability to reconcile both types of transactions.

mighty shard Jun 14, 2023, 4:12 PM

#

Okay well likely the Reports API is going to be the easiest way to handle this: https://stripe.com/docs/reports/api

#

You can use that API to generate Reports both on your platform or Connect accounts. You can see all the different types of Reports you can generate via the Reports Reference: https://stripe.com/docs/reports/report-types

#

Take a look at that and let me know if you think that will suit your use-case.

stoic turret Jun 14, 2023, 4:14 PM

#

Ok. Let me take a look.

#

Interesting. Ok, so if I understand it correctly, @mighty shard you're recommending the following solution with the Reports API - for connected accounts (through Stripe Financial Connections), we generated a CSV Report (through the Reports API you sent above). We then present said report to the user and have them manually view and reconcile transactions in their ledger with the CSV report shown?

#

Also, just to confirm, the Reports API will be able to pull in all transaction data in the bank accounts of our customers to our Platform? The bank accounts will be connected through Financial Connections.

mighty shard Jun 14, 2023, 4:27 PM

#

What do you mean exactly when you say "pull in all transaction data in the bank accounts of our customers to our platform"? You are using Finanical Connections to pull transaction data and want to see that data, which is not necessarily transactions that flowed through Stripe?

stoic turret Jun 14, 2023, 4:32 PM

#

Yes. So there will be two types of transactions in the system

Received payments / Payouts that have flown through Stripe - These will be ACH payments (invoices / payments). Platform will make appropriate ledger entries for these, as these transfers will be mostly triggered from Platform workflows. These are easy to reconcile, because Stripe will send webhooks when the funds settle (which I'm assuming should match up to our customers' bank statements)
Random ad-hoc payments (not flowing through stripe) - These will be manually entered into the ledger by our Customers. Because they happened outside of Stripe, there is no way for us to reconcile these other than to show our customers the bank statements and have them manually reconcile.

#

Feel free to correct me if I have mis-understand the Flow of Funds somehow. This is all quite new to me.

mighty shard Jun 14, 2023, 4:34 PM

#

Ah okay so the concern here is how to handle these "other" transactions that don't flow through Stripe

#

But that you have access to via Financial Connections

stoic turret Jun 14, 2023, 4:34 PM

#

Full disclosure: We are using Fragment (https://fragment.dev/) for our Ledger, not sure if y'all are aware of them. The Platform posts all ledger entries (manual or system-generated) to Fragment, which then needs to be reconciled.

Fragment

Accounting for Engineers

#

But that you have access to via Financial Connections
Yes.

mighty shard Jun 14, 2023, 4:34 PM

#

Gotcha yeah I'm not familiar with Fragment at all

stoic turret Jun 14, 2023, 4:34 PM

#

No worries. Imagine them just being a ledger where you can post accounting entries.

mighty shard Jun 14, 2023, 4:35 PM

#

Okay so for transactions that didn't flow through Stripe, the Financial Reports API won't work.

#

The only way you are going to be able to "export" that data is to retrieve it via the API and build your own export

#

We don't have any pre-built reports or anything for Financial Connections Account data

#

We only have prebuilt Reports for the transactions that flow through Stripe

stoic turret Jun 14, 2023, 4:36 PM

#

Fair. Yea that's understandable. I figured this would have to be a custom solution we build in-house.

#

On a similar note - are there ways, through the Financial Connection API, where Stripe sends the Platform webhooks when transactions are posted to connected bank accounts?

mighty shard Jun 14, 2023, 4:39 PM

#

For transactions outside of Stripe?

stoic turret Jun 14, 2023, 4:39 PM

#

Yes.

mighty shard Jun 14, 2023, 4:39 PM

#

No there is no webhook

#

The only way to get those transactions is to refresh the Financial Connections Account

stoic turret Jun 14, 2023, 4:39 PM

#

Ok, gotcha.

#

Re: reconciliation - I found this https://stripe.com/docs/reconciliation with Stripe. This sounds exactly what I'm trying to build into the Platform (reconcile transactions, settlement data with bank statements). But was not able to find any dev resources for this. Could you please point me in the right direction for this?

Reconciliation

Understand your money movement and automate your payment reconciliation process with Stripe.

#

Specially, this article of Reconciling your data (https://stripe.com/docs/reconciliation/reconcile-data)

Reconcile your data with Stripe

Reconcile your data with Stripe by using Stripe reconciliation to import data, define reconciliation statuses, view analytics, and generate custom reports.

mighty shard Jun 14, 2023, 4:43 PM

#

Yeah that is a separate beta that doesn't involve the API as far as I know. I really don't know anything about that beta (we just focus on GA products that involve the API) so I'd recommend asking our Support team via https://support.stripe.com/contact/login about that specific Reconciliation feature

stoic turret Jun 14, 2023, 4:44 PM

#

Ok, noted. I'll ask the support staff. Thanks.

#deep randhawa