Fees report? Actual net income report?

MDD
Explorer
47 0 39

Where can I find a simple montly fees report? Also, is there a way to see an actual net income report?  

In my Financial Summary report I see a "Net sales" number, but that number is highly misleading as it is not, in fact, net.  That number includes fees to payment services (including Shopifys own payment service) as well as not reflecting shipping expenses I've incurred during the month, which is something else Shopify should have a report for since I print and pay 100% of my shipping through shopify.

Is there an actual net income number somewhere that I'm missing?  Is there an easy way to see how much I paid Shopify, PayPal and Amazon Payments in fees on a monthly basis?

 

Replies 40 (40)
JREO
Tourist
7 0 6

GEEZ So have been using Shopify for 2 months now, was using paypal,  followed this thread. DISGUSTING   I wish I hadn't changed, every month crazy to do end of month.  data all over the place,  I refuse to pay for an app to get info that SHOULD  be readily available.  I am from Canada and cannot easily find out how much GST I pay on shipping.  If I didn't have a credit card that charges no exchange fee, I would lose money on shopify shipping.  I really don't think Shopify is better than Paypal, I get the same info from support re fees and shipping info NONE.  rant over 

Francine_Scheue
New Member
2 0 11

I'm looking for the report we used to get under "settings" then "billing" then "finance overview" that showed exactly the Shopify fees on the monthly sales.  Where can we find this report, now?

greensparkstech
Tourist
4 0 2

Getting the financial info out of Shopify is A NIGHTMARE. 

Transaction fees are in one place
Shipping fees and other bills in another and are reported in USD (I am in Australia)
Sales in another
 
Yes, just as you were thinking, it appears to have been designed inside a mirror maze by an octopus without a central nervous system.
 
If I want to find out how much I was actually charged for shipping, I have to go to the paypal transaction and look at the currency conversion. Further, because you get charged at the end of a cycle, it's REALLY fiddly to then match up shipping costs with orders.
 
So, if I want to match everything up, I have to stitch together three separate spreadsheets. I can't believe that it is THIS complicated. The info is all there, it's just in a gazzillion different places. How hard would it be to write a code thing that pulls all the figures together into one place (I don't want to pay an app to do basic functionality)? 
CE_Institute
Tourist
6 0 2

I agree  - trying to calculate merchant/credit card fees collected by shopify is a NIGHTMARE.  I think Shopify is HIDING this information from it's customers in an attempt to try to fool customers about their income by hiding our expenses.  Shopify gives us our gross totals no problem.  Why can't shopify include on it's report "merchant fees" or "credit card fees".  This is a BASIC tax requirement and undoubtedly being hidden by shopify for nefarious purpose

EricC
New Member
2 0 6

I hope someone from Shopify is monitoring this thread. We are moving our entire online ecosystem (online store, POS, email marketing, rewards program, and payroll) over to Square because of how horrendous it is to try to pull MY OWN information out of Shopify. It's unbelievable how bad it is. I realize they're a big company and they won't miss my ~$500 per month, but I figured I'd post here rather than just disappear without letting them know why we switched.

JREO
Tourist
7 0 6

a what a hassle, you can find the fees in settings, payout and trasactions,  it is there just hard to rectify everything, unless I am missing something, someone please tell me!!

thanks'

TribalMarks
New Member
2 0 0

I can't believe they haven't repsonded of late to this issue. They've moved things around since they last answered, but obviously don't see the need to make this seamless. Tsk

tysatera
New Member
1 0 1

I spent hours locating a document that would help me figure out what fees I paid for 2020.  I didn't find a consolidated document but these steps will work for now.  I chatted with Cheryl H/Shopify she helped me find my invoices for 2020 by navigating to the following:

  • Finances
  • Billing
  • Bills (under payment history)
  • Recent Bills 
  • View all billing history
  • Scroll to the bottom and click on "< or >"to navigate through the bills
  • Click the checkbox for all of 2020 bills
  • Top right, click on Export CSV file
  • Under "Export" select Selected: 12 bills
  • Under "Export As", I selected "CSV for Excel, Numbers, or other spreadsheet programs"
  • Click on Export Bills
  • The bills will be delivered to the email address associated with your Shopify account.  

Hopefully this helps

CloudlabGeorge
Excursionist
15 2 5

Well just so you all know, you can do all of this with our free app, Report Toaster: 

https://apps.shopify.com/report-toaster

Here's a screenshot that provides a nice overview of the sales on the storefront over the last 30 days. Everything is fully customizable, so I added a column for transaction fees. You can then change the date range, add filters, and even export it to CSV/JSON. 

CloudlabGeorge_1-1634347556748.png


Basically this sounds like exactly what many have you have mentioned that you're looking for. We have specific reports for Finances, Transaction Fees, all of your Sales information, and even the information you need for Taxes. Let me know if you need help in getting setup. 

George 

luciotti
Excursionist
18 0 6
Ok folks, after a lot of aggravation and yelling from my accountant, I'm happy to report that Shopify does have what we need, it's just buried in places that you would never imagine:
 
First of all, the Analytics menu is where you want to be, not the Finances menu.
 
Go to Analytics>Reports>Finances and expand the menu. Here you can find:
1. Finances Summary--> You can view a summary by month, quarters, YTD, MTD etc. You can also see the TOTAL of sales taxes paid by customers and shipping fees paid by customers. For a breakdown on sales taxes, click on the respective links and it will give you a detailed view..
 
2. Total sales --> Here you have a breakdown, by sale, of sales taxes paid by customer and shipping fees you paid. This is the detailed view, if you need to look at a transaction specifically, but it is not not the general summary report you need for your tax return. For more on this, keep reading.
 
At the top of the report there is a total of the SHIPPING FEES paid by customers (if they pay any). Keep in mind this is NOT the shipping fees YOU necessarily paid (therefore tax deductible), because sometimes you pay a little less or a little more depending on how you combine your orders or the app you use to print your shipping labels, but you can at least get a total number to subtract from your actual net sales.
 
3. TAXES --> This is where you can get a list of all sales taxes paid by county/city/state. This is what your accountant needs to file your quarterly excise tax report.
 
Payments --> This is also a summary of payments received minus refunds. I find this useless for tax reporting purposes.
 
Then go to Settings>Payments>View Payouts or Finances>Billing
This is where you can see the fees that Shopify withdraws from your payout.
Caveat 1: you still have to export this to csv or Excel and calculate the total, but that is at least doable once you have the whole list. It's a lot better than having to go through every single transaction.
Caveat 2: You cannot filter by year or even quarter, so you'll have to remove the unneeded rows from your export file.
 
Under Finances>Billing you see what Shopify charges you monthly, but this total combines the monthly plan fee + shipping fees you paid through Shopify. So either deduct the monthly charges from this total to get the actual shipping fees you paid or see above for how to get a total of shipping fees paid.
 
Warnings: PayPal payout fees are list in your PayPal account. There is no way and nowhere to see those in Shopify.
 
Same for AfterPay, Klarna or any other method of payment you may have installed on your site. Those fees are listed by each respective 3rd party app.