Calculating Net Profit

You can include shipping costs and channel marketplace fees in your net profit calculations. You can pull in shipping costs from ShipStation and StarshipIt. You can pull in channel marketplace fees from Amazon and Shopify, as well as define your own custom margins for other marketplaces.

How do I add shipping costs?

To pull shipping costs, you'll need a connection to your shipping system. Right now, we support ShipStation and StarshipIt.

Once you have your shipping system connected, go to your inventory system data source in Easy Insight and click on Configuration, then click on 'Set Up Shipping':

To actually use the configured shipping cost values, the fields will depend on your data source:

For Cin7, it will be Shipping Cost under Sales/CR Lines, and Net Profit for profit factoring in that shipping cost under Sales/CR Lines.
For DEAR, it will be Shipping Cost under Invoice/CR Lines, and Net Profit for profit factoring in that shipping cost under Invoice/CR Lines.
For Katana, it will be Shipping Cost under COGS Fields, and Net Profit for profit factoring in that shipping cost under COGS Fields.

If you're missing prebuilt templates that are necessary to map in the shipping costs, please contact our support team and we'll be happy to help.

Click on the enable costs link and Easy Insight will look at your data to identify how shipping costs map back into your inventory management sales and invoices. Assuming it can map the data together, it will create the connection and update your reports. The Shipping Cost and the Net Profit fields in your inventory system will update accordingly to help you track your true profit.

How do I pull channel fees?

You can pull in your channel fees to help calculate true profit and identify just what it's costing you to sell on a given marketplace. For example, you could pull in your FBA fees from Amazon to identify how much profit you're making on Amazon orders. By default, Easy Insight can pull your fees from Amazon and Shopify. If you want to pull in fees from another marketplace like Faire or Iconic, you can put in your own flat and % fees, or you can use an entirely custom calculation.

To get started, go to your inventory system data source in Easy Insight and click on Configuration, then click on 'Set Up Shipping':

Based on the appropriate source field in your inventory system, you can choose the channel mapping and costs. If you have the marketplace connected in Easy Insight, you can choose to automatically pull in the fees. Otherwise, you can specify the fees or to use a custom calculation.

Click on the Save button after configuring your channel fees. Once you save, it'll update the supporting calculations feeding into the channel fees in your reports, including updates of the net profit calculation to include channel fees.

To actually use the configured channel fee values, the fields will depend on your data source:

For Cin7, it will be Channel Fee under Sales/CR Lines, and Net Profit for profit factoring in that channel fee under Sales/CR Lines.
For DEAR, it will be Channel Fee under Invoice/CR Lines, and Net Profit for profit factoring in that channel fee under Invoice/CR Lines.
For Katana, it will be Channel Fee under COGS Fields, and Net Profit for profit factoring in that channel fee under COGS Fields.