I just spoke with Shopify support, and they figured out a way to get the info:
1. go to Settings > Billing
2. Choose the bill you need
3. Click Shipping - It should show a number of "items", which are the shipping charges.
4. You can export each month as a CSV.
Not as neat and tidy as a single report, but not crazy either.
Hope that helps.
I love this workaround.
Are there any other dropshippers out there using their supplier's carrier accounts like us?
In this case, our supplier emails us with an invoice for each order with total charged including the shipping price charged. In this case, what we are actually looking for is a way to tracking shipping charges per order. Our current process includes adding a comment on the order of the shipping price charged for our monthly P&L, but this is becoming more of an accounting burden and not scalable as we grow to a few hundred orders per month.
If I am alone in this fulfillment challenge that I will accept my fate and look for custom solutions, but hoping that is not the case!
Thanks, stay safe everyone.
I'm right there with you @alexstonehouse1. It's a workaround for something that I thought would be a standard part of the reports Shopify creates. But it's definitely not scaleable. And don't even get me started on the adjusted shipping charges. I'm sure there's a way to report it all simply and accurately. I'll post an update here if I find it. Best of luck to you.
Seems that the shipping and payout are in the order information, why don't they appear in the export of the orders. I do fulfillment for myself and others and need costs allocated by order. This in addition to obvious need for allocating fees and shipping for tax accounting purposes. This seems worse than paypal, I thought that was impossible.
Hi @ThankedRapier4 (and everybody else who has taken part in this thread!),
The BeProfit - Profit Tracker app could be exactly what you're looking for.
You'll get a dashboard that lets you track and analyze your profits and expenses including shipping costs, marketing, production, and more (you can manually enter expenses as well).
The app automatically pulls Shopify shipping profiles and even lets you create new shipping profiles and shipping zones for full customizability. You'll also get a full breakdown of how much you paid for shipping and how much the customer paid for shipping for every order. You can watch a short explainer video of how BeProfit tracks shipping costs, here.
While it's extremely useful for tracking shipping costs, BeProfit offers many more advanced features to help make sense of all your shop's data to accurately calculate your bottom line.
You can use BeProfit to:
Try BeProfit and let us know if you find it helpful. Plus, if you have any suggestions on how we can improve the app, we're always happy to get feedback!