patidarkishor777

[granite anvil]

I think you can look at all the Invoices of the Subscriptions

Then find the Payments from them

[azure dust]

but this won't help because invoice does not have start and end time of the subscription period

invoice is linked with the subscription but I did not find a way to get the subscription period

[granite anvil]

The invoice have period_start and period_end

[azure dust]

yes this is not the subcription period end and start

I see the values of period start and period end are having 2-3 days difference

Basically I want to calculate the MRR

Is there any other way to get the MRR?

[halcyon nexus]

If you reach out to Stripe Support - https://support.stripe.com/contact, they may be able to provide other suggestions on how to calcaulate the MRR ! We mainly help with developers who want to integrate directly with the Stripe API here on this channel so we won't be able to advise on that specifically.

can you give an example subscription id, and the invoice id where you're seeing a difference between the period start and period end?

[azure dust]

here you can find the period start adn period end

it does not looks good

[halcyon nexus]

that's your UI

i'm looking for the subscription id and invoice id of the relevant Stripe objects

[azure dust]

ahh sure

let me share

Invoice Id = in_1MNHDFGFzVS6XiiXP62urGEU
Subscription ID = sub_1MNHDFGFzVS6XiiXqm1O2Yls

[halcyon nexus]

I'll get back to you in a while

[azure dust]

sure thanks

[granite anvil]

Sorry can you clarify which differences you see for above IDs?

You mentioned it has 2-3 days different

I am not sure which information your UI displays, but do you see the differences on Stripe Dashboard?

[halcyon nexus]

for context, if i look at sub_1MNHDFGFzVS6XiiXqm1O2Yls period_start and period_end, i can match it to the invoice line item period : https://stripe.com/docs/api/invoices/line_item#invoice_line_item_object-period. The current (latest) invoice is the one you should refer to i.e. in_1NG1CvGFzVS6XiiXh8pOYuVF