While importing the item master sheet, you will have to add a new value: Product cost, across each item.
We can define product cost as the landing cost of any item, which means it involves the product price + freight charges of getting it to the warehouse.
With the introduction of feature: Reconciliation, the system will now have the all the payment related information (payments expected and received for sales made on various marketplaces). Thus our solution will be smart enough to calculate the actual P&L.
Please understand that Total revenue (Payment received) – Product Cost = Actual Gross profit. You can easily find it, Lets see how?
You can import Item Master, which now contains a new field called “Product Cost”.
Check the Format CSV to find this column: Cost Price.
With the help of this field and Reconciliation data, the system can calculate Actual Gross Profit = Payment Received – Product cost.
You can find that with the help of a report called “Sale Order” which can be exported from the system. Please see the steps below: