Needing 12 month total for transaction fees

Solved
offroad2430
Tourist
13 0 2

Hi,

I need to print a 12 month total for all the transaction fees I've paid this financial year (for tax purposes).

I can easily find a 12 month total for sales/ returns/ shipping/ taxes, etc, but no mention of what I've had to pay in transaction fees.

Where is this hidden? I can't see it under analytics, or under payouts.

The billing history invoices for the monthly store subscription are also in the wrong currency. How can this be changed too?

Thanks

 

Accepted Solution (1)

Accepted Solutions
Ava
Shopify Staff
Shopify Staff
1161 77 185

This is an accepted solution.

Glad to hear that helped!

 

For the rest of the statement, I'll break this down for you now. The annual Basic plan (yearly subscription) usually costs $312 USD. It looks like you switched to the annual plan a few days after you're last invoice of $9 was paid. The billing here is prorated, which means it will take into account what you have already paid for this month when you switch plans. This will mean you will pay slightly less for your next invoice after you switch plans once a new billing cycle has begun. In this case, our systems charged $310.27 instead of the full $312, as you have already paid for $1.73 of the 30-day billing cycle.

 

The following invoices for $26 USD are what the annual plan works out at, monthly. The Basic plan is normally $29 USD every 30 days, but when you pay for an annual subscription, you receive a 10% discount, so you this breaks down to $26 every 30 days instead of $29. Once you switch to annual billing, you would pay a once off fee, one per year. These invoices for $26 would mainly be for reporting/accounting purposes though, as you would not actually be charged a fee here. The invoices would be sent but instantly credited, but if you go to Settings > Billing, you will see there is actually $0.00 being charged. This is because there must be a record of your monthly payments, so although the $26 is there as subscription credit, it will still show up in your statement of charges. The statement of charges is a statement of all the charges generated by the account - it would not be a statement of payments so any credits, reversals or refunds would not be taken into account on that view.

 

Let me know if that makes sense, happy to keep chatting here!

 

Ava

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

View solution in original post

Replies 24 (24)
Ava
Shopify Staff
Shopify Staff
1161 77 185

Hey, @offroad2430!

 

Ava here from Shopify 🙂

 

Can I ask if you are using Shopify Payments as a gateway? If you are, then you would see no transaction fees appearing on your invoices, as Shopify Payments does not charge transaction fees. If you are using a third-party gateway, then they should show up as normal on your invoices, along with other app charges, etc. Can you confirm for me which gateway you are using? I'm happy to keep chatting here until we resolve this for you.

 

Speak soon!

 

Ava

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

offroad2430
Tourist
13 0 2

Hey Ava, I've added a couple of screen shots.

I receive payouts to my bank account from Shopify, so I'm guessing the Shopify Payments gateway is in operation.

I only use Shopify Payment or Paypal as far as I can tell. I've never used any third party ones.

When ever a non Paypal transaction occurs, I loose a small amount (Payout fee??) shown in the screen shot.

 

Thanks, LukeFees.pngPayments.png

 

Ava
Shopify Staff
Shopify Staff
1161 77 185

Thanks so much for the screenshots!

 

These fees from your Shopify Payments payouts would be credit card fees. 

 

24-07-5ce05-ekgoz

 

If you would like to see a breakdown of these fees, you can go to Settings > Billing, then scroll to the bottom of the page where it says "Financial Overview". Here, you will see a full overview of all your payouts and billing. You can click on 'view financial overview' to see a breakdown. If you adjust the dates here, you can go back 12 months to see a total of the fees you would have paid

 

24-32-tlib4-01qke

 

For your PayPal fees, we would not store that information within the Shopify admin I'm afraid. Those fees are paid to PayPal are determined by PayPal. I'd recommend contacting PayPal's support team, or have a look inside your PayPal business account/dashboard for that information.

 

Do let me know if this is what you were looking for!

 

Ava

 

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

offroad2430
Tourist
13 0 2

Thank you Ava, That was exactly what I needed.

Another question regarding the subscription fees, I uncovered a list of fees which I don't understand (pic attached).

It shows $9US monthly fees from when I started on the Lite plan, followed buy $310 for a yearly subscription when I changed to the Basic plan.

But I don't understand all of the $26US monthly fees following the annual fee, plus the total for $571US.

My understanding for that date period should be 3x $9 + 1x $310 for a total of $337US.

Thankmonthly fee.png

Ava
Shopify Staff
Shopify Staff
1161 77 185

This is an accepted solution.

Glad to hear that helped!

 

For the rest of the statement, I'll break this down for you now. The annual Basic plan (yearly subscription) usually costs $312 USD. It looks like you switched to the annual plan a few days after you're last invoice of $9 was paid. The billing here is prorated, which means it will take into account what you have already paid for this month when you switch plans. This will mean you will pay slightly less for your next invoice after you switch plans once a new billing cycle has begun. In this case, our systems charged $310.27 instead of the full $312, as you have already paid for $1.73 of the 30-day billing cycle.

 

The following invoices for $26 USD are what the annual plan works out at, monthly. The Basic plan is normally $29 USD every 30 days, but when you pay for an annual subscription, you receive a 10% discount, so you this breaks down to $26 every 30 days instead of $29. Once you switch to annual billing, you would pay a once off fee, one per year. These invoices for $26 would mainly be for reporting/accounting purposes though, as you would not actually be charged a fee here. The invoices would be sent but instantly credited, but if you go to Settings > Billing, you will see there is actually $0.00 being charged. This is because there must be a record of your monthly payments, so although the $26 is there as subscription credit, it will still show up in your statement of charges. The statement of charges is a statement of all the charges generated by the account - it would not be a statement of payments so any credits, reversals or refunds would not be taken into account on that view.

 

Let me know if that makes sense, happy to keep chatting here!

 

Ava

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

offroad2430
Tourist
13 0 2

That makes sense now. Thanks again

Ava
Shopify Staff
Shopify Staff
1161 77 185

No problem at all, happy to help! 

 

Ava

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

AngieP
New Member
2 0 3

I have just followed this, as I also need to see what Fees Shopify have taken for card payments made through Shopify payments - however, you can only get the last 90 days of transactions - despite trying to change the custom dates. This is obviously not good, if we need to find data before those 90 days - i.e. from beginning of UK tax Year 6th April 2019 onwards etc

Ava
Shopify Staff
Shopify Staff
1161 77 185

Hi, @AngieP!

 

I'm sorry to hear you're having trouble with the dates. If you go to Settings > Billing and scroll to the Financial Overview, you can select 'view full payouts', where you should see all of your payouts since you began using Shopify Payments. You can then export that full list! Do you know when you set up your Shopify Payments account? The list of payouts will only show as far back as when you completed your Shopify Payments account. SO if your store was operating from, for example, March 2017, but you only set up Shopify Payments in March 2019, you will only see payouts as far back as March 2019.

 

Let me know if that makes sense, and if selecting 'view full payouts' works for you!

 

Ava

Social Care

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

PinkForestCafe
New Member
1 0 2

Hi, Ava!  I followed your directions, thank you.  I exported the csv as you mention here.  This doesn't give me the lump sum that I need.  Are you saying that I now have to add each individual payout and then deduct that amount from my Shopify gross amount in order to get the TOTAL fees that were paid to you for the year?

 

I hope you see that this doesn't seem right, the amount should be a lump sum per account, no? Please let me know where the lump sum for fees paid in 2019 (or any other year) can be found, I would appreciate this!  I hope I am just missing something!  

Ava
Shopify Staff
Shopify Staff
1161 77 185

Hi, @PinkForestCafe.

 

Apologies for the delayed response!

 

Which figure are you looking for? The total amount in fees you have paid Shopify for a 12 month period? or your Shopify Payments payouts? Just so I know how to direct you! 

 

Ava

Social Care

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

20Kate11
New Member
2 0 1

I can only access 90 days as well

Ava
Shopify Staff
Shopify Staff
1161 77 185

Hi, @20Kate11!

 

The Statement of Charges is a page within the Billing Settings. To get there, follow these breadcrumbs: Settings > Billing > Finance Overview > View finance overview > View full statement. The statement of charges is a ledger of all billing transactions, including tax. Charges can be viewed by date range, up to a maximum of 3 months. Merchants used to be able to view historical charges older than 3 months old. Due to scalability concerns, this was limited to 3 months at the end of 2019.

 

However, if this is something you feel you need for your business, I can submit this to our internal team to be reviewed as a possible future feature of the admin. As our platform is constantly growing and improving, our team love to get feedback from our merchants on what features/edits they need to improve their workflow. So once I submit this as a feature request on your behalf, our team can review the request. So hopefully, this can be something that is available in the future.

 

There is never a guarantee that a request will get a Green Light, *or* make it to a product launch, but we really do appreciate you reaching out with your suggestion, as I’m sure you’re not the only merchant with this request.

While we would not have a specific timeline for how long that might take, you can definitely keep an eye on our announcements page. We will post any new updates or developments there!

 

Let me know what you think!

 

Ava
Social Care | help.shopify.com

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

oasisnz
Tourist
3 0 8

I am trying to get last 12 months transaction fees but when I go to Finance overview it is only allowing past 90 days?  

Ava
Shopify Staff
Shopify Staff
1161 77 185

Hi @oasisnz!

 

As I said in the post above, the Financial Overview would only show 90 days worth of information. Charges can be viewed by date range, up to a maximum of 3 months. Merchants used to be able to view historical charges older than 3 months old. Due to scalability concerns, this was limited to 3 months at the end of 2019.

 

There is the option of going to Settings > Payment Providers > View Payouts (under Shopify Payments) > Transactions (on the top right). You can then see all your transactions. You can then hit Export and select All Items. This way, you can import that file into a spreadsheet to view more than 90 days worth of reports.

 

Let me know what you think!

 

Ava
Social Care | help.shopify.com

Ava | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

DTA_Stores
Tourist
5 0 8

This really needs to be changed back to support more than 90 days of history. Not being able to generate a full detailed financial report for the previous year makes filing taxes a nightmare. Please (un)update this.

oasisnz
Tourist
3 0 8

I agree End of Year Tax time is already a nightmare and to have to go through every transaction is just ridiculous?  

David172
Tourist
7 0 6

I agree with you 100%. They used to have this option so I'm shocked they reduced the data available to only the last 90 days. They should really make accessing year-end tax information easier.

oasisnz
Tourist
3 0 8

I know its super annoying 😞