Is there a way to export, or even an app that can export your shipping data? I'd like to export the size of box I used, the actual weight, and the price I actually paid.
I am pretty tech inept LoL but in my fumbling around I discovered an easy way to generate the report.
- View all billing history
- In the upper right click on Export CSV
- You then have the option of choosing dates. Chose Jan 1 - Dec 31.
- You will then have to sum the shipping expenses column,
The report also includes fees for apps used for shipping like Boxify and Amazon Integration Plus.
Hope this helps. Amazon support had no idea.
Under the Admin homepage: go to Finances > Billing.
Under Recent Bills, click "View all Billing History"
Now the key is to Export to CSV File at the top.
Click Bill by Date > Export Bills.
Once you have the Excel file open, it will break down all charges by Shipping, Apps, etc. and you can view the report as needed for Accounting.
We just launched two new reports for Shopify Shipping labels that might also help you:
1. Shipping Labels
2. Shipping Labels Over Time
You can now see and export your shipping label costs per order along with other metrics such as average label costs over time.
The bills are always most accurate for any financial reconciliations, but these reports will give you a quick, high level overview of your costs and how they might change over time.
Thanks for all the great feedback!
Thank you @BjornD for letting us know. This is very helpful! Can we please have one more useful filter? I see we can filter the table for origin zip code, origin country, but it would be best to have the actual Shopify Shipping Location! This makes it easy to pull all the postage used for a specific fulfillment location. If the zipcode is already in there, hopefully isn't too hard to add in the origin name (the Shopify location name)
Explore the 30-30-30 rule, a dynamic social media strategy for new businesses. Learn how t...By Trevor Sep 20, 2023
Discover how to leverage the often overlooked footer of your ecommerce site to gain custom...By Skye Sep 15, 2023