How can I view the total annual transaction fees from all payments made from my store?

[skris]

Hello,

I'm wondering if there is a way I can see how much in "Fees" I have accumulated over the past year in sales from my store. I can only view under Finances > Payouts for each individual transaction how much in Fees were taken from each transaction. Is there an easier way of viewing this in an annual or YTD format? 

Best,

Kris

[Report-Pundit]

Hi @skris ,

I am John from Report Pundit, a reporting and analytics app in the Shopify app store.

Report Pundit has the option to summarize all the fees that were accumulated over the past year.

You can also filter & sort the report by Payment gateway, transaction amount, Gift card amount, payment reference, tax details, and many more.

Further, We can custom schedule the report to your Email, Google sheets, Google drive, Ftp & Big query on an Hourly, Daily, and Monthy basis.

I request you to install our Report Pundit App with a 14 day trial period and we will set up the reports free of cost.

You can reach us at support@reportpundit.com

Thanks!!

[skris]

Hello,

Thank you for your recommendation! I was wondering if those fees would be under commission? 

Thanks,

Kris

[Maz · Accepted solution]

Hi @skris!

Thanks for getting in touch! It is my understanding that you are wanting to see all your transaction fees for 2021. Let's look into this for you. 

You should be able to view this by going to the Shopify admin > Finances > Billing > and then scroll all the way down to Statement of Charges at the bottom of that very page. Next, you will then click Transaction Fees and then choose your view, keep in mind with this view data is only available for 90 days.

A workaround is to go to Finances > Billing and then go to View all billing history.

You will have the option to add filter and decide the date range that you would like to see. This will generate a list of all your bills in that time range, and the transaction fees for each will be there! You can also choose to export the data via a CSV file too if you wish!

Just in case you wanted to have a look, here are our help center guides exploring those topics below:

• Understanding your Shopify bill
• Charges

I hope the above has been illuminating for you. How are things going with the rest of your website? What are some aims and goals you have set for 2022? I would love to hear more!

[lift]

Hi Maz, Thanks for your solution. The second part worked for me. 

[Maz]

Hey @lift!

Thank you for letting me know the solution worked for you, and I am glad to hear that it worked!

I've gone ahead and marked this reply as the solution for the benefit of others who may discover this topic. By the way, how is your Shopify journey going so far? If there is anything else I can help you with, please let me know, I'm happy to help!

[eyeclothingco]

It looks like this is not accurate as it does not show all of the fees that are listed in our payouts and the number shown for fees in the billing section isn't anywhere close to what we have paid. 

I would like to find the YTD total of all fees from payouts and transactions. 

It says this on the billing page:

Transaction fees

Shopify Payments fees are deducted directly from your transactions, based on your credit card rate. You aren’t charged for transaction fees on your bill.

[Goldweitz]

Exactly right. They have the technology to give you a comprehensive report.

Instead you are getting a bill for obvious subscription fees, apps, shipping etc..

I should add for awareness: if you use Amazon Pay, they take an additional 2% for that luxury.

(Amazon charges you a separate fee)

Beware: the Credit Card transaction fee is hidden in your payout reports, all 365 of them.

Did you deduct these costs in all of your previous 1120s? I hope so!

[JulianP]

It seems this is not working anymore in 2022

[heskew]

export by csv and it allows you a window date to choose (2021) and filter

[Goldweitz]

This is an incomplete answer. Yes you can see a list of all of your periodic bills. Sometimes monthly, sometimes based upon a threshhold. You can add these up longhand, or you can pull a csv from your payment source such as bank account, and filter that..

What this list does NOT depict is the 2.9% credit card processing fee reduced from each of your payouts. This is not accounted for unless you flip through every single payout- for many this is 365 payouts. There is no proper way for Shopify to provide you a fully transparent report of costs. They make you hunt for it using all sorts of time. The purpose? to mask/camouflage the fleecing they are giving you every month?

If this is a new idea for you, look back on your last few years of tax preps and see if you forgot to account for the CC % you are charged from each payout! It's not included on the monthly bills!

[ncav36]

Hi, I tried the exact steps listed here and the transaction fees to not show up as an option to click on and view.  It seems I have to open each transaction for all of last year to see the transaction fees listed.  This is quite frustrating.

[Maz]

Hey @ncav36!

Thanks for subscribing to this thread!

There isn't a specific report in which you can pull for this. If we are talking specifically about Shopify Payments fees, you can head into Finances > Payouts and export a CSV of your payout transactions. This CSV should also include the transaction fee amount per order. If the workaround above is not sufficient, then you can use a third party app like the ones listed below;

• Mipler: Custom Reports

• Better Reports

• Report Pundit

I can appreciate how this would be beneficial for accounting purposes, so what I will do is, add this feedback for our developers to review. Let me know if there is anything else you need help with!

[Janit_Calvo]

Just want to add my name to this thread - to make such an easy task so difficult, seems very wrong. We need to find our merchant fees for our taxes, ICYMI. 

"There isn't a specific report in which you can pull for this." is ridiculous. 

To have to go and find an app that I prolly have to pay for is also ridiculous. 

**The Finance > Payouts and export the CSV** works but it should NOT be that hard to find out our fees. You can chose your timeframe when you click Export. 

The Finance > Billing  > Statement of Charges does NOT work - I only see half a year's charges and not every charge at that... 

(I didn't check to see if I needed to upgrade to access this info in a more-efficient way, but I would not be surprised, if this is the case. It seems Shopify doesn't care about the micro businesses anymore - they're too big now.)

[PWM]

7 months have passed. What's the word?

This is a basic and absolutely necessary report. Its absence is suspicious and entirely unprofessional. It'll take IT 20 minutes to write the query. FFS give me the table structure and I'll write it.