Have your say in Community Polls: What was/is your greatest motivation to start your own business?
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

Shopify API for Revenue Recongition

Shopify API for Revenue Recongition

kathleen123
New Member
7 0 0

Hi All,

 

Has anyone been able to pull in the created at date using Shopify API from the transaction detail? I have used the earnings report and noticed the report when I downloaded it from Shopify, it is not complete for monthly close. I was wondering what other companies have used for revenue recognition purposes.

 

Please let me know or if you used any other resources to calculate the revenue for the month/ which reports you find best to use for subscription based revenue. Thanks!!

Replies 7 (7)

CloudlabSam
Shopify Partner
591 47 103

What do you consider recognition of revenue? When the customer was charged (transaction) or when you received the money (payout)?

kathleen123
New Member
7 0 0

Have you encountered this situation?

kathleen123
New Member
7 0 0

When the services are provided to them so for subscriptions its usually when they are charged but if they are recurring I know based on my research, they are technically charged on the first day but the billing could occur weeks later which is why I am trying to understand if anyone has used the API to pull in the created date.

CloudlabSam
Shopify Partner
591 47 103

By created date, I assume you mean created date of the transaction. That is definitely available on the API, it is called created_at.

kathleen123
New Member
7 0 0

Yes what steps did you complete to do that? We tried but it pulled in the invoice date

CloudlabSam
Shopify Partner
591 47 103

Are you using the REST API? And if so are you using the transaction endpoint? 

 

/admin/api/2021-10/orders/{order id}/transactions.json should return the created date of the actual payment transaction, not the invoice (order).

 

https://shopify.dev/api/admin-rest/2021-10/resources/transaction#top

 

kathleen123
New Member
7 0 0

Do you know if when the customer pays = the created day for the invoice. I tried the whole process of signing up and you have to pay for it prior to the services being provided but the Shopify billing is confusing to me.