If this is something you're struggling with... It's one of the core use-cases we're solving for at Equals (https://equals.com).

We sync your Stripe data to a data warehouse and give you an MRR by customer by day table. You can use this table in our data connected spreadsheet to report on your business.