Shopify API for Revenue Recongition

[kathleen123]

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!!

[CloudlabSam]

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

[kathleen123]

Have you encountered this situation?

[kathleen123]

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]

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]

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

[CloudlabSam]

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]

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.