Hi Jane, I agree with you that we should know the actually cost for each inventory item, so that we can make sure that the price we charge is enough.

My company uses landed cost to input each inventory items, and we also use excel to calculate the landed cost for each item. My question is, if the vendor sends us the invoice of  duty and shipping next month along with next shipment, should I allocate that duty and shipping fee to the next shipment or last shipment? If I apply those to last shipment, then I will get negative duty and shipping fee since the inventory billing date and duty freight date are not in the same month.