I'm wondering the same thing. I have an issue where I offer a free shipping discount for orders over a certain revenue threshold, but because the customer pays $0.00 for shipping, this is reflecting as a $0 shipping cost to me in the app I use to track profits.
My customers pay dynamic prices pulled directly from USPS and UPS based on their location, so I don't have a flat shipping rate to apply to all orders as an additional expense in my reporting. I need a way to easily export my actual incurred shipping costs for a given order (not just the aggregate shipping invoice).
Yes, why are there no reports on shipping costs? I want to be able to pull a report on what I'm spending on shipping, as well as my average package cost. I also offer free shipping over a certain amount but that doesn't mean MY shipping is free. Need to be able to keep tabs on my profitability.
I'm adding my agreement on needing this report in a much more detailed and concise way for accounting purposes. You can't even pull it in the upgraded version with custom reports.
The only real work-around I've found (after working closely with a Shopify rep for other solutions for a few weeks, looking at paid apps, etc) is to download all my bills for the period and enter the shipping costs into an excel spreadsheet, and generate totals and averages that way. Cumbersome but at least we can track it. Seems crazy though and a waste of my time since obviously the numbers are there, we just need a report.
FYI I learned this yesterday from a long chat exchange with a Shopify rep:
From your owner account, you can go to Settings --> Billing --> View Finance Overview (at bottom) to get a generalized shipping cost total for whatever time period you'd like. Ok good.
BUT I also learned - and feel this is potentially a HUGE issue with transparency on Shopify's part - that any additional/secondary shipping charges (such as dimensional weight adjustments, returned packages fees, and address adjustment/change fees) also just get lumped into this one "Shipping Fees" category and there is no other way to find or view those additional charges except by looking back into past individual orders to check their Timeline feeds. How can anyone be expected to do that? How do I know I'm being charged appropriately and where I need to make adjustments to my own shipping process in the future?
That is totally unacceptable and I encourage others to contact Shopify and make some noise about this.
A simple fix, if Shopify is not willing or able to provide comprehensive bills, is that the carriers can send me bills directly for any additional charges so I can evaluate and pay them. We would just pay the initial label cost through Shopify.
Thank you for bringing this up!
I was just checking my billing info and can't believe that I can't see details on voided labels and other adjustments!
I am truly concerned now about the voided labels whether I am getting a refund for them as the billing is not showing any of that, just billing twice for the same order.
I hope Shopify would fix this soon.
Adding my support to this as well -- it'd really help me out to be able to pull the actual shipping cost I paid for "free shipping" orders. I can't get an accurate profit without that number, unless I go order by order which. . .I'm not going to do.
Please please add this!
I agree with the others and frustrated to learn this is data is not easily accessible. i just started using the shopify shipping and this is a very disappointing frustration. I change my process over to Shopping Shipping to make things easier - now I will have to do more back-end work to make sure my accounting/bookkeeping is correct. Please add this report!
We're going through the same laborious process right now. Ideally we could enter a shipping cost when fulfilling an order in Shopify, since rates fluctuate daily between our suppliers and we charge a flat shipping rate (based on product type) on the order. Although it all (hopefully) averages out, this is really what I would feel most comfortable with for an accurate P&L.
Here's the workaround I came up with -- and part of me dislikes how resourceful we are as entrepreneurs, because that means we will find a way when Shopify is lacking features and solutions they should really have. The reporting, for instance, is terrible!
There's an app in the Shopify app store called ReportPundit. I'm squeamish about giving my data to 3rd party apps, but Shopify is too worthless in the reporting area that I am just biting the bullet. Using the app, you can create the reports you wish Shopify offered.
I created a report with the following fields:
The key here is the "shipping label amount (created)" field, which shows the price you paid for the shipping label.
I'm finding a lot of uses for the app.
Their support chat is also really helpful and will create reports for you if you tell them what you're looking for.
This is really helpful. I hadn't found Report Pundit yet, but I think it does give me the report that I need. I hate that you have to pay for the app add on, but probably worth it since Shopify won't give us the report we need.
I'm not excited to rely on / pay for a 3rd party app either, especially when it seems like something Shopify should have built in. (note there is a 14 day trial)
I've justified ReportPundit because I am now using multiple really helpful reports:
As an eCommerce company, we use ShipStation for all of our shipping needs. With ShipStation we can easily supply customers with immediate shipping information and keep our ship team on track. What do we like best about ShipStation? Check them out:
*ShipStation ties in well with our Shopify account.
*The wide variety of shipping company’s allow us to ship internationally and within the US.
*Daily reports allow the ship team and management team to view Pending and Current Orders, Orders waiting to ship, Orders shipped, Stores from Orders shipped, and more.
*We operate our own online store as well as a store on Amazon and eBay seamlessly with ShipStation.
*ShipStation works on all platforms — PC, mobile devices, etc.
*Monitor inventory levels.
*Easily communicate with customers on their orders and shipments.
*Generate automatic communications with the Ship team and customers.
*Adding and changing products with ShipStation is not hard.
*Shipping labels print easily.
*API functions and procedures work well across operating systems and applications.
*There are all kinds of training videos for ShipStation online.
Ive reached out extensively. They don't care. They say you have to hire an expert. The fact they can't produce a viable report where they have taken your money on a daily basis is horrible business. I'm switching platforms based on this alone after almost 5 years with Shopify.
Thank you for sharing this. I'm sitting down to do taxes and have just discovered that Shopify reporting doesn't show the cost of labels printed. I'll look into the app you suggested. I will also give Shopify reps a call to make some (polite) noise.