Thank you so much, really appreciate.. 

Then i need to calculate inventory value, suddenly there is a change in terms of cost (cost of the product and shipment to present location). How do i adjust my cost and sales value in Quick Books online. Actually after doing my excel calculations like the qty on hand multiply cost of the inventory and the value i get after running my inventory value in Quick Books differs. What could be the reason is there anything i am missing up in quick books because i have already adjusted my Cost and Sales value in Quick books. Please help?