How to Export "Charges" spreadsheet for 2021

[errj]

Hi,

Last year I was able to create an "Export of your Charges" spreadsheet showing all of my Shopify transaction fees and shipping fees by Order in a single spreadsheet for the entire year. 

The file is called: charges_export.csv

And the email subject when the compiled report is delivered is called: Export of your charges

I can't seem to find a way to export this document. Can someone show me how?

Thanks,

Erik

[errj]

NVM. I figured it out.

The Charges report can be generated under: myshopify.com/admin/settings/billing/history for a US-based shopify store.

Then you:

1) click on the "Export CSV File" option

2) choose your date range (Jan 1, 2021 - Dec 31, 2021 to get a file for the whole year)

3) choose the CSV format option

4) click "Export Bills" (and the report will be emailed to you)

[PaulNewton]

Hi @errj 👋, you can mark your own answers as solutions!

This will help other merchants searching for this same issue in the future to see that there is hope with a big green Solved label in a sea of results.

Thanks!

https://xkcd.com/979/

[Symbolry]

Thank you! I wish Shopify would make it easier to find this information...

[WorkGPT1]

In case you want an automated way to solve your problem.

You can set the timer and format as you want and ShopFlex will send you the sheet/sync the date to google spreadsheet.

Find out more use cases:

https://ap.shopflex.io/workflow/use-cases

[dori_]

I can no longer find this feature.

Does anybody know a new solution to get all the charges in one csv file?

[dori_]

Please disregard my previous comment. The feature is still there, but maybe the method has changed:
In Billing, in the "Past Bills" box on the top right is a three dot menu. Click it, click Export Bills, and then Bills By Date, and that way you can choose any range you'd like. Hope this helps someone else!