I wanted the exact same thing and it's not totally trivial when you consider different discounts, quantities, past_due, trial dates, etc.
So I built a simple script to do some of it:
This is actually an awesome idea -- almost like a forecast of the money you'll earn? Should be simple to do it programmatically. I'm going to add something to our feature list to explore this.
Re:Paid for Stripe
by yesimahuman on Wednesday May 08, 2013 @06:46PM
(#5677531)
There's a service called Dig my Data that will do some cool predictions and analytics from your Stripe data. Things like churn rate and revenue over time.
Re:Paid for Stripe
by alexknowshtml on Wednesday May 08, 2013 @02:18PM
(#5675879)
Killer :)
I've got a question about the current dashboard: by default, "Today's Volume" seems to include more than today. "This Month's Volume" also seems to include more than this month (the range goes to the end of this month). How are these figures actually calculated?
Edit: you can email me directly, [email protected], if you'd like to talk more about this off-forum.
I'm already doing something like this for my personal money. Getting a forecast every couple of days.
https://github.com/Swizec/Personal-Runway
Have been trying to come up with a way to turn this into a product for over a year now. A service for SaaS owners ... might not be a bad idea.
Yeah I was thinking the exact same thing the other day. The churn rate on my app is so low that it would be pretty accurate. I'll try and build a ruby script this weekend.
Based on CURRENT subscriptions, how much money can I expect to collect over the next X days? Stripe tells me about transfers that are scheduled, but I can't look past money that's already been collected without manually pulling down a bunch of subscription data and trying to figure out how much we're going to be paid on each day in the future.
I'd be happy for this to be a command line script - I just haven't managed to figure out the best way to do it!