API access for finances summary report

I am looking for best way to pull the information presented in Finance Summary report (under Analytics > Reports > Finances > Summary) with a date parameter. Something like this below

/admin/reports/finances?since=2022-06-01&until=2022-06-03

I am trying to use API to get all the numbers presented in this report. Whats the best way to handle this?

https://www.screencast.com/t/jGLdjtYS3hB0

This is not possible via the Shopify API. There are their-party reporting apps that would allow this. Report Toaster, Advanced Reports, Better Reports, etc.

Thanks for the response but thats not going to be helpful as the API client may not have subscribed to these other reporting apps.

Is there an API way to pull Payout summary by Payment Processor? In other words can I query using API payout details for Shopify Pay and PayPal separately?

1 Like

Hi there! Were you successful in finding an API or another way to recreate these values - I’ve got the same question!

Did anyone find a robust solution for it? currently I am fetching all the raw data like orders, payment transactions and products, etc.. and calculating it via complex logic. It will be very helpful if Shopify tech team provide an efficient way to deal with it.