I am building AcquireBase - a marketplace for buying and selling side-projects, micro-SaaS, etc.
As part of our upcoming feature, we want to allow our seller to verify their reported MRR via Stripe - something IH already does for products.
It has been over one month since I am trying to figure out how to do this. I tried Google search but nothing came up useful. Stripe's documentation did help either.
Now, I'm getting frustrated.
Is there anyone who has successfully implemented Stripe revenue verification or knows how to do this?
I'd highly appreciate it if you share the info with me.
Thanks!
Really interesting challenge. We ran into the same issue when building Fusellit’s seller dashboard. The solution was to use Stripe’s OAuth flow to connect the seller’s account with read-only permissions. Once you have the access token, you can call the Subscriptions and Charges endpoints with the Stripe-Account header to fetch the customer subscriptions and payments. From there you normalise the data to calculate MRR (taking into account annual plans, coupons, trials, etc.). We also found it important to handle one-off charges separately so the MRR is not inflated. Hope this helps!
I might be entirely wrong I haven’t used the stripe API in a long time but I think the OAuth (I think it’s covered in “Build a stripe extension” in the docs) and/or reports API documentation might be of use here
Edit: here’s the link for the first one I mentioned https://stripe.com/docs/building-extensions
This is exactly the solution!
I'm not sure as not done this myself, but I suspect, the reason why Indiehackers is able to do it is because they are owned by Stripe so they probably have a way of integrating which isn't available to other companies/people.
@attacomsian
I haven't done that sort of calculation, but according to the Stripe documentation (https://support.stripe.com/questions/calculating-monthly-recurring-revenue-mrr-in-billing):
"You can calculate Monthly Recurring Revenue (MRR) by summing the monthly-normalized amounts of all active subscriptions at that time"
So, in theory, you can retrieve all active subscriptions for a particular month and normalize the annual ones for the monthly value to calculate the MRR.
There is of course discounts, tax, trials, delinquency, cancellations, and metered billing to also consider but this should be a good place to start.
Check out also the Subscriptions API at: https://stripe.com/docs/api/subscriptions/list