Shipping Cost and Net Profit
Report Toaster has introduced Shipping Cost into our dataset, which allows us to calculate net profit for an order.
Shopify Shipping is a very useful and popular service that merchants use to buy and print shipping labels from different providers at discounted rates.
If you are using Shopify Shipping, then normally you can access this data from the Shopify admin. The issue is that while the cost of the label is actually displayed on Shopify's Order Detail page, it's buried in the events section. There is therefore no way within Shopify to easily report on this data.
However with Report Toaster, you can track the shipping costs for labels created with Shopify Shipping and include them on order and sales reports. Now merchants can measure their profit/loss on shipping and know when they need to make adjustments to their shipping prices.
Better yet, with the addition of this new feature, we can now track net profit for an order:
Net Profit: Calculated as gross profit +
(shipping price - shipping cost) - transaction fees.
For example, if your gross profit is $50, shipping price $8, shipping cost $5 and transaction fees $1.80, then net profit (calculated as $50 + ($8 - $5) - $1.80) would be $51.20.
Net Profit Margin: Calculated as (net profit /
net sales) * 100.
For example if your net profit is $51.20 and your net sales is $94, then your net profit margin (calculated as ($51.20 / $94) * 100) would be 55%.
For most merchants, this represents a complete picture of their profit for an order.
Note - Currently these fields are only supported for usage with the Shopify Shipping service. If you purchase your shipping labels from another provider, feel free to contact us to discuss integration possibilities with your chosen service.
Related Articles
Product Cost and Profit Reports
Report Toaster has introduced Product Cost into our dataset, which allows us to calculate gross profit. Shopify allows product cost, or cost of goods sold (COGS), to be tracked at the product SKU or variant level. See this article for instructions on ...Premium Report - Shipping Labels Over Time
Shipping Labels Over Time This report is used for seeing the Cost of your Shipping Labels plotted over time. This is determined by looking at the Shipping Costs you have in Shopify and comparing against the number of Orders to work out your total ...Frequently Asked Questions (FAQ)
The following is a set of Frequently Asked Questions from users of Report Toaster: I'm stuck! How do I get help? Well don't panic - our dedicated support team is always here to help. Chat The best way to get in touch is via our chat widget in the ...Payment Gateway Transaction Fees
Report Toaster has introduced Transaction Fees into our dataset, which allows merchants to understand the NET amount earned from each sale. Every time a customer places an order online, a merchant is accepting payment. Shopify allows payments to be ...How Do You Calculate Values on Sales Reports?
We understand the importance of reliability and consistency in financial reporting. So we designed the Report Toaster app to use the same calculations as Shopify. See below for an excerpt from this Shopify article defining their report formulas. If ...
Suggestion Box
Didn't find what you were looking for in our knowledge base? Click here to suggest an article, and we'll try to put something together for you.